/// ////////////////////////////////////////////////////////////////////////
/// EVENTS
///
protected void Page_Load(object sender, System.EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!Convert.ToBoolean(Session["sgLFS_APP_VIEW"]))
{
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) && ((string)Request.QueryString["record_deleted"] == null))
{
Response.Redirect("./../error_page.aspx?error=" + "Invalid query string in view_fulllength.aspx");
}
// Prepare initial values
Session.Remove("pointRepairDummy");
addRecordTDS = new AddRecordTDS();
// If coming from navigator2.aspx or view_scopesheet.aspx
if (((string)Request.QueryString["source_page"] == "navigator2.aspx") || ((string)Request.QueryString["source_page"] == "view_scopesheet.aspx"))
{
int companyId = Convert.ToInt32(Session["companyID"]);
Guid id = (Guid)Session["lfsMasterAreaId"];
//... Get lfs master area record
LFSRecordGateway lfsRecordGateway = new LFSRecordGateway();
tdsLfsRecord = lfsRecordGateway.GetRecordByIdCompanyId(id, companyId);
AddRecordPointRepairsGateway addRecordPointRepairsGateway = new AddRecordPointRepairsGateway(addRecordTDS);
addRecordPointRepairsGateway.LoadById(id, companyId);
//... Store datasets
Session["tdsLfsRecord"] = tdsLfsRecord;
Session["addRecordTDS"] = addRecordTDS;
pointRepairs = addRecordTDS.PointRepairs;
Session["pointRepairs"] = pointRepairs;
}
// If coming from delete_record.aspx
if ((string)Request.QueryString["record_deleted"] == "false")
{
//... Restore dataset lfs record
tdsLfsRecord = (TDSLFSRecord)Session["tdsLfsRecord"];
addRecordTDS = (AddRecordTDS)Session["addRecordTDS"];
}
// Prepare initial data
// ... for client
CompaniesGateway companiesGateway = new CompaniesGateway();
tbxCOMPANIES_ID.Text = companiesGateway.GetName((int)tdsLfsRecord.LFS_MASTER_AREA.Rows[0]["COMPANIES_ID"], Convert.ToInt32(Session["companyID"]));
// ... for traffic control
LFSTrafficControlGateway lfsTrafficControlGateway = new LFSTrafficControlGateway();
DataSet dsLfsTrafficControl = lfsTrafficControlGateway.GetLFSTrafficControlForDropDownList("");
ddlDegreeOfTrafficControl.DataSource = dsLfsTrafficControl;
ddlDegreeOfTrafficControl.DataTextField = "TrafficControl";
// Databind
Page.DataBind();
TDSLFSRecord.LFS_MASTER_AREARow lfsMasterAreaRow = tdsLfsRecord.LFS_MASTER_AREA.FindByIDCOMPANY_ID(new Guid(tbxID.Text), Convert.ToInt32(Session["companyID"]));
ddlDegreeOfTrafficControl.SelectedValue = (lfsMasterAreaRow.IsDegreeOfTrafficControlNull()) ? "" : lfsMasterAreaRow.DegreeOfTrafficControl;
}
else
{
// Restore datasets
tdsLfsRecord = (TDSLFSRecord)Session["tdsLfsRecord"];
addRecordTDS = (AddRecordTDS)Session["addRecordTDS"];
}
}
/// ////////////////////////////////////////////////////////////////////////
/// EVENTS
///
//
// Page_Load
//
protected void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
//--- Security check
if (!Convert.ToBoolean(Session["sgLFS_APP_VIEW"]))
{
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) && ((string)Request.QueryString["record_deleted"] == null))
{
Response.Redirect("./../error_page.aspx?error=" + "Invalid query string in view_fulllength.aspx");
}
//--- If coming from navigator2.aspx or view_fulllength.aspx
if (((string)Request.QueryString["source_page"] == "navigator2.aspx") || ((string)Request.QueryString["source_page"] == "view_fulllength.aspx"))
{
//--- Get lfs master area record
LFSRecordGateway lfsRecordGateway = new LFSRecordGateway();
tdsLfsRecord = lfsRecordGateway.GetRecordByIdCompanyId((Guid)Session["lfsMasterAreaId"], Convert.ToInt32(Session["companyID"]));
hdfId.Value = ((Guid)Session["lfsMasterAreaId"]).ToString();
//--- Store datasets
Session["tdsLfsRecord"] = tdsLfsRecord;
}
//--- If coming from view_fulllength_m1.aspx, view_fulllength_m2.aspx, or delete_record.aspx
if (((string)Request.QueryString["source_page"] == "view_fulllength_m1.aspx") || ((string)Request.QueryString["source_page"] == "view_fulllength_m2.aspx") || ((string)Request.QueryString["record_deleted"] == "false"))
{
//--- Restore dataset lfs record
tdsLfsRecord = (TDSLFSRecord)Session["tdsLfsRecord"];
}
//--- Prepare initial data for client
CompaniesGateway companiesGateway = new CompaniesGateway();
tbxCOMPANIES_ID.Text = companiesGateway.GetName((int)tdsLfsRecord.LFS_MASTER_AREA.Rows[0]["COMPANIES_ID"], Convert.ToInt32(Session["companyID"]));
//--- Databind
Page.DataBind();
}
else
{
//--- Restore dataset lfs record
tdsLfsRecord = (TDSLFSRecord)Session["tdsLfsRecord"];
}
}
/// ////////////////////////////////////////////////////////////////////////
/// EVENTS
///
protected void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
//--- Security check
if (!Convert.ToBoolean(Session["sgLFS_APP_VIEW"]))
{
Response.Redirect("./../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
// Prepare initial
Session.Remove("lfsM2TablesDummy");
//... Restore data set lfs record
tdsLfsRecord = (TDSLFSRecord)Session["tdsLfsRecord"];
// ... for client
CompaniesGateway companiesGateway = new CompaniesGateway();
tbxCOMPANIES_ID.Text = companiesGateway.GetName((int)tdsLfsRecord.LFS_MASTER_AREA.Rows[0]["COMPANIES_ID"], Convert.ToInt32(Session["companyID"]));
// ... for measurement type
LFSMeasurementTypeGateway lfsMeasurementTypeGateway = new LFSMeasurementTypeGateway();
DataSet dsLfsMeasurementType = lfsMeasurementTypeGateway.GetLFSMeasurementTypeForDropDownList("");
ddlMeasurementType.DataSource = dsLfsMeasurementType;
ddlMeasurementType.DataTextField = "MeasurementType";
// Load LfsM2Tables data
int companyId = Convert.ToInt32(Session["companyID"]);
Guid id = new Guid(Request.QueryString["id"].ToString());
hdfId.Value = Request.QueryString["id"].ToString();
viewFullLengthLiningTDS = new ViewFullLengthLiningTDS();
ViewFullLengthLiningLfsM2TablesGateway viewFullLengthLiningLfsM2TablesGateway = new ViewFullLengthLiningLfsM2TablesGateway(viewFullLengthLiningTDS);
viewFullLengthLiningLfsM2TablesGateway.LoadById(id, companyId);
Session["viewFullLengthLiningTDS"] = viewFullLengthLiningTDS;
lfsM2Tables = viewFullLengthLiningTDS.LfsM2Tables;
Session["lfsM2Tables"] = lfsM2Tables;
// Databind
Page.DataBind();
TDSLFSRecord.LFS_MASTER_AREARow lfsMasterAreaRow = tdsLfsRecord.LFS_MASTER_AREA.FindByIDCOMPANY_ID(new Guid(tbxID.Text), Convert.ToInt32(Session["companyID"]));
ddlMeasurementType.SelectedValue = (lfsMasterAreaRow.IsMeasurementTypeNull()) ? "" : lfsMasterAreaRow.MeasurementType;
}
else
{
// Restore data set lfs record
tdsLfsRecord = (TDSLFSRecord)Session["tdsLfsRecord"];
viewFullLengthLiningTDS = (ViewFullLengthLiningTDS)Session["viewFullLengthLiningTDS"];
}
}
//
// GetRecordRCTAndExpandedRecordsByIdCompanyId
//
// Returns a typed dataset containing a record. The dataset contains
// one row for LFS_MASTER_AREA, zero or more rows for LFS_POINT_REPAIRS,
// zero or more rows for LFS_M2_TABLES, and zero or more tables for
// LFS_JUNCTION_LINER. It also returns LFS_MASTER_AREA_RCT,
// LFS_POINT_REPAIRS_RCT, LFS_M2_TABLES_RCT, and LFS_JUNCTION_LINER_RCT.
// Besides it expands LFS_MASTER_AREA_RCT, LFS_POINT_REPAIRS_RCT,
// LFS_M2_TABLES_RCT, and LFS_JUNCTION_LINER.
//
// This method is intended to be used in the Record Change Tracking tool.
//
public TDSLFSRecordForRCT GetRecordRCTAndExpandedRecordsByIdCompanyId(string id, int companyId)
{
TDSLFSRecordForRCT result = new TDSLFSRecordForRCT();
TDSLFSRecordForRCT auxiliar = new TDSLFSRecordForRCT();
LoginGateway loginGateway = new LoginGateway();
CompaniesGateway companiesGateway = new CompaniesGateway();
//--- Get lfs record and rct records
TDSLFSRecord tdsLfsRecord = this.GetRecordAndRCTByIdCompanyId(new Guid(id), companyId);
result.Merge(tdsLfsRecord, true, System.Data.MissingSchemaAction.Ignore);
//--- Prepare master area 2
TDSLFSRecord.LFS_MASTER_AREARow lfsMasterAreaRow = tdsLfsRecord.LFS_MASTER_AREA.FindByIDCOMPANY_ID(new Guid(id), companyId);
TDSLFSRecordForRCT.LFS_MASTER_AREA2Row lfsMasterArea2Row = result.LFS_MASTER_AREA2.NewLFS_MASTER_AREA2Row();
for (int i = 0; i < tdsLfsRecord.LFS_MASTER_AREA.Columns.Count; i++)
{
lfsMasterArea2Row[i] = lfsMasterAreaRow[i];
}
lfsMasterArea2Row.NAME = companiesGateway.GetName(lfsMasterAreaRow.COMPANIES_ID, companyId);
result.LFS_MASTER_AREA2.AddLFS_MASTER_AREA2Row(lfsMasterArea2Row);
//--- Expand master area rct
TDSLFSRecordForRCT.LFS_MASTER_AREA_RCT_EXPANDEDRow prevLfsMasterAreaRctExpandedRow = null;
foreach(TDSLFSRecord.LFS_MASTER_AREA_RCTRow lfsMasterAreaRctRow in tdsLfsRecord.LFS_MASTER_AREA_RCT)
{
//--- ... Create current record
TDSLFSRecordForRCT.LFS_MASTER_AREA_RCT_EXPANDEDRow lfsMasterAreaRctExpandedRow = result.LFS_MASTER_AREA_RCT_EXPANDED.NewLFS_MASTER_AREA_RCT_EXPANDEDRow();
//--- ... Copy data from previous record to current record (if previous record exists)
if (prevLfsMasterAreaRctExpandedRow != null)
{
for (int i = 0; i < result.LFS_MASTER_AREA_RCT_EXPANDED.Columns.Count; i++)
{
if (result.LFS_MASTER_AREA_RCT_EXPANDED.Columns[i].ColumnName != "RctID")
{
lfsMasterAreaRctExpandedRow[i] = prevLfsMasterAreaRctExpandedRow[i];
}
}
}
//--- ... Expand current record
lfsMasterAreaRctExpandedRow.ID = lfsMasterAreaRctRow.ID;
lfsMasterAreaRctExpandedRow.COMPANY_ID = lfsMasterAreaRctRow.COMPANY_ID;
#region Expand changes
foreach (string columnValueItem in RecordChangeTracking.Split(lfsMasterAreaRctRow.Changes))
{
switch (RecordChangeTracking.GetColumnName(columnValueItem))
{
case "ID":
break;
case "COMPANY_ID":
break;
case "RecordID":
lfsMasterAreaRctExpandedRow.RecordID = RecordChangeTracking.GetValue(columnValueItem);
break;
case "ClientID":
lfsMasterAreaRctExpandedRow.ClientID = RecordChangeTracking.GetValue(columnValueItem);
break;
case "COMPANIES_ID":
lfsMasterAreaRctExpandedRow.COMPANIES_ID = Convert.ToInt32(RecordChangeTracking.GetValue(columnValueItem));
lfsMasterAreaRctExpandedRow.NAME = companiesGateway.GetName(lfsMasterAreaRctExpandedRow.COMPANIES_ID, companyId);
break;
case "SubArea":
lfsMasterAreaRctExpandedRow.SubArea = RecordChangeTracking.GetValue(columnValueItem);
break;
case "Street":
lfsMasterAreaRctExpandedRow.Street = RecordChangeTracking.GetValue(columnValueItem);
break;
case "USMH":
lfsMasterAreaRctExpandedRow.USMH = RecordChangeTracking.GetValue(columnValueItem);
break;
case "DSMH":
lfsMasterAreaRctExpandedRow.DSMH = RecordChangeTracking.GetValue(columnValueItem);
break;
case "Size_":
lfsMasterAreaRctExpandedRow.Size_ = RecordChangeTracking.GetValue(columnValueItem);
break;
case "ScaledLength":
lfsMasterAreaRctExpandedRow.ScaledLength = RecordChangeTracking.GetValue(columnValueItem);
break;
case "P1Date":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.P1Date = Convert.ToDateTime(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetP1DateNull();
break;
case "ActualLength":
lfsMasterAreaRctExpandedRow.ActualLength = RecordChangeTracking.GetValue(columnValueItem);
break;
case "LiveLats":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.LiveLats = Convert.ToDouble(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetLiveLatsNull();
break;
case "CXIsRemoved":
lfsMasterAreaRctExpandedRow.CXIsRemoved = RecordChangeTracking.GetValue(columnValueItem);
break;
case "M1Date":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.M1Date = Convert.ToDateTime(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetM1DateNull();
break;
case "M2Date":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.M2Date = Convert.ToDateTime(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetM2DateNull();
break;
case "InstallDate":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.InstallDate = Convert.ToDateTime(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetInstallDateNull();
break;
case "FinalVideo":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.FinalVideo = Convert.ToDateTime(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetFinalVideoNull();
break;
case "Comments":
lfsMasterAreaRctExpandedRow.Comments = RecordChangeTracking.GetValue(columnValueItem);
break;
case "IssueIdentified":
lfsMasterAreaRctExpandedRow.IssueIdentified = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "IssueResolved":
lfsMasterAreaRctExpandedRow.IssueResolved = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "FullLengthLining":
lfsMasterAreaRctExpandedRow.FullLengthLining = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "SubcontractorLining":
lfsMasterAreaRctExpandedRow.SubcontractorLining = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "OutOfScopeInArea":
lfsMasterAreaRctExpandedRow.OutOfScopeInArea = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "IssueGivenToBayCity":
lfsMasterAreaRctExpandedRow.IssueGivenToBayCity = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "ConfirmedSize":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.ConfirmedSize = Convert.ToInt32(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetConfirmedSizeNull();
break;
case "InstallRate":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.InstallRate = Convert.ToDecimal(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetInstallRateNull();
break;
case "DeadlineDate":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.DeadlineDate = Convert.ToDateTime(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetDeadlineDateNull();
break;
case "ProposedLiningDate":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.ProposedLiningDate = Convert.ToDateTime(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetProposedLiningDateNull();
break;
case "SalesIssue":
lfsMasterAreaRctExpandedRow.SalesIssue = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "LFSIssue":
lfsMasterAreaRctExpandedRow.LFSIssue = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "ClientIssue":
lfsMasterAreaRctExpandedRow.ClientIssue = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "InvestigationIssue":
lfsMasterAreaRctExpandedRow.InvestigationIssue = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "PointLining":
lfsMasterAreaRctExpandedRow.PointLining = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "Grouting":
lfsMasterAreaRctExpandedRow.Grouting = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "LateralLining":
lfsMasterAreaRctExpandedRow.LateralLining = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "VacExDate":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.VacExDate = Convert.ToDateTime(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetVacExDateNull();
break;
case "PusherDate":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.PusherDate = Convert.ToDateTime(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetPusherDateNull();
break;
case "LinerOrdered":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.LinerOrdered = Convert.ToDateTime(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetLinerOrderedNull();
break;
case "Restoration":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.Restoration = Convert.ToDateTime(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetRestorationNull();
break;
case "GroutDate":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.GroutDate = Convert.ToDateTime(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetGroutDateNull();
break;
case "JLiner":
lfsMasterAreaRctExpandedRow.JLiner = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "RehabAssessment":
lfsMasterAreaRctExpandedRow.RehabAssessment = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "EstimatedJoints":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.EstimatedJoints = Convert.ToInt32(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetEstimatedJointsNull();
break;
case "JointsTestSealed":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.JointsTestSealed = Convert.ToInt32(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetJointsTestSealedNull();
break;
case "PreFlushDate":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.PreFlushDate = Convert.ToDateTime(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetPreFlushDateNull();
break;
case "PreVideoDate":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.PreVideoDate = Convert.ToDateTime(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetPreVideoDateNull();
break;
case "USMHMN":
lfsMasterAreaRctExpandedRow.USMHMN = RecordChangeTracking.GetValue(columnValueItem);
break;
case "DSMHMN":
lfsMasterAreaRctExpandedRow.DSMHMN = RecordChangeTracking.GetValue(columnValueItem);
break;
case "USMHDepth":
lfsMasterAreaRctExpandedRow.USMHDepth = RecordChangeTracking.GetValue(columnValueItem);
break;
case "DSMHDepth":
lfsMasterAreaRctExpandedRow.DSMHDepth = RecordChangeTracking.GetValue(columnValueItem);
break;
case "MeasurementsTakenBy":
lfsMasterAreaRctExpandedRow.MeasurementsTakenBy = RecordChangeTracking.GetValue(columnValueItem);
break;
case "SteelTapeThruPipe":
lfsMasterAreaRctExpandedRow.SteelTapeThruPipe = RecordChangeTracking.GetValue(columnValueItem);
break;
case "USMHAtMouth1200":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.USMHAtMouth1200 = Convert.ToDouble(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetUSMHAtMouth1200Null();
break;
case "USMHAtMouth100":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.USMHAtMouth100 = Convert.ToDouble(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetUSMHAtMouth100Null();
break;
case "USMHAtMouth200":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.USMHAtMouth200 = Convert.ToDouble(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetUSMHAtMouth200Null();
break;
case "USMHAtMouth300":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.USMHAtMouth300 = Convert.ToDouble(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetUSMHAtMouth300Null();
break;
case "USMHAtMouth400":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.USMHAtMouth400 = Convert.ToDouble(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetUSMHAtMouth400Null();
break;
case "USMHAtMouth500":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.USMHAtMouth500 = Convert.ToDouble(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetUSMHAtMouth500Null();
break;
case "DSMHAtMouth1200":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.DSMHAtMouth1200 = Convert.ToDouble(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetDSMHAtMouth1200Null();
break;
case "DSMHAtMouth100":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.DSMHAtMouth100 = Convert.ToDouble(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetDSMHAtMouth100Null();
break;
case "DSMHAtMouth200":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.DSMHAtMouth200 = Convert.ToDouble(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetDSMHAtMouth200Null();
break;
case "DSMHAtMouth300":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.DSMHAtMouth300 = Convert.ToDouble(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetDSMHAtMouth300Null();
break;
case "DSMHAtMouth400":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.DSMHAtMouth400 = Convert.ToDouble(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetDSMHAtMouth400Null();
break;
case "DSMHAtMouth500":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.DSMHAtMouth500 = Convert.ToDouble(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetDSMHAtMouth500Null();
break;
case "HydrantAddress":
lfsMasterAreaRctExpandedRow.HydrantAddress = RecordChangeTracking.GetValue(columnValueItem);
break;
case "DistanceToInversionMH":
lfsMasterAreaRctExpandedRow.DistanceToInversionMH = RecordChangeTracking.GetValue(columnValueItem);
break;
case "RampsRequired":
lfsMasterAreaRctExpandedRow.RampsRequired = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "DegreeOfTrafficControl":
lfsMasterAreaRctExpandedRow.DegreeOfTrafficControl = RecordChangeTracking.GetValue(columnValueItem);
break;
case "StandarBypass":
lfsMasterAreaRctExpandedRow.StandarBypass = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "HydroWireDetails":
lfsMasterAreaRctExpandedRow.HydroWireDetails = RecordChangeTracking.GetValue(columnValueItem);
break;
case "PipeMaterialType":
lfsMasterAreaRctExpandedRow.PipeMaterialType = RecordChangeTracking.GetValue(columnValueItem);
break;
case "CappedLaterals":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.CappedLaterals = Convert.ToInt32(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetCappedLateralsNull();
break;
case "RoboticPrepRequired":
lfsMasterAreaRctExpandedRow.RoboticPrepRequired = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "PipeSizeChange":
lfsMasterAreaRctExpandedRow.PipeSizeChange = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "M1Comments":
lfsMasterAreaRctExpandedRow.M1Comments = RecordChangeTracking.GetValue(columnValueItem);
break;
case "VideoDoneFrom":
lfsMasterAreaRctExpandedRow.VideoDoneFrom = RecordChangeTracking.GetValue(columnValueItem);
break;
case "ToManhole":
lfsMasterAreaRctExpandedRow.ToManhole = RecordChangeTracking.GetValue(columnValueItem);
break;
case "CutterDescriptionDuringMeasuring":
lfsMasterAreaRctExpandedRow.CutterDescriptionDuringMeasuring = RecordChangeTracking.GetValue(columnValueItem);
break;
case "FullLengthPointLiner":
lfsMasterAreaRctExpandedRow.FullLengthPointLiner = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "BypassRequired":
lfsMasterAreaRctExpandedRow.BypassRequired = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "RoboticDistances":
lfsMasterAreaRctExpandedRow.RoboticDistances = RecordChangeTracking.GetValue(columnValueItem);
break;
case "TrafficControlDetails":
lfsMasterAreaRctExpandedRow.TrafficControlDetails = RecordChangeTracking.GetValue(columnValueItem);
break;
case "LineWithID":
lfsMasterAreaRctExpandedRow.LineWithID = RecordChangeTracking.GetValue(columnValueItem);
break;
case "SchoolZone":
lfsMasterAreaRctExpandedRow.SchoolZone = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "RestaurantArea":
lfsMasterAreaRctExpandedRow.RestaurantArea = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "CarwashLaundromat":
lfsMasterAreaRctExpandedRow.CarwashLaundromat = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "HydroPulley":
lfsMasterAreaRctExpandedRow.HydroPulley = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "FridgeCart":
lfsMasterAreaRctExpandedRow.FridgeCart = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "TwoInchPump":
lfsMasterAreaRctExpandedRow.TwoInchPump = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "SixInchBypass":
lfsMasterAreaRctExpandedRow.SixInchBypass = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "Scaffolding":
lfsMasterAreaRctExpandedRow.Scaffolding = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "WinchExtension":
lfsMasterAreaRctExpandedRow.WinchExtension = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "ExtraGenerator":
lfsMasterAreaRctExpandedRow.ExtraGenerator = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "GreyCableExtension":
lfsMasterAreaRctExpandedRow.GreyCableExtension = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "EasementMats":
lfsMasterAreaRctExpandedRow.EasementMats = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "MeasurementType":
lfsMasterAreaRctExpandedRow.MeasurementType = RecordChangeTracking.GetValue(columnValueItem);
break;
case "DropPipe":
lfsMasterAreaRctExpandedRow.DropPipe = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "DropPipeInvertDepth":
lfsMasterAreaRctExpandedRow.DropPipeInvertDepth = RecordChangeTracking.GetValue(columnValueItem);
break;
case "Deleted":
lfsMasterAreaRctExpandedRow.Deleted = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "MeasuredFromManhole":
lfsMasterAreaRctExpandedRow.MeasuredFromManhole = RecordChangeTracking.GetValue(columnValueItem);
break;
case "MainLined":
lfsMasterAreaRctExpandedRow.MainLined = RecordChangeTracking.GetValue(columnValueItem);
break;
case "BenchingIssue":
lfsMasterAreaRctExpandedRow.BenchingIssue = RecordChangeTracking.GetValue(columnValueItem);
break;
case "Archived":
lfsMasterAreaRctExpandedRow.Archived = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "ScaledLength1":
break;
case "History":
lfsMasterAreaRctExpandedRow.History = RecordChangeTracking.GetValue(columnValueItem);
break;
case "NumLats":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.NumLats = Convert.ToInt32(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetNumLatsNull();
break;
case "NotLinedYet":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsMasterAreaRctExpandedRow.NotLinedYet = Convert.ToInt32(RecordChangeTracking.GetValue(columnValueItem)); else lfsMasterAreaRctExpandedRow.SetNotLinedYetNull();
break;
case "AllMeasured":
lfsMasterAreaRctExpandedRow.AllMeasured = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "City":
lfsMasterAreaRctExpandedRow.City = RecordChangeTracking.GetValue(columnValueItem);
break;
case "ProvState":
lfsMasterAreaRctExpandedRow.ProvState = RecordChangeTracking.GetValue(columnValueItem);
break;
default:
throw new Exception ("Invalid column in LFS_MASTER_AREA_RCT_EXPANDED.");
}
}
#endregion
lfsMasterAreaRctExpandedRow.Operation = lfsMasterAreaRctRow.Operation;
lfsMasterAreaRctExpandedRow.ChangedBy = lfsMasterAreaRctRow.ChangedBy;
lfsMasterAreaRctExpandedRow.USERNAME = loginGateway.GetUsername(lfsMasterAreaRctRow.ChangedBy, companyId);
lfsMasterAreaRctExpandedRow.Changed = lfsMasterAreaRctRow.Changed;
//--- ... Make a copy of current record as previous record
prevLfsMasterAreaRctExpandedRow = auxiliar.LFS_MASTER_AREA_RCT_EXPANDED.NewLFS_MASTER_AREA_RCT_EXPANDEDRow();
for (int i = 0; i < result.LFS_MASTER_AREA_RCT_EXPANDED.Columns.Count; i++)
{
if (result.LFS_MASTER_AREA_RCT_EXPANDED.Columns[i].ColumnName != "RctID")
{
prevLfsMasterAreaRctExpandedRow[i] = lfsMasterAreaRctExpandedRow[i];
}
}
//--- ... Add current record to result
result.LFS_MASTER_AREA_RCT_EXPANDED.AddLFS_MASTER_AREA_RCT_EXPANDEDRow(lfsMasterAreaRctExpandedRow);
}
//--- Expand point repairs rct
TDSLFSRecordForRCT.LFS_POINT_REPAIRS_RCT_EXPANDEDRow prevLfsPointRepairsRctExpandedRow = null;
foreach(TDSLFSRecord.LFS_POINT_REPAIRS_RCTRow lfsPointRepairsRctRow in tdsLfsRecord.LFS_POINT_REPAIRS_RCT)
{
//--- ... Create current record
TDSLFSRecordForRCT.LFS_POINT_REPAIRS_RCT_EXPANDEDRow lfsPointRepairsRctExpandedRow = result.LFS_POINT_REPAIRS_RCT_EXPANDED.NewLFS_POINT_REPAIRS_RCT_EXPANDEDRow();
//--- ... Copy data from previous record to current record (if previous record exists)
if ((prevLfsPointRepairsRctExpandedRow != null) && (prevLfsPointRepairsRctExpandedRow.RefID == lfsPointRepairsRctRow.RefID))
{
for (int i = 0; i < result.LFS_POINT_REPAIRS_RCT_EXPANDED.Columns.Count; i++)
{
if (result.LFS_POINT_REPAIRS_RCT_EXPANDED.Columns[i].ColumnName != "RctID")
{
lfsPointRepairsRctExpandedRow[i] = prevLfsPointRepairsRctExpandedRow[i];
}
}
}
//--- ... Expand current record
lfsPointRepairsRctExpandedRow.ID = lfsPointRepairsRctRow.ID;
lfsPointRepairsRctExpandedRow.RefID = lfsPointRepairsRctRow.RefID;
lfsPointRepairsRctExpandedRow.COMPANY_ID = lfsPointRepairsRctRow.COMPANY_ID;
#region Expand changes
foreach (string columnValueItem in RecordChangeTracking.Split(lfsPointRepairsRctRow.Changes))
{
switch (RecordChangeTracking.GetColumnName(columnValueItem))
{
case "ID":
break;
case "RefID":
break;
case "COMPANY_ID":
break;
case "DetailID":
lfsPointRepairsRctExpandedRow.DetailID = RecordChangeTracking.GetValue(columnValueItem);
break;
case "RepairSize":
lfsPointRepairsRctExpandedRow.RepairSize = RecordChangeTracking.GetValue(columnValueItem);
break;
case "InstallDate":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsPointRepairsRctExpandedRow.InstallDate = Convert.ToDateTime(RecordChangeTracking.GetValue(columnValueItem)); else lfsPointRepairsRctExpandedRow.SetInstallDateNull();
break;
case "Distance":
lfsPointRepairsRctExpandedRow.Distance = RecordChangeTracking.GetValue(columnValueItem);
break;
case "Cost":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsPointRepairsRctExpandedRow.Cost = Convert.ToDecimal(RecordChangeTracking.GetValue(columnValueItem)); else lfsPointRepairsRctExpandedRow.SetCostNull();
break;
case "Reinstates":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsPointRepairsRctExpandedRow.Reinstates = Convert.ToInt32(RecordChangeTracking.GetValue(columnValueItem)); else lfsPointRepairsRctExpandedRow.SetReinstatesNull();
break;
case "LTAtMH":
lfsPointRepairsRctExpandedRow.LTAtMH = RecordChangeTracking.GetValue(columnValueItem);
break;
case "VTAtMH":
lfsPointRepairsRctExpandedRow.VTAtMH = RecordChangeTracking.GetValue(columnValueItem);
break;
case "LinerDistance":
lfsPointRepairsRctExpandedRow.LinerDistance = RecordChangeTracking.GetValue(columnValueItem);
break;
case "Direction":
lfsPointRepairsRctExpandedRow.Direction = RecordChangeTracking.GetValue(columnValueItem);
break;
case "MHShot":
lfsPointRepairsRctExpandedRow.MHShot = RecordChangeTracking.GetValue(columnValueItem);
break;
case "Comments":
lfsPointRepairsRctExpandedRow.Comments = RecordChangeTracking.GetValue(columnValueItem);
break;
case "Deleted":
lfsPointRepairsRctExpandedRow.Deleted = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "ExtraRepair":
lfsPointRepairsRctExpandedRow.ExtraRepair = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "Cancelled":
lfsPointRepairsRctExpandedRow.Cancelled = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "Approved":
lfsPointRepairsRctExpandedRow.Approved = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "NotApproved":
lfsPointRepairsRctExpandedRow.NotApproved = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "Archived":
lfsPointRepairsRctExpandedRow.Archived = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
default:
throw new Exception ("Invalid column in LFS_POINT_REPAIRS_RCT_EXPANDED.");
}
}
#endregion
lfsPointRepairsRctExpandedRow.Operation = lfsPointRepairsRctRow.Operation;
lfsPointRepairsRctExpandedRow.ChangedBy = lfsPointRepairsRctRow.ChangedBy;
lfsPointRepairsRctExpandedRow.USERNAME = loginGateway.GetUsername(lfsPointRepairsRctRow.ChangedBy, companyId);
lfsPointRepairsRctExpandedRow.Changed = lfsPointRepairsRctRow.Changed;
//--- ... Make a copy of current record as previous record
prevLfsPointRepairsRctExpandedRow = auxiliar.LFS_POINT_REPAIRS_RCT_EXPANDED.NewLFS_POINT_REPAIRS_RCT_EXPANDEDRow();
for (int i = 0; i < result.LFS_POINT_REPAIRS_RCT_EXPANDED.Columns.Count; i++)
{
if (result.LFS_POINT_REPAIRS_RCT_EXPANDED.Columns[i].ColumnName != "RctID")
{
prevLfsPointRepairsRctExpandedRow[i] = lfsPointRepairsRctExpandedRow[i];
}
}
//--- ... Add current record to result
result.LFS_POINT_REPAIRS_RCT_EXPANDED.AddLFS_POINT_REPAIRS_RCT_EXPANDEDRow(lfsPointRepairsRctExpandedRow);
}
//--- Expand m2 tables rct
TDSLFSRecordForRCT.LFS_M2_TABLES_RCT_EXPANDEDRow prevLfsM2TablesRctExpandedRow = null;
foreach(TDSLFSRecord.LFS_M2_TABLES_RCTRow lfsM2TablesRctRow in tdsLfsRecord.LFS_M2_TABLES_RCT)
{
//--- ... Create current record
TDSLFSRecordForRCT.LFS_M2_TABLES_RCT_EXPANDEDRow lfsM2TablesRctExpandedRow = result.LFS_M2_TABLES_RCT_EXPANDED.NewLFS_M2_TABLES_RCT_EXPANDEDRow();
//--- ... Copy data from previous record to current record (if previous record exists)
if ((prevLfsM2TablesRctExpandedRow != null) && (prevLfsM2TablesRctExpandedRow.RefID == lfsM2TablesRctRow.RefID))
{
for (int i = 0; i < result.LFS_M2_TABLES_RCT_EXPANDED.Columns.Count; i++)
{
if (result.LFS_M2_TABLES_RCT_EXPANDED.Columns[i].ColumnName != "RctID")
{
lfsM2TablesRctExpandedRow[i] = prevLfsM2TablesRctExpandedRow[i];
}
}
}
//--- ... Expand current record
lfsM2TablesRctExpandedRow.ID = lfsM2TablesRctRow.ID;
lfsM2TablesRctExpandedRow.RefID = lfsM2TablesRctRow.RefID;
lfsM2TablesRctExpandedRow.COMPANY_ID = lfsM2TablesRctRow.COMPANY_ID;
#region Expand changes
foreach (string columnValueItem in RecordChangeTracking.Split(lfsM2TablesRctRow.Changes))
{
switch (RecordChangeTracking.GetColumnName(columnValueItem))
{
case "ID":
break;
case "RefID":
break;
case "COMPANY_ID":
break;
case "VideoDistance":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsM2TablesRctExpandedRow.VideoDistance = Convert.ToSingle(RecordChangeTracking.GetValue(columnValueItem)); else lfsM2TablesRctExpandedRow.SetVideoDistanceNull();
break;
case "ClockPosition":
lfsM2TablesRctExpandedRow.ClockPosition = RecordChangeTracking.GetValue(columnValueItem);
break;
case "LiveOrAbandoned":
lfsM2TablesRctExpandedRow.LiveOrAbandoned = RecordChangeTracking.GetValue(columnValueItem);
break;
case "DistanceToCentreOfLateral":
lfsM2TablesRctExpandedRow.DistanceToCentreOfLateral = RecordChangeTracking.GetValue(columnValueItem);
break;
case "LateralDiameter":
lfsM2TablesRctExpandedRow.LateralDiameter = RecordChangeTracking.GetValue(columnValueItem);
break;
case "LateralType":
lfsM2TablesRctExpandedRow.LateralType = RecordChangeTracking.GetValue(columnValueItem);
break;
case "DateTimeOpened":
lfsM2TablesRctExpandedRow.DateTimeOpened = RecordChangeTracking.GetValue(columnValueItem);
break;
case "Comments":
lfsM2TablesRctExpandedRow.Comments = RecordChangeTracking.GetValue(columnValueItem);
break;
case "ReverseSetup":
lfsM2TablesRctExpandedRow.ReverseSetup = RecordChangeTracking.GetValue(columnValueItem);
break;
case "Deleted":
lfsM2TablesRctExpandedRow.Deleted = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "Archived":
lfsM2TablesRctExpandedRow.Archived = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
default:
throw new Exception ("Invalid column in LFS_POINT_REPAIRS_RCT_EXPANDED.");
}
}
#endregion
lfsM2TablesRctExpandedRow.Operation = lfsM2TablesRctRow.Operation;
lfsM2TablesRctExpandedRow.ChangedBy = lfsM2TablesRctRow.ChangedBy;
lfsM2TablesRctExpandedRow.USERNAME = loginGateway.GetUsername(lfsM2TablesRctRow.ChangedBy, companyId);
lfsM2TablesRctExpandedRow.Changed = lfsM2TablesRctRow.Changed;
//--- ... Make a copy of current record as previous record
prevLfsM2TablesRctExpandedRow = auxiliar.LFS_M2_TABLES_RCT_EXPANDED.NewLFS_M2_TABLES_RCT_EXPANDEDRow();
for (int i = 0; i < result.LFS_M2_TABLES_RCT_EXPANDED.Columns.Count; i++)
{
if (result.LFS_M2_TABLES_RCT_EXPANDED.Columns[i].ColumnName != "RctID")
{
prevLfsM2TablesRctExpandedRow[i] = lfsM2TablesRctExpandedRow[i];
}
}
//--- ... Add current record to result
result.LFS_M2_TABLES_RCT_EXPANDED.AddLFS_M2_TABLES_RCT_EXPANDEDRow(lfsM2TablesRctExpandedRow);
}
//--- Expand junction liners rct
TDSLFSRecordForRCT.LFS_JUNCTION_LINER_RCT_EXPANDEDRow prevLfsJunctionLinerRctExpandedRow = null;
foreach(TDSLFSRecord.LFS_JUNCTION_LINER_RCTRow lfsJunctionLinerRctRow in tdsLfsRecord.LFS_JUNCTION_LINER_RCT)
{
//--- ... Create current record
TDSLFSRecordForRCT.LFS_JUNCTION_LINER_RCT_EXPANDEDRow lfsJunctionLinerRctExpandedRow = result.LFS_JUNCTION_LINER_RCT_EXPANDED.NewLFS_JUNCTION_LINER_RCT_EXPANDEDRow();
//--- ... Copy data from previous record to current record (if previous record exists)
if ((prevLfsJunctionLinerRctExpandedRow != null) && (prevLfsJunctionLinerRctExpandedRow.RefID == lfsJunctionLinerRctRow.RefID))
{
for (int i = 0; i < result.LFS_JUNCTION_LINER_RCT_EXPANDED.Columns.Count; i++)
{
if (result.LFS_JUNCTION_LINER_RCT_EXPANDED.Columns[i].ColumnName != "RctID")
{
lfsJunctionLinerRctExpandedRow[i] = prevLfsJunctionLinerRctExpandedRow[i];
}
}
}
//--- ... Expand current record
lfsJunctionLinerRctExpandedRow.ID = lfsJunctionLinerRctRow.ID;
lfsJunctionLinerRctExpandedRow.RefID = lfsJunctionLinerRctRow.RefID;
lfsJunctionLinerRctExpandedRow.COMPANY_ID = lfsJunctionLinerRctRow.COMPANY_ID;
#region Expand changes
foreach (string columnValueItem in RecordChangeTracking.Split(lfsJunctionLinerRctRow.Changes))
{
switch (RecordChangeTracking.GetColumnName(columnValueItem))
{
case "ID":
break;
case "RefID":
break;
case "COMPANY_ID":
break;
case "DetailID":
lfsJunctionLinerRctExpandedRow.DetailID = RecordChangeTracking.GetValue(columnValueItem);
break;
case "MN":
lfsJunctionLinerRctExpandedRow.MN = RecordChangeTracking.GetValue(columnValueItem);
break;
case "DistanceFromUSMH":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsJunctionLinerRctExpandedRow.DistanceFromUSMH = Convert.ToDouble(RecordChangeTracking.GetValue(columnValueItem)); else lfsJunctionLinerRctExpandedRow.SetDistanceFromUSMHNull();
break;
case "ConfirmedLatSize":
lfsJunctionLinerRctExpandedRow.ConfirmedLatSize = RecordChangeTracking.GetValue(columnValueItem);
break;
case "LateralMaterial":
lfsJunctionLinerRctExpandedRow.LateralMaterial = RecordChangeTracking.GetValue(columnValueItem);
break;
case "SharedLateral":
lfsJunctionLinerRctExpandedRow.SharedLateral = RecordChangeTracking.GetValue(columnValueItem);
break;
case "CleanoutRequired":
lfsJunctionLinerRctExpandedRow.CleanoutRequired = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "PitRequired":
lfsJunctionLinerRctExpandedRow.PitRequired = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "MHShot":
lfsJunctionLinerRctExpandedRow.MHShot = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "MainConnection":
lfsJunctionLinerRctExpandedRow.MainConnection = RecordChangeTracking.GetValue(columnValueItem);
break;
case "Transition":
lfsJunctionLinerRctExpandedRow.Transition = RecordChangeTracking.GetValue(columnValueItem);
break;
case "CleanoutInstalled":
lfsJunctionLinerRctExpandedRow.CleanoutInstalled = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "PitInstalled":
lfsJunctionLinerRctExpandedRow.PitInstalled = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "CleanoutGrouted":
lfsJunctionLinerRctExpandedRow.CleanoutGrouted = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "CleanoutCored":
lfsJunctionLinerRctExpandedRow.CleanoutCored = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "PrepCompleted":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsJunctionLinerRctExpandedRow.PrepCompleted = Convert.ToDateTime(RecordChangeTracking.GetValue(columnValueItem)); else lfsJunctionLinerRctExpandedRow.SetPrepCompletedNull();
break;
case "MeasuredLatLength":
lfsJunctionLinerRctExpandedRow.MeasuredLatLength = RecordChangeTracking.GetValue(columnValueItem);
break;
case "MeasurementsTakenBy":
lfsJunctionLinerRctExpandedRow.MeasurementsTakenBy = RecordChangeTracking.GetValue(columnValueItem);
break;
case "LinerInstalled":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsJunctionLinerRctExpandedRow.LinerInstalled = Convert.ToDateTime(RecordChangeTracking.GetValue(columnValueItem)); else lfsJunctionLinerRctExpandedRow.SetLinerInstalledNull();
break;
case "FinalVideo":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsJunctionLinerRctExpandedRow.FinalVideo = Convert.ToDateTime(RecordChangeTracking.GetValue(columnValueItem)); else lfsJunctionLinerRctExpandedRow.SetFinalVideoNull();
break;
case "RestorationComplete":
lfsJunctionLinerRctExpandedRow.RestorationComplete = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "LinerOrdered":
lfsJunctionLinerRctExpandedRow.LinerOrdered = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "LinerInStock":
lfsJunctionLinerRctExpandedRow.LinerInStock = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "LinerPrice":
if (RecordChangeTracking.GetValue(columnValueItem) != "") lfsJunctionLinerRctExpandedRow.LinerPrice = Convert.ToDecimal(RecordChangeTracking.GetValue(columnValueItem)); else lfsJunctionLinerRctExpandedRow.SetLinerPriceNull();
break;
case "Comments":
lfsJunctionLinerRctExpandedRow.Comments = RecordChangeTracking.GetValue(columnValueItem);
break;
case "Deleted":
lfsJunctionLinerRctExpandedRow.Deleted = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
case "Archived":
lfsJunctionLinerRctExpandedRow.Deleted = Convert.ToBoolean(RecordChangeTracking.GetValue(columnValueItem));
break;
default:
throw new Exception ("Invalid column in LFS_JUNCTION_LINER_RCT_EXPANDED.");
}
}
#endregion
lfsJunctionLinerRctExpandedRow.Operation = lfsJunctionLinerRctRow.Operation;
lfsJunctionLinerRctExpandedRow.ChangedBy = lfsJunctionLinerRctRow.ChangedBy;
lfsJunctionLinerRctExpandedRow.USERNAME = loginGateway.GetUsername(lfsJunctionLinerRctRow.ChangedBy, companyId);
lfsJunctionLinerRctExpandedRow.Changed = lfsJunctionLinerRctRow.Changed;
//--- ... Make a copy of current record as previous record
prevLfsJunctionLinerRctExpandedRow = auxiliar.LFS_JUNCTION_LINER_RCT_EXPANDED.NewLFS_JUNCTION_LINER_RCT_EXPANDEDRow();
for (int i = 0; i < result.LFS_JUNCTION_LINER_RCT_EXPANDED.Columns.Count; i++)
{
if (result.LFS_JUNCTION_LINER_RCT_EXPANDED.Columns[i].ColumnName != "RctID")
{
prevLfsJunctionLinerRctExpandedRow[i] = lfsJunctionLinerRctExpandedRow[i];
}
}
//--- ... Add current record to result
result.LFS_JUNCTION_LINER_RCT_EXPANDED.AddLFS_JUNCTION_LINER_RCT_EXPANDEDRow(lfsJunctionLinerRctExpandedRow);
}
return result;
}
/// ////////////////////////////////////////////////////////////////////////
/// EVENTS
///
protected void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
// Security check
if (!Convert.ToBoolean(Session["sgLFS_APP_VIEW"]))
{
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) && ((string)Request.QueryString["record_deleted"] == null))
{
Response.Redirect("./../error_page.aspx?error=" + "Invalid query string in view_fulllength.aspx");
}
//... Prepare initial
Session.Remove("pointRepairDummy");
addRecordTDS = new AddRecordTDS();
// If coming from navigator2.aspx or view_pointliner.aspx
if (((string)Request.QueryString["source_page"] == "navigator2.aspx") || ((string)Request.QueryString["source_page"] == "view_pointliner.aspx"))
{
int companyId = Convert.ToInt32(Session["companyID"]);
Guid id = (Guid)Session["lfsMasterAreaId"];
// Get lfs master area record
LFSRecordGateway lfsRecordGateway = new LFSRecordGateway();
tdsLfsRecord = lfsRecordGateway.GetRecordByIdCompanyId(id, companyId);
AddRecordPointRepairsGateway addRecordPointRepairsGateway = new AddRecordPointRepairsGateway(addRecordTDS);
addRecordPointRepairsGateway.LoadById(id, companyId);
//... Store datasets
Session["tdsLfsRecord"] = tdsLfsRecord;
Session["addRecordTDS"] = addRecordTDS;
pointRepairs = addRecordTDS.PointRepairs;
Session["pointRepairs"] = pointRepairs;
}
// If coming from delete_record.aspx
if ((string)Request.QueryString["record_deleted"] == "false")
{
//... Restore dataset lfs record
tdsLfsRecord = (TDSLFSRecord)Session["tdsLfsRecord"];
addRecordTDS = (AddRecordTDS)Session["addRecordTDS"];
}
// Prepare initial data for client
CompaniesGateway companiesGateway = new CompaniesGateway();
tbxCOMPANIES_ID.Text = companiesGateway.GetName((int)tdsLfsRecord.LFS_MASTER_AREA.Rows[0]["COMPANIES_ID"], Convert.ToInt32(Session["companyID"]));
// Databind
Page.DataBind();
}
else
{
// Restore dataset lfs record
tdsLfsRecord = (TDSLFSRecord)Session["tdsLfsRecord"];
addRecordTDS = (AddRecordTDS)Session["addRecordTDS"];
}
}
/// ////////////////////////////////////////////////////////////////////////
/// EVENTS
///
//
// Page_Load
//
protected void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
//--- Security check
if (!Convert.ToBoolean(Session["sgLFS_APP_VIEW"]))
{
Response.Redirect("./../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
//--- Restore dataset lfs record
tdsLfsRecord = (TDSLFSRecord)Session["tdsLfsRecord"];
//--- Prepare initial data
hdfId.Value = Request.QueryString["id"].ToString();
//--- ... for client
CompaniesGateway companiesGateway = new CompaniesGateway();
tbxCOMPANIES_ID.Text = companiesGateway.GetName((int)tdsLfsRecord.LFS_MASTER_AREA.Rows[0]["COMPANIES_ID"], Convert.ToInt32(Session["companyID"]));
//--- ... for traffic control
LFSTrafficControlGateway lfsTrafficControlGateway = new LFSTrafficControlGateway();
DataSet dsLfsTrafficControl = lfsTrafficControlGateway.GetLFSTrafficControlForDropDownList("");
ddlDegreeOfTrafficControl.DataSource = dsLfsTrafficControl;
ddlDegreeOfTrafficControl.DataTextField = "TrafficControl";
//--- Databind
Page.DataBind();
TDSLFSRecord.LFS_MASTER_AREARow lfsMasterAreaRow = tdsLfsRecord.LFS_MASTER_AREA.FindByIDCOMPANY_ID(new Guid(tbxID.Text), Convert.ToInt32(Session["companyID"]));
ddlDegreeOfTrafficControl.SelectedValue = (lfsMasterAreaRow.IsDegreeOfTrafficControlNull()) ? "" : lfsMasterAreaRow.DegreeOfTrafficControl;
}
else
{
//--- Restore dataset lfs record
tdsLfsRecord = (TDSLFSRecord)Session["tdsLfsRecord"];
}
}
/// ////////////////////////////////////////////////////////////////////////
/// EVENTS
///
protected void Page_Load(object sender, System.EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!Convert.ToBoolean(Session["sgLFS_APP_VIEW"]))
{
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) && ((string)Request.QueryString["record_deleted"] == null))
{
Response.Redirect("./../error_page.aspx?error=" + "Invalid query string in view_jlinersheet.aspx");
}
// Prepare initial data
Session.Remove("jlinerDummy");
lblMaxNumber.Visible = false;
// If coming from navigator2.aspx or view_jlinersheet.aspx
if (((string)Request.QueryString["source_page"] == "navigator2.aspx") || ((string)Request.QueryString["source_page"] == "view_jlinersheet.aspx"))
{
//... Get lfs master area record
LFSRecordGateway lfsRecordGateway = new LFSRecordGateway();
viewJLinersheetTDS = new ViewJLinersheetTDS();
ViewJLinersheetJunctionLinerGateway viewJLinersheetJunctionLinerGateway = new ViewJLinersheetJunctionLinerGateway(viewJLinersheetTDS);
viewJLinersheetJunctionLinerGateway.LoadById((Guid)Session["lfsMasterAreaId"], Convert.ToInt32(Session["companyID"]));
tdsLfsRecord = lfsRecordGateway.GetRecordByIdCompanyId((Guid)Session["lfsMasterAreaId"], Convert.ToInt32(Session["companyID"]));
//... Store datasets
Session["tdsLfsRecord"] = tdsLfsRecord;
Session["viewJLinersheetTDS"] = viewJLinersheetTDS;
jliner = viewJLinersheetTDS.JunctionLiner;
Session["jliner"] = jliner;
}
// If coming from delete_record.aspx
if ((string)Request.QueryString["record_deleted"] == "false")
{
//... Restore dataset lfs record
tdsLfsRecord = (TDSLFSRecord)Session["tdsLfsRecord"];
viewJLinersheetTDS = (ViewJLinersheetTDS)Session["viewJLinersheetTDS"];
}
// ... for client
CompaniesGateway companiesGateway = new CompaniesGateway();
tbxCOMPANIES_ID.Text = companiesGateway.GetName((int)tdsLfsRecord.LFS_MASTER_AREA.Rows[0]["COMPANIES_ID"], Convert.ToInt32(Session["companyID"]));
// Databind
Page.DataBind();
ddlMainLined.SelectedIndex = (tdsLfsRecord.LFS_MASTER_AREA[0].IsMainLinedNull()) ? 2 : ((tdsLfsRecord.LFS_MASTER_AREA[0].MainLined == "Yes") ? 0 : 1);
ddlBenchingIssue.SelectedIndex = (tdsLfsRecord.LFS_MASTER_AREA[0].IsBenchingIssueNull()) ? 2 : ((tdsLfsRecord.LFS_MASTER_AREA[0].BenchingIssue == "Yes") ? 0 : 1);
}
else
{
//--- Restore dataset lfs record
tdsLfsRecord = (TDSLFSRecord)Session["tdsLfsRecord"];
viewJLinersheetTDS = (ViewJLinersheetTDS)Session["viewJLinersheetTDS"];
}
}