public int Insert(AdditionalProcessing additionalprocess_) { try { var processtoinsert = new AdditionalProcessing { PartSetUpID = additionalprocess_.PartSetUpID, Notes = additionalprocess_.Notes, SequenceID = additionalprocess_.SequenceID, IsActive = additionalprocess_.IsActive, Description = additionalprocess_.Description, DescriptionES = additionalprocess_.DescriptionES, DescriptionCN = additionalprocess_.DescriptionCN, LastEditDate = additionalprocess_.LastEditDate, LastEditedBy = additionalprocess_.LastEditedBy }; _qualityEntities.AddToAdditionalProcessings(processtoinsert); _qualityEntities.SaveChanges(SaveOptions.None); // _qualityEntities.Detach(additionalprocess_); return(processtoinsert.ProcessingID); } catch (Exception ex) { string errormessage = ex.ToString(); return(0); //TODO:Log the error } }
public void InsertClonedAdditionalProcess(Int16 partsetupid_, string descEnglish_, string descSpanish_, string notes_, string sequenceid_, string lastupdatedby_, DateTime lastupdateddate_) { try { AdditionalProcessing processtoinsert = new AdditionalProcessing { PartSetUpID = partsetupid_, Notes = notes_, SequenceID = sequenceid_, IsActive = true, Description = descEnglish_, DescriptionES = descSpanish_, LastEditDate = lastupdateddate_, LastEditedBy = lastupdatedby_ }; _qualityEntities.AddToAdditionalProcessings(processtoinsert); _qualityEntities.SaveChanges(SaveOptions.None); _qualityEntities.Detach(processtoinsert); } catch (Exception ex) { string errormessage = ex.ToString(); //TODO:Log the error } }
public void UpdateAdditionalProcessingSequenceOrder(AdditionalProcessing additionalprocess_) { var additionalprocesstoupdate = _qualityEntities.AdditionalProcessings .FirstOrDefault(x => x.ProcessingID == additionalprocess_.ProcessingID); additionalprocesstoupdate.SequenceID = additionalprocess_.SequenceID; additionalprocesstoupdate.LastEditedBy = additionalprocess_.LastEditedBy; additionalprocesstoupdate.LastEditDate = DateTime.Now; _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); }