public List<RepairRecipe> GetCombineFaultRecipes(CombineFault cmbFault, int palletId, int actionId) { List<RepairRecipe> recipes = new List<RepairRecipe>(); List<TorqueRepair> trqRepairs = new List<TorqueRepair>(); List<BarcodeRepair> bcRepairs = new List<BarcodeRepair>(); ReworkFactory factory = new ReworkFactory(); var skuInfo = factory.GetSkuInfoByPalletId(palletId); foreach (var t in cmbFault.TorqueFaults) { var tmpTrqRepair = GetTorqueRepair(t); trqRepairs.Add(tmpTrqRepair); } foreach (var b in cmbFault.BarcodeFaults) { var tmpBcRepair = GetBarcodeRepair(b); bcRepairs.Add(tmpBcRepair); } var dispRecipes = GetRepairRecipes(skuInfo, cmbFault.Disposition, actionId); foreach (var r in dispRecipes) { if (r.RequireRepaired) { foreach (var t in r.TorqueRepairs) { } foreach (var b in r.BarcodeRepairs) { if (!bcRepairs.Where(bc => bc.CSType == bc.CSType).Any()) bcRepairs.Add(b); } } else { recipes.Add(r); } } if (bcRepairs.Any() || trqRepairs.Any()) { recipes.Add(new RepairRecipe { Title = "Combine Fault Recipe", TorqueRepairs = trqRepairs, BarcodeRepairs = bcRepairs, Repaired = false, RequireRepaired = true, Priority = 1, RecipeId = 100 }); } return recipes.OrderByDescending(r=>r.Priority).ToList(); }
public RepairRecipeResponse GetReworkRecipes([FromBody]ReworkRecipeRequest request, int actionId) { ItemDetailsModel model = new ItemDetailsModel(); RecipeFactory recipeFactory = new RecipeFactory(); ReworkFactory reworkFactory = new ReworkFactory(); var recipes = recipeFactory.GetRepairRecipes(request.SkuInfo, request.Disposition, actionId); return new RepairRecipeResponse { RepairRecipes = recipes }; }
public RepairPalletInfo RepairPalletInfo(int id, int mode, int testerMode) { ReworkFactory factory = new ReworkFactory(); var palletInfo = factory.GetPalletInfo(id, testerMode, mode); if (palletInfo == null) { throw new HttpResponseException( HttpErrorResponse.GetHttpErrorResponse( HttpStatusCode.NotFound, "No Pallet Data", string.Format("Pallet ID = {0} Has No Data", id))); } return palletInfo; }
public PalletChange GetPalletChange(int palletId) { DispositionDataContext db = new DispositionDataContext(); IntegramMESDataContext trackDb = new IntegramMESDataContext(); MesDataContext dbMes = new MesDataContext(); ItemDetailsModel itemDetailModel = new ItemDetailsModel(); ReworkFactory reworkFactory = new ReworkFactory(); var palletHdr = (from p in dbMes.PalletInfos where p.PalletNbr == palletId && (p.Pallet_Type == "S1" || p.Pallet_Type == "S2") select p).FirstOrDefault(); if (palletHdr == null) return null; var jobInfo = (from j in dbMes.MasterJobTables where j.Job_ID == palletHdr.Job_ID select j).FirstOrDefault(); if (jobInfo == null) return null; var item = itemDetailModel.GetItemInfo(jobInfo.SKU); var convertSkuInfo = reworkFactory.GetSkuInfo(item).OrderBy(s=>s.PartIndex).ToList(); var palletChangeHistory = trackDb.PalletChangeHistories.Where(p => p.JobId == jobInfo.Job_ID).ToList(); PalletChange palletChange = new PalletChange { PalletId = palletId, Sku = jobInfo.SKU, JobId = jobInfo.Job_ID, OrderNumber = jobInfo.Order_Nbr, SkuInfo = convertSkuInfo, FinishDTM = (DateTime)jobInfo.FinishBld_DTTM, PalletChangeHistory = palletChangeHistory }; return palletChange; }
private RepairRecipe GetGenericRepairRecipe(List<SkuInfo> skuInfo) { ReworkFactory factory = new ReworkFactory(); //var palletValidationRequirements = factory.GetPalletValidationRequirements(skuInfo); int lineId = skuInfo[0].LineId; ReworkDataContext db = new ReworkDataContext(); int genericrecipeid = 4; if (lineId == 1) genericrecipeid = 3; RepairRecipe recipe = new RepairRecipe { RecipeId = genericrecipeid, Priority = 0, Title = "Generic Repair", RequireRepaired = false, BarcodeRepairs = (from t in db.IWS_SP_GetSerialRequirementByRecipeDefinitionId(genericrecipeid) select new BarcodeRepair { Description = t.Description, LineId = t.LineId, Repaired = false, }).ToList(), TorqueRepairs = (from t in db.IWS_SP_GetTorqueRequirementByRecipeDefinitionId(genericrecipeid) select new TorqueRepair { ControllerName = t.ControllerName.Trim(), Repaired = t.Pset == 0 ? true : false, Description = t.Description, Pset = t.Pset, TorquesPresent = 0, TorquesRequired = (int)t.TorquesRequired }).ToList() }; return recipe; }
public HttpResponseMessage CompleteRepair([FromBody]RepairFaults repairFaults, int palletId, string userId) { ReworkFactory factory = new ReworkFactory(); factory.CompleteRepair(repairFaults, palletId, userId); return new HttpResponseMessage(HttpStatusCode.OK); }
public List<SkuInfo> GetSkuInfo(string sku) { ItemDetailsModel itemDetailModel = new ItemDetailsModel(); ReworkFactory reworkFactory = new ReworkFactory(); var item = itemDetailModel.GetItemInfo(sku); if (item == null) return null; var convertSkuInfo = reworkFactory.GetSkuInfo(item).OrderBy(s => s.PartIndex).ToList(); return convertSkuInfo; }
//public void GetRepairInfo(int jobId) //{ // RepairReportingDataContext db = new RepairReportingDataContext(); // var repairHeader = db.RPT_GetRepairInfoHeader(jobId).ToList(); // foreach(var header in repairHeader) // { // dynamic Repair = new // { // HeaderInfo = header, // RepairHistory = new // { // } // }; // } //} public PalletHistoryInfo GetPalletInfoByJobId(long jobId) { ReworkFactory reworkFactory = new ReworkFactory(); RepairFaults faults = new RepairFaults(); DispositionDataContext db = new DispositionDataContext(); REWORK_REPORTINGEntities reworkEntities = new REWORK_REPORTINGEntities(); MesDataContext dbMes = new MesDataContext(); ItemDetailsModel itemDetailModel = new ItemDetailsModel(); var jobInfo = (from j in dbMes.MasterJobTables where j.Job_ID == jobId select j).FirstOrDefault(); if (jobInfo == null) return null; var palletInfo = GetPalletInfo(jobInfo); return palletInfo; }
private PalletHistoryInfo GetPalletInfo(MasterJobTable jobInfo) { ReworkFactory reworkFactory = new ReworkFactory(); RepairFaults faults = new RepairFaults(); DispositionDataContext db = new DispositionDataContext(); REWORK_REPORTINGEntities reworkEntities = new REWORK_REPORTINGEntities(); MesDataContext dbMes = new MesDataContext(); ItemDetailsModel itemDetailModel = new ItemDetailsModel(); var item = itemDetailModel.GetItemInfo(jobInfo.SKU); var convertSkuInfo = reworkFactory.GetSkuInfo(item).OrderBy(x => x.PartIndex).ToList(); var lineInfos = reworkFactory.GetLineInfo(jobInfo); //RepairTorqueDetails = Count = 0 reworkEntities.Configuration.ProxyCreationEnabled = false; reworkEntities.Configuration.LazyLoadingEnabled = false; var repairHistory = reworkEntities.RepairHistories .Include("RepairFaultXrefRepairHistories") .Include("RepairFaultXrefRepairHistories.RepairFault") .Include("RepairFaultXrefRepairHistories.RepairFault.FaultType") .Include("RepairFaultXrefRepairHistories.RepairFault.RepairFaultDetails") .Include("RepairFaultXrefRepairHistories.RepairFault.RepairDispositionDetails") .Include("RepairFaultXrefRepairHistories.RepairFault.RepairRecipes") //.Include("RepairFaultXrefRepairHistories.RepairFault.RepairRecipes.RepairBarcodeDetails") //.Include("RepairFaultXrefRepairHistories.RepairFault.RepairRecipes.RepairTorqueDetails") .Include("RepairTestRequirements") .Include("RepairTestRequirements.RepairTestRequirementDetails") .Where(r => r.JobId == jobInfo.Job_ID) .Select(i => new { i.ArriveDtm, i.CompletedDtm, i.EmployeeId, i.EmployeeName, i.JobId, i.PalletId, RepairFaultXrefRepairHistories = i.RepairFaultXrefRepairHistories.Select(j => new { RepairFault = new { FaultType = j.RepairFault.FaultType, RepairDispositionDetails = j.RepairFault.RepairDispositionDetails, RepairFaultDetails = j.RepairFault.RepairFaultDetails, RepairRecipes = j.RepairFault.RepairRecipes } }).ToList(), RepairTestRequirements = i.RepairTestRequirements.Select(k => new { k.TestId, k.TestName, k.TestResult, k.TestStatus, k.Buildcode, RepairTestRequirementDetails = k.RepairTestRequirementDetails }).ToList(), }).ToList(); dynamic extract = new List<dynamic>(); foreach (var j in repairHistory) { dynamic onejob = new { PalletId = j.PalletId, JobId = j.JobId, CompletedDtm = j.CompletedDtm, EmployeeName = j.EmployeeName, RepairTestRequirements = (from t in j.RepairTestRequirements select new { TestId = t.TestId, TestName = t.TestName, TestResult = t.TestResult, TestStatus = t.TestStatus, Buildcode = t.Buildcode, RepairTestRequirementDetails = (from d in t.RepairTestRequirementDetails select new { BitNo = d.BitNo, Description = d.Description, Result = d.Result }).ToList(), }).ToList(), RepairFaultXrefRepairHistories = from s in j.RepairFaultXrefRepairHistories select new { RepairFault = new { FaultType = new { Id = s.RepairFault.FaultType.Id, Description = s.RepairFault.FaultType.Description, }, RepairRecipes = from r in s.RepairFault.RepairRecipes select new { Description = r.Description, RepairBarcodeDetails = (from b in r.RepairBarcodeDetails select new { Description = b.Description, OriginalBarcode = b.OriginalBarcode, ReplaceBarcode = b.ReplaceBarcode }).ToList(), RepairTorqueDetails = (from t in r.RepairTorqueDetails select new { Angle = t.Angle, AngleStatus = t.AngleStatus, CompletedDTM = t.CompletedDTM, ControllerName = t.ControllerName, Pset = t.Pset, TighteningID = t.TighteningID, TighteningStatus = t.TighteningStatus, Torque = t.Torque, TorqueStatus = t.TorqueStatus }).ToList(), }, RepairFaultDetails = (from d in s.RepairFault.RepairFaultDetails select new { Station = d.Station, Description = d.Description }).ToList(), RepairDispositionDetails = (from disp in s.RepairFault.RepairDispositionDetails select new { Type = disp.Type, Side = disp.Side, SeatPortion = disp.SeatPortion, Commodity = disp.Commodity, Defect = disp.Defect, DefectDetail = disp.DefectDetail, Responsibility = disp.Responsibility }).ToList() } } }; extract.Add(onejob); } PalletHistoryInfo palletInfo = new PalletHistoryInfo { OrderNumber = jobInfo.Order_Nbr, FinishDTM = (DateTime)jobInfo.FinishBld_DTTM, JobId = jobInfo.Job_ID, Sku = jobInfo.SKU, PalletId = (int)jobInfo.Ship_Pallet, SkuInfo = convertSkuInfo, LineInfo = lineInfos, RepairHistory = extract }; return palletInfo; }
public PalletHistoryInfo GetPalletInfoByPalletId(int palletId) { ReworkFactory reworkFactory = new ReworkFactory(); RepairFaults faults = new RepairFaults(); DispositionDataContext db = new DispositionDataContext(); REWORK_REPORTINGEntities reworkEntities = new REWORK_REPORTINGEntities(); MesDataContext dbMes = new MesDataContext(); ItemDetailsModel itemDetailModel = new ItemDetailsModel(); var palletHdr = (from p in dbMes.PalletInfos where p.PalletNbr == palletId && (p.Pallet_Type == "S1" || p.Pallet_Type == "S2") select p).FirstOrDefault(); if (palletHdr == null) return null; var jobInfo = (from j in dbMes.MasterJobTables where j.Job_ID == palletHdr.Job_ID select j).FirstOrDefault(); if (jobInfo == null) return null; var palletInfo = GetPalletInfo(jobInfo); return palletInfo; }