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();
}
