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>
/// Save
/// </summary>
/// <param name="countryId">countryId</param>
/// <param name="provinceId">provinceId</param>
/// <param name="countyId">countyId</param>
/// <param name="cityId">cityId</param>
/// <param name="projectId">projectId</param>
/// <param name="assetId">assetId</param>
/// <param name="companyId">companyId</param>
/// <param name="inProject">inProject</param>
/// <returns>WorkID</returns>
public int Save(Int64? countryId, Int64? provinceId, Int64? countyId, Int64? cityId, int projectId, int assetId, int companyId, bool inProject)
{
ManholeRehabilitationTDS manholeRehabilitationChanges = (ManholeRehabilitationTDS)Data.GetChanges();
int workId = 0;
if (manholeRehabilitationChanges.WorkDetails.Rows.Count > 0)
{
ManholeRehabilitationWorkDetailsGateway manholeRehabilitationWorkDetailsGateway = new ManholeRehabilitationWorkDetailsGateway(manholeRehabilitationChanges);
// Update manhole rehabilitation
foreach (ManholeRehabilitationTDS.WorkDetailsRow row in (ManholeRehabilitationTDS.WorkDetailsDataTable)manholeRehabilitationChanges.WorkDetails)
{
// Unchanged values
workId = row.WorkID;
WorkManholeRehabilitationGateway workManholeRehabilitationGateway = new WorkManholeRehabilitationGateway();
workManholeRehabilitationGateway.LoadByWorkId(workId, companyId);
if (workManholeRehabilitationGateway.Table.Rows.Count > 0)
{
// Update Information
// Original values
// ... work values
DateTime? originalPreppedDate = manholeRehabilitationWorkDetailsGateway.GetPreppedDateOriginal(workId);
DateTime? originalSprayedDate = manholeRehabilitationWorkDetailsGateway.GetSprayedDateOriginal(workId);
// ... Comments
string originalComments = manholeRehabilitationWorkDetailsGateway.GetCommentsOriginal(workId);
// New variables
DateTime? newPreppedDate = manholeRehabilitationWorkDetailsGateway.GetPreppedDate(workId);
DateTime? newSprayedDate = manholeRehabilitationWorkDetailsGateway.GetSprayedDate(workId);
// comments
string newComments = manholeRehabilitationWorkDetailsGateway.GetComments(workId);
// Update work
UpdateWork(countryId, provinceId, countyId, cityId, projectId, assetId, originalPreppedDate, originalSprayedDate, row.BatchID, originalComments, false, companyId, newPreppedDate, newSprayedDate, row.BatchID, newComments, false);
}
else
{
// Loading workId
WorkGateway workGateway = new WorkGateway();
workGateway.LoadByProjectIdAssetIdWorkType(projectId, assetId, "Manhole Rehabilitation", companyId);
if (workGateway.Table.Rows.Count == 0)
{
// New variables
DateTime? newPreppedDate = manholeRehabilitationWorkDetailsGateway.GetPreppedDate(workId);
DateTime? newSprayedDate = manholeRehabilitationWorkDetailsGateway.GetSprayedDate(workId);
int? newBatchId = manholeRehabilitationWorkDetailsGateway.GetBatchID(workId);
string newComments = manholeRehabilitationWorkDetailsGateway.GetComments(workId);
// InsertWork
Work work = new Work();
int? libraryCategories = null;
string history = "";
int newWorkId = work.InsertDirect(projectId, assetId, "Manhole Rehabilitation", libraryCategories, false, companyId, newComments, history);
// ... Insert manhole rehabilitation work
WorkManholeRehabilitation workManholeRehabilitation = new WorkManholeRehabilitation();
workManholeRehabilitation.InsertDirect(newWorkId, newPreppedDate, newSprayedDate, newBatchId, false, companyId);
workId = newWorkId;
}
}
}
}
return workId;
}
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;
}
}
}