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