public ActionResult GetColorByComb(byte storeId, string qcLabel, int?buyerId, long?buyerOrderId, int?articleId, long?articleChallanId, byte?itemTypeId, byte?leatherTypeId, byte?leatherStatusId) { var colors = _dalInvCrustedLeatherIssueFrom.GetColorByComb(storeId, qcLabel, buyerId, buyerOrderId, articleId, articleChallanId, itemTypeId, leatherTypeId, leatherStatusId); var result = new List <InvCrustLeatherIssueColor>(); foreach (var color in colors) { var item = new InvCrustLeatherIssueColor(); item.CrustLeatherIssueID = color.CrustLeatherIssueID; item.CrustLeatherIssueItemID = color.CrustLeatherIssueItemID; item.CrustLeatherIssueColorID = color.CrustLeatherIssueColorID; item.ArticleColorNo = color.ArticleColorNo; item.ColorID = color.ColorID; item.ColorName = color.ColorName; ////item.GradeID = color.GradeID; ////item.GradeName = color.GradeName; item.GradeRange = color.GradeRange; item.ClosingStockPcs = color.ClosingStockPcs; item.ClosingStockSide = color.ClosingStockSide; item.ClosingStockArea = color.ClosingStockArea; item.IssuePcs = color.ClosingStockPcs; item.IssueSide = color.ClosingStockSide; item.IssueArea = color.ClosingStockArea; item.SideArea = color.SideArea; item.AreaUnit = color.AreaUnit; item.AreaUnitName = color.AreaUnitName; item.CrustQCLabel = color.CrustQCLabel; result.Add(item); } return(Json(result, JsonRequestBehavior.AllowGet)); }
private INV_CrustLeatherIssueColor ConvertIssueItemColor(InvCrustLeatherIssueColor model, long itemId, long issueId, int userId) { var entity = model.CrustLeatherIssueColorID == 0 ? new INV_CrustLeatherIssueColor() : (from b in _context.INV_CrustLeatherIssueColor.AsEnumerable() where b.CrustLeatherIssueColorID == model.CrustLeatherIssueColorID select b).FirstOrDefault(); 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); }
public List <InvCrustLeatherIssueItem> GetReqItemNColors(long reqDateId, byte?issueFrom, byte?issueTo, string qcLabel) { var items = _unit.FinishReqItem.Get().Where(ob => ob.RequisitionDateID == reqDateId).ToList(); var result = new List <InvCrustLeatherIssueItem>(); foreach (var item in items) { var rslt = new InvCrustLeatherIssueItem(); rslt.RequisitionItemID = item.RequisitionItemID; rslt.RequisitionNo = item.RequisitionNo; rslt.RequisitionDateID = item.RequisitionDateID; rslt.BuyerID = item.BuyerID; rslt.BuyerName = item.BuyerID == null ? "" : _unit.SysBuyerRepository.GetByID(item.BuyerID).BuyerName; rslt.BuyerOrderID = item.BuyerOrderID; rslt.BuyerOrderNo = item.BuyerOrderID == null ? "" : _unit.SlsBuyerOrederRepository.GetByID(item.BuyerOrderID).BuyerOrderNo; rslt.ArticleID = item.ArticleID; rslt.ArticleNo = item.ArticleNo; rslt.ArticleChallanID = item.ArticleChallanID; rslt.ArticleChallanNo = item.ArticleChallanNo; rslt.ArticleName = item.ArticleID == null ? "" : _unit.ArticleRepository.GetByID(item.ArticleID).ArticleName; rslt.ItemTypeID = item.ItemTypeID; rslt.ItemTypeName = item.ItemTypeID == null ? "" : _unit.SysItemTypeRepository.GetByID(item.ItemTypeID).ItemTypeName; rslt.LeatherTypeID = item.LeatherTypeID; rslt.LeatherTypeName = item.LeatherTypeID == null ? "" : _unit.SysLeatherTypeRepository.GetByID(item.LeatherTypeID).LeatherTypeName; rslt.LeatherStatusID = item.LeatherStatusID; rslt.LeatherStatusName = item.LeatherStatusID == null ? "" : _unit.SysLeatherStatusRepo.GetByID(item.LeatherStatusID).LeatherStatusName; rslt.Colors = new List <InvCrustLeatherIssueColor>(); var rqClrs = _unit.FinishReqItemColor.Get().Where(ob => ob.RequisitionItemID == item.RequisitionItemID); foreach (var rqClr in rqClrs) { var clr = new InvCrustLeatherIssueColor(); clr.ColorID = rqClr.ColorID; clr.ColorName = rqClr.ColorID == null ? "" : _unit.SysColorRepository.GetByID(rqClr.ColorID).ColorName; var clsngStkPcs = _context.INV_CrustBuyerStock.FirstOrDefault( ob => ob.StoreID == 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 == rqClr.ColorID && ob.CrustQCLabel == qcLabel && ob.ArticleChallanNo == item.ArticleChallanNo); clr.GradeRange = clsngStkPcs == null ? "" : clsngStkPcs.GradeRange; clr.IssuePcs = rqClr.ColorPcs ?? 0; clr.IssueSide = rqClr.ColorSide ?? 0; clr.IssueArea = rqClr.ColorArea ?? 0; //clr.AreaUnit = rqClr.AreaUnit; //clr.AreaUnitName = rqClr.AreaUnit == null // ? "" // : _unit.SysUnitRepository.GetByID(rqClr.AreaUnit).UnitName; clr.ClosingStockPcs = clsngStkPcs == null ? 0 : clsngStkPcs.ClosingStockPcs; var clsngStkArea = _context.INV_CrustBuyerStock.FirstOrDefault( ob => ob.StoreID == 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 == rqClr.ColorID && ob.CrustQCLabel == qcLabel && ob.ArticleChallanNo == item.ArticleChallanNo); clr.ClosingStockArea = clsngStkArea == null ? 0 : clsngStkArea.ClosingStockArea; var clsngStkSide = _context.INV_CrustBuyerStock.FirstOrDefault( ob => ob.StoreID == 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 == rqClr.ColorID && ob.CrustQCLabel == qcLabel && ob.ArticleChallanNo == item.ArticleChallanNo); clr.ClosingStockSide = clsngStkSide == null ? 0 : clsngStkSide.ClosingStockSide; clr.CrustQCLabel = qcLabel; clr.ArticleColorNo = rqClr.ArticleColorNo; rslt.Colors.Add(clr); } result.Add(rslt); } return(result); }
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)); }