public ActionResult FillOldBillDetails(int BillNo)
{
List <Purchase> obj1 = new List <Models.Pharmacy.Purchase>();
DataSet dsProductPurchaseReturn = new DataSet();
DataSet dsProductPurchaseReturnDetails = new DataSet();
int ProductPurchaseID = Convert.ToInt32(BillNo);
dsProductPurchaseReturn = objbl.GetProductPruchase1(BillNo);
dsProductPurchaseReturnDetails = objbl.GetProductPruchaseDetails(BillNo);
foreach (DataRow dr in dsProductPurchaseReturnDetails.Tables[0].Rows)
{
obj1.Add(new Models.Pharmacy.Purchase
{
//ProductPurchaseDetailID = dr["ProductPurchaseDetailID"].ToString(),
ProductPurchaseID = dr["ProductPurchaseID"].ToString(),
ProductID1 = dr["ProductID"].ToString(),
productName1 = dr["ProductName"].ToString(),
batchNumber1 = dr["BatchNo"].ToString(),
ProductDetailsID1 = dr["ProductDetailID"].ToString(),
expiry1 = dr["Expiry"].ToString(),
HSNSACCode1 = dr["HSNCode"].ToString(),
purchaseRate1 = dr["PurchaseRate"].ToString(),
mrp1 = dr["MRPRate"].ToString(),
salesRate1 = dr["SaleRate"].ToString(),
quantity1 = dr["Quantity"].ToString(),
free1 = dr["FreeQuantity"].ToString(),
TaxRate = dr["TaxRate"].ToString(),
discount1 = dr["DiscBy"].ToString(),
discountSymbol1 = dr["DiscountType"].ToString(),
lessBy1 = dr["LessBy"].ToString(),
lessBySymbol1 = dr["LessByType"].ToString(),
totalamount1 = dr["TotalAmount"].ToString(),
gst1 = dr["GST"].ToString(),
sgst1 = dr["SGST"].ToString(),
cgst1 = dr["CGST"].ToString(),
utgst1 = dr["UTGST"].ToString(),
});
}
if (dsProductPurchaseReturn.Tables[0].Rows.Count > 0)
{
objmodel.ProductPurchaseID = dsProductPurchaseReturn.Tables[0].Rows[0]["ProductPurchaseID"].ToString();
objmodel.ProductSupplierID = dsProductPurchaseReturn.Tables[0].Rows[0]["ProductSupplierID"].ToString();
objmodel.ProductSupplierName = dsProductPurchaseReturn.Tables[0].Rows[0]["SupplierName"].ToString();
objmodel.Address = dsProductPurchaseReturn.Tables[0].Rows[0]["Address"].ToString();
objmodel.SupplierRemark = dsProductPurchaseReturn.Tables[0].Rows[0]["SupplierRemark"].ToString();
objmodel.billDate = dsProductPurchaseReturn.Tables[0].Rows[0]["BillDate"].ToString();
objmodel.Date = dsProductPurchaseReturn.Tables[0].Rows[0]["Date"].ToString();
objmodel.DueDate = dsProductPurchaseReturn.Tables[0].Rows[0]["DueDate"].ToString();
objmodel.BillDiscountPercent = dsProductPurchaseReturn.Tables[0].Rows[0]["BillDiscountPercent"].ToString();
objmodel.BillNo = dsProductPurchaseReturn.Tables[0].Rows[0]["BillNo"].ToString();
objmodel.grossTotal = dsProductPurchaseReturn.Tables[0].Rows[0]["GrossAmount"].ToString();
objmodel.discountAmt = dsProductPurchaseReturn.Tables[0].Rows[0]["DiscountAmount"].ToString();
objmodel.taxAmount = dsProductPurchaseReturn.Tables[0].Rows[0]["TaxAmount"].ToString();
objmodel.totalAmount = dsProductPurchaseReturn.Tables[0].Rows[0]["TotalAmount"].ToString();
objmodel.lessCreditDebit = dsProductPurchaseReturn.Tables[0].Rows[0]["LessCrDr"].ToString();
objmodel.netAmount = dsProductPurchaseReturn.Tables[0].Rows[0]["NetAmount"].ToString();
objmodel.otherAdj = dsProductPurchaseReturn.Tables[0].Rows[0]["OtherAdg"].ToString();
objmodel.billAmount = dsProductPurchaseReturn.Tables[0].Rows[0]["BillAmount"].ToString();
objmodel.PurchaseTaxType = dsProductPurchaseReturn.Tables[0].Rows[0]["PurchaseTaxType"].ToString();
objmodel.PurchaseTax = dsProductPurchaseReturn.Tables[0].Rows[0]["PurchaseTax"].ToString();
objmodel.currentBalance = dsProductPurchaseReturn.Tables[0].Rows[0]["CurBalance"].ToString();
objmodel.BillType = dsProductPurchaseReturn.Tables[0].Rows[0]["BillType"].ToString();
objmodel.payment_type = dsProductPurchaseReturn.Tables[0].Rows[0]["PaymentType"].ToString();
objmodel.cheque = dsProductPurchaseReturn.Tables[0].Rows[0]["Number"].ToString();
objmodel.bankName = dsProductPurchaseReturn.Tables[0].Rows[0]["Name"].ToString();
objmodel.chequeDate = dsProductPurchaseReturn.Tables[0].Rows[0]["ChequeDate"].ToString();
objmodel.Remarks = dsProductPurchaseReturn.Tables[0].Rows[0]["Remarks"].ToString();
}
return(Json(new { obj1 = obj1, objmodel = objmodel }, JsonRequestBehavior.AllowGet));
}
