public ActionResult AddReturnItem() { var model = new INV_IssueReturnViewModal(); ViewBag.IssueReturnByUserID = new SelectList(db.SEC_User, "UserID", "UserName", model.IssueReturnByUserID); ViewData["errorReturn"] = TempData["errorReturn"]; return(View(model)); }
// GET: INV_PurchaseOrder/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } INV_IssueReturnViewModal _iNV_IssueReturnViewModal = new INV_IssueReturnViewModal(); INV_IssueReturn IssueReturnData = db.INV_IssueReturn.Find(id); _iNV_IssueReturnViewModal.IssueReturnNo = IssueReturnData.IssueReturnNo; _iNV_IssueReturnViewModal.IssueReturnItems = db.INV_StockHistory.Where(w => w.IssueNumber == IssueReturnData.IssueReturnNo).ToList(); return(View(_iNV_IssueReturnViewModal)); }
public ActionResult RertunNewItem(INV_IssueReturnViewModal iNV_IssueReturnViewModal) { try { if (iNV_IssueReturnViewModal.IssueReturnItems.Count <= 0) { TempData["errorReturn"] = "Select Item."; return(View(iNV_IssueReturnViewModal)); } #region Generate IssueReturnNo String _NewIssueReturnNo = CommonConfig.GetNextNumber("Return"); #endregion Generate IssueReturnNo INV_IssueReturn iNV_IssueReturn = new INV_IssueReturn(); iNV_IssueReturn.CompanyID = CommonConfig.GetCompanyID(); if (Session["UserID"] != null) { iNV_IssueReturn.IssueReturnByUserID = Convert.ToInt16(Session["UserID"].ToString()); } iNV_IssueReturn.IssueReturnToUserID = iNV_IssueReturnViewModal.IssueReturnToUserID; iNV_IssueReturn.Created = DateTime.Now; iNV_IssueReturn.Modified = DateTime.Now; iNV_IssueReturn.Remarks = "Return"; iNV_IssueReturn.IssueReturnDate = DateTime.Now; iNV_IssueReturn.IssueReturnNo = _NewIssueReturnNo; iNV_IssueReturn.FinYearID = CommonConfig.GetFinYearID(); iNV_IssueReturn.ReturnIssueNo = iNV_IssueReturnViewModal.IssueReturnNo; db.INV_IssueReturn.Add(iNV_IssueReturn); //db.SaveChanges(); string Err = ""; TempData["errorReturn"] = ""; if (iNV_IssueReturnViewModal.IssueReturnItems != null) { foreach (var item in iNV_IssueReturnViewModal.IssueReturnItems) { INV_Item inv_Item = new INV_Item(); inv_Item = db.INV_Item.Where(i => i.ItemID == item.ItemID).FirstOrDefault(); INV_StockHistory _StockHistoryNew = new INV_StockHistory(); _StockHistoryNew = db.INV_StockHistory.Where(w => w.IssueNumber == iNV_IssueReturnViewModal.IssueReturnNo && w.ItemID == item.ItemID).FirstOrDefault(); List <INV_StockHistory> _receivedStockHistory = new List <INV_StockHistory>(); _receivedStockHistory = db.INV_StockHistory.Where(w => w.IssueNumber == iNV_IssueReturnViewModal.IssueReturnNo && w.ItemID == item.ItemID && w.Remarks == "Return" && w.OperationTypeID == 9).ToList(); if (_StockHistoryNew != null) { if (_StockHistoryNew.Quantity < (item.Quantity + _receivedStockHistory.Sum(i => i.Quantity))) { if (Err == "") { Err = Err + "You can not return more than issue. " + inv_Item.ItemName; } else { Err = Err + ", You can not return more than issue. " + inv_Item.ItemName; } } } if (Session["UserID"] != null) { item.UserID = Convert.ToInt16(Session["UserID"].ToString()); } INV_StockHistory new_INV_StockHistory = new INV_StockHistory(); new_INV_StockHistory.ItemID = item.ItemID; new_INV_StockHistory.OperationTypeID = 9; new_INV_StockHistory.ReferenceID = _NewIssueReturnNo; new_INV_StockHistory.Quantity = item.Quantity; new_INV_StockHistory.UserID = item.UserID; new_INV_StockHistory.Created = DateTime.Now; new_INV_StockHistory.Modified = DateTime.Now; new_INV_StockHistory.Remarks = "Return"; new_INV_StockHistory.FinYearID = CommonConfig.GetFinYearID(); new_INV_StockHistory.IssueNumber = iNV_IssueReturnViewModal.IssueReturnNo; new_INV_StockHistory.ReturnNumber = _NewIssueReturnNo; db.INV_StockHistory.Add(new_INV_StockHistory); if (iNV_IssueReturnViewModal.IsRejected) { //inv_Item.Quantity = Convert.ToInt32(inv_Item.RejectedQuantity) + item.Quantity; if (inv_Item.RejectedQuantity == null) { inv_Item.RejectedQuantity = item.Quantity; } else { inv_Item.RejectedQuantity = inv_Item.RejectedQuantity + item.Quantity; } } else { inv_Item.Quantity = inv_Item.Quantity + item.Quantity; } } if (Err != "") { TempData["errorReturn"] = Err; ViewData["errorReturn"] = TempData["errorReturn"]; return(View(iNV_IssueReturnViewModal)); } db.SaveChanges(); } } catch (Exception exception) { //exception handiling } return(Json("failure", JsonRequestBehavior.AllowGet)); }
public ActionResult SaveForAssmeble(INV_IssueReturnViewModal iNV_IssueReturnViewModal) { try { if (iNV_IssueReturnViewModal.IssueReturnItems.Count <= 0) { TempData["errorIssue"] = "Select Item."; return(View(iNV_IssueReturnViewModal)); } #region Generate IssueReturnNo String _NewIssueReturnNo = CommonConfig.GetNextNumber("Issue"); #endregion Generate IssueReturnNo INV_IssueReturn iNV_IssueReturn = new INV_IssueReturn(); if (Session["UserID"] != null) { iNV_IssueReturn.IssueReturnByUserID = Convert.ToInt16(Session["UserID"].ToString()); } iNV_IssueReturn.CompanyID = CommonConfig.GetCompanyID(); iNV_IssueReturn.IssueReturnToUserID = iNV_IssueReturnViewModal.IssueReturnToUserID; iNV_IssueReturn.Created = DateTime.Now; iNV_IssueReturn.Modified = DateTime.Now; iNV_IssueReturn.Remarks = "Issue for Assemble"; iNV_IssueReturn.IssueReturnDate = DateTime.Now; iNV_IssueReturn.IssueReturnNo = _NewIssueReturnNo; iNV_IssueReturn.FinYearID = CommonConfig.GetFinYearID(); db.INV_IssueReturn.Add(iNV_IssueReturn); db.SaveChanges(); string Err = ""; TempData["errorIssue"] = ""; if (iNV_IssueReturnViewModal.IssueReturnItems != null) { foreach (var item in iNV_IssueReturnViewModal.IssueReturnItems) { INV_Item inv_Item = new INV_Item(); inv_Item = db.INV_Item.Where(i => i.ItemID == item.ItemID).FirstOrDefault(); if (inv_Item.Quantity - item.Quantity < 0) { if (Err == "") { Err = Err + "Check Stock for " + inv_Item.ItemName; } else { Err = Err + ", Check Stock for " + inv_Item.ItemName; } } if (Session["UserID"] != null) { item.UserID = Convert.ToInt16(Session["UserID"].ToString()); } INV_StockHistory new_INV_StockHistory = new INV_StockHistory(); new_INV_StockHistory.ItemID = item.ItemID; new_INV_StockHistory.OperationTypeID = 8; new_INV_StockHistory.ReferenceID = _NewIssueReturnNo; new_INV_StockHistory.Quantity = item.Quantity; new_INV_StockHistory.UserID = item.UserID; new_INV_StockHistory.Created = DateTime.Now; new_INV_StockHistory.Modified = DateTime.Now; new_INV_StockHistory.Remarks = "Issue"; new_INV_StockHistory.FinYearID = CommonConfig.GetFinYearID(); new_INV_StockHistory.IssueNumber = _NewIssueReturnNo; db.INV_StockHistory.Add(new_INV_StockHistory); inv_Item.Quantity = inv_Item.Quantity - item.Quantity; } if (Err != "") { TempData["errorIssue"] = Err; return(View(iNV_IssueReturnViewModal)); } db.SaveChanges(); } } catch (Exception exception) { //exception handiling } return(Json("failure", JsonRequestBehavior.AllowGet)); }