Skip to content

Instantly share code, notes, and snippets.

View ritacse's full-sized avatar

Wahida Yasmin ritacse

  • Bangladesh
View GitHub Profile
@ritacse
ritacse / CTE
Last active February 17, 2026 10:37
ALTER PROCEDURE [dbo].[GetPOBasicParentDataByParamsForAdvanceBill_SP]
@FromDate date,
@ToDate date,
@POId int = 2011,
@SupplierId int=0,
@CompanyId int=0,
@userId int = 3
AS
;WITH AlreadyBilledAmount AS (
@ritacse
ritacse / TRG_ITEM_History
Created February 10, 2026 08:37
-- Tracking any update or delete on item table
ALTER TRIGGER [dbo].[TRG_ITEM_History]
ON [dbo].[Item]
AFTER UPDATE, DELETE
AS
BEGIN
SET NOCOUNT ON;
-- ==========================
@ritacse
ritacse / Bar Chart
Last active November 4, 2025 11:44
Link: https://www.chartjs.org/docs/latest/charts/bar.html
<!DOCTYPE html>
<html>
<head>
<title>CM-wise Qty & Value Bar Chart</title>
<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<script src="https://cdn.jsdelivr.net/npm/chartjs-plugin-datalabels"></script>
<style>
body {
@ritacse
ritacse / Kendo Grid Dynamic Column Binding
Last active January 19, 2026 06:12
function BindGrid(response) {
if (!response || response.length === 0) return;
var knownStaticKeys = [
"store", "brand", "category", "subCategory", "subSubCategory", "collection",
"type", "productName", "productId", "styleCode", "colour", "totalSale", "mrp",
"discount", "vat", "totalValue", "paymentType", "salesmanName"
];
// Get all keys from first item
@ritacse
ritacse / click event handler
Last active April 16, 2025 12:28
var BindreportDataToHTML = function () {
ReceiveSummary = _.chain(ReceiveSummary)
.sortBy('companyID')
.sortBy('purchaseIndentID')
.sortBy('itemID')
.value();
var html = '';
@ritacse
ritacse / NOCOUNT
Last active February 18, 2025 14:41
SET NOCOUNT ON;
--It's often used at the beginning of stored procedures and triggers.
--Benefits of SET NOCOUNT ON
--1.Reduces network traffic:
--2.Reduces processing
--Example:
ALTER PROCEDURE [dbo].[CheckUserMenuPermission]
@UserId INT,
@ritacse
ritacse / .Map object callback
Last active December 24, 2025 08:25
// ~~~~~ jQuery.map( object, callback )
//The function to process each item against. The first argument to the function is the array item,
//the second argument is the index in array the function can return any value. A returned array will be flattened into the resulting array.
o.LCItemList = ItemDetails.map(item => {
return {
childID: item.childID,
itemID: item.itemID,
quantity: item.quantity,
@ritacse
ritacse / gist:189090891a162b51c724efa99843a9de
Last active October 10, 2024 13:42
We couldn’t find that file to show.
@ritacse
ritacse / SP refresh to add new column
Last active April 11, 2023 05:41
1. change SP as per requirment
2. Field Explorer >> Right click on "Database fields" >> Select "Verify Database"
3. provide database connection, password & click "Finish" [database will be uptodate]
4. expand "Database fields">> command>> get your new column here
@ritacse
ritacse / thousand separator comma
Last active January 22, 2023 11:25
Convert.ToDouble("1234567.12345").ToString("N")
//If you want to control the decimal places you can do something like:
Convert.ToDouble("1234567.12345").ToString("N3") // 3decimal point
Convert.ToDouble("1234567.12345").ToString("N0") // int
or
(Int32.Parse("78956258")).ToString("N0")