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);
}