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