public ActionResult Create(string id) { EHMSEntities ent = new EHMSEntities(); StockReturnInModel model = new StockReturnInModel(); model.ReturnInList = new List <StockReturnInModel>(); model.ReturnInDate = DateTime.Today; var objlist = (from ro in ent.StockReturnOuts join pm in ent.StockItemPurchases on ro.PurchaseId equals pm.ItemPurchaseId where ro.ReturnOutNo == id select new { ro, pm }).ToList(); foreach (var item in objlist) { StockReturnInModel obj = new StockReturnInModel(); obj.PurchaseId = item.ro.PurchaseId; obj.ReturnOutId = item.ro.ReturnOutId; obj.ItemId = item.ro.ItemId; obj.Remarks = item.ro.ReturnOutNo; obj.ReturnInId = item.pm.ItemBillNo; obj.ReturnInQty = item.ro.ReturnOutQty; model.ReturnInList.Add(obj); } return(View(model)); }
public ActionResult SaveReturnIn(StockReturnInModel model) { EHMSEntities ent = new EHMSEntities(); foreach (var item in model.ReturnInList) { if (item.ReturnInQty != 0) { StockReturnIn obj = new StockReturnIn(); var itemmaster = ent.StockItemMasters.Where(x => x.StockItemEntryId == item.ItemId).SingleOrDefault(); obj.ReturnOutId = item.ReturnOutId; obj.PurchaseId = item.PurchaseId; obj.ItemId = item.ItemId; obj.ReturnInQty = item.ReturnInQty; obj.ReturnInDate = model.ReturnInDate; obj.Remarks = model.Remarks; obj.Status = true; obj.CreatedBy = HospitalManagementSystem.Utility.GetCurrentLoginUserId(); obj.CreatedDate = DateTime.Today; ent.StockReturnIns.Add(obj); itemmaster.Quantity = itemmaster.Quantity + item.ReturnInQty; ent.Entry(itemmaster).State = System.Data.EntityState.Modified; } } ent.SaveChanges(); return(RedirectToAction("Index")); }
// // GET: /StockReturnIn/ public ActionResult Index() { EHMSEntities ent = new EHMSEntities(); StockReturnInModel model = new StockReturnInModel(); model.ReturnInList = new List <StockReturnInModel>(AutoMapper.Mapper.Map <IEnumerable <StockReturnIn>, IEnumerable <StockReturnInModel> >(ent.StockReturnIns.Where(x => x.Status == true))); return(View(model)); }
public ActionResult Create(int?returnoutno, DateTime?fromdate, DateTime?todate, int?SupplierId) { EHMSEntities ent = new EHMSEntities(); StockReturnInModel model = new StockReturnInModel(); model.ReturnInList = new List <StockReturnInModel>(); string df = fromdate.ToString(); string dt = todate.ToString(); string retoutno = returnoutno.ToString(); if (df != "" && dt != "") { DateTime dafr = Convert.ToDateTime(df); DateTime dto = Convert.ToDateTime(dt); var objlist = (from ro in ent.StockReturnOuts join pm in ent.StockItemPurchases on ro.PurchaseId equals pm.ItemPurchaseId where ro.ReturnOutDate >= dafr && ro.ReturnOutDate <= dto select new { ro, pm }).ToList(); foreach (var item in objlist) { StockReturnInModel obj = new StockReturnInModel(); obj.PurchaseId = item.ro.PurchaseId; obj.ReturnOutId = item.ro.ReturnOutId; obj.ItemId = item.ro.ItemId; obj.Remarks = item.pm.StockEntryNo; obj.ReturnInId = item.pm.ItemBillNo; obj.ReturnInQty = item.ro.ReturnOutQty; model.ReturnInList.Add(obj); } } else if (retoutno != "") { var objlist = (from ro in ent.StockReturnOuts join pm in ent.StockItemPurchases on ro.PurchaseId equals pm.ItemPurchaseId where ro.ReturnOutNo == retoutno select new { ro, pm }).ToList(); foreach (var item in objlist) { StockReturnInModel obj = new StockReturnInModel(); obj.PurchaseId = item.ro.PurchaseId; obj.ReturnOutId = item.ro.ReturnOutId; obj.ItemId = item.ro.ItemId; obj.Remarks = item.pm.StockEntryNo; obj.ReturnInId = item.pm.ItemBillNo; obj.ReturnInQty = item.ro.ReturnOutQty; model.ReturnInList.Add(obj); } } else { var objlist = (from ro in ent.StockReturnOuts join pm in ent.StockItemPurchases on ro.PurchaseId equals pm.ItemPurchaseId where ro.SupplierId == SupplierId select new { ro, pm }).ToList(); foreach (var item in objlist) { StockReturnInModel obj = new StockReturnInModel(); obj.PurchaseId = item.ro.PurchaseId; obj.ReturnOutId = item.ro.ReturnOutId; obj.ItemId = item.ro.ItemId; obj.Remarks = item.pm.StockEntryNo; obj.ReturnInId = item.pm.ItemBillNo; obj.ReturnInQty = item.ro.ReturnOutQty; model.ReturnInList.Add(obj); } } model.ReturnInDate = DateTime.Today; return(View(model)); }