//............................Delete......................... public ActionResult Delete(tbl_IndorMedicenPurshaseVoucher tbv, tbl_IndorMedicinePurchaseDetails tbvd, string MedicinePurchaseVoucherNo) { var info = (from item in db.tbl_IndorMedicinePurchaseDetails where item.MedicinePurchaseVoucherNo == MedicinePurchaseVoucherNo select item).ToList(); if (info.Count > 1) { foreach (var vp in info) { db.tbl_IndorMedicinePurchaseDetails.Remove(vp); } } else { if (MedicinePurchaseVoucherNo != null) { tbvd = db.tbl_IndorMedicinePurchaseDetails.FirstOrDefault(x => x.MedicinePurchaseVoucherNo == MedicinePurchaseVoucherNo); db.tbl_IndorMedicinePurchaseDetails.Remove(tbvd); } } db.SaveChanges(); tbv = db.tbl_IndorMedicenPurshaseVoucher.FirstOrDefault(x => x.MedicinePurchaseVoucherNo == MedicinePurchaseVoucherNo); db.tbl_IndorMedicenPurshaseVoucher.Remove(tbv); db.SaveChanges(); return(RedirectToAction("IndorMedicinePurchaseList")); }
public JsonResult IndormedicinePurchaseDelete(tbl_IndorMedicenPurshaseVoucher tbv, tbl_IndorMedicinePurchaseDetails tbvd, string MedicinePurchaseVoucherNo, int MedicinePurchaseId, decimal GrandTotalAmount) { tbvd = db.tbl_IndorMedicinePurchaseDetails.FirstOrDefault(x => x.MedicinePurchaseId == MedicinePurchaseId); db.tbl_IndorMedicinePurchaseDetails.Remove(tbvd); db.SaveChanges(); tbv = db.tbl_IndorMedicenPurshaseVoucher.FirstOrDefault(x => x.MedicinePurchaseVoucherNo == MedicinePurchaseVoucherNo); tbv.GrandTotalAmount = tbv.GrandTotalAmount - GrandTotalAmount; tbv.PayAmount = 0; tbv.DueAmount = tbv.GrandTotalAmount; db.SaveChanges(); var jsonData = new { success = true, message = "Successfully Deleted." }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }
public JsonResult IndorMedicinePurchaseUpdate(tbl_IndorMedicenPurshaseVoucher tbv, tbl_IndorMedicinePurchaseDetails tbvd, string MedicinePurchaseVoucherNo, int MediSupplyerID, DateTime PurchaseDate, decimal GrandTotalAmount, decimal PayAmount, decimal DueAmount, int MedicinePurchaseId, int MediInfoID, decimal Rate, int Quantity, decimal Amount) { tbv = db.tbl_IndorMedicenPurshaseVoucher.FirstOrDefault(x => x.MedicinePurchaseVoucherNo == MedicinePurchaseVoucherNo); tbv.MediSupplyerID = MediSupplyerID; tbv.PurchaseDate = PurchaseDate; tbv.GrandTotalAmount = GrandTotalAmount; tbv.PayAmount = PayAmount; tbv.DueAmount = DueAmount; db.SaveChanges(); tbvd = db.tbl_IndorMedicinePurchaseDetails.FirstOrDefault(x => x.MedicinePurchaseId == MedicinePurchaseId); tbvd.MediInfoID = MediInfoID; tbvd.Rate = Rate; tbvd.Quantity = Quantity; tbvd.Amount = Amount; db.SaveChanges(); var jsonData = new { success = true, message = "Successfully Updated" }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }