//......................................Delete.............................
public ActionResult Delete(tbl_BloodPurchaseVoucher tbv, tbl_BloodPurchaseeDetails tbvd, string BloodPurchaseVoucherNo)
{
var info = (from item in db.tbl_BloodPurchaseeDetails where item.BloodPurchaseVoucherNo == BloodPurchaseVoucherNo select item).ToList();
if (info.Count > 1)
{
foreach (var bpv in info)
{
db.tbl_BloodPurchaseeDetails.Remove(bpv);
}
}
else
{
if (BloodPurchaseVoucherNo != null)
{
tbvd = db.tbl_BloodPurchaseeDetails.FirstOrDefault(x => x.BloodPurchaseVoucherNo == BloodPurchaseVoucherNo);
db.tbl_BloodPurchaseeDetails.Remove(tbvd);
}
}
db.SaveChanges();
tbv = db.tbl_BloodPurchaseVoucher.FirstOrDefault(x => x.BloodPurchaseVoucherNo == BloodPurchaseVoucherNo);
db.tbl_BloodPurchaseVoucher.Remove(tbv);
db.SaveChanges();
return(RedirectToAction("bloodpurchaseList"));
}
public JsonResult VoucherDelete(tbl_BloodPurchaseVoucher tbv, tbl_BloodPurchaseeDetails tbvd, string BloodPurchaseVoucherNo, int BloodPurchaseID, decimal GrandTotalAmount)
{
tbvd = db.tbl_BloodPurchaseeDetails.FirstOrDefault(x => x.BloodPurchaseID == BloodPurchaseID);
db.tbl_BloodPurchaseeDetails.Remove(tbvd);
db.SaveChanges();
tbv = db.tbl_BloodPurchaseVoucher.FirstOrDefault(x => x.BloodPurchaseVoucherNo == BloodPurchaseVoucherNo);
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));
}
public JsonResult VoucherUpdate(tbl_BloodPurchaseVoucher tbv, tbl_BloodPurchaseeDetails tbvd, string BloodPurchaseVoucherNo, DateTime PurchaseDate, int BloodSupplyerID, decimal GrandTotalAmount, decimal PayAmount, decimal DueAmount, int BloodPurchaseID, int BloodID, decimal Rate, decimal Quantity, decimal Amount)
{
tbv = db.tbl_BloodPurchaseVoucher.FirstOrDefault(x => x.BloodPurchaseVoucherNo == BloodPurchaseVoucherNo);
tbv.PurchaseDate = PurchaseDate;
tbv.BloodSupplyerID = BloodSupplyerID;
tbv.GrandTotalAmount = GrandTotalAmount;
tbv.PayAmount = PayAmount;
tbv.DueAmount = DueAmount;
db.SaveChanges();
tbvd = db.tbl_BloodPurchaseeDetails.FirstOrDefault(x => x.BloodPurchaseID == BloodPurchaseID);
tbvd.BloodID = BloodID;
tbvd.Rate = Rate;
tbvd.Quantity = Quantity;
tbvd.Amount = Amount;
db.SaveChanges();
var jsonData = new { success = true, message = "Successfully Updated" };
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
