// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// LoadAll
/// </summary>
/// <param name="companyId">companyId</param>
public void LoadAll(int companyId)
{
MrBatchVerificationGateway mrBatchVerificationGateway = new MrBatchVerificationGateway(Data);
mrBatchVerificationGateway.LoadAll(companyId);
}
private void LoadWorkData(int workId, int assetId)
{
int companyId = Int32.Parse(hdfCompanyId.Value);
if (workId != 0)
{
ManholeRehabilitationWorkDetailsGateway manholeRehabilitationWorkDetailsGateway = new ManholeRehabilitationWorkDetailsGateway(manholeRehabilitationTDS);
if (manholeRehabilitationWorkDetailsGateway.Table.Rows.Count > 0)
{
if (manholeRehabilitationWorkDetailsGateway.GetPreppedDate(workId).HasValue)
{
DateTime preppedDate = (DateTime)manholeRehabilitationWorkDetailsGateway.GetPreppedDate(workId);
tkrdpRehabilitationPreppedDate.SelectedDate = DateTime.Parse(preppedDate.Month.ToString() + "/" + preppedDate.Day.ToString() + "/" + preppedDate.Year.ToString());
}
if (manholeRehabilitationWorkDetailsGateway.GetSprayedDate(workId).HasValue)
{
DateTime sprayedDate = (DateTime)manholeRehabilitationWorkDetailsGateway.GetSprayedDate(workId);
tkrdpRehabilitationSprayedDate.SelectedDate = DateTime.Parse(sprayedDate.Month.ToString() + "/" + sprayedDate.Day.ToString() + "/" + sprayedDate.Year.ToString());
}
if (manholeRehabilitationWorkDetailsGateway.GetDate(workId).HasValue)
{
//Load saved batch
int batchId = (manholeRehabilitationWorkDetailsGateway.GetBatchID(workId));
ddlRehabilitationBatchDate.SelectedValue = batchId.ToString();
hdfExistBatchId.Value = "True";
hdfBatchId.Value = batchId.ToString();
}
else
{
ddlRehabilitationBatchDate.SelectedValue = "0";
hdfExistBatchId.Value = "False";
}
// Show Comments
tbxCommentsDataComments.Text = manholeRehabilitationWorkDetailsGateway.GetComments(workId);
// ... ... Store datasets
Session["manholeRehabilitationTDS"] = manholeRehabilitationTDS;
}
}
// Load last batch
MrBatchVerificationGateway mrBatchVerificationGateway = new MrBatchVerificationGateway();
mrBatchVerificationGateway.LoadAll(companyId);
if (mrBatchVerificationGateway.Table.Rows.Count > 0)
{
WorkManholeRehabilitationBatchGateway workManholeRehabilitationBatchGateway = new WorkManholeRehabilitationBatchGateway();
hdfBatchId.Value = workManholeRehabilitationBatchGateway.GetLastId(companyId).ToString();
int batchId = Int32.Parse(hdfBatchId.Value);
mrBatchVerificationGateway.LoadByBatchId(batchId, companyId);
DateTime batchDate = mrBatchVerificationGateway.GetDate(batchId);
tbxLastRehabilitationBatchDate.Text = batchDate.Month.ToString() + "/" + batchDate.Day.ToString() + "/" + batchDate.Year.ToString();
lblBatchDateRequired.Visible = false;
// ... ... Store datasets
Session["manholeRehabilitationTDS"] = manholeRehabilitationTDS;
}
else
{
lblBatchDateRequired.Visible = true;
}
}
/// <summary>
/// Update
/// </summary>
/// <param name="workId">workId</param>
/// <param name="preppedDate">preppedDate</param>
/// <param name="sprayedDate">sprayedDate</param>
/// <param name="batchId">batchId</param>
/// <param name="date">date</param>
/// <param name="companyId">companyId</param>
public void Update(int workId, DateTime? preppedDate, DateTime? sprayedDate, int? batchId, DateTime date, int companyId)
{
WorkManholeRehabilitationGateway workManholeRehabilitationGatewayForReview = new WorkManholeRehabilitationGateway();
workManholeRehabilitationGatewayForReview.LoadByWorkId(workId, companyId);
if (workManholeRehabilitationGatewayForReview.Table.Rows.Count > 0)
{
// Update work
ManholeRehabilitationTDS.WorkDetailsRow row = GetRow(workId);
if (preppedDate.HasValue) row.PreppedDate = (DateTime)preppedDate; else row.SetPreppedDateNull();
if (sprayedDate.HasValue) row.SprayedDate = (DateTime)sprayedDate; else row.SetSprayedDateNull();
row.Date = date;
row.BatchID = (int)batchId;
}
else
{
// ... Insert work
ManholeRehabilitationTDS.WorkDetailsRow lfsManholeRehabilitationRow = ((ManholeRehabilitationTDS.WorkDetailsDataTable)Table).NewWorkDetailsRow();
workId = GetNewId();
lfsManholeRehabilitationRow.WorkID = workId;
if (preppedDate.HasValue) lfsManholeRehabilitationRow.PreppedDate = (DateTime)preppedDate; else lfsManholeRehabilitationRow.SetPreppedDateNull();
if (sprayedDate.HasValue) lfsManholeRehabilitationRow.SprayedDate = (DateTime)sprayedDate; else lfsManholeRehabilitationRow.SetSprayedDateNull();
lfsManholeRehabilitationRow.BatchID = 0;
MrBatchVerificationGateway mrBatchVerificationGateway = new MrBatchVerificationGateway();
mrBatchVerificationGateway.LoadAll(companyId);
if (mrBatchVerificationGateway.Table.Rows.Count > 0)
{
WorkManholeRehabilitationBatchGateway workManholeRehabilitationBatchGateway = new WorkManholeRehabilitationBatchGateway();
lfsManholeRehabilitationRow.BatchID = workManholeRehabilitationBatchGateway.GetLastId(companyId);
}
else
{
lfsManholeRehabilitationRow.SetBatchIDNull();
}
lfsManholeRehabilitationRow.Date = (DateTime)date;
lfsManholeRehabilitationRow.Deleted = false;
lfsManholeRehabilitationRow.COMPANY_ID = companyId;
((ManholeRehabilitationTDS.WorkDetailsDataTable)Table).AddWorkDetailsRow(lfsManholeRehabilitationRow);
}
}
private void LoadWorkData(int workId, int assetId)
{
int companyId = Int32.Parse(hdfCompanyId.Value);
if (workId != 0)
{
ManholeRehabilitationWorkDetailsGateway manholeRehabilitationWorkDetailsGateway = new ManholeRehabilitationWorkDetailsGateway(manholeRehabilitationTDS);
if (manholeRehabilitationWorkDetailsGateway.Table.Rows.Count > 0)
{
tbxRehabilitationPreppedDate.Text = "";
if (manholeRehabilitationWorkDetailsGateway.GetPreppedDate(workId).HasValue)
{
DateTime preppedDate = (DateTime)manholeRehabilitationWorkDetailsGateway.GetPreppedDate(workId);
tbxRehabilitationPreppedDate.Text = preppedDate.Month.ToString() + "/" + preppedDate.Day.ToString() + "/" + preppedDate.Year.ToString();
}
tbxRehabilitationSprayedDate.Text = "";
if (manholeRehabilitationWorkDetailsGateway.GetSprayedDate(workId).HasValue)
{
DateTime sprayedDate = (DateTime)manholeRehabilitationWorkDetailsGateway.GetSprayedDate(workId);
tbxRehabilitationSprayedDate.Text = sprayedDate.Month.ToString() + "/" + sprayedDate.Day.ToString() + "/" + sprayedDate.Year.ToString();
}
tbxRehabilitationBatchDate.Text = "";
if (manholeRehabilitationWorkDetailsGateway.GetDate(workId).HasValue)
{
try
{
DateTime batchDate = (DateTime)manholeRehabilitationWorkDetailsGateway.GetDate(workId);
tbxRehabilitationBatchDate.Text = batchDate.Month.ToString() + "/" + batchDate.Day.ToString() + "/" + batchDate.Year.ToString();
hdfBatchId.Value = manholeRehabilitationWorkDetailsGateway.GetBatchID(workId).ToString();
}
catch
{
}
}
// Show Comments
tbxCommentsDataComments.Text = manholeRehabilitationWorkDetailsGateway.GetComments(workId);
// ... ... Store datasets
Session["manholeRehabilitationTDS"] = manholeRehabilitationTDS;
}
}
else
{
// Load last batch
MrBatchVerificationGateway mrBatchVerificationGateway = new MrBatchVerificationGateway();
mrBatchVerificationGateway.LoadAll(companyId);
if (mrBatchVerificationGateway.Table.Rows.Count > 0)
{
WorkManholeRehabilitationBatchGateway workManholeRehabilitationBatchGateway = new WorkManholeRehabilitationBatchGateway();
hdfBatchId.Value = workManholeRehabilitationBatchGateway.GetLastId(companyId).ToString();
int batchId = Int32.Parse(hdfBatchId.Value);
mrBatchVerificationGateway.LoadByBatchId(batchId, companyId);
DateTime batchDate = mrBatchVerificationGateway.GetDate(batchId);
tbxRehabilitationBatchDate.Text = batchDate.Month.ToString() + "/" + batchDate.Day.ToString() + "/" + batchDate.Year.ToString();
// ... ... Store datasets
Session["manholeRehabilitationTDS"] = manholeRehabilitationTDS;
}
}
}
