//public JsonResult InvoiceDelete(InvoiceVocher tbv, InvoiceDetails tbvd, string InvoiceVoucherNo, int InvoiceID, decimal TotalAmount)
//{
// tbvd = db.InvoiceDetails.FirstOrDefault(x => x.InvoiceID == InvoiceID);
// db.InvoiceDetails.Remove(tbvd);
// db.SaveChanges();
// tbv = db.InvoiceVochers.FirstOrDefault(x => x.InvoiceVoucherNo == InvoiceVoucherNo);
// //tbv.GrandTotalAmount = tbv.GrandTotalAmount - GrandTotalAmount;
// //tbv.vat = 0;
// //tbv.Discount = tbv.GrandTotalAmount;
// tbv.TotalAmount = tbv.TotalAmount - TotalAmount;
// //tbv.vat = 0;
// //tbv.Discount = tbv.TotalAmount;
// db.SaveChanges();
// var jsonData = new { success = true, message = "Successfully Deleted." };
// return Json(jsonData, JsonRequestBehavior.AllowGet);
//}
//............Delete...........
public ActionResult Delete(tbl_InvoiceVocher tbv, tbl_InvoiceDetails tbvd, string InvoiceVoucherNo)
{
var info = (from item in db.tbl_InvoiceDetails where item.InvoiceVoucherNo == InvoiceVoucherNo select item).ToList();
if (info.Count > 1)
{
foreach (var vp in info)
{
db.tbl_InvoiceDetails.Remove(vp);
}
}
else
{
if (InvoiceVoucherNo != null)
{
tbvd = db.tbl_InvoiceDetails.FirstOrDefault(x => x.InvoiceVoucherNo == InvoiceVoucherNo);
db.tbl_InvoiceDetails.Remove(tbvd);
}
}
db.SaveChanges();
tbv = db.tbl_InvoiceVocher.FirstOrDefault(x => x.InvoiceVoucherNo == InvoiceVoucherNo);
db.tbl_InvoiceVocher.Remove(tbv);
db.SaveChanges();
return(RedirectToAction("Invoicelist"));
}
public JsonResult IvoiceUpdate(tbl_InvoiceVocher tbv, tbl_InvoiceDetails tbvd, string InvoiceVoucherNo, int PatientID, DateTime ReleaseDate, decimal TotalAmount, decimal vat, decimal Discount, decimal GrandTotalAmount, int InvoiceID, int ServiceId, float Amount)
{
tbv = db.tbl_InvoiceVocher.FirstOrDefault(x => x.InvoiceVoucherNo == InvoiceVoucherNo);
tbv.PatientID = PatientID;
tbv.ReleaseDate = ReleaseDate;
tbv.TotalAmount = TotalAmount;
tbv.vat = vat;
tbv.Discount = Discount;
tbv.GrandTotalAmount = GrandTotalAmount;
db.SaveChanges();
tbvd = db.tbl_InvoiceDetails.FirstOrDefault(x => x.InvoiceID == InvoiceID);
tbvd.ServiceId = ServiceId;
tbvd.Amount = Amount;
db.SaveChanges();
var jsonData = new { success = true, message = "Successfully Updated" };
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}