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; }
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 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 IEnumerable<Commodity> GetCommoditiesByDefectId(int id) { DispositionDataContext dbDisposition = new DispositionDataContext(); var commodities = (from x in DispositionCacheManager.Defect2Commodities join c in dbDisposition.Commodities on x.CommodityID equals c.CommodityID where x.DefectID == id select new Commodity { Code = c.Code, CommodityID = c.CommodityID, Description = c.Description, Obsolete = c.Obsolete }).ToList(); return commodities; }
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 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 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; //} 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 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 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 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 void CreateDefectXrefCommodity(Xref_Defects_Commodity reference) { DispositionDataContext dispositionDb = new DispositionDataContext(); dispositionDb.Xref_Defects_Commodities.InsertOnSubmit(reference); try { dispositionDb.SubmitChanges(); DispositionCacheManager.RefreshDefect2Commodities(); } catch (Exception ex) { } }
public void CreateFinalQuestion(FinalQuestion question) { DispositionDataContext dbDisposition = new DispositionDataContext(); dbDisposition.FinalQuestions.InsertOnSubmit(question); dbDisposition.SubmitChanges(); }
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 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 List<FinalQuestion> GetFinalQuestions() { DispositionDataContext dbDisposition = new DispositionDataContext(); var questions = (from q in dbDisposition.FinalQuestions orderby q.Priority descending select q).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 IEnumerable<SeatSide> GetSeatSides() { DispositionDataContext dispositionDb = new DispositionDataContext(); return (from s in dispositionDb.SeatSides select s).ToList().OrderBy(c => c.Description).ToList(); }
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 void DeleteDefectById(int id) { DispositionDataContext dispositionDb = new DispositionDataContext(); var defect = (from s in dispositionDb.Defects where s.DefectID == id select s).Single(); dispositionDb.Defects.DeleteOnSubmit(defect); dispositionDb.SubmitChanges(); }
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 CreateSeatSide(SeatSide seatSide) { DispositionDataContext dispositionDb = new DispositionDataContext(); dispositionDb.SeatSides.InsertOnSubmit(seatSide); dispositionDb.SubmitChanges(); }
public void CreateDefect(Defect defect) { DispositionDataContext dispositionDb = new DispositionDataContext(); dispositionDb.Defects.InsertOnSubmit(defect); dispositionDb.SubmitChanges(); }