//public JsonResult AllowanceDelete(AllowanceVoucher tbv, AllowanceDetails tbvd, string AllowanceVocherNo, int AllowanceDetailId, decimal GrandTotalAmount) //{ // tbvd = db.AllowanceDetails.FirstOrDefault(x => x.AllowanceDetailId == AllowanceDetailId); // db.AllowanceDetails.Remove(tbvd); // db.SaveChanges(); // tbv = db.AllowanceVouchers.FirstOrDefault(x => x.AllowanceVocherNo == AllowanceVocherNo); // 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); //} //................Delet...................... public ActionResult Delete(tbl_AllowanceVoucher tbv, tbl_AllowanceDetails tbvd, string AllowanceVocherNo) { var info = (from item in db.tbl_AllowanceDetails where item.AllowanceVocherNo == AllowanceVocherNo select item).ToList(); if (info.Count > 1) { foreach (var vp in info) { db.tbl_AllowanceDetails.Remove(vp); } } else { if (AllowanceVocherNo != null) { tbvd = db.tbl_AllowanceDetails.FirstOrDefault(x => x.AllowanceVocherNo == AllowanceVocherNo); db.tbl_AllowanceDetails.Remove(tbvd); } } db.SaveChanges(); tbv = db.tbl_AllowanceVoucher.FirstOrDefault(x => x.AllowanceVocherNo == AllowanceVocherNo); db.tbl_AllowanceVoucher.Remove(tbv); db.SaveChanges(); return(RedirectToAction("AllowanceList")); }
public JsonResult AllowanceUpdate(tbl_AllowanceVoucher tbv, tbl_AllowanceDetails tbvd, string AllowanceVocherNo, int StaffID, decimal GrandTotalAmount, int AllowanceDetailId, int AllowanceID, decimal AllowanceAmount) { tbv = db.tbl_AllowanceVoucher.FirstOrDefault(x => x.AllowanceVocherNo == AllowanceVocherNo); tbv.StaffID = StaffID; tbv.GrandTotalAmount = GrandTotalAmount; //tbv.PayAmount = PayAmount; //tbv.DueAmount = DueAmount; db.SaveChanges(); tbvd = db.tbl_AllowanceDetails.FirstOrDefault(x => x.AllowanceDetailId == AllowanceDetailId); tbvd.AllowanceID = AllowanceID; tbvd.AllowanceAmount = AllowanceAmount; db.SaveChanges(); var jsonData = new { success = true, message = "Successfully Updated" }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }