protected void radOldSurvey_CheckedChanged(object sender, EventArgs e)
{
try
{
if (radOldSurvey.Checked)
{
pnlDistressDetails.Visible = false;
pnlNewSurvey.Visible = false;
radlOldSurveys.Visible = true;
radlOldSurveys.DataBind();
lblSurveysCount.Text = radlOldSurveys.Items.Count.ToString();
lbtnAddDistress.Visible = (radlOldSurveys.Items.Count > 0);
if (radlOldSurveys.Items.Count == 1)
{
radlOldSurveys.SelectedValue = DistressSurvey.GetLastSecondaryStreetSurveyNumber(int.Parse(gvRegionSamples.SelectedValue.ToString())).ToString();
radlOldSurveys_SelectedIndexChanged(sender, e);
//gvDistresses.DataBind();
}
else if (radlOldSurveys.Items.Count > 1)
{
radlOldSurveys.SelectedIndex = 0; //-1;
}
else
{
radlOldSurveys.SelectedIndex = -1;
}
}
}
catch (Exception ex)
{
lblFeedback.Text = ex.Message;
}
}
public bool UpdateSecondaryStreetSampleArea(int STREET_ID, string SECOND_AR_NAME, double SECOND_ST_LENGTH, double SECOND_ST_WIDTH, string user, string NOTES)
{
string sql = "";
SECOND_AR_NAME = (string.IsNullOrEmpty(SECOND_AR_NAME)) ? "NULL" : string.Format("'{0}'", SECOND_AR_NAME.Replace("'", "''"));
NOTES = (string.IsNullOrEmpty(NOTES)) ? "NULL" : string.Format("'{0}'", NOTES.Replace("'", "''"));
int lastSecondaryStSurveyNum = DistressSurvey.GetLastSecondaryStreetSurveyNumber(STREET_ID);
if (lastSecondaryStSurveyNum == 0)
{
// no surveys have been done over this secondar street, so we can update its length and width directly
//sql = string.Format("UPDATE SECONDARY_STREETS SET SECOND_ST_WIDTH={0}, SECOND_ST_LENGTH={1}, ARNAME={2}, SECOND_ARNAME={2} WHERE SECOND_ID={3} ",
sql = string.Format("UPDATE STREETS SET SECOND_ST_WIDTH={0}, SECOND_ST_LENGTH={1}, ARNAME={2}, SECOND_ARNAME={2} WHERE STREET_ID={3} ",
SECOND_ST_WIDTH, SECOND_ST_LENGTH, SECOND_AR_NAME, STREET_ID);
int rows = db.ExecuteNonQuery(sql);
sql = string.Format("UPDATE SECONDARY_STREET_DETAILS SET SECOND_ST_WIDTH={0}, SECOND_ST_LENGTH={1}, ARNAME={2}, SECOND_AR_NAME={2} WHERE STREET_ID={3} ",
SECOND_ST_WIDTH, SECOND_ST_LENGTH, SECOND_AR_NAME, STREET_ID);
rows += db.ExecuteNonQuery(sql);
Shared.SaveLogfile("SECONDARY_STREETS", STREET_ID.ToString(), "Update", user);
return(rows > 0);
}
else
{
// surveys have been done over this secondar street, so we have to remove them before we can update its length and width directly
sql = string.Format("UPDATE STREETS SET SECOND_ST_WIDTH={0}, SECOND_ST_LENGTH={1}, ARNAME={2}, SECOND_ARNAME={2}, NOTES={4} WHERE STREET_ID={3} ",
SECOND_ST_WIDTH, SECOND_ST_LENGTH, SECOND_AR_NAME, STREET_ID, NOTES);
int rows = db.ExecuteNonQuery(sql);
sql = string.Format("UPDATE SECONDARY_STREET_DETAILS SET SECOND_ST_WIDTH={0}, SECOND_ST_LENGTH={1}, ARNAME={2}, SECOND_AR_NAME={2} WHERE STREET_ID={3} ",
SECOND_ST_WIDTH, SECOND_ST_LENGTH, SECOND_AR_NAME, STREET_ID);
rows += db.ExecuteNonQuery(sql);
rows += new SecondaryStreets().FixDistressesAfterAreaChange(SECOND_ST_LENGTH, SECOND_ST_WIDTH, STREET_ID, user);
sql = string.Format("DELETE FROM MAINTENANCE_DECISIONS WHERE STREET_ID={0} ", STREET_ID); // second_id
db.ExecuteNonQuery(sql);
Shared.SaveLogfile("SECONDARY_STREETS", STREET_ID.ToString(), "Update with nulling UDI", user);
return(rows > 0);
}
}