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