protected void AddElement()
{
string element_info = " ";
if (!string.IsNullOrEmpty(reElementInfo.Content))
{
element_info = reElementInfo.Content;
}
Data.SiteElement elem = new Data.SiteElement()
{
site_id = currSite.site_id,
element_id = element_id,
element_info = element_info.FormatParagraphIn(),
revised_by = rtbRevisedBy.Text,
revised_dt = DateTime.Now,
entered_by = user.ID,
entered_dt = DateTime.Now
};
db.SiteElements.InsertOnSubmit(elem);
db.SubmitChanges();
if (element_id == 9)
{
UpdateDateOfLastLevels();
}
UpdateMaxRevisedDate();
}
protected void Page_Load(object sender, EventArgs e)
{
currSiteElem = db.SiteElements.FirstOrDefault(p => p.element_id == ElementID && p.site_id == SiteID);
ltlElemRevisedInfo.Text = "Revised by: " + currSiteElem.revised_by + " Date revised: " + currSiteElem.revised_dt.ToString();
if (currSiteElem.element_info != null)
{
ltlElemInfo.Text = currSiteElem.element_info.FormatParagraphOut();
}
else
{
ltlElemInfo.Text = "";
}
ltlElemName.Text = currSiteElem.ElementDetail.element_nm;
ltlElemName2.Text = currSiteElem.ElementDetail.element_nm;
hlRevisionHistory.NavigateUrl = String.Format("{0}StationDoc/Archive.aspx?element_id={1}&site+id={2}&begin_dt=1/1/1900&end_dt={3}", Config.SIMSURL, ElementID, SiteID, DateTime.Now);
if (hfToggleElementEditMode.Value == "true")
{
lbToggleElementEditMode.Text = "leave element edit mode";
pnlEditElemInfo.Visible = true;
pnlStaticElemInfo.Visible = false;
}
else
{
lbToggleElementEditMode.Text = "enter element edit mode";
pnlEditElemInfo.Visible = false;
pnlStaticElemInfo.Visible = true;
}
if (hfToggleElementHazardEditMode.Value == "true")
{
lbToggleElementHazardEditMode.Text = "leave hazard edit mode";
}
else
{
lbToggleElementHazardEditMode.Text = "enter hazard edit mode";
}
}
protected void btnNewMeasType_Command(object sender, System.Web.UI.WebControls.CommandEventArgs e)
{
if (string.IsNullOrEmpty(Session["btnpressed"].ToString()) | Session["btnpressed"].ToString() == "true")
{
int element_id = Convert.ToInt32(ddlNewMeasType.SelectedValue);
Data.SiteElement elem_temp = new Data.SiteElement();
try
{
elem_temp.site_id = SiteID;
elem_temp.element_id = element_id;
elem_temp.element_info = " ";
elem_temp.entered_by = user.ID;
elem_temp.entered_dt = DateTime.Now;
elem_temp.revised_by = user.ID;
elem_temp.revised_dt = DateTime.Now;
db.SiteElements.InsertOnSubmit(elem_temp);
db.SP_Report_Update_Site_LastEdited(SiteID);
db.SubmitChanges();
DisplayMessage(false, "The element was added!", "element");
ReviewSHA();
}
catch (Exception ex)
{
Session["btnpressed"] = "";
DisplayMessage(true, ex.Message, "element");
}
ddlNewMeasType.SelectedValue = "0";
SetupMeasurementSpecificPanel();
}
Session["btnpressed"] = "true";
}
protected void SubmitEvent(object sender, CommandEventArgs e)
{
if (e.CommandArgument.ToString() == "ConfirmSite")
{
if (string.IsNullOrEmpty(rtbSiteNo.Text.ToString()) || string.IsNullOrEmpty(rtbAgencyCode.Text))
{
pnlError.Visible = true;
ltlError.Text = "You must enter a site number and agency code.";
}
else
{
var sims_site = db.Sites.FirstOrDefault(p => p.site_no.Trim() == rtbSiteNo.Text.ToString() && p.agency_cd == rtbAgencyCode.Text);
if (sims_site != null)
{
pnlError.Visible = true;
ltlError.Text = "The site number you entered is already registered in SIMS.";
return;
}
var site = db.vSITEFILEUNUSEDs.FirstOrDefault(p => p.site_no.Trim() == rtbSiteNo.Text.ToString() && p.agency_cd == rtbAgencyCode.Text);
if (site == null)
{
pnlError.Visible = true;
ltlError.Text = "The site number you entered was not found in the NWISWeb SITEFILE.";
return;
}
pnlError.Visible = false;
pnlEnterSite.Visible = false;
pnlConfirmSite.Visible = true;
ltlSiteNo.Text = rtbSiteNo.Text;
ltlOffice.Text = rddlOffice.SelectedText;
ltlSiteName.Text = site.station_nm;
rtbSiteName.Text = site.station_nm;
}
}
else if (e.CommandArgument.ToString() == "AddSite")
{
var site = db.vSITEFILEUNUSEDs.FirstOrDefault(p => p.site_no.Trim() == rtbSiteNo.Text.ToString() && p.agency_cd == rtbAgencyCode.Text);
var site_type = db.SiteTypes.FirstOrDefault(p => p.site_tp_cd == site.site_tp_cd).sims_site_tp;
Data.Site new_site = new Data.Site()
{
site_no = rtbSiteNo.Text,
station_full_nm = rtbSiteName.Text,
office_id = Convert.ToInt32(rddlOffice.SelectedValue),
agency_cd = rtbAgencyCode.Text,
nwisweb_site_id = site.site_id,
nwis_host = site.nwis_host,
db_no = site.db_no
};
db.Sites.InsertOnSubmit(new_site);
db.SubmitChanges();
Data.SiteElement elem = new Data.SiteElement()
{
site_id = new_site.site_id,
element_id = 28,
entered_by = "Admin",
entered_dt = DateTime.Now,
revised_by = "Admin",
revised_dt = DateTime.Now,
};
db.SiteElements.InsertOnSubmit(elem);
db.SubmitChanges();
//If GW site, then also add the WELL CHARACTERISTICS (104) and DATUM (106) elements
if (site_type == "gw")
{
elem = new Data.SiteElement()
{
site_id = new_site.site_id,
element_id = 104,
entered_by = "Admin",
entered_dt = DateTime.Now,
revised_by = "Admin",
revised_dt = DateTime.Now,
};
db.SiteElements.InsertOnSubmit(elem);
db.SubmitChanges();
elem = new Data.SiteElement()
{
site_id = new_site.site_id,
element_id = 106,
entered_by = "Admin",
entered_dt = DateTime.Now,
revised_by = "Admin",
revised_dt = DateTime.Now,
};
db.SiteElements.InsertOnSubmit(elem);
db.SubmitChanges();
}
//Add record to the Elem_Report_Approve table for the MANU
Data.ElemReportApprove elem_approve = new Data.ElemReportApprove()
{
site_id = new_site.site_id,
report_type_cd = "MANU",
publish_complete = "N"
};
db.ElemReportApproves.InsertOnSubmit(elem_approve);
db.SubmitChanges();
//Add three records to the Eleme_Report_Sum table for each report type
Data.ElemReportSum elem_report = new Data.ElemReportSum()
{
site_id = new_site.site_id,
report_type_cd = "MANU",
revised_dt = DateTime.Now
};
db.ElemReportSums.InsertOnSubmit(elem_report);
db.SubmitChanges();
elem_report = new Data.ElemReportSum()
{
site_id = new_site.site_id,
report_type_cd = "SDESC",
revised_dt = DateTime.Now
};
db.ElemReportSums.InsertOnSubmit(elem_report);
db.SubmitChanges();
elem_report = new Data.ElemReportSum()
{
site_id = new_site.site_id,
report_type_cd = "SANAL",
revised_dt = DateTime.Now
};
db.ElemReportSums.InsertOnSubmit(elem_report);
db.SubmitChanges();
pnlEnterSite.Visible = false;
pnlConfirmSite.Visible = false;
pnlFinal.Visible = true;
hlStationInfo.NavigateUrl = String.Format("{0}StationInfo.aspx?site_id={1}", Config.SIMSURL, new_site.site_id);
}
else
{
InitialPageSetup();
}
}
