public void Update(DemandMasterModel model) { EHMSEntities ent = new EHMSEntities(); var obj = ent.ItemDemandMasters.Where(x => x.ItemDemandID == model.ItemDemandID).SingleOrDefault(); model.CreatedBy = obj.CreatedBy; model.CreatedDate = obj.CreatedDate; model.Status = obj.Status; AutoMapper.Mapper.Map(model, obj); ent.Entry(obj).State = System.Data.EntityState.Modified; foreach (var item in ent.ItemDemandDetails.Where(x => x.ItemDemandID == obj.ItemDemandID && x.DispatchStatus == false).ToList()) { ent.ItemDemandDetails.Remove(item); } foreach (var item in model.StockItemEntryList) { ItemDemandDetail demandDetail = new ItemDemandDetail(); demandDetail.ItemDemandID = obj.ItemDemandID; demandDetail.ItemID = item.StockItemEntryId; demandDetail.QuantityDemand = item.Quantity; demandDetail.DispatchStatus = false; demandDetail.Remarks = ""; ent.ItemDemandDetails.Add(demandDetail); } ent.SaveChanges(); }
public ActionResult Create(DemandMasterModel model) { var errors = ModelState.Values.SelectMany(v => v.Errors); if (model.StockItemEntryList == null || model.StockItemEntryList.Count == 0) { TempData["message"] = "Add Items!"; return(View(model)); } if (ModelState.IsValid) { try { // TODO: Add insert logic here pro.Insert(model); return(RedirectToAction("Index")); } catch (Exception e) { return(View(model)); } } else { return(View(model)); } }
public ActionResult Index() { DemandMasterModel model = new DemandMasterModel(); model.DemandMasterList = pro.GetList(); return(View(model)); }
// // GET: /Demand/Edit/5 public ActionResult Edit(int id) { DemandMasterModel model = new DemandMasterModel(); model = pro.GetDemandForEdit(id); return(View(model)); }
public ActionResult Index(int?id) { EHMSEntities ent = new EHMSEntities(); DemandMasterModel model = new DemandMasterModel(); model.ItemDemandNo = ent.ItemDemandMasters.Where(x => x.ItemDemandID == id).SingleOrDefault().ItemDemandNo; model.DemandMasterList = new List <DemandMasterModel>(); model.DemandDetailList = new List <DemandDetailModel>(AutoMapper.Mapper.Map <IEnumerable <ItemDemandDetail>, IEnumerable <DemandDetailModel> >(ent.ItemDemandDetails.Where(x => x.ItemDemandID == id && x.DispatchStatus == false))); if (model.DemandDetailList.Count == 0) { TempData["message"] = "Items not available!!"; return(RedirectToAction("Index", "Demand")); } try { var obj = ent.ItemAllotmentMasters.Where(x => x.ItemAllotmentMasterID == ent.ItemAllotmentMasters.Max(y => y.ItemAllotmentMasterID)).SingleOrDefault(); string[] nums = obj.ItemAllotmentNo.Split('N'); RecordNumGen rcnum = new RecordNumGen(nums[1]); model.ItemAllotmentNo = "AN" + rcnum.RecNumGen(); } catch (Exception e) { model.ItemAllotmentNo = "AN001"; } return(View(model)); }
public ActionResult DemandDetails(int id) { DemandMasterModel model = new DemandMasterModel(); model.DemandDetailList = pro.GetDemandDetails(id); return(View("Index", model)); }
public ActionResult Index() { EHMSEntities ent = new EHMSEntities(); DemandMasterModel model = new DemandMasterModel(); model.DemandMasterList = pro.GetList(); foreach (var item in model.DemandMasterList) { var c = ent.DemandPatientAssignments.Where(x => x.DemandId == item.ItemDemandID && x.Status == true).Count(); if (c == 0) { item.Orderer = "Assign Patients"; } else { item.Orderer = c + " Patient(s) Assigned"; } } return(View(model)); }
// // GET: /Demand/Create public ActionResult Create() { EHMSEntities ent = new EHMSEntities(); DemandMasterModel model = new DemandMasterModel(); try { var obj = ent.ItemDemandMasters.Where(x => x.ItemDemandID == ent.ItemDemandMasters.Max(y => y.ItemDemandID)).SingleOrDefault(); string[] nums = obj.ItemDemandNo.Split('N'); RecordNumGen rcnum = new RecordNumGen(nums[1]); model.ItemDemandNo = "DN" + rcnum.RecNumGen(); } catch (Exception e) { model.ItemDemandNo = "DN001"; } model.DemandDate = DateTime.Today; return(View(model)); }
public void Insert(DemandMasterModel model) { EHMSEntities ent = new EHMSEntities(); var objToSave = AutoMapper.Mapper.Map <DemandMasterModel, ItemDemandMaster>(model); objToSave.CreatedBy = 1; objToSave.CreatedDate = DateTime.Now; objToSave.Status = true; objToSave.DepartmentID = 1; ent.ItemDemandMasters.Add(objToSave); ent.SaveChanges(); foreach (var item in model.StockItemEntryList) { ItemDemandDetail demandDetail = new ItemDemandDetail(); demandDetail.ItemDemandID = ent.ItemDemandMasters.OrderByDescending(x => x.ItemDemandID).FirstOrDefault().ItemDemandID; demandDetail.ItemID = item.StockItemEntryId; demandDetail.QuantityDemand = item.Quantity; demandDetail.DispatchStatus = false; demandDetail.Remarks = ""; ent.ItemDemandDetails.Add(demandDetail); } ent.SaveChanges(); }
public DemandMasterModel GetDemandForEdit(int id) { EHMSEntities ent = new EHMSEntities(); DemandMasterModel model = new DemandMasterModel(); var obj = ent.ItemDemandMasters.Where(x => x.ItemDemandID == id).SingleOrDefault(); AutoMapper.Mapper.Map(obj, model); var demandDetails = ent.ItemDemandDetails.Where(x => x.ItemDemandID == id).ToList(); foreach (var item in demandDetails) { if (item.DispatchStatus == false) { StockItemEntry itemEntry = new StockItemEntry(); itemEntry.StockCategoryId = ent.SetupStockItemEntries.Where(x => x.StockItemEntryId == item.ItemID).SingleOrDefault().StockCategoryId; itemEntry.StockSubCategoryId = ent.SetupStockItemEntries.Where(x => x.StockItemEntryId == item.ItemID).SingleOrDefault().StockSubCategoryId; itemEntry.StockItemEntryId = item.ItemID; itemEntry.Quantity = item.QuantityDemand; model.StockItemEntryList.Add(itemEntry); } } return(model); }
public void Insert(DemandMasterModel model) { EHMSEntities ent = new EHMSEntities(); var objToSave = AutoMapper.Mapper.Map <DemandMasterModel, ItemDemandMaster>(model); objToSave.CreatedBy = 1; objToSave.CreatedDate = DateTime.Now; objToSave.Status = true; objToSave.DepartmentID = HospitalManagementSystem.Utility.GetCurrentUserDepartmentId(); ent.ItemDemandMasters.Add(objToSave); ent.SaveChanges(); foreach (var item in model.StockItemEntryList) { ItemDemandDetail demandDetail = new ItemDemandDetail(); demandDetail.ItemDemandID = objToSave.ItemDemandID; demandDetail.ItemID = item.StockItemEntryId; demandDetail.QuantityDemand = item.Quantity; demandDetail.DispatchStatus = false; demandDetail.Remarks = ""; ent.ItemDemandDetails.Add(demandDetail); } ent.SaveChanges(); }
public ActionResult Edit(int id, DemandMasterModel model) { if (model.StockItemEntryList == null || model.StockItemEntryList.Count == 0) { return(View(model)); } if (ModelState.IsValid) { try { // TODO: Add update logic here pro.Update(model); return(RedirectToAction("Index")); } catch { return(View(model)); } } else { return(View(model)); } }
public string Insert(DemandMasterModel model) { int flag = 0; string s = ""; EHMSEntities ent = new EHMSEntities(); ItemAllotmentMaster master = new ItemAllotmentMaster(); master.ItemDemandID = model.DemandDetailList[0].ItemDemandID; master.AllotmentDate = (DateTime)model.AllotmentDate; master.Orderer = model.Orderer; master.OrdererPost = model.OrdererPost; master.CreatedBy = 1; master.CreatedDate = DateTime.Now; master.Status = true; master.ItemAllotmentNo = model.ItemAllotmentNo; ent.ItemAllotmentMasters.Add(master); ent.SaveChanges(); foreach (var item in model.DemandDetailList) { if (item.CancellationStatus == false) { ItemAllotmentDetail detail = new ItemAllotmentDetail(); DepartmentWiseStock depStock = new DepartmentWiseStock(); int did = HospitalManagementSystem.Utility.GetCurrentUserDepartmentId(); var stockItem = ent.StockItemMasters.Where(x => x.StockItemEntryId == item.ItemID).SingleOrDefault(); detail.ItemAllotmentMasterID = master.ItemAllotmentMasterID; detail.ItemID = item.ItemID; detail.QuantityIssued = item.QuantityIssued; detail.QuantityRemained = item.QuantityDemand - item.QuantityIssued; detail.SourceFrom = item.SourceFrom; detail.CancellationStatus = item.CancellationStatus; detail.Remarks = item.Remarks; detail.Status = true; depStock.DepartmentID = ent.ItemDemandMasters.Where(x => x.ItemDemandID == master.ItemDemandID).SingleOrDefault().DepartmentID; depStock.ItemId = item.ItemID; depStock.Quantity = item.QuantityIssued; depStock.CreatedBy = HospitalManagementSystem.Utility.GetCurrentLoginUserId(); depStock.CreatedDate = DateTime.Today; if ((item.QuantityIssued > item.QuantityDemand) || (item.SourceFrom == 1 && item.QuantityIssued > stockItem.Quantity)) { s = "Quantity issued is greater than that availabe in stock OR Quantity Demanded!"; } else { flag = 1; var demandDetail = ent.ItemDemandDetails.Where(x => x.ItemDemandDetailId == item.ItemDemandDetailId).SingleOrDefault(); demandDetail.DispatchStatus = true; stockItem = ent.StockItemMasters.Where(x => x.StockItemEntryId == item.ItemID).SingleOrDefault(); stockItem.Quantity = (item.SourceFrom == 1) ? (stockItem.Quantity - item.QuantityIssued) : stockItem.Quantity; ent.ItemAllotmentDetails.Add(detail); if (ent.DepartmentWiseStocks.Where(x => x.DepartmentID == did && x.ItemId == item.ItemID).Any()) { var obj = ent.DepartmentWiseStocks.Where(x => x.DepartmentID == did && x.ItemId == item.ItemID).SingleOrDefault(); obj.Quantity = obj.Quantity + item.QuantityIssued; ent.Entry(obj).State = System.Data.EntityState.Modified; } else { ent.DepartmentWiseStocks.Add(depStock); } ent.Entry(demandDetail).State = System.Data.EntityState.Modified; ent.Entry(stockItem).State = System.Data.EntityState.Modified; ent.SaveChanges(); } } else { var demandDetail = ent.ItemDemandDetails.Where(x => x.ItemDemandDetailId == item.ItemDemandDetailId).SingleOrDefault(); demandDetail.DispatchStatus = item.isSelected == true ? false : true; ent.Entry(demandDetail).State = System.Data.EntityState.Modified; ent.SaveChanges(); } } if (flag != 1) { EHMSEntities ent1 = new EHMSEntities(); var obj = ent1.ItemAllotmentMasters.OrderByDescending(x => x.ItemAllotmentMasterID).FirstOrDefault(); ent1.ItemAllotmentMasters.Remove(obj); ent1.SaveChanges(); } return(s); }
public ActionResult DemandItemList() { DemandMasterModel model = new DemandMasterModel(); return(PartialView("DemandItemList")); }
public ActionResult Index(DemandMasterModel model) { EHMSEntities ent = new EHMSEntities(); string s = ""; //ViewBag.datef = datefrom; //ViewBag.datet = dateto; //ViewBag.dmdno = demandno; //if (saveDetails != null) //{ // if (demandno == "") // { // model.DemandMasterList = pro.GetCustomDemandList(model.DepartmentID, datefrom, dateto); // } foreach (var item in model.DemandDetailList) { if (item.CancellationStatus == false && item.isSelected == false && item.QuantityIssued == 0) { TempData["message"] = "Enter quantity to be dispatched!"; return(View(model)); } } s = proA.Insert(model); if (s != "") { TempData["message"] = s; foreach (var item in model.DemandDetailList) { if (ent.ItemDemandDetails.Any(x => x.ItemID == item.ItemID && x.ItemDemandID == item.ItemDemandID && x.DispatchStatus == true)) { model.DemandDetailList = model.DemandDetailList.Where(x => x.ItemID != item.ItemID && x.ItemDemandID != item.ItemDemandID).ToList(); } } return(View(model)); } if (model.isSelected == true) { StockPurchaseOrderModel purchasemodel = new StockPurchaseOrderModel(); purchasemodel.StockPurchaseItemEntryList = new List <StockPurchaseItemEntry>(); foreach (var item in model.DemandDetailList) { if (item.isSelected == true) { StockPurchaseItemEntry itementry = new StockPurchaseItemEntry(); var obj = ent.SetupStockItemEntries.Where(x => x.StockItemEntryId == item.ItemID).SingleOrDefault(); itementry.StockCategoryId = obj.StockCategoryId; itementry.StockSubCategoryId = obj.StockSubCategoryId; itementry.StockItemEntryId = obj.StockItemEntryId; purchasemodel.StockPurchaseItemEntryList.Add(itementry); } } Session["purchaseitementrylist"] = purchasemodel.StockPurchaseItemEntryList; return(RedirectToAction("CreateView", "StockPurchaseOrder")); } //} //model.DemandDetailList = new List<DemandDetailModel>(); //if (demandno != "") //{ // var objList = (from dd in ent.ItemDemandDetail // join dm in ent.ItemDemandMaster // on dd.ItemDemandID equals dm.ItemDemandID // where dm.ItemDemandNo == demandno && dd.DispatchStatus == false // select dd).ToList(); // try // { // int i = objList[0].ItemDemandID; // model.ItemDemandNo = ent.ItemDemandMaster.Where(x => x.ItemDemandID == i).SingleOrDefault().ItemDemandNo; // AutoMapper.Mapper.Map(objList, model.DemandDetailList); // } // catch { } // try // { // string num = ent.ItemAllotmentMaster.Max(x => x.ItemAllotmentNo); // string[] nums = num.Split('N'); // RecordNumGen rcnum = new RecordNumGen(nums[1]); // model.ItemAllotmentNo = "AN" + rcnum.RecNumGen(); // } // catch (Exception e) // { // model.ItemAllotmentNo = "AN001"; // } //} //else //{ // model.DemandMasterList = pro.GetCustomDemandList(model.DepartmentID, datefrom, dateto); // if (DemandId != "") // { // model.DemandDetailList = pro.GetCDemandDetails(Convert.ToInt32(DemandId)); // try // { // int i = model.DemandDetailList[0].ItemDemandID; // model.ItemDemandNo = ent.ItemDemandMaster.Where(x => x.ItemDemandID == i).SingleOrDefault().ItemDemandNo; // } // catch { } // try // { // string num = ent.ItemAllotmentMaster.Max(x => x.ItemAllotmentNo); // string[] nums = num.Split('N'); // RecordNumGen rcnum = new RecordNumGen(nums[1]); // model.ItemAllotmentNo = "AN" + rcnum.RecNumGen(); // } // catch (Exception e) // { // model.ItemAllotmentNo = "AN001"; // } // } //} return(RedirectToAction("AllotmentMaster")); }