public SeatSide GetSeatSideById(int id)
 {
     DispositionDataContext dispositionDb = new DispositionDataContext();
     return (from s in dispositionDb.SeatSides
             where s.SideID == id
             select s).Single();
 }
 public void DeleteSeatSideById(int id)
 {
     DispositionDataContext dispositionDb = new DispositionDataContext();
     var seatSide = (from s in dispositionDb.SeatSides
                     where s.SideID == id
                     select s).Single();
     dispositionDb.SeatSides.DeleteOnSubmit(seatSide);
     dispositionDb.SubmitChanges();
 }
 public void UpdateSeatType(SeatType seatType)
 {
     DispositionDataContext dispositionDb = new DispositionDataContext();
     var updateSeatType = (from s in dispositionDb.SeatTypes
                     where s.TypeID == seatType.TypeID
                     select s).Single();
     updateSeatType.Code = seatType.Code;
     updateSeatType.Description = seatType.Description;
     updateSeatType.Obsolete = seatType.Obsolete;
     dispositionDb.SubmitChanges();
 }
        public IEnumerable<Defect> GetDefectsByCommodityId(int id)
        {
            DispositionDataContext dbDisposition = new DispositionDataContext();
            var defectList = (from d in DispositionCacheManager.Defect2Commodities
                              where d.CommodityID == id
                              orderby d.Defect.Description
                              select new Defect
                              {
                                  DefectID = d.Defect.DefectID,
                                  Description = d.Defect.Description.Trim(),
                                  Obsolete = d.Defect.Obsolete,
                                  Code = d.Defect.Code
                              }).ToList().OrderBy(c => c.Description);

            return defectList;
        }
        public IEnumerable<DefectDetail> GetDefectDetailsByCommodityAndDefect(int commodityID, int defectID)
        {
            DispositionDataContext dbDisposition = new DispositionDataContext();

            var defectDetailList = (from d in DispositionCacheManager.DefectDetail2CommoditiyAndDefect
                                    where d.CommodityID == commodityID && d.DefectID == defectID
                                    orderby d.DefectDetail.Description
                                    select new DefectDetail
                                    {
                                        DefectDetailID = d.DefectDetail.DefectDetailID,
                                        Code = d.DefectDetail.Code,
                                        Description = d.DefectDetail.Description.Trim(),
                                        Obsolete = d.DefectDetail.Obsolete
                                    }).ToList().OrderBy(c => c.Description);
            return defectDetailList;
        }
Beispiel #6
0
        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;
        }
 public void UpdateFinalQuestion(FinalQuestion question)
 {
     DispositionDataContext dbDisposition = new DispositionDataContext();
     var item = dbDisposition.FinalQuestions.Where(q => q.Id == question.Id).FirstOrDefault();
     if (item != null)
     {
         item.Parent = question.Parent;
         item.Priority = question.Priority;
         item.Question = question.Question.Trim();
         item.Group = question.Group;
         dbDisposition.SubmitChanges();
     }
     
 }
 public void CreateFinalQuestion(FinalQuestion question)
 {
     DispositionDataContext dbDisposition = new DispositionDataContext();
     dbDisposition.FinalQuestions.InsertOnSubmit(question);
     dbDisposition.SubmitChanges();
 }
 public void DeleteDefectXrefCommodity(Xref_Defects_Commodity reference)
 {
     DispositionDataContext dispositionDb = new DispositionDataContext();
     var result = (from d in dispositionDb.Xref_Defects_Commodities
                   where d.CommodityID == reference.CommodityID && d.DefectID == reference.DefectID 
                   select d).Single();
     dispositionDb.Xref_Defects_Commodities.DeleteOnSubmit(result);
     dispositionDb.SubmitChanges();
     DispositionCacheManager.RefreshDefect2Commodities();
 }
 public IEnumerable<SeatSide> GetSeatSides()
 {
     DispositionDataContext dispositionDb = new DispositionDataContext();
     return (from s in dispositionDb.SeatSides
             select s).ToList().OrderBy(c => c.Description).ToList();
 }
        private SeatSide GetValidSeatSide(string side) {
            DispositionDataContext dbDisposition = new DispositionDataContext();
            string filter = side;
            if (filter.Equals("RHD")) {
                filter = "RH";
            } else if (filter.Equals("LHD")) {
                filter = "LH";
            }

            var sides = (from s in dbDisposition.SeatSides where s.Description.Trim().Equals(filter) select s).ToList();
            if (sides.Count() > 0)
                return sides.Single();
            else
            {
                return (from s in dbDisposition.SeatSides where s.Description.Trim().Equals("N/A") select s).Single();
            }
        }
 public List<FinalQuestionResult> GetFinalQuestionsResult(string groupType)
 {
     DispositionDataContext dbDisposition = new DispositionDataContext();
     var questions = (from q in dbDisposition.FinalQuestions.Where(s=>s.Group == groupType)
                      orderby q.Priority descending
                      select new FinalQuestionResult
                      {
                          FinalQuestion = q,
                          Result = -1,
                      }).ToList();
     return questions;
 }
        public void DeleteDefectDetailRefCommodityDefect(int commodityId, int defectId, int defectDetailId)
        {
            DispositionDataContext dbDisposition = new DispositionDataContext();
            var reference = (from r in dbDisposition.Xref_DefectDetail_Commodity_Defects
                             where r.CommodityID == commodityId && r.DefectID == defectId && r.DefectDetailID == defectDetailId
                             select r).Single();

            dbDisposition.Xref_DefectDetail_Commodity_Defects.DeleteOnSubmit(reference);
            dbDisposition.SubmitChanges();
            DispositionCacheManager.RefreshDefectDetail2CommoditiyAndDefect();
        }
        public void CreateDefectDetailRefCommodityDefect(int commodityId, int defectId, int defectDetailId) 
        {
            DispositionDataContext dbDisposition = new DispositionDataContext();
            Xref_DefectDetail_Commodity_Defect reference = new Xref_DefectDetail_Commodity_Defect
            {
                CommodityID = commodityId,
                DefectID = defectId,
                DefectDetailID = defectDetailId
            };

            dbDisposition.Xref_DefectDetail_Commodity_Defects.InsertOnSubmit(reference);
            dbDisposition.SubmitChanges();
            DispositionCacheManager.RefreshDefectDetail2CommoditiyAndDefect();
        }
        public void UpdateDefectDetail(DefectDetail defectDetail)
        {
            DispositionDataContext dispositionDb = new DispositionDataContext();
            var updateDefectDetail = (from s in dispositionDb.DefectDetails
                                      where s.DefectDetailID == defectDetail.DefectDetailID
                                      select s).Single();

            updateDefectDetail.Code = defectDetail.Code;
            updateDefectDetail.Description = defectDetail.Description;
            updateDefectDetail.Obsolete = defectDetail.Obsolete;
            dispositionDb.SubmitChanges();
        }
 public void CreateDefectDetail(DefectDetail defectDetail)
 {
     DispositionDataContext dispositionDb = new DispositionDataContext();
     dispositionDb.DefectDetails.InsertOnSubmit(defectDetail);
     dispositionDb.SubmitChanges();
     DispositionCacheManager.RefreshDefectDetails();
 }
 public void DeleteDefectDetailById(int id)
 {
     DispositionDataContext dispositionDb = new DispositionDataContext();
     var defectDetail = (from s in dispositionDb.DefectDetails
                      where s.DefectDetailID == id
                      select s).Single();
     dispositionDb.DefectDetails.DeleteOnSubmit(defectDetail);
     dispositionDb.SubmitChanges();
     DispositionCacheManager.RefreshDefectDetails();
 }
        public DefectDetail GetDefectDetailById(int id)
        {
            DispositionDataContext dispositionDb = new DispositionDataContext();
            var defectDetail = (from s in dispositionDb.DefectDetails
                    where s.DefectDetailID == id
                    select s).Single();

            var result = new DefectDetail
            {
                Code = defectDetail.Code,
                DefectDetailID = defectDetail.DefectDetailID,
                Description = defectDetail.Description,
                Obsolete = defectDetail.Obsolete
            };
            return result;
        }
        public IEnumerable<DefectDetail> GetDefectDetails()
        {
            DispositionDataContext dispositionDb = new DispositionDataContext();
            var defectDetailList = (from d in dispositionDb.DefectDetails
                                    select d).ToList();

            var results = (from d in defectDetailList
                            select new DefectDetail
                            {
                                DefectDetailID = d.DefectDetailID,
                                Code = d.Code,
                                Description = d.Description.Trim(),
                                Obsolete = d.Obsolete
                            }).ToList().OrderBy(c=>c.Description).ToList();
            return results;
        }
        public void DeleteFinalQuestionById(int id)
        {
            DispositionDataContext dbDisposition = new DispositionDataContext();
            var item = dbDisposition.FinalQuestions.Where(q => q.Id == id).FirstOrDefault();
            if (item != null)
            {
                dbDisposition.FinalQuestions.DeleteOnSubmit(item);
                dbDisposition.SubmitChanges();
            }

        }
 public List<FinalQuestion> GetFinalQuestions()
 {
     DispositionDataContext dbDisposition = new DispositionDataContext();
     var questions = (from q in dbDisposition.FinalQuestions
                      orderby q.Priority descending
                      select q).ToList();
     return questions;
 }
 public IEnumerable<Xref_DefectDetail_Commodity_Defect> GetDefectDetail2CommoditiyAndDefect()
 {
     DispositionDataContext dbDisposition = new DispositionDataContext();
     var defect2commoditiesanddefect = (from d in dbDisposition.Xref_DefectDetail_Commodity_Defects select d).ToList();
     return defect2commoditiesanddefect;
 }
        public FinalQuestion GetFinalMoreQuestions(int id, int result)
        {
            DispositionDataContext dbDisposition = new DispositionDataContext();
            FinalQuestion newQuestion = null;
            var more = (from q in dbDisposition.FinalMoreQuestions
                        where q.FinalQuestionId == id && q.Result == result
                        select q).FirstOrDefault();

            if (more != null) {
                newQuestion = dbDisposition.FinalQuestions.Where(q => q.Id == more.FinalLinkQuestionId).FirstOrDefault();
            }
            return newQuestion;
        }
 public IEnumerable<Xref_Defects_Commodity> GetDefect2Commodities()
 {
     DispositionDataContext dbDisposition = new DispositionDataContext();
     var defect2commodities = (from d in dbDisposition.Xref_Defects_Commodities select d).ToList();
     return defect2commodities;
 }
        public void InsertScrapDispositionDefectHistory(IEnumerable<DispositionTag> tags)
        {
            DispositionDataContext dbDisposition = new DispositionDataContext();

            foreach (var tag in tags)
            {
                var side = GetValidSeatSide(tag.Part.side.Trim());
                ScrapDispositionDefectHistory history = new ScrapDispositionDefectHistory
                {
                    DispositionType = tag.Disposition.Transaction.Trim(),
                    Employee = tag.EmployeeInfo.Name.Trim(),
                    PartNumber = tag.Part.partno.Trim(),
                    Qty = tag.Disposition.Qty,
                    TypeID = tag.Disposition.SeatType.TypeID,
                    SeatPortionID = tag.Disposition.SeatPortion.SeatPortionID,
                    SideID = side.SideID,
                    CommodityID = tag.Disposition.SeatCommodity.CommodityID,
                    DefectID = tag.Disposition.SeatDefect.DefectID,
                    DefectDetailID = tag.Disposition.SeatDefectDetail.DefectDetailID,
                    CompletedOn = DateTime.Now,
                };

                dbDisposition.ScrapDispositionDefectHistories.InsertOnSubmit(history);
            }
            dbDisposition.SubmitChanges();
        }
 public IEnumerable<Printer> GetPrinters()
 {
     DispositionDataContext dbDisposition = new DispositionDataContext();
     var printers = (from p in dbDisposition.Printers select p).ToList();
     return printers;
 }
 public void DeleteDefectXrefCommodity(int defectId, int commodityId)
 {
     DispositionDataContext dispositionDb = new DispositionDataContext();
     var xref = (from s in dispositionDb.Xref_Defects_Commodities
                 where s.CommodityID == commodityId && s.DefectID == defectId 
                 select s).Single();
     dispositionDb.Xref_Defects_Commodities.DeleteOnSubmit(xref);
     DispositionCacheManager.RefreshDefect2Commodities();
 }
 public Printer GetPrinter(int id)
 {
     DispositionDataContext dbDisposition = new DispositionDataContext();
     var printer = (from p in dbDisposition.Printers where p.Id == id select p).Single();
     return printer;
 }
 public void CreateSeatSide(SeatSide seatSide)
 {
     DispositionDataContext dispositionDb = new DispositionDataContext();
     dispositionDb.SeatSides.InsertOnSubmit(seatSide);
     dispositionDb.SubmitChanges();
 }
        public void CreateDefectXrefCommodity(Xref_Defects_Commodity reference)
        {
            DispositionDataContext dispositionDb = new DispositionDataContext();
            dispositionDb.Xref_Defects_Commodities.InsertOnSubmit(reference);
            try
            {
                dispositionDb.SubmitChanges();
                DispositionCacheManager.RefreshDefect2Commodities();
            }
            catch (Exception ex)
            {

            }
        }