/// ////////////////////////////////////////////////////////////////////////
/// 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 ((Request.QueryString["target_page"] == null) || (Request.QueryString["target_report"] == null))
{
Response.Redirect("./../error_page.aspx?error=" + "Invalid query string in print2.aspx");
}
//--- Get clients
CompaniesGateway companiesGateway = new CompaniesGateway();
DataSet dataSet = companiesGateway.GetCompaniesForDropDownList("-1", "-- ALL CLIENTS --", Convert.ToInt32(Session["companyID"]));
ddlSelectAClient.DataSource = dataSet;
ddlSelectAClient.DataValueField = "COMPANIES_ID";
ddlSelectAClient.DataTextField = "NAME";
ddlSelectAClient.SelectedValue = "-1";
//--- Databind
ddlSelectAClient.DataBind();
}
}
/// ////////////////////////////////////////////////////////////////////////
/// 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)
{
// 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
///
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"];
}
}
/// ////////////////////////////////////////////////////////////////////////
/// EVENTS
///
protected void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
//--- Security check
if (!(Convert.ToBoolean(Session["sgLFS_APP_VIEW"]) && Convert.ToBoolean(Session["sgLFS_APP_ADD"])))
{
Response.Redirect("./../error_page.aspx?error=" + "You are not authorized to add new records. Contact your system administrator.");
}
//... Add lfs master area record
TDSLFSRecord.LFS_MASTER_AREARow lfsMasterAreaRow = tdsLfsRecord.LFS_MASTER_AREA.NewLFS_MASTER_AREARow();
lfsMasterAreaRow.ID = newId;
lfsMasterAreaRow.COMPANY_ID = Convert.ToInt32(Session["companyID"]);
lfsMasterAreaRow.RecordID = "";
tdsLfsRecord.LFS_MASTER_AREA.AddLFS_MASTER_AREARow(lfsMasterAreaRow);
//... Prepare initial
Session.Remove("pointRepairDummy");
addRecordTDS = new AddRecordTDS();
lblMaxNumber.Visible = false;
//... Store datasets
Session["tdsLfsRecord"] = tdsLfsRecord;
Session["addRecordTDS"] = addRecordTDS;
pointRepairs = addRecordTDS.PointRepairs;
Session["pointRepairs"] = pointRepairs;
// ... For clients
CompaniesGateway companiesGateway = new CompaniesGateway();
DataSet dsCompanies = companiesGateway.GetCompaniesForDropDownList("-1", "", Convert.ToInt32(Session["companyID"]));
ddlCOMPANIES_ID.DataSource = dsCompanies;
ddlCOMPANIES_ID.DataValueField = "COMPANIES_ID";
ddlCOMPANIES_ID.DataTextField = "NAME";
ddlCOMPANIES_ID.SelectedValue = "-1";
//... Databind
ddlCOMPANIES_ID.DataBind();
}
else
{
//... Restore dataset lfs record
tdsLfsRecord = (TDSLFSRecord)Session["tdsLfsRecord"];
addRecordTDS = (AddRecordTDS)Session["addRecordTDS"];
}
}
///////////////////////////////////////////////////////////////////////////
/// METHODS
///
//
// ProcessBulkUpload
//
private bool ProcessBulkUpload(string fName, out string bulkUploadResultMessage)
{
//--- Initialize
bool bulkUploadProccessed = true;
bulkUploadResultMessage = "";
TDSLFSRecord tdsLfsRecord = new TDSLFSRecord(); // holds the current record being uploaded
TDSLFSRecord tdsLfsRecord2 = new TDSLFSRecord(); // holds all the records uploaded so far
CompaniesGateway companiesGateway = new CompaniesGateway();
LFSMasterAreaGateway lfsMasterAreaGateway = new LFSMasterAreaGateway();
AppSettingsReader appSettingReader = new AppSettingsReader();
string excelConnectionString = appSettingReader.GetValue("ExcelConnectionString", typeof(System.String)).ToString() + fName + ";";
OleDbConnection connection = new OleDbConnection(excelConnectionString);
OleDbConnection connection2 = new OleDbConnection(excelConnectionString);
OleDbCommand command = null;
OleDbCommand command2 = null;
OleDbDataReader dataReader = null;
OleDbDataReader dataReader2 = null;
try
{
//--- Preliminar validation of lfs_master_area data range
#region Preliminar validation of lfs_master_area data range
ArrayList validatedRecordIds = new ArrayList();
try
{
connection.Open();
command = new OleDbCommand("select * from [lfs_master_area]", connection);
dataReader = command.ExecuteReader();
while (dataReader.Read())
{
if (!IsEmptyRow(dataReader))
{
string recordId = dataReader.GetValue(dataReader.GetOrdinal("ID")).ToString().ToUpper().Trim();
if ( (recordId != "NULL") && (recordId != "") )
{
//--- ... validate whether the ID is unique
foreach (string tempRecordId in validatedRecordIds)
{
if (tempRecordId == recordId)
{
bulkUploadResultMessage = "The ID '" + recordId + "' is not unique within the lfs_master_area data range. Bulk upload ABORTED.";
bulkUploadProccessed = false;
break;
}
}
//--- ... validate whether the ID is not already in use in the database
if (bulkUploadProccessed)
{
if (lfsMasterAreaGateway.IsRecordIdInUse(recordId, Convert.ToInt32(Session["companyID"])))
{
bulkUploadResultMessage = "'" + recordId + "' is already in the database. Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
else
{
validatedRecordIds.Add(recordId);
}
}
}
else
{
bulkUploadResultMessage = "Do not enter NULL in 'ID' column (lfs_master_area data range). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
if (!bulkUploadProccessed)
{
break;
}
}
}
dataReader.Close();
connection.Close();
}
catch(Exception ex)
{
bulkUploadResultMessage = "You did not define the 'lfs_master_area' data range. Bulk upload ABORTED. Original message: " + ex.Message;
bulkUploadProccessed = false;
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
#endregion
//--- Preliminar validation of lfs_point_repairs data range
#region Preliminar validation of lfs_point_repairs data range
if (bulkUploadProccessed && cbxUploadLfsPointRepairs.Checked)
{
try
{
connection.Open();
command = new OleDbCommand("select * from [lfs_point_repairs]", connection);
dataReader = command.ExecuteReader();
while (dataReader.Read())
{
if (!IsEmptyRow(dataReader))
{
string recordId = dataReader.GetValue(dataReader.GetOrdinal("ID")).ToString().ToUpper().Trim();
if ( (recordId != "NULL") && (recordId != "") )
{
//--- ... validate whether the ID is defined in the lfs_master_area data range
bool found = false;
foreach (string tempRecordId in validatedRecordIds)
{
if (tempRecordId == recordId)
{
found = true;
break;
}
}
if (!found)
{
bulkUploadResultMessage = "The ID '" + recordId + "' defined in lfs_point_repairs data range does not have a corresponding ID defined in lfs_master_area data range. Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
bulkUploadResultMessage = "Do not enter NULL in 'ID' column (lfs_point_repairs data range). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
if (!bulkUploadProccessed)
{
break;
}
}
}
dataReader.Close();
connection.Close();
}
catch(Exception ex)
{
bulkUploadResultMessage = "You did not define the 'lfs_point_repairs' data range. Bulk upload ABORTED. Original message: " + ex.Message;
bulkUploadProccessed = false;
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
}
#endregion
//--- Preliminar validation of lfs_junction_liner data range
#region Preliminar validation of lfs_junction_liner data range
if (bulkUploadProccessed && cbxUploadLfsJunctionLiner.Checked)
{
try
{
connection.Open();
command = new OleDbCommand("select * from [lfs_junction_liner]", connection);
dataReader = command.ExecuteReader();
while (dataReader.Read())
{
if (!IsEmptyRow(dataReader))
{
string recordId = dataReader.GetValue(dataReader.GetOrdinal("ID")).ToString().ToUpper().Trim();
if ( (recordId != "NULL") && (recordId != "") )
{
//--- ... validate whether the ID is defined in the lfs_master_area data range
bool found = false;
foreach (string tempRecordId in validatedRecordIds)
{
if (tempRecordId == recordId)
{
found = true;
break;
}
}
if (!found)
{
bulkUploadResultMessage = "The ID '" + recordId + "' defined in lfs_junction_liner data range does not have a corresponding ID defined in lfs_master_area data range. Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
bulkUploadResultMessage = "Do not enter NULL in 'ID' column (lfs_junction_liner data range). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
if (!bulkUploadProccessed)
{
break;
}
}
}
dataReader.Close();
connection.Close();
}
catch(Exception ex)
{
bulkUploadResultMessage = "You did not define the 'lfs_junction_liner' data range. Bulk upload ABORTED. Original message: " + ex.Message;
bulkUploadProccessed = false;
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
}
#endregion
//--- Process bulk upload
if (bulkUploadProccessed)
{
connection.Open();
command = new OleDbCommand("select * from [lfs_master_area]", connection);
dataReader = command.ExecuteReader();
while (dataReader.Read())
{
if (!IsEmptyRow(dataReader))
{
//--- ... fill lfs master area row
string recordId = dataReader.GetValue(dataReader.GetOrdinal("ID")).ToString().Trim();
TDSLFSRecord.LFS_MASTER_AREARow lfsMasterAreaRow = tdsLfsRecord.LFS_MASTER_AREA.NewLFS_MASTER_AREARow();
#region fill lfsMasterAreaRow
lfsMasterAreaRow.ID = lfsMasterAreaGateway.GetNewId();
lfsMasterAreaRow.COMPANY_ID = Convert.ToInt32(Session["companyID"]);
lfsMasterAreaRow.RecordID = recordId;
lfsMasterAreaRow.IssueIdentified = false;
lfsMasterAreaRow.IssueResolved = false;
lfsMasterAreaRow.FullLengthLining = false;
lfsMasterAreaRow.SubcontractorLining = false;
lfsMasterAreaRow.OutOfScopeInArea = false;
lfsMasterAreaRow.IssueGivenToBayCity = false;
lfsMasterAreaRow.SalesIssue = false;
lfsMasterAreaRow.LFSIssue = false;
lfsMasterAreaRow.ClientIssue = false;
lfsMasterAreaRow.InvestigationIssue = false;
lfsMasterAreaRow.PointLining = false;
lfsMasterAreaRow.Grouting = false;
lfsMasterAreaRow.LateralLining = false;
lfsMasterAreaRow.JLiner = false;
lfsMasterAreaRow.RehabAssessment = false;
lfsMasterAreaRow.RampsRequired = false;
lfsMasterAreaRow.StandarBypass = false;
lfsMasterAreaRow.RoboticPrepRequired = false;
lfsMasterAreaRow.PipeSizeChange = false;
lfsMasterAreaRow.FullLengthPointLiner = false;
lfsMasterAreaRow.BypassRequired = false;
///
lfsMasterAreaRow.SchoolZone = false;
lfsMasterAreaRow.RestaurantArea = false;
lfsMasterAreaRow.CarwashLaundromat = false;
lfsMasterAreaRow.HydroPulley = false;
lfsMasterAreaRow.FridgeCart = false;
lfsMasterAreaRow.TwoInchPump = false;
lfsMasterAreaRow.SixInchBypass = false;
lfsMasterAreaRow.Scaffolding = false;
lfsMasterAreaRow.WinchExtension = false;
lfsMasterAreaRow.ExtraGenerator = false;
lfsMasterAreaRow.GreyCableExtension = false;
lfsMasterAreaRow.EasementMats = false;
lfsMasterAreaRow.DropPipe = false;
lfsMasterAreaRow.AllMeasured = false;
lfsMasterAreaRow.Deleted = false;
lfsMasterAreaRow.Archived = false;
string dataCell = null;
string dataCellToUpper = null;
string actualLength = null;
string steelTapeThruPipe = null;
for (int i=0; i < dataReader.FieldCount; i++)
{
dataCell = dataReader.GetValue(i).ToString().Trim();
dataCellToUpper = dataReader.GetValue(i).ToString().Trim().ToUpper();
switch (dataReader.GetName(i).Trim())
{
case "ID":
break;
case "ClientID":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.ClientID = dataCell;
}
else
{
lfsMasterAreaRow.SetClientIDNull();
}
break;
case "Client":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.COMPANIES_ID = companiesGateway.GetCOMPANIES_ID(Convert.ToInt32(Session["companyID"]), dataCell);
if (lfsMasterAreaRow.COMPANIES_ID == Int32.MinValue)
{
bulkUploadResultMessage = "Client '" + dataReader.GetValue(i).ToString() + "' was not found in the database (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
bulkUploadResultMessage = "Do not enter NULL in 'Client' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "SubArea":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.SubArea = dataCell;
}
else
{
lfsMasterAreaRow.SetSubAreaNull();
}
break;
case "Street":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.Street = dataCell;
}
else
{
lfsMasterAreaRow.SetStreetNull();
}
break;
case "USMH":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.USMH = dataCell;
}
else
{
lfsMasterAreaRow.SetUSMHNull();
}
break;
case "DSMH":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.DSMH = dataCell;
}
else
{
lfsMasterAreaRow.SetDSMHNull();
}
break;
case "Size":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.Size_ = dataCell;
}
else
{
lfsMasterAreaRow.SetSize_Null();
}
break;
case "ScaledLength":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDouble(dataCell))
{
lfsMasterAreaRow.ScaledLength = dataCell;
lfsMasterAreaRow.ScaledLength1 = Double.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'ScaledLength' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetScaledLengthNull();
lfsMasterAreaRow.SetScaledLength1Null();
}
break;
case "P1Date":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDate(dataCell))
{
lfsMasterAreaRow.P1Date = DateTime.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'P1Date' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetP1DateNull();
}
break;
case "ActualLength":
if (dataCellToUpper != "NULL")
{
if (Distance.IsValidDistance(dataCell))
{
if (steelTapeThruPipe == null || steelTapeThruPipe == dataCell)
{
lfsMasterAreaRow.ActualLength = dataCell;
lfsMasterAreaRow.SteelTapeThruPipe = dataCell;
actualLength = dataCell;
}
else
{
bulkUploadResultMessage = "'ActualLength' value is not equal to 'SteelTapeThruPipe' value (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
bulkUploadResultMessage = "Invalid value in 'ActualLength' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
if (steelTapeThruPipe == null || steelTapeThruPipe == "")
{
lfsMasterAreaRow.SetActualLengthNull();
lfsMasterAreaRow.SetSteelTapeThruPipeNull();
actualLength = "";
}
else
{
bulkUploadResultMessage = "'ActualLength' value is not equal to 'SteelTapeThruPipe' value (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
break;
case "LiveLats":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDouble(dataCell))
{
lfsMasterAreaRow.LiveLats = Double.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'LiveLats' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetLiveLatsNull();
}
break;
case "CXIsRemoved":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.CXIsRemoved = dataCell;
}
else
{
lfsMasterAreaRow.SetCXIsRemovedNull();
}
break;
case "M1Date":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDate(dataCell))
{
lfsMasterAreaRow.M1Date = DateTime.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'M1Date' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetM1DateNull();
}
break;
case "M2Date":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDate(dataCell))
{
lfsMasterAreaRow.M2Date = DateTime.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'M2Date' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetM2DateNull();
}
break;
case "InstallDate":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDate(dataCell))
{
lfsMasterAreaRow.InstallDate = DateTime.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'InstallDate' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetInstallDateNull();
}
break;
case "FinalVideo":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDate(dataCell))
{
lfsMasterAreaRow.FinalVideo = DateTime.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'FinalVideo' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetFinalVideoNull();
}
break;
case "Comments":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.Comments = dataCell;
}
else
{
lfsMasterAreaRow.SetCommentsNull();
}
break;
case "IssueIdentified":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.IssueIdentified = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'IssueIdentified' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "IssueResolved":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.IssueResolved = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'IssueResolved' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "FullLengthLining":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.FullLengthLining = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'FullLengthLining' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "SubcontractorLining":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.SubcontractorLining = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'SubcontractorLining' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "OutOfScopeInArea":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.OutOfScopeInArea = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'OutOfScopeInArea' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "IssueGivenToBayCity":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.IssueGivenToBayCity = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'IssueGivenToBayCity' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "ConfirmedSize":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidInt32(dataCell))
{
lfsMasterAreaRow.ConfirmedSize = Int32.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'ConfirmedSize' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetConfirmedSizeNull();
}
break;
case "InstallRate":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDecimal(dataCell))
{
lfsMasterAreaRow.InstallRate = Decimal.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'InstallRate' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetInstallRateNull();
}
break;
case "DeadlineDate":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDate(dataCell))
{
lfsMasterAreaRow.DeadlineDate = DateTime.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'DeadlineDate' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetDeadlineDateNull();
}
break;
case "ProposedLiningDate":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDate(dataCell))
{
lfsMasterAreaRow.ProposedLiningDate = DateTime.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'ProposedLiningDate' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetProposedLiningDateNull();
}
break;
case "SalesIssue":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.SalesIssue = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'SalesIssue' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "LFSIssue":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.LFSIssue = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'LFSIssue' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "ClientIssue":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.ClientIssue = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'ClientIssue' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "InvestigationIssue":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.InvestigationIssue = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'InvestigationIssue' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "PointLining":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.PointLining = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'PointLining' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "Grouting":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.Grouting = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'Grouting' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "LateralLining":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.LateralLining = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'LateralLining' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "VacExDate":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDate(dataCell))
{
lfsMasterAreaRow.VacExDate = DateTime.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'VacExDate' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetVacExDateNull();
}
break;
case "PusherDate":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDate(dataCell))
{
lfsMasterAreaRow.PusherDate = DateTime.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'PusherDate' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetPusherDateNull();
}
break;
case "LinerOrdered":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDate(dataCell))
{
lfsMasterAreaRow.LinerOrdered = DateTime.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'LinerOrdered' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetLinerOrderedNull();
}
break;
case "Restoration":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDate(dataCell))
{
lfsMasterAreaRow.Restoration = DateTime.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'Restoration' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetRestorationNull();
}
break;
case "GroutDate":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDate(dataCell))
{
lfsMasterAreaRow.GroutDate = DateTime.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'GroutDate' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetGroutDateNull();
}
break;
case "JLiner":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.JLiner = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'JLiner' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "RehabAssessment":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.RehabAssessment = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'RehabAssessment' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "EstimatedJoints":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidInt32(dataCell))
{
lfsMasterAreaRow.EstimatedJoints = Int32.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'EstimatedJoints' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetEstimatedJointsNull();
}
break;
case "JointsTestSealed":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidInt32(dataCell))
{
lfsMasterAreaRow.JointsTestSealed = Int32.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'JointsTestSealed' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetJointsTestSealedNull();
}
break;
case "PreFlushDate":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDate(dataCell))
{
lfsMasterAreaRow.PreFlushDate = DateTime.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'PreFlushDate' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetPreFlushDateNull();
}
break;
case "PreVideoDate":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDate(dataCell))
{
lfsMasterAreaRow.PreVideoDate = DateTime.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'PreVideoDate' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetPreVideoDateNull();
}
break;
case "USMHMN":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.USMHMN = dataCell;
}
else
{
lfsMasterAreaRow.SetUSMHMNNull();
}
break;
case "DSMHMN":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.DSMHMN = dataCell;
}
else
{
lfsMasterAreaRow.SetDSMHMNNull();
}
break;
case "USMHDepth":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.USMHDepth = dataCell;
}
else
{
lfsMasterAreaRow.SetUSMHDepthNull();
}
break;
case "DSMHDepth":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.DSMHDepth = dataCell;
}
else
{
lfsMasterAreaRow.SetDSMHDepthNull();
}
break;
case "MeasurementsTakenBy":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.MeasurementsTakenBy = dataCell;
}
else
{
lfsMasterAreaRow.SetMeasurementsTakenByNull();
}
break;
case "SteelTapeThruPipe":
if (dataCellToUpper != "NULL")
{
if (Distance.IsValidDistance(dataCell))
{
if (actualLength == null || actualLength == dataCell)
{
lfsMasterAreaRow.SteelTapeThruPipe = dataCell;
lfsMasterAreaRow.ActualLength = dataCell; // SYNCHRONIZED
steelTapeThruPipe = dataCell;
}
else
{
bulkUploadResultMessage = "'SteelTapeThruPipe' value is not equal to 'ActualLength' value (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
bulkUploadResultMessage = "Invalid value in 'SteelTapeThruPipe' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
if (actualLength == null || actualLength == "")
{
lfsMasterAreaRow.SetSteelTapeThruPipeNull();
lfsMasterAreaRow.SetActualLengthNull(); // SYNCHRONIZED
steelTapeThruPipe = "";
}
else
{
bulkUploadResultMessage = "'SteelTapeThruPipe' value is not equal to 'ActualLength' value (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
break;
case "USMHAtMouth1200":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDouble(dataCell))
{
lfsMasterAreaRow.USMHAtMouth1200 = Double.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'USMHAtMouth1200' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetUSMHAtMouth1200Null();
}
break;
case "USMHAtMouth100":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDouble(dataCell))
{
lfsMasterAreaRow.USMHAtMouth100 = Double.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'USMHAtMouth100' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetUSMHAtMouth100Null();
}
break;
case "USMHAtMouth200":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDouble(dataCell))
{
lfsMasterAreaRow.USMHAtMouth200 = Double.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'USMHAtMouth200' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetUSMHAtMouth200Null();
}
break;
case "USMHAtMouth300":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDouble(dataCell))
{
lfsMasterAreaRow.USMHAtMouth300 = Double.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'USMHAtMouth300' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetUSMHAtMouth300Null();
}
break;
case "USMHAtMouth400":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDouble(dataCell))
{
lfsMasterAreaRow.USMHAtMouth400 = Double.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'USMHAtMouth400' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetUSMHAtMouth400Null();
}
break;
case "USMHAtMouth500":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDouble(dataCell))
{
lfsMasterAreaRow.USMHAtMouth500 = Double.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'USMHAtMouth500' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetUSMHAtMouth500Null();
}
break;
case "DSMHAtMouth1200":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDouble(dataCell))
{
lfsMasterAreaRow.DSMHAtMouth1200 = Double.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'DSMHAtMouth1200' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetDSMHAtMouth1200Null();
}
break;
case "DSMHAtMouth100":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDouble(dataCell))
{
lfsMasterAreaRow.DSMHAtMouth100 = Double.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'DSMHAtMouth100' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetDSMHAtMouth100Null();
}
break;
case "DSMHAtMouth200":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDouble(dataCell))
{
lfsMasterAreaRow.DSMHAtMouth200 = Double.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'DSMHAtMouth200' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetDSMHAtMouth200Null();
}
break;
case "DSMHAtMouth300":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDouble(dataCell))
{
lfsMasterAreaRow.DSMHAtMouth300 = Double.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'DSMHAtMouth300' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetDSMHAtMouth300Null();
}
break;
case "DSMHAtMouth400":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDouble(dataCell))
{
lfsMasterAreaRow.DSMHAtMouth400 = Double.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'DSMHAtMouth400' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetDSMHAtMouth400Null();
}
break;
case "DSMHAtMouth500":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDouble(dataCell))
{
lfsMasterAreaRow.DSMHAtMouth500 = Double.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'DSMHAtMouth500' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetDSMHAtMouth500Null();
}
break;
case "HydrantAddress":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.HydrantAddress = dataCell;
}
else
{
lfsMasterAreaRow.SetHydrantAddressNull();
}
break;
case "DistanceToInversionMH":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.DistanceToInversionMH = dataCell;
}
else
{
lfsMasterAreaRow.SetDistanceToInversionMHNull();
}
break;
case "RampsRequired":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.RampsRequired = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'RampsRequired' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "DegreeOfTrafficControl":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.DegreeOfTrafficControl = dataCell;
if ( (dataCell != "FLAGMEN REQUIRED") && (dataCell != "MAJOR ROAD") && (dataCell != "PERMIT REQUIRED") && (dataCell != "RESIDENTIAL"))
{
bulkUploadResultMessage = "Invalid value in 'DegreeOfTrafficControl' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetDegreeOfTrafficControlNull();
}
break;
case "StandarBypass":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.StandarBypass = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'StandarBypass' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "HydroWireDetails":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.HydroWireDetails = dataCell;
}
else
{
lfsMasterAreaRow.SetHydroWireDetailsNull();
}
break;
case "PipeMaterialType":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.PipeMaterialType = dataCell;
}
else
{
lfsMasterAreaRow.SetPipeMaterialTypeNull();
}
break;
case "CappedLaterals":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidInt32(dataCell))
{
lfsMasterAreaRow.CappedLaterals = Int32.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'CappedLaterals' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetCappedLateralsNull();
}
break;
case "RoboticPrepRequired":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.RoboticPrepRequired = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'RoboticPrepRequired' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "PipeSizeChange":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.PipeSizeChange = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'PipeSizeChange' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "M1Comments":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.M1Comments = dataCell;
}
else
{
lfsMasterAreaRow.SetM1CommentsNull();
}
break;
case "VideoDoneFrom":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.VideoDoneFrom = dataCell;
}
else
{
lfsMasterAreaRow.SetVideoDoneFromNull();
}
break;
case "ToManhole":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.ToManhole = dataCell;
}
else
{
lfsMasterAreaRow.SetToManholeNull();
}
break;
case "CutterDescriptionDuringMeasuring":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.CutterDescriptionDuringMeasuring = dataCell;
}
else
{
lfsMasterAreaRow.SetCutterDescriptionDuringMeasuringNull();
}
break;
case "FullLengthPointLiner":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.FullLengthPointLiner = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'FullLengthPointLiner' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "BypassRequired":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.BypassRequired = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'BypassRequired' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "RoboticDistances":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.RoboticDistances = dataCell;
}
else
{
lfsMasterAreaRow.SetRoboticDistancesNull();
}
break;
///
case "TrafficControlDetails":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.TrafficControlDetails = dataCell;
}
else
{
lfsMasterAreaRow.SetTrafficControlDetailsNull();
}
break;
case "LineWithID":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.LineWithID = dataCell;
}
else
{
lfsMasterAreaRow.SetLineWithIDNull();
}
break;
case "SchoolZone":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.SchoolZone = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'SchoolZone' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "RestaurantArea":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.RestaurantArea = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'RestaurantArea' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "CarwashLaundromat":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.CarwashLaundromat = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'CarwashLaundromat' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "HydroPulley":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.HydroPulley = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'HydroPulley' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "FridgeCart":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.FridgeCart = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'FridgeCart' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "TwoInchPump":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.TwoInchPump = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'TwoInchPump' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "SixInchBypass":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.SixInchBypass = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'SixInchBypass' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "Scaffolding":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.Scaffolding = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'Scaffolding' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "WinchExtension":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.WinchExtension = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'WinchExtension' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "ExtraGenerator":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.ExtraGenerator = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'ExtraGenerator' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "GreyCableExtension":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.GreyCableExtension = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'GreyCableExtension' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "EasementMats":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.EasementMats = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'EasementMats' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "MeasurementType":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.MeasurementType = dataCell;
if ( (dataCell != "CAMERA") && (dataCell != "SIMULATOR"))
{
bulkUploadResultMessage = "Invalid value in 'MeasurementType' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetMeasurementTypeNull();
}
break;
case "DropPipe":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsMasterAreaRow.DropPipe = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'DropPipe' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "DropPipeInvertDepth":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.DropPipeInvertDepth = dataCell;
}
else
{
lfsMasterAreaRow.SetDropPipeInvertDepthNull();
}
break;
case "MeasuredFromManhole":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.MeasuredFromManhole = dataCell;
}
else
{
lfsMasterAreaRow.SetMeasuredFromManholeNull();
}
break;
case "MainLined":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.MainLined = dataCell;
if ( (dataCellToUpper != "YES") && (dataCellToUpper != "NO"))
{
bulkUploadResultMessage = "Invalid value in 'MainLined' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetMainLinedNull();
}
break;
case "BenchingIssue":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.BenchingIssue = dataCell;
if ( (dataCellToUpper != "YES") && (dataCellToUpper != "NO"))
{
bulkUploadResultMessage = "Invalid value in 'BenchingIssue' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.SetBenchingIssueNull();
}
break;
case "History":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.History = dataCell;
}
else
{
lfsMasterAreaRow.SetHistoryNull();
}
break;
case "NumLats":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidInt32(dataCell))
{
lfsMasterAreaRow.NumLats = Int32.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'NumLats' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.NumLats = 0;
}
break;
case "NotLinedYet":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidInt32(dataCell))
{
lfsMasterAreaRow.NotLinedYet = Int32.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'NotLinedYet' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsMasterAreaRow.NotLinedYet = 0;
}
break;
case "AllMeasured":
if ((dataCellToUpper == "YES") || (dataCellToUpper == "NO"))
{
lfsMasterAreaRow.AllMeasured = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'AllMeasured' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "City":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.City = dataCell;
}
else
{
lfsMasterAreaRow.SetCityNull();
}
break;
case "ProvState":
if (dataCellToUpper != "NULL")
{
lfsMasterAreaRow.ProvState = dataCell;
}
else
{
lfsMasterAreaRow.SetProvStateNull();
}
break;
default:
bulkUploadResultMessage = "Invalid column name '" + dataReader.GetName(i) + "' in lfs_master_area data range.";
bulkUploadProccessed = false;
break;
}
if (!bulkUploadProccessed)
{
break;
}
}
#endregion
tdsLfsRecord.LFS_MASTER_AREA.AddLFS_MASTER_AREARow(lfsMasterAreaRow);
//--- ... fill lfs point repairs rows
if (cbxUploadLfsPointRepairs.Checked)
{
connection2.Open();
command2 = new OleDbCommand("select * from [lfs_point_repairs] where ID = '" + recordId + "'", connection2);
dataReader2 = command2.ExecuteReader();
while (dataReader2.Read())
{
if (!IsEmptyRow(dataReader))
{
TDSLFSRecord.LFS_POINT_REPAIRSRow lfsPointRepairsRow = tdsLfsRecord.LFS_POINT_REPAIRS.NewLFS_POINT_REPAIRSRow();
#region fill lfsPointRepairsRow
lfsPointRepairsRow.ID = lfsMasterAreaRow.ID;
lfsPointRepairsRow.RefID = Generator.GetNewLfsPointRepairsRefId(tdsLfsRecord);
lfsPointRepairsRow.COMPANY_ID = Convert.ToInt32(Session["companyID"]);
lfsPointRepairsRow.DetailID = Generator.GetNewLfsPointRepairsDetailId(tdsLfsRecord);
lfsPointRepairsRow.Deleted = false;
lfsPointRepairsRow.ExtraRepair = false;
lfsPointRepairsRow.Cancelled = false;
lfsPointRepairsRow.Approved = false;
lfsPointRepairsRow.NotApproved = false;
lfsPointRepairsRow.Archived = false;
for (int i=0; i < dataReader2.FieldCount; i++)
{
dataCell = dataReader2.GetValue(i).ToString().Trim();
dataCellToUpper = dataReader2.GetValue(i).ToString().Trim().ToUpper();
switch (dataReader2.GetName(i).Trim())
{
case "ID":
break;
case "RepairSize":
if (dataCellToUpper != "NULL")
{
lfsPointRepairsRow.RepairSize = dataCell;
}
else
{
lfsPointRepairsRow.SetRepairSizeNull();
}
break;
case "InstallDate":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDate(dataCell))
{
lfsPointRepairsRow.InstallDate = DateTime.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'InstallDate' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsPointRepairsRow.SetInstallDateNull();
}
break;
case "Distance":
if (dataCellToUpper != "NULL")
{
lfsPointRepairsRow.Distance = dataCell;
}
else
{
lfsPointRepairsRow.SetDistanceNull();
}
break;
case "Cost":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDecimal(dataCell))
{
lfsPointRepairsRow.Cost = Decimal.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'Cost' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsPointRepairsRow.SetCostNull();
}
break;
case "Reinstates":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidInt32(dataCell))
{
lfsPointRepairsRow.Reinstates = Int32.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'Reinstates' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsPointRepairsRow.SetReinstatesNull();
}
break;
case "LTAtMH":
if (dataCellToUpper != "NULL")
{
lfsPointRepairsRow.LTAtMH = dataCell;
}
else
{
lfsPointRepairsRow.SetLTAtMHNull();
}
break;
case "VTAtMH":
if (dataCellToUpper != "NULL")
{
lfsPointRepairsRow.VTAtMH = dataCell;
}
else
{
lfsPointRepairsRow.SetVTAtMHNull();
}
break;
case "LinerDistance":
if (dataCellToUpper != "NULL")
{
lfsPointRepairsRow.LinerDistance = dataCell;
}
else
{
lfsPointRepairsRow.SetLinerDistanceNull();
}
break;
case "Direction":
if (dataCellToUpper != "NULL")
{
lfsPointRepairsRow.Direction = dataCell;
if ( (dataCell != "DS PULL IN") && (dataCell != "DS PUSH IN") && (dataCell != "US PULL IN") && (dataCell != "US PUSH IN"))
{
bulkUploadResultMessage = "Invalid value in 'Direction' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsPointRepairsRow.SetDirectionNull();
}
break;
case "MHShot":
if (dataCellToUpper != "NULL")
{
lfsPointRepairsRow.MHShot = dataCell;
if ( (dataCell != "DS MH SHOT") && (dataCell != "US MH SHOT"))
{
bulkUploadResultMessage = "Invalid value in 'MHShot' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsPointRepairsRow.SetMHShotNull();
}
break;
case "Comments":
if (dataCellToUpper != "NULL")
{
lfsPointRepairsRow.Comments = dataCell;
}
else
{
lfsPointRepairsRow.SetCommentsNull();
}
break;
case "ExtraRepair":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsPointRepairsRow.ExtraRepair = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'ExtraRepair' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "Cancelled":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsPointRepairsRow.Cancelled = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'Cancelled' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "Approved":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsPointRepairsRow.Approved = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'Approved' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "NotApproved":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsPointRepairsRow.NotApproved = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'NotApproved' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
default:
bulkUploadResultMessage = "Invalid column name '" + dataReader2.GetName(i) + "' in lfs_point_repairs data range.";
bulkUploadProccessed = false;
break;
}
if (!bulkUploadProccessed)
{
break;
}
}
#endregion
tdsLfsRecord.LFS_POINT_REPAIRS.AddLFS_POINT_REPAIRSRow(lfsPointRepairsRow);
if (!bulkUploadProccessed)
{
break;
}
}
}
dataReader2.Close();
connection2.Close();
}
//--- ... fill lfs junction liner rows
if (cbxUploadLfsJunctionLiner.Checked)
{
connection2.Open();
command2 = new OleDbCommand("select * from [lfs_junction_liner] where ID = '" + recordId + "'", connection2);
dataReader2 = command2.ExecuteReader();
while (dataReader2.Read())
{
if (!IsEmptyRow(dataReader))
{
TDSLFSRecord.LFS_JUNCTION_LINERRow lfsJunctionLinerRow = tdsLfsRecord.LFS_JUNCTION_LINER.NewLFS_JUNCTION_LINERRow();
#region fill lfsJunctionLinerRow
lfsJunctionLinerRow.ID = lfsMasterAreaRow.ID;
lfsJunctionLinerRow.RefID = Generator.GetNewLfsJunctionLinerRefId(tdsLfsRecord);
lfsJunctionLinerRow.COMPANY_ID = Convert.ToInt32(Session["companyID"]);
lfsJunctionLinerRow.DetailID = Generator.GetNewLfsJunctionLinerDetailId(tdsLfsRecord);
lfsJunctionLinerRow.CleanoutRequired = false;
lfsJunctionLinerRow.PitRequired = false;
lfsJunctionLinerRow.MHShot = false;
lfsJunctionLinerRow.CleanoutInstalled = false;
lfsJunctionLinerRow.PitInstalled = false;
lfsJunctionLinerRow.CleanoutGrouted = false;
lfsJunctionLinerRow.CleanoutCored = false;
lfsJunctionLinerRow.RestorationComplete = false;
lfsJunctionLinerRow.LinerOrdered = false;
lfsJunctionLinerRow.LinerInStock = false;
lfsJunctionLinerRow.Deleted = false;
lfsJunctionLinerRow.Archived = false;
for (int i=0; i < dataReader2.FieldCount; i++)
{
dataCell = dataReader2.GetValue(i).ToString().Trim();
dataCellToUpper = dataReader2.GetValue(i).ToString().Trim().ToUpper();
switch (dataReader2.GetName(i).Trim())
{
case "ID":
break;
case "MN":
if (dataCellToUpper != "NULL")
{
lfsJunctionLinerRow.MN = dataCell;
}
else
{
lfsJunctionLinerRow.SetMNNull();
}
break;
case "DistanceFromUSMH":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDouble(dataCell))
{
lfsJunctionLinerRow.DistanceFromUSMH = Double.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'DistanceFromUSMH' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsJunctionLinerRow.SetDistanceFromUSMHNull();
}
break;
case "ConfirmedLatSize":
if (dataCellToUpper != "NULL")
{
lfsJunctionLinerRow.ConfirmedLatSize = dataCell;
}
else
{
lfsJunctionLinerRow.SetConfirmedLatSizeNull();
}
break;
case "LateralMaterial":
if (dataCellToUpper != "NULL")
{
lfsJunctionLinerRow.LateralMaterial = dataCell;
}
else
{
lfsJunctionLinerRow.SetLateralMaterialNull();
}
break;
case "SharedLateral":
if (dataCellToUpper != "NULL")
{
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsJunctionLinerRow.SharedLateral = (dataCellToUpper == "YES") ? "Yes" : "No";
}
else
{
bulkUploadResultMessage = "Invalid value in 'SharedLateral' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsJunctionLinerRow.SetSharedLateralNull();
}
break;
case "CleanoutRequired":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsJunctionLinerRow.CleanoutRequired = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'CleanoutRequired' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "PitRequired":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsJunctionLinerRow.PitRequired = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'PitRequired' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "MHShot":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsJunctionLinerRow.MHShot = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'MHShot' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "MainConnection":
if (dataCellToUpper != "NULL")
{
if ( (dataCellToUpper == "TEE") || (dataCellToUpper == "WEE") )
{
lfsJunctionLinerRow.MainConnection = (dataCellToUpper == "TEE") ? "Tee" : "Wee";
}
else
{
bulkUploadResultMessage = "Invalid value in 'MainConnection' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsJunctionLinerRow.SetMainConnectionNull();
}
break;
case "Transition":
if (dataCellToUpper != "NULL")
{
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsJunctionLinerRow.Transition = (dataCellToUpper == "YES") ? "Yes" : "No";
}
else
{
bulkUploadResultMessage = "Invalid value in 'Transition' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsJunctionLinerRow.SetTransitionNull();
}
break;
case "CleanoutInstalled":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsJunctionLinerRow.CleanoutInstalled = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'CleanoutInstalled' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "PitInstalled":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsJunctionLinerRow.PitInstalled = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'PitInstalled' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "CleanoutGrouted":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsJunctionLinerRow.CleanoutGrouted = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'CleanoutGrouted' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "CleanoutCored":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsJunctionLinerRow.CleanoutCored = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'CleanoutCored' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "PrepCompleted":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDate(dataCell))
{
lfsJunctionLinerRow.PrepCompleted = DateTime.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'PrepCompleted' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsJunctionLinerRow.SetPrepCompletedNull();
}
break;
case "MeasuredLatLength":
if (dataCellToUpper != "NULL")
{
lfsJunctionLinerRow.MeasuredLatLength = dataCell;
}
else
{
lfsJunctionLinerRow.SetMeasuredLatLengthNull();
}
break;
case "MeasurementsTakenBy":
if (dataCellToUpper != "NULL")
{
lfsJunctionLinerRow.MeasurementsTakenBy = dataCell;
}
else
{
lfsJunctionLinerRow.SetMeasurementsTakenByNull();
}
break;
case "LinerInstalled":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDate(dataCell))
{
lfsJunctionLinerRow.LinerInstalled = DateTime.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'LinerInstalled' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsJunctionLinerRow.SetLinerInstalledNull();
}
break;
case "FinalVideo":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDate(dataCell))
{
lfsJunctionLinerRow.FinalVideo = DateTime.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'FinalVideo' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsJunctionLinerRow.SetFinalVideoNull();
}
break;
case "RestorationComplete":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsJunctionLinerRow.RestorationComplete = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'RestorationComplete' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "LinerOrdered":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsJunctionLinerRow.LinerOrdered = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'LinerOrdered' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "LinerInStock":
if ( (dataCellToUpper == "YES") || (dataCellToUpper == "NO") )
{
lfsJunctionLinerRow.LinerInStock = (dataCellToUpper == "YES") ? true : false;
}
else
{
bulkUploadResultMessage = "Invalid value in 'LinerInStock' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
case "LinerPrice":
if (dataCellToUpper != "NULL")
{
if (Validator.IsValidDecimal(dataCell))
{
lfsJunctionLinerRow.LinerPrice = Decimal.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'LinerPrice' column (" + recordId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
else
{
lfsJunctionLinerRow.SetLinerPriceNull();
}
break;
case "Comments":
if (dataCellToUpper != "NULL")
{
lfsJunctionLinerRow.Comments = dataCell;
}
else
{
lfsJunctionLinerRow.SetCommentsNull();
}
break;
default:
bulkUploadResultMessage = "Invalid column name '" + dataReader2.GetName(i) + "' in lfs_junction_liner data range.";
bulkUploadProccessed = false;
break;
}
if (!bulkUploadProccessed)
{
break;
}
}
#endregion
tdsLfsRecord.LFS_JUNCTION_LINER.AddLFS_JUNCTION_LINERRow(lfsJunctionLinerRow);
if (!bulkUploadProccessed)
{
break;
}
}
}
dataReader2.Close();
connection2.Close();
}
//--- ... caculate data for record change tracking
tdsLfsRecord2.Merge(tdsLfsRecord);
tdsLfsRecord.Clear();
if (!bulkUploadProccessed)
{
break;
}
}
}
dataReader.Close();
connection.Close();
//--- Insert bulk uploaded data in database
if (bulkUploadProccessed)
{
//--- Update database
LFSRecordGateway lfsRecordGateway = new LFSRecordGateway();
lfsRecordGateway.UpdateRecord(tdsLfsRecord2);
}
}
}
catch(Exception ex)
{
if (!dataReader2.IsClosed)
{
dataReader2.Close();
}
if (connection2.State == ConnectionState.Open)
{
connection2.Close();
}
if (!dataReader.IsClosed)
{
dataReader.Close();
}
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
throw ex;
}
return (bulkUploadProccessed) ? true : false;
}
