public void UpdateReleaseReadyEdits(PartSetUp partsetup_) { try { var setuptoupdate = _qualityEntities.PartSetUp .FirstOrDefault(x => x.PartSetUpID == partsetup_.PartSetUpID); setuptoupdate.IsReleaseReady = partsetup_.IsReleaseReady; setuptoupdate.LastEditBy = partsetup_.LastEditBy; setuptoupdate.LastEditDate = partsetup_.LastEditDate; if (partsetup_.IsReleaseReady) { setuptoupdate.LastApprovalDateTime = partsetup_.LastApprovalDateTime; setuptoupdate.LastApprover = partsetup_.LastApprover; } _qualityEntities.SaveChanges(SaveOptions.None); _qualityEntities.Detach(partsetup_); } catch (Exception ex) { string errormessage = ex.ToString(); //TODO:Log the error } }
public void UpdateCommunicationNoteEdits(PartSetUp partsetup_) { try { var setuptoupdate = _qualityEntities.PartSetUp .FirstOrDefault(x => x.PartSetUpID == partsetup_.PartSetUpID); setuptoupdate.CommunicationNote = partsetup_.CommunicationNote; setuptoupdate.LastEditBy = partsetup_.LastEditBy; setuptoupdate.LastEditDate = partsetup_.LastEditDate; _qualityEntities.SaveChanges(SaveOptions.None); _qualityEntities.Detach(partsetup_); } catch (Exception ex) { string errormessage = ex.ToString(); //TODO:Log the error } }
public int Insert(PartSetUp partsetup_) { try { var partsetuptoinsert = new PartSetUp { PartID = partsetup_.PartID, CategoryID = partsetup_.CategoryID, CreatedBy = partsetup_.CreatedBy, CreateDate = partsetup_.CreateDate, DrawingFile = partsetup_.DrawingFile, DeviationFile = partsetup_.DeviationFile, DieSetUpFile = partsetup_.DieSetUpFile, Revision = partsetup_.Revision, SetupDrawingFile = partsetup_.SetupDrawingFile, HasQualityAlert = partsetup_.HasQualityAlert, QualityAlertFile = partsetup_.QualityAlertFile, RedLightGreenLightFile = partsetup_.RedLightGreenLightFile, PackCode = partsetup_.PackCode, IsReleaseReady = partsetup_.IsReleaseReady, PartRemarks = partsetup_.PartRemarks, PartComment = partsetup_.PartComment, DrawingNumber = partsetup_.DrawingNumber, LastApprovalDateTime = partsetup_.LastApprovalDateTime, Notes = partsetup_.Notes, CommunicationNote = partsetup_.CommunicationNote, LastApprover = partsetup_.LastApprover, LastEditDate = partsetup_.LastEditDate, LastEditBy = partsetup_.LastEditBy }; _qualityEntities.AddToPartSetUp(partsetuptoinsert); _qualityEntities.SaveChanges(true); return(partsetuptoinsert.PartSetUpID); } catch (Exception ex) { string errormessage = ex.ToString(); return(0); } }
public void Update(PartSetUp partsetup_) { var setuptoupdate = _qualityEntities.PartSetUp .FirstOrDefault(x => x.PartSetUpID == partsetup_.PartSetUpID); setuptoupdate.CategoryID = partsetup_.CategoryID; setuptoupdate.Revision = partsetup_.Revision; setuptoupdate.IsReleaseReady = partsetup_.IsReleaseReady; setuptoupdate.PartComment = partsetup_.PartComment; setuptoupdate.PartRemarks = partsetup_.PartRemarks; setuptoupdate.DrawingNumber = partsetup_.DrawingNumber; setuptoupdate.LastApprovalDateTime = partsetup_.LastApprovalDateTime; setuptoupdate.PackCode = partsetup_.PackCode; setuptoupdate.Notes = partsetup_.Notes; setuptoupdate.CommunicationNote = partsetup_.CommunicationNote; setuptoupdate.LastApprover = partsetup_.LastApprover; setuptoupdate.LastEditDate = partsetup_.LastEditDate; setuptoupdate.LastEditBy = partsetup_.LastEditBy; _qualityEntities.SaveChanges(SaveOptions.None); }
public OMIPdfGenerator(string partid_, string html, string outputFileName, bool returnAsAttachment, int numofcopies, string baseurl, PartSetUp partsetup, int partsetupid) { this.ContentType = "application/pdf"; if (html == string.Empty) { html = "<h2>There was a problem. No data was returned.</h2>"; } this.Content = html; this.OutputFileName = outputFileName; this.ReturnAsAttachment = true; this.NumofCopies = numofcopies; this.BaseUrl = baseurl; this.QualityAlert1File = partsetup.QualityAlertFile; this.QualityAlert1StartDte = partsetup.QualityAlertStartDte; this.QualityAlert1EndDte = partsetup.QualityAlertEndDte; this.QualityAlert2File = partsetup.QualityAlert2; this.QualityAlert2StartDte = partsetup.QualityAlert2StartDte; this.QualityAlert2EndDte = partsetup.QualityAlert2EndDte; this.MachineSetUpFile = partsetup.SetupDrawingFile; this.DeviationFile1Path = partsetup.DeviationFile; this.DeviationFile1StartDte = partsetup.DeviationFileStartDte; this.DeviationFile1EndDte = partsetup.DeviationFileEndDte; this.DeviationFile2Path = partsetup.DeviationFile2; this.DeviationFile2StartDte = partsetup.DeviationFile2StartDte; this.DeviationFile2EndDte = partsetup.DeviationFile2EndDte; this.DrawingFilePath = partsetup.DrawingFile; this.DieSetUpFilePath = partsetup.DieSetUpFile; this.AdditionalFilePath = partsetup.AdditionalFile; this.PartSetUpId = partsetupid; this.PartID = partid_; this.HtmlString = html; }
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); }