public ActionResult Delete(tbl_IndorBloodSalesVoucher tbv, tbl_IndorBloodSalesDetails tbvd, string IndorBloodsalesVoucherNo)
{
var info = (from item in db.tbl_IndorBloodSalesDetails where item.IndorBloodsalesVoucherNo == IndorBloodsalesVoucherNo select item).ToList();
if (info.Count > 1)
{
foreach (var vp in info)
{
db.tbl_IndorBloodSalesDetails.Remove(vp);
}
}
else
{
if (IndorBloodsalesVoucherNo != null)
{
tbvd = db.tbl_IndorBloodSalesDetails.FirstOrDefault(x => x.IndorBloodsalesVoucherNo == IndorBloodsalesVoucherNo);
db.tbl_IndorBloodSalesDetails.Remove(tbvd);
}
}
db.SaveChanges();
tbv = db.tbl_IndorBloodSalesVoucher.FirstOrDefault(x => x.IndorBloodsalesVoucherNo == IndorBloodsalesVoucherNo);
db.tbl_IndorBloodSalesVoucher.Remove(tbv);
db.SaveChanges();
return(RedirectToAction("indorBloodsalesLists"));
}
public JsonResult IBloodSalesDelete(tbl_IndorBloodSalesVoucher tbv, tbl_IndorBloodSalesDetails tbvd, string IndorBloodsalesVoucherNo, int IndorBloodSalesID, decimal GrandTotalAmount)
{
tbvd = db.tbl_IndorBloodSalesDetails.FirstOrDefault(x => x.IndorBloodSalesID == IndorBloodSalesID);
db.tbl_IndorBloodSalesDetails.Remove(tbvd);
db.SaveChanges();
tbv = db.tbl_IndorBloodSalesVoucher.FirstOrDefault(x => x.IndorBloodsalesVoucherNo == IndorBloodsalesVoucherNo);
tbv.GrandTotalAmount = tbv.GrandTotalAmount - GrandTotalAmount;
tbv.PayAmount = 0;
tbv.DeuAmount = tbv.GrandTotalAmount;
db.SaveChanges();
var jsonData = new { success = true, message = "Successfully Deleted." };
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public JsonResult IndoorBloodsalesUpdate(tbl_IndorBloodSalesVoucher tbv, tbl_IndorBloodSalesDetails tbvd, string IndorBloodsalesVoucherNo, string BuyerName, decimal GrandTotalAmount, decimal PayAmount, decimal DeuAmount, int IndorBloodSalesID, int BloodID, int Quantity, decimal Rate, int MediUnitID, decimal TotalAmount)
{
tbv = db.tbl_IndorBloodSalesVoucher.FirstOrDefault(x => x.IndorBloodsalesVoucherNo == IndorBloodsalesVoucherNo);
tbv.BuyerName = BuyerName;
tbv.GrandTotalAmount = GrandTotalAmount;
tbv.PayAmount = PayAmount;
tbv.DeuAmount = DeuAmount;
db.SaveChanges();
tbvd = db.tbl_IndorBloodSalesDetails.FirstOrDefault(x => x.IndorBloodSalesID == IndorBloodSalesID);
tbvd.BloodID = BloodID;
tbvd.Quantity = Quantity;
tbvd.Rate = Rate;
tbvd.MediUnitID = MediUnitID;
tbvd.TotalAmount = TotalAmount;
db.SaveChanges();
var jsonData = new { success = true, message = "Successfully Updated" };
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
