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