//......................................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 ActionResult bloodpurchaseList(string keyword, tbl_BloodPurchaseVoucher blood) { var results = (from item in db.tbl_BloodPurchaseVoucher where item.tbl_BloodSupplierInfo.CompanyName.Contains(keyword) select item).ToList(); var pageIndex = blood.Page ?? 1; blood.bloodpurchaseListResults = results.ToPagedList(pageIndex, RecordsPerPage); return(View(blood)); }
public JsonResult indorBloodPurchaseProcess(tbl_BloodPurchaseVoucher o) { bool status = false; int vc; var MaxValue = (from item in db.tbl_BloodPurchaseVoucher select item.BloodPurchaseVoucherNo); if (MaxValue.Count() > 0) { vc = Convert.ToInt32(MaxValue.Max()) + 1; BloodPurchaseVoucherNo = vc.ToString("0000000000"); } else { BloodPurchaseVoucherNo = "0000000001"; } ViewBag.BloodPurchaseVoucherNo = BloodPurchaseVoucherNo; string userid = ""; string userSettings = ""; if (Request.Cookies["UserSettings"] != null) { if (Request.Cookies["UserSettings"]["UserName"] != null) { userSettings = Request.Cookies["UserSettings"]["UserName"]; userid = Request.Cookies["UserSettings"]["UserId"]; } } o.EntryDate = DateTime.Today; o.UserInfoID = Convert.ToInt32(userid); if (ModelState.IsValid) { tbl_BloodPurchaseVoucher fc = new tbl_BloodPurchaseVoucher { BloodPurchaseVoucherNo = BloodPurchaseVoucherNo, PurchaseDate = o.PurchaseDate, BloodSupplyerID = o.BloodSupplyerID, GrandTotalAmount = o.GrandTotalAmount, PayAmount = o.PayAmount, DueAmount = o.DueAmount, Remark = o.Remark, UserInfoID = o.UserInfoID, EntryDate = o.EntryDate, UpdateDate = o.UpdateDate }; foreach (var i in o.tbl_BloodPurchaseeDetails) { fc.tbl_BloodPurchaseeDetails.Add(i); } db.tbl_BloodPurchaseVoucher.Add(fc); status = true; } else { status = false; } db.SaveChanges(); ViewBag.UserInfoID = new SelectList(db.tbl_UserInfo, "UserInfoID", "UserName"); ViewBag.BloodSupplyerID = new SelectList(db.tbl_BloodSupplierInfo, "BloodSupplyerID", "CompanyName"); var jsonData = new { success = true, status = status, BloodPurchaseVoucherNo = BloodPurchaseVoucherNo }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }
public ActionResult VoucherEdit(tbl_BloodPurchaseVoucher tbv, string BloodPurchaseVoucherNo, ReferenceBloodPurchaseModel model) { ViewBag.BloodID = new SelectList(db.tbl_BloodGroup, "BloodID", "BloodName"); ViewBag.BloodSupplyerID = new SelectList(db.tbl_BloodSupplierInfo, "BloodSupplyerID", "CompanyName"); ViewBag.BloodPurchaseVoucherNo = BloodPurchaseVoucherNo; model.VoucherTbl = (from item in db.tbl_BloodPurchaseVoucher where item.BloodPurchaseVoucherNo == BloodPurchaseVoucherNo select item).ToList(); model.VoucherDetailsTbl = (from item in db.tbl_BloodPurchaseeDetails where item.BloodPurchaseVoucherNo == BloodPurchaseVoucherNo select item).ToList(); return(View(model)); }
//..................list....................... public ActionResult bloodpurchaseList(tbl_BloodPurchaseVoucher blood) { var results = (from item in db.tbl_BloodPurchaseVoucher select item).ToList().OrderBy(p => p.BloodPurchaseVoucherNo); var pageIndex = blood.Page ?? 1; blood.bloodpurchaseListResults = results.ToPagedList(pageIndex, RecordsPerPage); return(View(blood)); //return View(db.BloodPurchaseVouchers.ToList()); }
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)); }