public List <SysArticleChallanColor> GetArticleColorListAfterSave(long ArticleChallanID) { using (var context = new BLC_DEVEntities()) { var Data = (from d in context.Sys_ArticleChallanColor.AsEnumerable() where d.ArticleChallanID == ArticleChallanID join c in _context.Sys_Color on d.ArticleColor equals c.ColorID into Colors from c in Colors.DefaultIfEmpty() join u in _context.Sys_Unit on d.ColorAreaUnit equals u.UnitID into Units from u in Units.DefaultIfEmpty() orderby d.ArticleColorNo ascending select new SysArticleChallanColor { ArticleChallanIDColor = d.ArticleChallanIDColor, ArticleColorNo = d.ArticleColorNo, ArticleColor = d.ArticleColor, ArticleColorName = (c == null ? null : c.ColorName), ColorAreaUnit = d.ColorAreaUnit, ColorAreaUnitName = (u == null ? "SFT" : u.UnitName), ArticleColorArea = d.ArticleColorArea, RemarkDate = d.RemarkDate == null ? null : Convert.ToDateTime(d.RemarkDate).ToString("dd'/'MM'/'yyyy"), Remarks = d.Remarks, QuantityDescription = d.QuantityDescription, }).ToList(); return(Data); } }
public List <SysArticleChallanDetail> GetArticleDetailListAfterSave(long ArticleChallanID) { using (var context = new BLC_DEVEntities()) { var Data = (from d in context.Sys_ArticleChallanDetail.AsEnumerable() where d.ArticleChallanID == ArticleChallanID join u in _context.Sys_Unit on d.SizeRangeUnit equals u.UnitID into Units from u in Units.DefaultIfEmpty() join tu in _context.Sys_Unit on d.ThicknessUnit equals tu.UnitID into ThicknessUnits from tu in ThicknessUnits.DefaultIfEmpty() select new SysArticleChallanDetail { ArticleChallanDtlID = d.ArticleChallanDtlID, SizeRange = d.SizeRange, PcsSideDescription = d.PcsSideDescription, GradeRange = d.GradeRange, ThicknessRange = d.ThicknessRange, ThicknessAt = (d.ThicknessAt == "AFFN" ? "After Finishing" : "After Shaving"), SizeRangeUnit = d.SizeRangeUnit, SizeRangeUnitName = (u == null ? "SFT" : u.UnitName), RequiredPercentage = d.RequiredPercentage, ThicknessUnit = d.ThicknessUnit, ThicknessUnitName = (tu == null?"SFT":tu.UnitName), Remarks = d.Remarks }).ToList(); return(Data); } }
public List <PrdYearMonthCrustScheduleColor> GetColorListForOrderItem(string _BuyerOrderItemID) { using (_context) { var Data = (from c in _context.SLS_BuyerOrderItemColor.AsEnumerable() where c.BuyerOrderItemID.ToString() == _BuyerOrderItemID join col in _context.Sys_Color on c.ColorID equals col.ColorID into Colors from col in Colors.DefaultIfEmpty() join u in _context.Sys_Unit on c.ColorUnit equals u.UnitID into Units from u in Units.DefaultIfEmpty() select new PrdYearMonthCrustScheduleColor { //SdulItemColorID = c.SdulItemColorID, ColorID = c.ColorID, ColorName = (col == null ? null : col.ColorName), //ColorArea = c.ColorArea, //ColorPCS = c.ColorPCS, //ColorSide = c.ColorSide, //Remarks = c.Remarks, AreaUnit = c.ColorUnit, AreaUnitName = (u == null ? "" : u.UnitName) }).ToList(); return(Data); } }
public List <PrdYearMonthCrustScheduleColor> GetColorListForRequisitionItem(string _RequisitionItemID) { using (_context) { var Data = (from c in _context.PRD_YearMonthFinishReqItemColor.AsEnumerable() where c.RequisitionItemID.ToString() == _RequisitionItemID join col in _context.Sys_Color on c.ColorID equals col.ColorID into Colors from col in Colors.DefaultIfEmpty() join u in _context.Sys_Unit on c.AreaUnit equals u.UnitID into Units from u in Units.DefaultIfEmpty() orderby c.ArticleColorNo ascending select new PrdYearMonthCrustScheduleColor { //SdulItemColorID = c.SdulItemColorID, ReqItemColorID = c.ReqItemColorID, RequisitionItemID = c.RequisitionItemID, ColorID = c.ColorID, ArticleColorNo = c.ArticleColorNo, ColorName = (col == null ? null : col.ColorName), ColorArea = c.ColorArea, ColorPCS = c.ColorPcs, ColorSide = c.ColorSide, Remarks = c.Remarks, AreaUnit = c.AreaUnit, AreaUnitName = (u == null ? "" : u.UnitName) }).ToList(); return(Data); } }
public List <PrdYearMonthCrustScheduleColor> GetColorListForScheduleItem(string _ScheduleItemID) { using (_context) { var Data = (from c in _context.PRD_YearMonthFinishScheduleColor.AsEnumerable() where c.ScheduleItemID.ToString() == _ScheduleItemID join col in _context.Sys_Color on c.ColorID equals col.ColorID into Colors from col in Colors.DefaultIfEmpty() join u in _context.Sys_Unit on c.AreaUnit equals u.UnitID into Units from u in Units.DefaultIfEmpty() join wu in _context.Sys_Unit on c.WeightUnit equals wu.UnitID into WUnits from wu in WUnits.DefaultIfEmpty() select new PrdYearMonthCrustScheduleColor { SdulItemColorID = c.SdulItemColorID, ColorID = c.ColorID, ArticleColorNo = c.ArticleColorNo, ColorName = (col == null ? null : col.ColorName), ColorArea = c.ColorArea, ColorPCS = c.ColorPCS, ColorSide = c.ColorSide, Remarks = c.Remarks, AreaUnit = c.AreaUnit, AreaUnitName = (u == null ? "" : u.UnitName), ColorWeight = c.ColorWeight, WeightUnit = c.WeightUnit, WeightUnitName = (wu == null ? "" : wu.UnitName), }).ToList(); return(Data); } }
public PRDChemProdReq GetRequisitionDetailsAfterSearch(int _RequisitionID) { var model = new PRDChemProdReq(); var RequisitionInfo = (from r in _context.PRD_ChemProdReq.AsEnumerable() where r.RequisitionID == _RequisitionID join re in _context.PRD_Recipe on(r == null?null:r.RecipeID) equals re.RecipeID into Recepies from re in Recepies.DefaultIfEmpty() join c in _context.Sys_Color on(re == null? null: re.ArticleColor) equals c.ColorID into Colors from c in Colors.DefaultIfEmpty() join u in _context.Sys_Unit on(re == null ? 0 : re.BaseUnit) equals u.UnitID into Units from u in Units.DefaultIfEmpty() select new PRDChemProdReq { RequisitionID = r.RequisitionID, RequisitionNo = r.RequisitionNo, RequisitionCategory = r.RequisitionCategory, RequisitionType = r.RequisitionType, ReqRaisedOn = (Convert.ToDateTime(r.ReqRaisedOn)).ToString("dd'/'MM'/'yyyy"), RequiredByTime = (r.RequiredByTime == 0? null: r.RequiredByTime), ReqRaisedBy = (r.ReqRaisedBy), RequisitionFrom = r.RequisitionFrom, RequisitionTo = r.RequisitionTo, RecipeFor = (r.RecipeFor), RecipeID = (r.RecipeID), ArticleNo = r.ArticleNo, ArticleName = (re == null? null: re.ArticleName), ArticleChallanNo = (re == null ? null : re.ArticleChallanNo), ArticleColor = (re == null ? null : re.ArticleColor), ArticleColorName = (c == null ? null : c.ColorName), BaseQuantity = (re == null ? null : (re.BaseQuantity).ToString()), //BaseUnit = (re == null ? null : re.BaseUnit), BaseUnitName = (u == null ? null : u.UnitName), LeatherSize = r.LeatherSize, SizeUnit = (r.SizeUnit), Selection = r.Selection, Thickness = r.Thickness, ThicknessUnit = (r.ThicknessUnit), ProductionQty = (r.ProductionQty == 0 ? null : r.ProductionQty), ProductionQuantityUnit = (u == null ? null : u.UnitName), RecordStatus = r.RecordStatus }).FirstOrDefault(); model.RequisitionInfo = RequisitionInfo; model.RequisitionItemList = GetRequisitionItemList(_RequisitionID, RequisitionInfo.RequisitionTo); return(model); }
//For LOV in Grid public List <PRDChemProdReqItem> GetStoreWiseChemicalItemStock(string _IssueFrom) { using (_context) { var StockResult = (from p in _context.INV_ChemStockSupplier where p.StoreID.ToString() == _IssueFrom group p by new { //p.StoreID, p.SupplierID, p.PackSize, p.ItemID, p.SizeUnit, p.UnitID } into g select new { TransectionID = g.Max(p => p.TransectionID), //StoreID = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.StoreID).FirstOrDefault(), ItemID = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.ItemID).FirstOrDefault(), SupplierID = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.SupplierID).FirstOrDefault(), //UnitID = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.UnitID).FirstOrDefault(), PackSize = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.PackSize).FirstOrDefault(), SizeUnit = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.SizeUnit).FirstOrDefault(), PackQty = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.PackClosingQty).FirstOrDefault(), ClosingQty = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.ClosingQty).FirstOrDefault(), StockUnit = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.UnitID).FirstOrDefault() }).ToList(); var Data = (from s in StockResult where s.ClosingQty > 0 join i in _context.Sys_ChemicalItem on(s == null ? null : s.ItemID) equals i.ItemID into Items from i in Items.DefaultIfEmpty() join sup in _context.Sys_Supplier on(s == null ? 0 : s.SupplierID) equals sup.SupplierID into Suppliers from sup in Suppliers.DefaultIfEmpty() join si in _context.Sys_Size on(s == null ? 0 : s.PackSize) equals si.SizeID into Sizes from si in Sizes.DefaultIfEmpty() join siu in _context.Sys_Unit on(s == null ? 0 : s.SizeUnit) equals siu.UnitID into Units from siu in Units.DefaultIfEmpty() join su in _context.Sys_Unit on(s == null ? 0 : s.StockUnit) equals su.UnitID into StockUnits from su in StockUnits.DefaultIfEmpty() orderby(i == null ? null : i.ItemName) select new PRDChemProdReqItem { ItemID = s.ItemID, ItemName = (i == null ? null : i.ItemName), SupplierID = s.SupplierID, SupplierName = (sup == null ? null : sup.SupplierName), PackSize = s.PackSize, PackSizeName = (si == null ? null : si.SizeName), SizeUnit = s.SizeUnit, SizeUnitName = (siu == null ? null : siu.UnitName), StockQty = s.ClosingQty, StockUnit = s.StockUnit, StockUnitName = (su == null ? null : su.UnitName), PackQty = (Int32)(s.PackQty) }).ToList(); return(Data); } }