//public JsonResult IndormedicinesalesDelete(IndorMedicineSalesVoucher tbv, IndorMedicineSalesDetails tbvd, string IndorMedicenSaleseVocherNo, int IndorMedicenSaleseId, decimal GrandTotalAmount) //{ // tbvd = db.IndorMedicineSalesDetails.FirstOrDefault(x => x.IndorMedicenSaleseId == IndorMedicenSaleseId); // db.IndorMedicineSalesDetails.Remove(tbvd); // db.SaveChanges(); // tbv = db.IndorMedicineSalesVouchers.FirstOrDefault(x => x.IndorMedicenSaleseVocherNo == IndorMedicenSaleseVocherNo); // 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); //} //..................Delete................ public ActionResult Delete(tbl_OutdorMedicineSalesVoucher tbv, tbl_OutdorMedicineSalesDetails tbvd, string OutdorMedicineSalesVoucherNo) { var info = (from item in db.tbl_OutdorMedicineSalesDetails where item.OutdorMedicineSalesVoucherNo == OutdorMedicineSalesVoucherNo select item).ToList(); if (info.Count > 1) { foreach (var vp in info) { db.tbl_OutdorMedicineSalesDetails.Remove(vp); } } else { if (OutdorMedicineSalesVoucherNo != null) { tbvd = db.tbl_OutdorMedicineSalesDetails.FirstOrDefault(x => x.OutdorMedicineSalesVoucherNo == OutdorMedicineSalesVoucherNo); db.tbl_OutdorMedicineSalesDetails.Remove(tbvd); } } db.SaveChanges(); tbv = db.tbl_OutdorMedicineSalesVoucher.FirstOrDefault(x => x.OutdorMedicineSalesVoucherNo == OutdorMedicineSalesVoucherNo); db.tbl_OutdorMedicineSalesVoucher.Remove(tbv); db.SaveChanges(); return(RedirectToAction("outdorMedicineSalesList")); }
public ActionResult outdorMedicineSalesList(string keyword, tbl_OutdorMedicineSalesVoucher medicine) { var results = (from item in db.tbl_OutdorMedicineSalesVoucher where item.OutdorPatientName.Contains(keyword) select item).ToList(); var pageIndex = medicine.Page ?? 1; medicine.outdorMedicineSalesListResults = results.ToPagedList(pageIndex, RecordPerPages); return(View(medicine)); }
public ActionResult outdorMedicineSalesList(tbl_OutdorMedicineSalesVoucher medicine) { var results = (from item in db.tbl_OutdorMedicineSalesVoucher select item).ToList().OrderBy(i => i.OutdorMedicineSalesVoucherNo); var pageIndex = medicine.Page ?? 1; medicine.outdorMedicineSalesListResults = results.ToPagedList(pageIndex, RecordPerPages); return(View(medicine)); //return View(db.OutdorMedicineSalesVouchers.ToList()); }
public ActionResult OutDoorMedicineSalesEdit(tbl_OutdorMedicineSalesVoucher tbv, string OutdorMedicineSalesVoucherNo, ReferenceOutDoorMedicineSalesModel model) { ViewBag.UserInfoID = new SelectList(db.tbl_UserInfo, "UserInfoID", "UserName"); ViewBag.MediInfoID = new SelectList(db.tbl_MedicineInfo, "MediInfoID", "MediName"); ViewBag.OutdorMedicineSalesVoucherNo = OutdorMedicineSalesVoucherNo; model.OutdorMedicineSalesVoucherTbl = (from item in db.tbl_OutdorMedicineSalesVoucher where item.OutdorMedicineSalesVoucherNo == OutdorMedicineSalesVoucherNo select item).ToList(); model.OutdoorMedicinesalesDeltailsTbl = (from item in db.tbl_OutdorMedicineSalesDetails where item.OutdorMedicineSalesVoucherNo == OutdorMedicineSalesVoucherNo select item).ToList(); return(View(model)); }
public JsonResult OutdoorMedicineSalesProcess(tbl_OutdorMedicineSalesVoucher o) { bool status = false; int vc; var MaxValue = (from item in db.tbl_OutdorMedicineSalesVoucher select item.OutdorMedicineSalesVoucherNo); if (MaxValue.Count() > 0) { vc = Convert.ToInt32(MaxValue.Max()) + 1; OutdorMedicineSalesVoucherNo = vc.ToString("0000000000"); } else { OutdorMedicineSalesVoucherNo = "0000000001"; } ViewBag.OutdorMedicineSalesVoucherNo = OutdorMedicineSalesVoucherNo; 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_OutdorMedicineSalesVoucher fc = new tbl_OutdorMedicineSalesVoucher { OutdorMedicineSalesVoucherNo = OutdorMedicineSalesVoucherNo, OutdorPatientName = o.OutdorPatientName, InvoiceNo = o.InvoiceNo, TotalAmount = o.TotalAmount, VatAmount = o.VatAmount, DiscountAmount = o.DiscountAmount, GrandTotalAmount = o.GrandTotalAmount, PayAmount = o.PayAmount, DueAmount = o.DueAmount, PayDate = o.PayDate, UserInfoID = o.UserInfoID, EntryDate = o.EntryDate, UpdateDate = o.UpdateDate, Address = o.Address, MobNo = o.MobNo }; foreach (var i in o.tbl_OutdorMedicineSalesDetails) { fc.tbl_OutdorMedicineSalesDetails.Add(i); } db.tbl_OutdorMedicineSalesVoucher.Add(fc); status = true; } else { status = false; } db.SaveChanges(); ViewBag.UserInfoID = new SelectList(db.tbl_UserInfo, "UserInfoID", "UserName"); var jsonData = new { success = true, status = status, OutdorMedicineSalesVoucherNo = OutdorMedicineSalesVoucherNo }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }
public JsonResult OutDoorMedicineSalesUpdate(tbl_OutdorMedicineSalesVoucher tbv, tbl_OutdorMedicineSalesDetails tbvd, string OutdorMedicineSalesVoucherNo, string OutdorPatientName, decimal TotalAmount, decimal VatAmount, decimal DiscountAmount, decimal GrandTotalAmount, decimal PayAmount, decimal DueAmount, int OutdorMedicenSaleseId, int MediInfoID, decimal Rate, int Quantity, decimal Amount) { tbv = db.tbl_OutdorMedicineSalesVoucher.FirstOrDefault(x => x.OutdorMedicineSalesVoucherNo == OutdorMedicineSalesVoucherNo); tbv.OutdorPatientName = OutdorPatientName; tbv.TotalAmount = TotalAmount; tbv.VatAmount = VatAmount; tbv.DiscountAmount = DiscountAmount; tbv.GrandTotalAmount = GrandTotalAmount; tbv.PayAmount = PayAmount; tbv.DueAmount = DueAmount; db.SaveChanges(); tbvd = db.tbl_OutdorMedicineSalesDetails.FirstOrDefault(x => x.OutdorMedicenSaleseId == OutdorMedicenSaleseId); tbvd.MediInfoID = MediInfoID; tbvd.Rate = Rate; tbvd.Quantity = Quantity; tbvd.Amount = Amount; db.SaveChanges(); var jsonData = new { success = true, message = "Successfully Updated" }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }