public ActionResult Delete(tbl_IndorBloodSalesVoucher tbv, tbl_IndorBloodSalesDetails tbvd, string IndorBloodsalesVoucherNo) { var info = (from item in db.tbl_IndorBloodSalesDetails where item.IndorBloodsalesVoucherNo == IndorBloodsalesVoucherNo select item).ToList(); if (info.Count > 1) { foreach (var vp in info) { db.tbl_IndorBloodSalesDetails.Remove(vp); } } else { if (IndorBloodsalesVoucherNo != null) { tbvd = db.tbl_IndorBloodSalesDetails.FirstOrDefault(x => x.IndorBloodsalesVoucherNo == IndorBloodsalesVoucherNo); db.tbl_IndorBloodSalesDetails.Remove(tbvd); } } db.SaveChanges(); tbv = db.tbl_IndorBloodSalesVoucher.FirstOrDefault(x => x.IndorBloodsalesVoucherNo == IndorBloodsalesVoucherNo); db.tbl_IndorBloodSalesVoucher.Remove(tbv); db.SaveChanges(); return(RedirectToAction("indorBloodsalesLists")); }
public JsonResult IBloodSalesDelete(tbl_IndorBloodSalesVoucher tbv, tbl_IndorBloodSalesDetails tbvd, string IndorBloodsalesVoucherNo, int IndorBloodSalesID, decimal GrandTotalAmount) { tbvd = db.tbl_IndorBloodSalesDetails.FirstOrDefault(x => x.IndorBloodSalesID == IndorBloodSalesID); db.tbl_IndorBloodSalesDetails.Remove(tbvd); db.SaveChanges(); tbv = db.tbl_IndorBloodSalesVoucher.FirstOrDefault(x => x.IndorBloodsalesVoucherNo == IndorBloodsalesVoucherNo); tbv.GrandTotalAmount = tbv.GrandTotalAmount - GrandTotalAmount; tbv.PayAmount = 0; tbv.DeuAmount = tbv.GrandTotalAmount; db.SaveChanges(); var jsonData = new { success = true, message = "Successfully Deleted." }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }
public JsonResult IndoorBloodsalesUpdate(tbl_IndorBloodSalesVoucher tbv, tbl_IndorBloodSalesDetails tbvd, string IndorBloodsalesVoucherNo, string BuyerName, decimal GrandTotalAmount, decimal PayAmount, decimal DeuAmount, int IndorBloodSalesID, int BloodID, int Quantity, decimal Rate, int MediUnitID, decimal TotalAmount) { tbv = db.tbl_IndorBloodSalesVoucher.FirstOrDefault(x => x.IndorBloodsalesVoucherNo == IndorBloodsalesVoucherNo); tbv.BuyerName = BuyerName; tbv.GrandTotalAmount = GrandTotalAmount; tbv.PayAmount = PayAmount; tbv.DeuAmount = DeuAmount; db.SaveChanges(); tbvd = db.tbl_IndorBloodSalesDetails.FirstOrDefault(x => x.IndorBloodSalesID == IndorBloodSalesID); tbvd.BloodID = BloodID; tbvd.Quantity = Quantity; tbvd.Rate = Rate; tbvd.MediUnitID = MediUnitID; tbvd.TotalAmount = TotalAmount; db.SaveChanges(); var jsonData = new { success = true, message = "Successfully Updated" }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }