public ActionResult GetAllGridList(string CrustLeatherIssueID, string StoreId, string QCTransactionOf) { InvCrustLeatherIssue model = new InvCrustLeatherIssue(); if (string.IsNullOrEmpty(CrustLeatherIssueID)) { return(Json(model, JsonRequestBehavior.AllowGet)); } model.IssueItemList = Dalobject.GetQCColorList(CrustLeatherIssueID); if (model.IssueItemList.Count > 0) { model.IssueColorList = Dalobject.GetQCSelectionList(model.IssueItemList[0].CrustLeatherIssueItemID.ToString(), StoreId, QCTransactionOf); } return(Json(model, JsonRequestBehavior.AllowGet)); }
public ActionResult IssueAfterFinishQC(InvCrustLeatherIssue model) { _vmMsg = model.CrustLeatherIssueID == 0 ? Dalobject.Save(model, Convert.ToInt32(Session["UserID"]), "IssueAfterFinishQC/IssueAfterFinishQC") : Dalobject.Update(model, Convert.ToInt32(Session["UserID"])); //_vmMsg = model.CrustLeatherIssueID == 0 ? Dalobject.Save(model, Convert.ToInt32(Session["UserID"]), "CrustLeatherQC/CrustLeatherQC") : Dalobject.Update(model, Convert.ToInt32(Session["UserID"])); return(Json(new { CrustLeatherIssueID = Dalobject.GetQCID(), CrustLeatherQCNo = Dalobject.GetQCNo(), msg = _vmMsg })); }
public ActionResult ConfirmedAfterCrustQC(InvCrustLeatherIssue model) { _vmMsg = Dalobject.ConfirmedAfterCrustQC(model, Convert.ToInt32(Session["UserID"])); return(Json(new { msg = _vmMsg })); }
public ValidationMsg Save(InvCrustLeatherIssue model, int userId, string url) { try { using (var tx = new TransactionScope()) { using (_context) { var issue = ConvertIssue(model, userId, url); if (model.CrustLeatherIssueID == 0) { _context.INV_CrustLeatherIssue.Add(issue); _context.SaveChanges(); _mode = 1; } else { _context.SaveChanges(); _mode = 2; } if (model.Items != null) { foreach (var item in model.Items) { var issueItem = ConvertIssueItem(item, issue.CrustLeatherIssueID, userId); if (item.CrustLeatherIssueItemID == 0) { _context.INV_CrustLeatherIssueItem.Add(issueItem); _context.SaveChanges(); } else { _context.SaveChanges(); } if (item.Colors != null) { foreach (var color in item.Colors) { var itemColor = ConvertIssueItemColor(color, issueItem.CrustLeatherIssueItemID, issue.CrustLeatherIssueID, userId); if (color.CrustLeatherIssueColorID == 0) { _context.INV_CrustLeatherIssueColor.Add(itemColor); //_context.SaveChanges(); } else { //_context.SaveChanges(); } } } } _context.SaveChanges(); } tx.Complete(); if (_mode == 1) { _vmMsg.ReturnId = issue.CrustLeatherIssueID; _vmMsg.ReturnCode = issue.CrustLeatherIssueNo; _vmMsg.Type = Enums.MessageType.Success; _vmMsg.Msg = "Saved successfully."; } if (_mode == 2) { _vmMsg.ReturnId = issue.CrustLeatherIssueID; _vmMsg.Type = Enums.MessageType.Update; _vmMsg.Msg = "Updated successfully."; } } } } catch { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to save."; } return(_vmMsg); }
private INV_CrustLeatherIssue ConvertIssue(InvCrustLeatherIssue model, int userId, string url) { var entity = model.CrustLeatherIssueID == 0 ? new INV_CrustLeatherIssue() : (from b in _context.INV_CrustLeatherIssue.AsEnumerable() where b.CrustLeatherIssueID == model.CrustLeatherIssueID select b).FirstOrDefault(); entity.CrustLeatherIssueID = model.CrustLeatherIssueID; entity.CrustLeatherIssueNo = model.CrustLeatherIssueNo ?? DalCommon.GetPreDefineNextCodeByUrl(url); entity.CrustLeatherIssueDate = model.CrustLeatherIssueDate == null ? DateTime.Now : DalCommon.SetDate(model.CrustLeatherIssueDate); entity.IssueCategory = model.IssueCategory; entity.IssueFor = model.IssueFor; entity.IssueFrom = model.IssueFrom; entity.IssueTo = model.IssueTo; entity.RecordStatus = model.RecordStatus ?? "NCF"; entity.SetOn = model.CrustLeatherIssueID == 0 ? DateTime.Now : _unit.CrustLeatherIssue.GetByID(model.CrustLeatherIssueID).SetOn; entity.SetBy = model.CrustLeatherIssueID == 0 ? userId : _unit.CrustLeatherIssue.GetByID(model.CrustLeatherIssueID).SetBy; entity.ModifiedOn = model.CrustLeatherIssueID == 0 ? (DateTime?)null : DateTime.Now; entity.ModifiedBy = model.CrustLeatherIssueID == 0 ? (int?)null : userId; #region New Code //var put = entity.INV_CrustLeatherReceiveItem; //if (model.Items.Count > 0) //{ // foreach (var item in model.Items) // { // put.CrustLeatherIssueItemID = item.CrustLeatherIssueItemID; // put.CrustLeatherIssueID = entity.CrustLeatherIssueID; // put.RequisitionDateID = item.RequisitionDateID ?? null; // //entity.RequisitionNo = null; // put.CrustQCLabel = item.CrustQCLabel ?? null; // put.BuyerID = item.BuyerID; // put.BuyerOrderID = item.BuyerOrderID; // put.ArticleID = item.ArticleID; // put.ArticleNo = item.ArticleNo; // put.ArticleChallanID = item.ArticleChallanID; // put.ArticleChallanNo = item.ArticleChallanNo; // put.ItemTypeID = item.ItemTypeID; // put.LeatherTypeID = item.LeatherTypeID; // put.LeatherStatusID = item.LeatherStatusID; // put.SetOn = item.CrustLeatherIssueItemID == 0 // ? DateTime.Now // : _unit.CrustLeatherIssueItem.GetByID(item.CrustLeatherIssueItemID).SetOn; // entity.SetBy = item.CrustLeatherIssueItemID == 0 // ? userId // : _unit.CrustLeatherIssueItem.GetByID(item.CrustLeatherIssueItemID).SetBy; // entity.ModifiedOn = item.CrustLeatherIssueItemID == 0 ? (DateTime?)null : DateTime.Now; // entity.ModifiedBy = item.CrustLeatherIssueItemID == 0 ? (int?)null : userId; // var col = new INV_CrustLeatherIssueColor(); // if (item.Colors.Count > 0) // { // foreach (var color in item.Colors) // { // entity.CrustLeatherIssueColorID = model.CrustLeatherIssueColorID; // entity.CrustLeatherIssueItemID = itemId; // entity.CrustLeatherIssueID = issueId; // entity.ArticleColorNo = entity.ArticleColorNo; // entity.ColorID = model.ColorID; // entity.GradeID = model.GradeID; // entity.GradeRange = model.GradeRange; // entity.CrustQCLabel = model.CrustQCLabel; // entity.IssuePcs = model.IssuePcs ?? 0; // entity.IssueSide = model.IssueSide ?? 0; // entity.IssueArea = model.IssueArea ?? 0; // entity.SideArea = model.SideArea; // entity.AreaUnit = model.AreaUnit; // entity.SetOn = model.CrustLeatherIssueColorID == 0 // ? DateTime.Now // : _unit.CrustLeatherIssueColor.GetByID(model.CrustLeatherIssueColorID).SetOn; // entity.SetBy = model.CrustLeatherIssueColorID == 0 // ? userId // : _unit.CrustLeatherIssueColor.GetByID(model.CrustLeatherIssueColorID).SetBy; // entity.ModifiedBy = model.CrustLeatherIssueColorID == 0 ? (int?)null : userId; // entity.ModifiedOn = model.CrustLeatherIssueColorID == 0 ? (DateTime?)null : DateTime.Now; // return entity; // } // } // } //} #endregion return(entity); }
public ActionResult Save(InvCrustLeatherIssue model) { _userId = Convert.ToInt32(Session["UserID"]); _validationMsg = _dalInvCrustedLeatherIssueFrom.Save(model, _userId, "CrustedLeatherIssueFromStore/CrustedLeatherIssueFromStore"); return(Json(_validationMsg, JsonRequestBehavior.AllowGet)); }
public ActionResult GetIssueById(long issueId) { //var result = _dalInvCrustedLeatherIssueFrom.GetIssueById(issueId); var issue = _unit.CrustLeatherIssue.GetByID(issueId); var result = new InvCrustLeatherIssue(); result.CrustLeatherIssueID = issue.CrustLeatherIssueID; result.CrustLeatherIssueNo = issue.CrustLeatherIssueNo; result.CrustLeatherIssueDate = string.Format("{0:dd/MM/yyyy}", issue.CrustLeatherIssueDate); result.IssueCategory = issue.IssueCategory; result.IssueFor = issue.IssueFor; result.IssueFrom = issue.IssueFrom; result.IssueTo = issue.IssueTo; result.RecordStatus = issue.RecordStatus; result.CheckNote = issue.CheckNote; result.IssueNote = issue.IssueNote; result.Items = new List <InvCrustLeatherIssueItem>(); var items = _unit.CrustLeatherIssueItem.Get() .Where(ob => ob.CrustLeatherIssueID == result.CrustLeatherIssueID) .ToList(); if (items.Count > 0) { foreach (var item in items) { var x = new InvCrustLeatherIssueItem(); x.CrustLeatherIssueID = item.CrustLeatherIssueID; x.CrustLeatherIssueItemID = item.CrustLeatherIssueItemID; x.RequisitionDateID = item.RequisitionDateID; x.RequisitionNo = item.RequisitionDateID == null ? "" : _unit.PrdYearMonthFinishReqDate.GetByID(item.RequisitionDateID).RequisitionNo; x.BuyerID = item.BuyerID; x.BuyerName = item.BuyerID == null ? "" : _unit.SysBuyerRepository.GetByID(item.BuyerID).BuyerName; x.BuyerOrderID = item.BuyerOrderID; x.BuyerOrderNo = item.BuyerOrderID == null ? "" : _unit.SlsBuyerOrederRepository.GetByID(item.BuyerOrderID).BuyerOrderNo; x.ArticleID = item.ArticleID; x.ArticleName = item.ArticleID == null ? "" : _unit.ArticleRepository.GetByID(item.ArticleID).ArticleName; x.ArticleNo = item.ArticleID == null ? "" : _unit.ArticleRepository.GetByID(item.ArticleID).ArticleNo; x.ArticleChallanNo = item.ArticleChallanNo; x.ArticleChallanID = item.ArticleChallanID; x.ItemTypeID = item.ItemTypeID; x.ItemTypeName = item.ItemTypeID == null ? "" : _unit.SysItemTypeRepository.GetByID(item.ItemTypeID).ItemTypeName; x.LeatherTypeID = item.LeatherTypeID; x.LeatherTypeName = item.LeatherTypeID == null ? "" : _unit.SysLeatherTypeRepository.GetByID(item.LeatherTypeID).LeatherTypeName; x.LeatherStatusID = item.LeatherStatusID; x.LeatherStatusName = item.LeatherStatusID == null ? "" : _unit.SysLeatherStatusRepo.GetByID(item.LeatherStatusID).LeatherStatusName; x.CrustQCLabel = item.CrustQCLabel; x.Colors = new List <InvCrustLeatherIssueColor>(); var colors = _unit.CrustLeatherIssueColor.Get() .Where(ob => ob.CrustLeatherIssueItemID == x.CrustLeatherIssueItemID) .ToList(); if (colors.Count > 0) { foreach (var color in colors) { var y = new InvCrustLeatherIssueColor(); y.CrustLeatherIssueID = color.CrustLeatherIssueID; y.CrustLeatherIssueItemID = color.CrustLeatherIssueItemID; y.CrustLeatherIssueColorID = color.CrustLeatherIssueColorID; y.ArticleColorNo = color.ArticleColorNo; y.ColorID = color.ColorID; y.ColorName = color.ColorID == null ? "" : _unit.SysColorRepository.GetByID(color.ColorID).ColorName; y.GradeRange = color.GradeRange; //y.GradeID = color.GradeID; //y.GradeName = color.GradeID == null ? "" : _unit.SysGrade.GetByID(color.GradeID).GradeName; var clsngStkPcs = _context.INV_CrustBuyerStock.Where( ob => ob.StoreID == issue.IssueFrom && ob.BuyerID == item.BuyerID && ob.BuyerOrderID == item.BuyerOrderID && ob.ArticleID == item.ArticleID && ob.ItemTypeID == item.ItemTypeID && ob.LeatherTypeID == item.LeatherTypeID && ob.LeatherStatusID == item.LeatherStatusID && ob.ColorID == color.ColorID && ob.CrustQCLabel == color.CrustQCLabel && ob.ArticleChallanNo == item.ArticleChallanNo) .OrderByDescending(m => m.TransectionID) .FirstOrDefault(); y.ClosingStockPcs = clsngStkPcs == null ? 0 : clsngStkPcs.ClosingStockPcs; var clsngStkSide = _context.INV_CrustBuyerStock.Where( ob => ob.StoreID == issue.IssueFrom && ob.BuyerID == item.BuyerID && ob.BuyerOrderID == item.BuyerOrderID && ob.ArticleID == item.ArticleID && ob.ItemTypeID == item.ItemTypeID && ob.LeatherTypeID == item.LeatherTypeID && ob.LeatherStatusID == item.LeatherStatusID && ob.ColorID == color.ColorID && ob.CrustQCLabel == color.CrustQCLabel && ob.ArticleChallanNo == item.ArticleChallanNo) .OrderByDescending(m => m.TransectionID) .FirstOrDefault(); y.ClosingStockSide = clsngStkSide == null ? 0 : clsngStkSide.ClosingStockSide; var clsngStkArea = _context.INV_CrustBuyerStock.Where( ob => ob.StoreID == issue.IssueFrom && ob.BuyerID == item.BuyerID && ob.BuyerOrderID == item.BuyerOrderID && ob.ArticleID == item.ArticleID && ob.ItemTypeID == item.ItemTypeID && ob.LeatherTypeID == item.LeatherTypeID && ob.LeatherStatusID == item.LeatherStatusID && ob.ColorID == color.ColorID && ob.CrustQCLabel == color.CrustQCLabel && ob.ArticleChallanNo == item.ArticleChallanNo) .OrderByDescending(m => m.TransectionID) .FirstOrDefault(); y.ClosingStockArea = clsngStkArea == null ? 0 : clsngStkArea.ClosingStockArea; y.IssuePcs = color.IssuePcs; y.IssueSide = color.IssueSide; y.IssueArea = color.IssueArea; y.SideArea = color.SideArea; y.AreaUnit = color.AreaUnit; y.AreaUnitName = color.AreaUnit == null ? "" : _unit.SysUnitRepository.GetByID(color.AreaUnit).UnitName; y.CrustQCLabel = color.CrustQCLabel; x.Colors.Add(y); } } result.Items.Add(x); } } return(Json(result, JsonRequestBehavior.AllowGet)); }