/// <summary>
/// Save all batch to database (direct)
/// </summary>
/// <param name="companyId">companyId</param>
public void Save(int companyId)
{
MrBatchVerificationTDS flBatchValidationChanges = (MrBatchVerificationTDS)Data.GetChanges();
if (flBatchValidationChanges != null)
{
if (flBatchValidationChanges.BatchValidation.Rows.Count > 0)
{
MrBatchVerificationGateway mrBatchVerificationGateway = new MrBatchVerificationGateway(flBatchValidationChanges);
foreach (MrBatchVerificationTDS.BatchValidationRow row in (MrBatchVerificationTDS.BatchValidationDataTable)flBatchValidationChanges.BatchValidation)
{
// Insert new catalysts
if ((!row.Deleted) && (!row.InDatabase))
{
WorkManholeRehabilitationBatch workManholeRehabilitationBatch = new WorkManholeRehabilitationBatch(null);
workManholeRehabilitationBatch.InsertDirect(row.BatchID, row.Description, row.Date, row.Deleted, row.COMPANY_ID);
}
//Update catalysts
if ((!row.Deleted) && (row.InDatabase))
{
int batchId = row.BatchID;
bool originalDeleted = false;
int originalCompanyId = companyId;
//original values
string originalDescription = mrBatchVerificationGateway.GetDescriptionOriginal(batchId);
DateTime originalDate = mrBatchVerificationGateway.GetDateOriginal(batchId);
// new values
string newDescription = mrBatchVerificationGateway.GetDescription(batchId);
DateTime newDate = mrBatchVerificationGateway.GetDate(batchId);
WorkManholeRehabilitationBatch workManholeRehabilitationBatch = new WorkManholeRehabilitationBatch(null);
workManholeRehabilitationBatch.UpdateDirect(batchId, originalDescription, originalDate, originalDeleted, originalCompanyId, batchId, newDescription, newDate, originalDeleted, originalCompanyId);
}
// Deleted catalysts
if ((row.Deleted) && (row.InDatabase))
{
WorkManholeRehabilitationBatch workManholeRehabilitationBatch = new WorkManholeRehabilitationBatch(null);
workManholeRehabilitationBatch.DeleteDirect(row.BatchID, row.COMPANY_ID);
}
}
}
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_CWP_MANHOLEREHABILITATION_ADMIN"])))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
// Validate query string
if (((string)Request.QueryString["source_page"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in mr_batch_add.aspx");
}
// Tag page
hdfCompanyId.Value = Session["companyID"].ToString();
hdfUpdate.Value = "no";
Session.Remove("mrBatchVerification");
Session.Remove("mrBatchVerificationDummy");
// Load information
mrBatchVerificationTDS = new MrBatchVerificationTDS();
int companyId = Int32.Parse(hdfCompanyId.Value);
MrBatchVerification mrBatchVerificationForLastRow = new MrBatchVerification();
mrBatchVerificationForLastRow.LoadLastBatch(companyId);
if (mrBatchVerificationForLastRow.Table.Rows.Count > 0)
{
MrBatchVerificationGateway mrBatchVerificationGatewayForLastRow = new MrBatchVerificationGateway(mrBatchVerificationForLastRow.Data);
WorkManholeRehabilitationBatchGateway workManholeRehabilitationBatchGateway = new WorkManholeRehabilitationBatchGateway();
hdfBatchId.Value = workManholeRehabilitationBatchGateway.GetLastId(companyId).ToString();
int batchId = Int32.Parse(hdfBatchId.Value);
DateTime date = mrBatchVerificationGatewayForLastRow.GetDate(batchId);
hdfBatchDate.Value = date.Month.ToString() + "/" + date.Day.ToString() + "/" + date.Year.ToString();
hdfBatchDescription.Value = mrBatchVerificationGatewayForLastRow.GetDescription(batchId);
}
// ... Store datasets
Session["mrBatchVerificationTDS"] = mrBatchVerificationTDS;
Session["mrBatchVerification"] = mrBatchVerificationTDS.BatchValidation;
// StepIn
wizardBatch.ActiveStepIndex = 0;
StepNewBatchIn();
}
else
{
// Restore datasets
mrBatchVerificationTDS = (MrBatchVerificationTDS)Session["mrBatchVerificationTDS"];
// Store
Session["mrBatchVerification"] = mrBatchVerificationTDS.BatchValidation;
}
}
// /////////////////////////////////////////////////////////////////////////////////////////////////////
//
// STEP1 - BEGIN
//
// ////////////////////////////////////////////////////////////////////////
// STEP - BEGIN - AUXILIAR EVENTS
//
protected void StartBatch_OnCheckedChanged(object sender, EventArgs e)
{
if (rbtnUseLastBatch.Checked)
{
int companyId = Int32.Parse(hdfCompanyId.Value);
MrBatchVerification mrBatchVerificationForLastRow = new MrBatchVerification(mrBatchVerificationTDS);
mrBatchVerificationForLastRow.LoadLastBatch(companyId);
if (mrBatchVerificationForLastRow.Table.Rows.Count > 0)
{
MrBatchVerificationGateway mrBatchVerificationGatewayForLastRow = new MrBatchVerificationGateway(mrBatchVerificationForLastRow.Data);
WorkManholeRehabilitationBatchGateway workManholeRehabilitationBatchGateway = new WorkManholeRehabilitationBatchGateway();
hdfBatchId.Value = workManholeRehabilitationBatchGateway.GetLastId(companyId).ToString();
int batchId = Int32.Parse(hdfBatchId.Value);
DateTime date = mrBatchVerificationGatewayForLastRow.GetDate(batchId);
hdfBatchDate.Value = date.Month.ToString() + "/" + date.Day.ToString() + "/" + date.Year.ToString();
hdfBatchDescription.Value = mrBatchVerificationGatewayForLastRow.GetDescription(batchId);
// Show messages at wizard
lblBatchIdWarning.Visible = false;
lblBatchLast.Visible = true;
lblBatchLast.Text = "Last Batch used: " + hdfBatchDate.Value + " " + hdfBatchDescription.Value;
}
else
{
lblBatchIdWarning.Visible = true;
lblBatchLast.Visible = false;
}
}
if (rbtnUseNewBatch.Checked)
{
lblBatchIdWarning.Visible = false;
lblBatchLast.Visible = false;
}
}
