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 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 UpdateSeatPortion(SeatPortion seatPortion) { DispositionDataContext dispositionDb = new DispositionDataContext(); var updateSeatPortion = (from s in dispositionDb.SeatPortions where s.SeatPortionID == seatPortion.SeatPortionID select s).Single(); updateSeatPortion.Code = seatPortion.Code; updateSeatPortion.Description = seatPortion.Description; updateSeatPortion.Obsolete = seatPortion.Obsolete; dispositionDb.SubmitChanges(); }
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 CreateFinalQuestion(FinalQuestion question) { DispositionDataContext dbDisposition = new DispositionDataContext(); dbDisposition.FinalQuestions.InsertOnSubmit(question); dbDisposition.SubmitChanges(); }
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 void UpdateCommodity(Commodity commodity) { DispositionDataContext dispositionDb = new DispositionDataContext(); var updateCommodity = (from s in dispositionDb.Commodities where s.CommodityID == commodity.CommodityID select s).Single(); updateCommodity.Code = commodity.Code; updateCommodity.Description = commodity.Description; updateCommodity.Obsolete = commodity.Obsolete; dispositionDb.SubmitChanges(); }
public void CreateCommodity(Commodity commodity) { DispositionDataContext dispositionDb = new DispositionDataContext(); dispositionDb.Commodities.InsertOnSubmit(commodity); dispositionDb.SubmitChanges(); }
public void DeleteCommodityById(int id) { DispositionDataContext dispositionDb = new DispositionDataContext(); var commodity = (from s in dispositionDb.Commodities where s.CommodityID == id select s).Single(); dispositionDb.Commodities.DeleteOnSubmit(commodity); dispositionDb.SubmitChanges(); }
public void UpdateResponsibility(Responsibility seatResponsibility) { DispositionDataContext dispositionDb = new DispositionDataContext(); var updateResponsibility = (from s in dispositionDb.Responsibilities where s.ResponsibilityID == seatResponsibility.ResponsibilityID select s).Single(); updateResponsibility.Code = seatResponsibility.Code; updateResponsibility.Description = seatResponsibility.Description; updateResponsibility.Obsolete = seatResponsibility.Obsolete; dispositionDb.SubmitChanges(); }
public void CreateResponsibility(Responsibility responsibility) { DispositionDataContext dispositionDb = new DispositionDataContext(); dispositionDb.Responsibilities.InsertOnSubmit(responsibility); dispositionDb.SubmitChanges(); }
public void DeleteResponsibilityById(int id) { DispositionDataContext dispositionDb = new DispositionDataContext(); var seatResponsibility = (from s in dispositionDb.Responsibilities where s.ResponsibilityID == id select s).Single(); dispositionDb.Responsibilities.DeleteOnSubmit(seatResponsibility); dispositionDb.SubmitChanges(); }
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 CreateDefect(Defect defect) { DispositionDataContext dispositionDb = new DispositionDataContext(); dispositionDb.Defects.InsertOnSubmit(defect); 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) { } }
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 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 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 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 void CreateSeatSide(SeatSide seatSide) { DispositionDataContext dispositionDb = new DispositionDataContext(); dispositionDb.SeatSides.InsertOnSubmit(seatSide); dispositionDb.SubmitChanges(); }
public void CreateSeatPortion(SeatPortion seatPortion) { DispositionDataContext dispositionDb = new DispositionDataContext(); dispositionDb.SeatPortions.InsertOnSubmit(seatPortion); dispositionDb.SubmitChanges(); }