public void Update(PartSpecification partspecification_)
{
//test
var partspecificationtoupdate = _qualityEntities.PartSpecifications
.FirstOrDefault(x => x.SpecificationID == partspecification_.SpecificationID);
partspecificationtoupdate.Notes = partspecification_.Notes;
partspecificationtoupdate.Characteristic = partspecification_.Characteristic;
partspecificationtoupdate.CharacteristicES = partspecification_.CharacteristicES;
partspecificationtoupdate.CharacteristicCN = partspecification_.CharacteristicCN;
partspecificationtoupdate.unitID = partspecification_.unitID;
partspecificationtoupdate.LowSpec = partspecification_.LowSpec;
partspecificationtoupdate.LowSpecES = partspecification_.LowSpecES;
partspecificationtoupdate.HighSpec = partspecification_.HighSpec;
partspecificationtoupdate.HighSpecES = partspecification_.HighSpecES;
partspecificationtoupdate.IsActive = partspecification_.IsActive;
partspecificationtoupdate.MeasurementMethodID = partspecification_.MeasurementMethodID;
partspecificationtoupdate.Gauges = partspecification_.Gauges;
partspecificationtoupdate.GaugesES = partspecification_.GaugesES;
partspecificationtoupdate.SampleSize = partspecification_.SampleSize;
partspecificationtoupdate.SampleSizeES = partspecification_.SampleSizeES;
partspecificationtoupdate.FrequencyID = partspecification_.FrequencyID;
partspecificationtoupdate.OperationCode = partspecification_.OperationCode;
partspecificationtoupdate.IsComponentCharacteristic = partspecification_.IsComponentCharacteristic;
partspecificationtoupdate.IsMachineSetUpCharacteristic = partspecification_.IsMachineSetUpCharacteristic;
partspecificationtoupdate.IsPartCharacteristic = partspecification_.IsPartCharacteristic;
partspecificationtoupdate.IsDieSetUpCharcteristic = partspecification_.IsDieSetUpCharcteristic;
partspecificationtoupdate.LastEditBy = partspecification_.LastEditBy;
partspecificationtoupdate.LastEditDate = DateTime.Now;
_qualityEntities.SaveChanges(SaveOptions.None);
}
public void Update(UserSetting UserSetting_)
{
var usersettingtoupdate = _qualityEntities.UserSettings
.FirstOrDefault(x => x.UserID == UserSetting_.UserID);
usersettingtoupdate.PlantCodeID = UserSetting_.PlantCodeID;
usersettingtoupdate.LanguageID = UserSetting_.LanguageID;
_qualityEntities.SaveChanges(SaveOptions.None);
}
public void Update(TravelCard.DomainModel.Entities.TCBarCode TCBarCode_)
{
var tcbarcodetoupdate = _qualityEntities.TCBarCodes
.FirstOrDefault(x => x.TCBarCodeID == TCBarCode_.TCBarCodeID);
tcbarcodetoupdate.PartSetUpID = TCBarCode_.PartSetUpID;
tcbarcodetoupdate.BarCodeText = TCBarCode_.BarCodeText;
tcbarcodetoupdate.BarCodeFile = TCBarCode_.BarCodeFile;
_qualityEntities.SaveChanges(SaveOptions.None);
}
public void Update(AdditionalProcessing additionalprocess_)
{
var processtoupdate = _qualityEntities.AdditionalProcessings
.FirstOrDefault(x => x.ProcessingID == additionalprocess_.ProcessingID);
// processtoupdate.PartSetUpID = additionalprocess_.PartSetUpID;
processtoupdate.Notes = additionalprocess_.Notes;
processtoupdate.SequenceID = additionalprocess_.SequenceID;
processtoupdate.IsActive = additionalprocess_.IsActive;
processtoupdate.Description = additionalprocess_.Description;
processtoupdate.DescriptionES = additionalprocess_.DescriptionES;
processtoupdate.DescriptionCN = additionalprocess_.DescriptionCN;
processtoupdate.LastEditedBy = additionalprocess_.LastEditedBy;
processtoupdate.LastEditDate = additionalprocess_.LastEditDate;
_qualityEntities.SaveChanges(SaveOptions.None);
}
public void Update(MeasurementMethod MeasurementMethod_)
{
var methodtoupdate = _qualityEntities.MeasurementMethods
.FirstOrDefault(x => x.MeasurementMethodID == MeasurementMethod_.MeasurementMethodID);
methodtoupdate.Description_EN = MeasurementMethod_.Description_EN;
methodtoupdate.Description_MX = MeasurementMethod_.Description_MX;
methodtoupdate.Description_CN = MeasurementMethod_.Description_CN;
methodtoupdate.IsActive = MeasurementMethod_.IsActive;
methodtoupdate.Notes = MeasurementMethod_.Notes;
methodtoupdate.LastEditDate = MeasurementMethod_.LastEditDate;
methodtoupdate.LastEditBy = MeasurementMethod_.LastEditBy;
_qualityEntities.SaveChanges(SaveOptions.None);
}
public void Update(Frequency Frequency_)
{
var frequencytoupdate = _qualityEntities.Frequencies
.FirstOrDefault(x => x.FrequencyID == Frequency_.FrequencyID);
frequencytoupdate.Description_EN = Frequency_.Description_EN;
frequencytoupdate.Description_MX = Frequency_.Description_MX;
frequencytoupdate.Description_CN = Frequency_.Description_CN;
frequencytoupdate.IsActive = Frequency_.IsActive;
frequencytoupdate.Notes = Frequency_.Notes;
frequencytoupdate.LastEditDate = Frequency_.LastEditDate;
frequencytoupdate.LastEditBy = Frequency_.LastEditBy;
_qualityEntities.SaveChanges(SaveOptions.None);
}
public void Update(PartCategory PartCategory_)
{
var categorytoupdate = _qualityEntities.PartCategories
.FirstOrDefault(x => x.CategoryID == PartCategory_.CategoryID);
categorytoupdate.CategoryName = PartCategory_.CategoryName;
categorytoupdate.CategoryNameES = PartCategory_.CategoryNameES;
categorytoupdate.CategoryNameCN = PartCategory_.CategoryNameCN;
categorytoupdate.CategoryDescription = PartCategory_.CategoryDescription;
categorytoupdate.CategoryDescriptionCN = PartCategory_.CategoryDescriptionCN;
categorytoupdate.CategoryDescriptionES = PartCategory_.CategoryDescriptionES;
categorytoupdate.IsActive = PartCategory_.IsActive;
categorytoupdate.Notes = PartCategory_.Notes;
categorytoupdate.LastEditDate = PartCategory_.LastEditDate;
categorytoupdate.LastEditedBy = PartCategory_.LastEditedBy;
_qualityEntities.SaveChanges(SaveOptions.None);
}
public void Update(TravelCard.DomainModel.Entities.TravelCard TravelCard_)
{
var travelcardtoupdate = _qualityEntities.TravelCards
.FirstOrDefault(x => x.TCID == TravelCard_.TCID);
travelcardtoupdate.PartSetUpID = TravelCard_.PartSetUpID;
travelcardtoupdate.TCBarCodeText = TravelCard_.TCBarCodeText;
travelcardtoupdate.IsContinuationCard = TravelCard_.IsContinuationCard;
travelcardtoupdate.IsDraft = TravelCard_.IsDraft;
travelcardtoupdate.OperationCode = TravelCard_.OperationCode;
travelcardtoupdate.PrintDate = TravelCard_.PrintDate;
travelcardtoupdate.PrintDate = TravelCard_.PrintDate;
travelcardtoupdate.PrintLocation = TravelCard_.PrintLocation;
travelcardtoupdate.LanguageID = TravelCard_.LanguageID;
travelcardtoupdate.PrintedBy = TravelCard_.PrintedBy;
travelcardtoupdate.Notes = TravelCard_.Notes;
_qualityEntities.SaveChanges(SaveOptions.AcceptAllChangesAfterSave);
}
public void UpdateAttachments(PartSetUp partsetup_)
{
var setuptoupdate = _qualityEntities.PartSetUp
.FirstOrDefault(x => x.PartSetUpID == partsetup_.PartSetUpID);
var drawingfile = partsetup_.DrawingFile != null || partsetup_.DrawingFile != "" ? partsetup_.DrawingFile : null;
var deviationfile = partsetup_.DeviationFile != null || partsetup_.DeviationFile != "" ? partsetup_.DeviationFile : null;
var deviationfile2 = partsetup_.DeviationFile2 != null || partsetup_.DeviationFile2 != "" ? partsetup_.DeviationFile2 : null;
var diesetup = partsetup_.DieSetUpFile != null || partsetup_.DieSetUpFile != "" ? partsetup_.DieSetUpFile : null;
var setupdrawing = partsetup_.DrawingFile != null || partsetup_.SetupDrawingFile != "" ? partsetup_.SetupDrawingFile : null;
var qualityalertfile = partsetup_.QualityAlertFile != null || partsetup_.QualityAlertFile != "" ? partsetup_.QualityAlertFile : null;
var qualityalertfile2 = partsetup_.QualityAlert2 != null || partsetup_.QualityAlert2 != "" ? partsetup_.QualityAlert2 : null;
var redlightgreenlightfile = partsetup_.RedLightGreenLightFile != null || partsetup_.RedLightGreenLightFile != "" ? partsetup_.RedLightGreenLightFile : null;
var additionalfile = partsetup_.AdditionalFile != null || partsetup_.AdditionalFile != "" ? partsetup_.AdditionalFile : null;
if (drawingfile != null)
{
setuptoupdate.DrawingFile = drawingfile;
}
if (deviationfile != null)
{
var startdate = partsetup_.DeviationFileStartDte != null ? partsetup_.DeviationFileStartDte : null;
var enddate = partsetup_.DeviationFileEndDte != null ? partsetup_.DeviationFileEndDte : null;
setuptoupdate.DeviationFile = deviationfile;
setuptoupdate.DeviationFileStartDte = startdate;
setuptoupdate.DeviationFileEndDte = enddate;
}
if (deviationfile2 != null)
{
var startdate = partsetup_.DeviationFile2StartDte != null ? partsetup_.DeviationFile2StartDte : null;
var enddate = partsetup_.DeviationFile2EndDte != null ? partsetup_.DeviationFile2EndDte : null;
setuptoupdate.DeviationFile2 = deviationfile2;
setuptoupdate.DeviationFile2StartDte = startdate;
setuptoupdate.DeviationFile2EndDte = enddate;
}
if (diesetup != null)
{
setuptoupdate.DieSetUpFile = diesetup;
}
if (setupdrawing != null)
{
setuptoupdate.SetupDrawingFile = setupdrawing;
}
if (qualityalertfile != null)
{
setuptoupdate.QualityAlertFile = qualityalertfile;
var startdate = partsetup_.QualityAlertStartDte != null ? partsetup_.QualityAlertStartDte : null;
var enddate = partsetup_.QualityAlertEndDte != null ? partsetup_.QualityAlertEndDte : null;
setuptoupdate.QualityAlertStartDte = startdate;
setuptoupdate.QualityAlertEndDte = enddate;
}
if (qualityalertfile2 != null)
{
setuptoupdate.QualityAlert2 = qualityalertfile2;
var startdate = partsetup_.QualityAlert2StartDte != null ? partsetup_.QualityAlert2StartDte : null;
var enddate = partsetup_.QualityAlert2EndDte != null ? partsetup_.QualityAlert2EndDte : null;
setuptoupdate.QualityAlert2StartDte = startdate;
setuptoupdate.QualityAlert2EndDte = enddate;
}
if (redlightgreenlightfile != null)
{
setuptoupdate.RedLightGreenLightFile = partsetup_.RedLightGreenLightFile;
}
if (additionalfile != null)
{
setuptoupdate.AdditionalFile = partsetup_.AdditionalFile;
}
setuptoupdate.HasQualityAlert = partsetup_.HasQualityAlert;
_qualityEntities.SaveChanges(SaveOptions.None);
}
