public static List <VoucherVM> LoadDEGrid(string leadId, string dealerCode)
{
List <VoucherVM> lst = new List <VoucherVM>();
ReceiptNo = leadId;
ds = new DataSet();
ds.Tables.Add();
ds.Tables[0].Columns.Add(new DataColumn("AccountCode", typeof(string)));
ds.Tables[0].Columns.Add(new DataColumn("AccountTitle", typeof(string)));
ds.Tables[0].Columns.Add(new DataColumn("Debit", typeof(string)));
ds.Tables[0].Columns.Add(new DataColumn("Credit", typeof(string)));
ds.Tables[0].Columns.Add(new DataColumn("Narration", typeof(string)));
SqlParameter[] dsParamInv =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5),
new SqlParameter("@ExpInvNo", SqlDbType.Char, 8)
};
dsParamInv[0].Value = dealerCode;
dsParamInv[1].Value = leadId;
totCredit = totDebit = 0;
DataSet dsReceipt = new DataSet();
dsReceipt = sysfun.FillDataSet("SP_DailyExpense_Voucher", dsParamInv);
if (dsReceipt.Tables[0].Rows.Count > 0)
{
//double ReceiptAmount = Convert.ToDouble(dsReceipt.Tables[0].Compute("SUM(InsAmount)", ""));
double ReceiptAmount = Convert.ToDouble(dsReceipt.Tables[0].Rows[0]["InsAmount"]);
string Naration = "Daily Expenditure No : " + dsReceipt.Tables[0].Rows[0]["ExpInvNo"].ToString().Trim() + " | " +
"Remarks : " + dsReceipt.Tables[0].Rows[0]["Remarks"].ToString().Trim();
AddDebitAmount(ReceiptAmount, "", Naration, dealerCode);
for (int i = 0; i < dsReceipt.Tables[0].Rows.Count; i++)
{
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5),
new SqlParameter("@ExpInvNo", SqlDbType.Char, 8),
new SqlParameter("@ExpFor", SqlDbType.Char, 8)
};
param[0].Value = dealerCode;
param[1].Value = leadId;
param[2].Value = dsReceipt.Tables[0].Rows[i]["ExpFor"].ToString();
DataSet dsServiceCharges = sysfun.FillDataSet("SP_GetExpenseHeadDetail", param);
string AccountCode = dsServiceCharges.Tables[0].Rows[0]["AccountCode"].ToString();
string VehExpDesc = dsServiceCharges.Tables[0].Rows[0]["EDesc"].ToString().Trim();
double Amount = Convert.ToDouble(dsServiceCharges.Tables[0].Rows[0]["Amount"]);
AddCreditAmount(Amount, AccountCode, Naration, VehExpDesc);
}
return(lst = EnumerableExtension.ToList <VoucherVM>(ds.Tables[0]));
}
return(lst);
}
public static List <VoucherVM> LoadGVGrid(string leadId, string dealerCode, string ChassisNo)
{
List <VoucherVM> lst = new List <VoucherVM>();
ReceiptNo = leadId;
//ReceiptNo = Session["leadId"];
ds = new DataSet();
ds.Tables.Add();
ds.Tables[0].Columns.Add(new DataColumn("AccountCode", typeof(string)));
ds.Tables[0].Columns.Add(new DataColumn("AccountTitle", typeof(string)));
ds.Tables[0].Columns.Add(new DataColumn("Debit", typeof(string)));
ds.Tables[0].Columns.Add(new DataColumn("Credit", typeof(string)));
ds.Tables[0].Columns.Add(new DataColumn("Narration", typeof(string)));
SqlParameter[] dsParamInv =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5),
new SqlParameter("@RecNo", SqlDbType.Char, 8),
new SqlParameter("@ChasisNo", SqlDbType.Char, 25)
};
dsParamInv[0].Value = dealerCode;
dsParamInv[1].Value = leadId;
dsParamInv[2].Value = ChassisNo;
totCredit = totDebit = 0;
DataSet dsReceipt = new DataSet();
dsReceipt = sysfun.FillDataSet("SP_Get_VehicleAccountCodeDetail", dsParamInv);
if (dsReceipt.Tables[0].Rows.Count > 0)
{
// string Customer = dsReceipt.Tables[0].Rows[0]["CusDesc"].ToString().Trim();
//DataRow[] dr = dsReceipt.Tables[0].Compute("SUM(ReceiptAmount)","");
double ReceiptAmount = Convert.ToDouble(dsReceipt.Tables[0].Compute("SUM(Amount)", ""));
//double ReceiptAmount = Convert.ToDouble(dsReceipt.Tables[0].Rows[0]["ReceiptAmount"]);
string Naration = "Type : " + dsReceipt.Tables[0].Rows[0]["Type"].ToString().Trim()
+ " | " + "Chassis No : " + dsReceipt.Tables[0].Rows[0]["ChasisNo"].ToString().Trim()
+ " | " + "Product : " + dsReceipt.Tables[0].Rows[0]["ProdDesc"].ToString().Trim();
string Acc = dsReceipt.Tables[0].Rows[0]["VehicleStock"].ToString().Trim();
AddDebitAmount(ReceiptAmount, Acc, Naration, dealerCode);
for (int i = 0; i < dsReceipt.Tables[0].Rows.Count; i++)
{
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5),
new SqlParameter("@RecNo", SqlDbType.Char, 8),
new SqlParameter("@ChasisNo", SqlDbType.Char, 25)
//new SqlParameter("@VehExpCode",SqlDbType.Char,8)
};
param[0].Value = dealerCode;
param[1].Value = leadId;
param[2].Value = ChassisNo;
DataSet dsServiceCharges = sysfun.FillDataSet("SP_Get_VehicleAccountCodeDetail", param);
string AccountCode = dsServiceCharges.Tables[0].Rows[0]["VendorPayable"].ToString();
string VehExpDesc = dsServiceCharges.Tables[0].Rows[0]["VendorDesc"].ToString().Trim();
double Amount = Convert.ToDouble(dsServiceCharges.Tables[0].Rows[0]["Amount"]);
AddCreditAmount(Amount, AccountCode, Naration, VehExpDesc);
}
return(lst = EnumerableExtension.ToList <VoucherVM>(ds.Tables[0]));
}
return(lst);
}
public static List <VoucherVM> LoadCSGrid(string leadId, string dealerCode, string ChassisNo, string VouchNo)
{
List <VoucherVM> lst = new List <VoucherVM>();
ReceiptNo = VouchNo;
ds = new DataSet();
ds.Tables.Add();
ds.Tables[0].Columns.Add(new DataColumn("AccountCode", typeof(string)));
ds.Tables[0].Columns.Add(new DataColumn("AccountTitle", typeof(string)));
ds.Tables[0].Columns.Add(new DataColumn("Debit", typeof(string)));
ds.Tables[0].Columns.Add(new DataColumn("Credit", typeof(string)));
ds.Tables[0].Columns.Add(new DataColumn("Narration", typeof(string)));
SqlParameter[] dsParamInv =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5),
new SqlParameter("@RceiptNo", SqlDbType.Char, 8)
};
dsParamInv[0].Value = dealerCode;
dsParamInv[1].Value = leadId;
totCredit = totDebit = 0;
DataSet dsReceipt = new DataSet();
dsReceipt = sysfun.FillDataSet("SP_Select_ReceiptDetail", dsParamInv);
if (dsReceipt.Tables[0].Rows.Count > 0)
{
string Customer = dsReceipt.Tables[0].Rows[0]["CusDesc"].ToString().Trim();
string ChasisNo = dsReceipt.Tables[0].Rows[0]["ChasisNo"].ToString().Trim();
string EngineNo = dsReceipt.Tables[0].Rows[0]["EngineNo"].ToString().Trim();
string InvoiceNo = dsReceipt.Tables[0].Rows[0]["InvoiceNo"].ToString().Trim();
//DataRow[] dr = dsReceipt.Tables[0].Compute("SUM(ReceiptAmount)","");
double ReceiptAmount = Convert.ToDouble(dsReceipt.Tables[0].Compute("SUM(ReceiptAmount)", ""));
//double ReceiptAmount = Convert.ToDouble(dsReceipt.Tables[0].Rows[0]["ReceiptAmount"]);
string Naration = "Sale Invoice : " + dsReceipt.Tables[0].Rows[0]["ReceiptNo"].ToString().Trim() + " | " +
"Customer : " + dsReceipt.Tables[0].Rows[0]["CusDesc"].ToString().Trim() + " | " +
"ChassisNo : " + ChasisNo;
string Account = dsReceipt.Tables[0].Rows[0]["AccountCode"].ToString().ToString();
AddCustomerDebitAmount(ReceiptAmount, Account, Customer, Naration);
for (int i = 0; i < dsReceipt.Tables[0].Rows.Count; i++)
{
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5),
new SqlParameter("@ReceiptNo", SqlDbType.Char, 8),
new SqlParameter("@VehExpCode", SqlDbType.Char, 8)
};
param[0].Value = dealerCode;
param[1].Value = leadId;
param[2].Value = dsReceipt.Tables[0].Rows[i]["VehExpCode"].ToString();
DataSet dsServiceCharges = sysfun.FillDataSet("SP_GetServiceAmountTemp", param);
string AccountCode = dsServiceCharges.Tables[0].Rows[0]["ServicesAccountCode"].ToString();
string VehExpDesc = dsServiceCharges.Tables[0].Rows[0]["VehExpDesc"].ToString().Trim();
double Amount = Convert.ToDouble(dsServiceCharges.Tables[0].Rows[0]["ReceiptAmount"]);
AddCreditAmount(Amount, AccountCode, Naration, VehExpDesc);
}
return(lst = EnumerableExtension.ToList <VoucherVM>(ds.Tables[0]));
}
return(lst);
}
public static List <VoucherVM> LoadCSI(string leadId, string dealerCode, string ChassisNo)
{
List <VoucherVM> lst = new List <VoucherVM>();
ReceiptNo = leadId;
//ReceiptNo = Session["leadId"];
ds = new DataSet();
ds.Tables.Add();
ds.Tables[0].Columns.Add(new DataColumn("AccountCode", typeof(string)));
ds.Tables[0].Columns.Add(new DataColumn("AccountTitle", typeof(string)));
ds.Tables[0].Columns.Add(new DataColumn("Debit", typeof(string)));
ds.Tables[0].Columns.Add(new DataColumn("Credit", typeof(string)));
ds.Tables[0].Columns.Add(new DataColumn("Narration", typeof(string)));
SqlParameter[] dsParamInv =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5),
new SqlParameter("@TransCode", SqlDbType.Char, 8),
new SqlParameter("@ChasisNo", SqlDbType.Char, 25)
};
dsParamInv[0].Value = dealerCode;
dsParamInv[1].Value = leadId;
dsParamInv[2].Value = ChassisNo;
ReceiptNo = leadId;
totCredit = totDebit = 0;
DataSet dsReceipt = new DataSet();
dsReceipt = sysfun.FillDataSet("SP_Get_VehicleSaleAccountCode", dsParamInv);
if (dsReceipt.Tables[0].Rows.Count > 0)
{
// string Customer = dsReceipt.Tables[0].Rows[0]["CusDesc"].ToString().Trim();
//DataRow[] dr = dsReceipt.Tables[0].Compute("SUM(ReceiptAmount)","");
double ReceiptAmount = Convert.ToDouble(dsReceipt.Tables[0].Compute("SUM(TotalAmount)", ""));
//double ReceiptAmount = Convert.ToDouble(dsReceipt.Tables[0].Rows[0]["ReceiptAmount"]);
string Naration = "Type : " + dsReceipt.Tables[0].Rows[0]["StockType"].ToString().Trim()
+ " | " + "Chassis No : " + dsReceipt.Tables[0].Rows[0]["ChassisNo"].ToString().Trim()
+ " | " + "Product : " + dsReceipt.Tables[0].Rows[0]["ProdDesc"].ToString().Trim();
string Acc = dsReceipt.Tables[0].Rows[0]["CusAccountCode"].ToString().Trim();
string CusDesc = dsReceipt.Tables[0].Rows[0]["CusDesc"].ToString().Trim();
string MarketRate = dsReceipt.Tables[0].Rows[0]["MarketRate"].ToString().Trim();
string Discount = dsReceipt.Tables[0].Rows[0]["Discount"].ToString().Trim();
string Own = dsReceipt.Tables[0].Rows[0]["OwnMoney"].ToString().Trim();
string DownMoney = dsReceipt.Tables[0].Rows[0]["DownMoney"].ToString().Trim();
string AccountCode = dsReceipt.Tables[0].Rows[0]["VendorPayable"].ToString();
string VendorDesc = dsReceipt.Tables[0].Rows[0]["VendorDesc"].ToString().Trim();
double SalePrice = Convert.ToDouble(dsReceipt.Tables[0].Rows[0]["FactoryPrice"]);
double market = Convert.ToDouble(MarketRate);
double discount = Convert.ToDouble(Discount);
if (market > 0)
{
AddCustomerDebitAmount(ReceiptAmount, Acc, CusDesc, Naration);
// AddCustomerDebitAmount(discount, DownMoney, "Down Money", Naration);
AddCreditAmount(SalePrice, AccountCode, Naration, VendorDesc);
AddCreditAmount(market, Own, Naration, "Own Money");
}
if (discount > 0)
{
AddCustomerDebitAmount(ReceiptAmount, Acc, CusDesc, Naration);
AddCustomerDebitAmount(discount, DownMoney, "Down Money", Naration);
AddCreditAmount(SalePrice, AccountCode, Naration, VendorDesc);
// AddCreditAmount(market, Own, Naration, "Own Money");
}
if (discount == 0 && market == 0)
{
AddCustomerDebitAmount(ReceiptAmount, Acc, CusDesc, Naration);
//AddCustomerDebitAmount(discount, DownMoney, "Down Money", Naration);
AddCreditAmount(SalePrice, AccountCode, Naration, VendorDesc);
// AddCreditAmount(market, Own, Naration, "Own Money");
}
return(lst = EnumerableExtension.ToList <VoucherVM>(ds.Tables[0]));
}
return(lst);
}
