// // GET: /ReturnInOut/Details/5 public ActionResult Details(string id) { EHMSEntities ent = new EHMSEntities(); StockReturnOutModel model = new StockReturnOutModel(); model.ReturnOutList = new List <StockReturnOutModel>(AutoMapper.Mapper.Map <IEnumerable <StockReturnOut>, IEnumerable <StockReturnOutModel> >(ent.StockReturnOuts.Where(x => x.Status == true && x.ReturnOutNo == id))); return(View(model)); }
// // GET: /ReturnInOut/ public ActionResult Index() { EHMSEntities ent = new EHMSEntities(); StockReturnOutModel model = new StockReturnOutModel(); StockReturnOutModel model2 = new StockReturnOutModel(); model2.ReturnOutList = new List <StockReturnOutModel>(); model.ReturnOutList = new List <StockReturnOutModel>(AutoMapper.Mapper.Map <IEnumerable <StockReturnOut>, IEnumerable <StockReturnOutModel> >(ent.StockReturnOuts.Where(x => x.Status == true))); foreach (var item in model.ReturnOutList) { if (model2.ReturnOutList.Any(s => s.ReturnOutNo == item.ReturnOutNo) == false) { model2.ReturnOutList.Add(item); } } model.ReturnOutList = model2.ReturnOutList; return(View(model)); }
// // GET: /ReturnInOut/Create public ActionResult Create() { EHMSEntities ent = new EHMSEntities(); StockReturnOutModel model = new StockReturnOutModel(); model.ReturnOutDate = DateTime.Today; try { var obj = ent.StockReturnOuts.Where(x => x.ReturnOutId == ent.StockReturnOuts.Max(y => y.ReturnOutId)).SingleOrDefault(); string[] nums = obj.ReturnOutNo.Split('O'); RecordNumGen rcnum = new RecordNumGen(nums[1]); model.ReturnOutNo = "RO" + rcnum.RecNumGen(); } catch (Exception e) { model.ReturnOutNo = "RO001"; } return(View(model)); }
public ActionResult Create(StockReturnOutModel model) { EHMSEntities ent = new EHMSEntities(); try { // TODO: Add insert logic here foreach (var item in model.ReturnOutList) { if (item.ReturnOutQty != 0) { StockReturnOut obj = new StockReturnOut(); var objitem = ent.StockItemMasters.Where(x => x.StockItemEntryId == item.ItemId).SingleOrDefault(); obj.PurchaseId = item.PurchaseId; obj.PurchaseOrderNo = item.PurchaseOrderNo; obj.ItemId = item.ItemId; obj.ReturnOutQty = item.ReturnOutQty; obj.ReturnOutDate = model.ReturnOutDate; obj.SupplierId = item.SupplierId; obj.Remarks = model.Remarks; obj.ReturnOutNo = model.ReturnOutNo; obj.Status = true; obj.CreatedBy = HospitalManagementSystem.Utility.GetCurrentLoginUserId(); obj.CreatedDate = DateTime.Today; ent.StockReturnOuts.Add(obj); objitem.Quantity = objitem.Quantity - item.ReturnOutQty; ent.Entry(objitem).State = System.Data.EntityState.Modified; } } ent.SaveChanges(); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult SearchPurchase(string SupplierId, string PurchaseOrderNo, string stockentryno, string billno, string dateto, string fromdate) { EHMSEntities ent = new EHMSEntities(); StockReturnOutModel model = new StockReturnOutModel(); model.ReturnOutList = new List <StockReturnOutModel>(); if (dateto != "" && fromdate != "") { DateTime df = Convert.ToDateTime(fromdate); DateTime dt = Convert.ToDateTime(dateto); df = df.AddDays(-1); dt = dt.AddDays(1); var objlist = (from pm in ent.StockItemPurchases join pd in ent.StockItemPurchaseDetails on pm.ItemPurchaseId equals pd.ItemPurchaseId where pm.CreatedDate >= df && pm.CreatedDate <= dt select new { pm, pd }).ToList(); foreach (var item in objlist) { StockReturnOutModel obj = new StockReturnOutModel(); obj.ItemId = item.pd.StockItemEntryId; obj.PurchaseId = item.pd.ItemPurchaseId; obj.SupplierId = item.pm.StockSupplierId; obj.PurchaseOrderNo = item.pm.ItemOrderId; obj.ReturnOutQty = item.pd.Quantity; model.ReturnOutList.Add(obj); } } else if (PurchaseOrderNo != "") { var objlist = (from pm in ent.StockItemPurchases join pd in ent.StockItemPurchaseDetails on pm.ItemPurchaseId equals pd.ItemPurchaseId where pm.ItemOrderId == PurchaseOrderNo select new { pm, pd }).ToList(); foreach (var item in objlist) { StockReturnOutModel obj = new StockReturnOutModel(); obj.ItemId = item.pd.StockItemEntryId; obj.PurchaseId = item.pd.ItemPurchaseId; obj.SupplierId = item.pm.StockSupplierId; obj.PurchaseOrderNo = item.pm.ItemOrderId; obj.ReturnOutQty = item.pd.Quantity; model.ReturnOutList.Add(obj); } } else if (stockentryno != "") { var objlist = (from pm in ent.StockItemPurchases join pd in ent.StockItemPurchaseDetails on pm.ItemPurchaseId equals pd.ItemPurchaseId where pm.StockEntryNo == stockentryno select new { pm, pd }).ToList(); foreach (var item in objlist) { StockReturnOutModel obj = new StockReturnOutModel(); obj.ItemId = item.pd.StockItemEntryId; obj.PurchaseId = item.pd.ItemPurchaseId; obj.SupplierId = item.pm.StockSupplierId; obj.PurchaseOrderNo = item.pm.ItemOrderId; obj.ReturnOutQty = item.pd.Quantity; model.ReturnOutList.Add(obj); } } else if (billno != "") { int i = Convert.ToInt32(billno); var objlist = (from pm in ent.StockItemPurchases join pd in ent.StockItemPurchaseDetails on pm.ItemPurchaseId equals pd.ItemPurchaseId where pm.ItemBillNo == i select new { pm, pd }).ToList(); foreach (var item in objlist) { StockReturnOutModel obj = new StockReturnOutModel(); obj.ItemId = item.pd.StockItemEntryId; obj.PurchaseId = item.pd.ItemPurchaseId; obj.SupplierId = item.pm.StockSupplierId; obj.PurchaseOrderNo = item.pm.ItemOrderId; obj.ReturnOutQty = item.pd.Quantity; model.ReturnOutList.Add(obj); } } else { int i = Convert.ToInt32(SupplierId); var objlist = (from pm in ent.StockItemPurchases join pd in ent.StockItemPurchaseDetails on pm.ItemPurchaseId equals pd.ItemPurchaseId where pm.StockSupplierId == i select new { pm, pd }).ToList(); foreach (var item in objlist) { StockReturnOutModel obj = new StockReturnOutModel(); obj.ItemId = item.pd.StockItemEntryId; obj.PurchaseId = item.pd.ItemPurchaseId; obj.SupplierId = item.pm.StockSupplierId; obj.PurchaseOrderNo = item.pm.ItemOrderId; obj.ReturnOutQty = item.pd.Quantity; model.ReturnOutList.Add(obj); } } model.ReturnOutDate = DateTime.Today; try { string num = ent.StockReturnOuts.Max(x => x.ReturnOutNo); string[] nums = num.Split('O'); RecordNumGen rcnum = new RecordNumGen(nums[1]); model.ReturnOutNo = "RO" + rcnum.RecNumGen(); } catch (Exception e) { model.ReturnOutNo = "RO001"; } return(View("Create", model)); }