//public JsonResult IndormedicinesalesDelete(IndorMedicineSalesVoucher tbv, IndorMedicineSalesDetails tbvd, string IndorMedicenSaleseVocherNo, int IndorMedicenSaleseId, decimal GrandTotalAmount) //{ // tbvd = db.IndorMedicineSalesDetails.FirstOrDefault(x => x.IndorMedicenSaleseId == IndorMedicenSaleseId); // db.IndorMedicineSalesDetails.Remove(tbvd); // db.SaveChanges(); // tbv = db.IndorMedicineSalesVouchers.FirstOrDefault(x => x.IndorMedicenSaleseVocherNo == IndorMedicenSaleseVocherNo); // 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); //} //..................Delete................ public ActionResult Delete(tbl_OutdorMedicineSalesVoucher tbv, tbl_OutdorMedicineSalesDetails tbvd, string OutdorMedicineSalesVoucherNo) { var info = (from item in db.tbl_OutdorMedicineSalesDetails where item.OutdorMedicineSalesVoucherNo == OutdorMedicineSalesVoucherNo select item).ToList(); if (info.Count > 1) { foreach (var vp in info) { db.tbl_OutdorMedicineSalesDetails.Remove(vp); } } else { if (OutdorMedicineSalesVoucherNo != null) { tbvd = db.tbl_OutdorMedicineSalesDetails.FirstOrDefault(x => x.OutdorMedicineSalesVoucherNo == OutdorMedicineSalesVoucherNo); db.tbl_OutdorMedicineSalesDetails.Remove(tbvd); } } db.SaveChanges(); tbv = db.tbl_OutdorMedicineSalesVoucher.FirstOrDefault(x => x.OutdorMedicineSalesVoucherNo == OutdorMedicineSalesVoucherNo); db.tbl_OutdorMedicineSalesVoucher.Remove(tbv); db.SaveChanges(); return(RedirectToAction("outdorMedicineSalesList")); }
public JsonResult OutDoorMedicineSalesUpdate(tbl_OutdorMedicineSalesVoucher tbv, tbl_OutdorMedicineSalesDetails tbvd, string OutdorMedicineSalesVoucherNo, string OutdorPatientName, decimal TotalAmount, decimal VatAmount, decimal DiscountAmount, decimal GrandTotalAmount, decimal PayAmount, decimal DueAmount, int OutdorMedicenSaleseId, int MediInfoID, decimal Rate, int Quantity, decimal Amount) { tbv = db.tbl_OutdorMedicineSalesVoucher.FirstOrDefault(x => x.OutdorMedicineSalesVoucherNo == OutdorMedicineSalesVoucherNo); tbv.OutdorPatientName = OutdorPatientName; tbv.TotalAmount = TotalAmount; tbv.VatAmount = VatAmount; tbv.DiscountAmount = DiscountAmount; tbv.GrandTotalAmount = GrandTotalAmount; tbv.PayAmount = PayAmount; tbv.DueAmount = DueAmount; db.SaveChanges(); tbvd = db.tbl_OutdorMedicineSalesDetails.FirstOrDefault(x => x.OutdorMedicenSaleseId == OutdorMedicenSaleseId); 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)); }