public override void Update()
{
try
{
if (!CheckIfJobTypeIsNewSetupAndQATaskIsEntered())
{
throw new Exception("You haven't entered a QA tasks for this job, sorry you cannot change job status to Proof");
}
SQLDBCommand dbc = new SQLDBCommand(SQLDBCommand.TransactionType.WithoutTransaction);
string jobSQL = string.Empty;
string jobCommand = string.Empty;
jobCommand = string.Format(SQLCommands.UpdateJob, CurrentJob.CustomerId, CurrentJob.JobDescription.Replace("'", "''"), CurrentJob.DocketNo, CurrentJob.LotNo, CurrentJob.LodgementDate, CurrentJob.CampaignManagerId,
CurrentJob.ProgrammerId, CurrentJob.DocketReceivedDate, CurrentJob.NoOfRecords, CurrentJob.NoOfFiles, CurrentJob.IsSOARequired, CurrentJob.IsPresortRequired, CurrentJob.IsAddressCleansingRequired,
CurrentJob.IsTitleCasingRequired, 5, CurrentJob.JobTypeId, CurrentJob.IsEDM, CurrentJob.IsLabel, CurrentJob.JobNotes.Replace("'", "''"), CurrentJob.JobId);
dbc.ExecuteCommand(jobCommand);
// Add Job Log
string activity = "Job Updated to PROOF - " + DateTime.Now.ToString();
dbc.ExecuteCommand(string.Format(SQLCommands.InsertJobLog, CurrentJob.JobId, activity));
dbc.CloseConnection();
dbc.CloseConnection();
JobTaskData jobTaskdata = new JobTaskData();
jobTaskdata.UpdateJobTasks(CurrentJob.JobTasks);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public override void Update()
{
try
{
if (!CheckIfAnyUndeletedTasksExists())
{
throw new Exception("You haven't entered any tasks, sorry you cannot close this job");
}
if (!CheckIfJobTypeIsNewSetupAndQATaskIsEntered())
{
throw new Exception("For 'DM-New setup' jobs You need to enter a QA entry, sorry you cannot close this job");
}
SQLDBCommand dbc = new SQLDBCommand(SQLDBCommand.TransactionType.WithoutTransaction);
// string jobSQL = string.Empty;
string jobCommand = string.Empty;
//jobSQL = "UPDATE Job SET CustomerId={0},JobDescription='{1}',DocketNo='{2}',LotNo='{3}',LodgementDate='{4}',CampaignManagerId={5},ProgrammerId={6}," +
//"DocketReceivedDate='{7}',NoOfRecords={8},NoOfFiles={9},IsSOARequired={10},IsPresortRequired={11},IsAddressCleansingRequired={12},IsTitleCasingRequired={13}," +
//"JobStatusId={14}, JobTypeId={15}, JobCompletedDate='{16}',IsEDM={17},IsLabel={18},JobNotes='{19}' WHERE JobId = {20}";
jobCommand = string.Format(SQLCommands.CompleteJob, CurrentJob.CustomerId, CurrentJob.JobDescription.Replace("'", "''"), CurrentJob.DocketNo, CurrentJob.LotNo, CurrentJob.LodgementDate, CurrentJob.CampaignManagerId,
CurrentJob.ProgrammerId, CurrentJob.DocketReceivedDate, CurrentJob.NoOfRecords, CurrentJob.NoOfFiles, CurrentJob.IsSOARequired, CurrentJob.IsPresortRequired, CurrentJob.IsAddressCleansingRequired,
CurrentJob.IsTitleCasingRequired, CurrentJob.JobStatusId, CurrentJob.JobTypeId, DateTime.Now, CurrentJob.IsEDM, CurrentJob.IsLabel, CurrentJob.JobNotes.Replace("'", "''"), CurrentJob.JobId);
dbc.ExecuteCommand(jobCommand);
// Add Job Log
string activity = "Job Completed - " + DateTime.Now.ToString();
dbc.ExecuteCommand(string.Format(SQLCommands.InsertJobLog, CurrentJob.JobId, activity));
dbc.CloseConnection();
dbc.CloseConnection();
JobTaskData jobTaskdata = new JobTaskData();
jobTaskdata.UpdateJobTasks(CurrentJob.JobTasks);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
// CurrentJob = job;
//}
public override void Update()
{
SQLDBCommand dbc = new SQLDBCommand(SQLDBCommand.TransactionType.WithoutTransaction);
string jobSQL = string.Empty;
string jobCommand = string.Empty;
jobCommand = string.Format(SQLCommands.UpdateJob, CurrentJob.CustomerId, CurrentJob.JobDescription.Replace("'", "''"), CurrentJob.DocketNo, CurrentJob.LotNo, CurrentJob.LodgementDate, CurrentJob.CampaignManagerId,
CurrentJob.ProgrammerId, CurrentJob.DocketReceivedDate, CurrentJob.NoOfRecords, CurrentJob.NoOfFiles, CurrentJob.IsSOARequired, CurrentJob.IsPresortRequired, CurrentJob.IsAddressCleansingRequired,
CurrentJob.IsTitleCasingRequired, 1, CurrentJob.JobTypeId, CurrentJob.IsEDM, CurrentJob.IsLabel, CurrentJob.JobNotes.Replace("'", "''"), CurrentJob.JobId);
dbc.ExecuteCommand(jobCommand);
// Add Job Log
string activity = "Job Updated to IN PROGRESS - " + DateTime.Now.ToString();
dbc.ExecuteCommand(string.Format(SQLCommands.InsertJobLog, CurrentJob.JobId, activity));
dbc.CloseConnection();
JobTaskData jobTaskdata = new JobTaskData();
jobTaskdata.UpdateJobTasks(CurrentJob.JobTasks);
}