protected void rgPersonnel_UpdateCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem item = e.Item as GridEditableItem;
string user_id = item.GetDataKeyValue("user_id").ToString();
var currUser = db.Employees.FirstOrDefault(p => p.user_id == user_id);
int office_id = Convert.ToInt32((item.FindControl("rddlOffice") as RadDropDownList).SelectedValue);
string first_nm = (item.FindControl("rtbFirstNm") as RadTextBox).Text;
string last_nm = (item.FindControl("rtbLastNm") as RadTextBox).Text;
string administrator_va = (item.FindControl("rddlAdminLevel") as RadDropDownList).SelectedValue.ToString();
string pass_access = (item.FindControl("rddlPASSLevel") as RadDropDownList).SelectedValue.ToString();
Boolean approver_va = Convert.ToBoolean((item.FindControl("rrblSafetyApprover") as RadRadioButtonList).SelectedValue);
Boolean active = Convert.ToBoolean((item.FindControl("rrblStatus") as RadRadioButtonList).SelectedValue);
Boolean show_reports = Convert.ToBoolean((item.FindControl("rcbReports") as RadCheckBox).Checked);
currUser.first_nm = first_nm;
currUser.last_nm = last_nm;
currUser.office_id = office_id;
currUser.administrator_va = administrator_va;
currUser.pass_access = pass_access;
currUser.approver_va = approver_va;
currUser.active = active;
currUser.show_reports = show_reports;
db.SubmitChanges();
DisplayMessage(false, "The user's info was updated!");
}
protected void rgRecordTypes_UpdateCommand(object source, GridCommandEventArgs e)
{
GridEditableItem editedItem = (GridEditableItem)e.Item;
UserControl MyUserControl = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID);
try
{
int record_type_id = Convert.ToInt32(editedItem.GetDataKeyValue("record_type_id"));
var rec_type = db.RecordTypes.FirstOrDefault(p => p.record_type_id == record_type_id);
rec_type.type_cd = ((TextBox)MyUserControl.FindControl("tbCode")).Text;
rec_type.type_ds = ((TextBox)MyUserControl.FindControl("tbDescription")).Text;
rec_type.TemplateID = Convert.ToInt32(((RadDropDownList)MyUserControl.FindControl("rddlTemplates")).SelectedValue);
rec_type.analyze_html_va = ((RadTextBox)MyUserControl.FindControl("rtbAnalyzeInstructions")).Text;
rec_type.approve_html_va = ((RadTextBox)MyUserControl.FindControl("rtbApproveInstructions")).Text;
db.SubmitChanges();
rgRecordTypes.Rebind();
}
catch (Exception ex)
{
Label lblError = new Label();
lblError.Text = "Unable to update record-type. Reason: " + ex.Message;
lblError.ForeColor = System.Drawing.Color.Red;
rgRecordTypes.Controls.Add(lblError);
e.Canceled = true;
}
}
protected void rgFieldTrips_UpdateCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem item = e.Item as GridEditableItem;
int trip_id = Convert.ToInt32(item.GetDataKeyValue("trip_id"));
var currTrip = db.Trips.FirstOrDefault(p => p.trip_id == trip_id);
string trip_nm = (item.FindControl("rtbTripName") as RadTextBox).Text;
string assigned_to = (item.FindControl("rddlAssignedTo") as RadDropDownList).SelectedValue.ToString();
RadListBox assigned_sites = (item.FindControl("rlbSitesEnd") as RadListBox);
currTrip.trip_nm = trip_nm;
currTrip.user_id = assigned_to;
db.TripSites.DeleteAllOnSubmit(currTrip.TripSites);
db.SubmitChanges();
List <Data.TripSite> tripSites = new List <Data.TripSite>();
foreach (RadListBoxItem site in assigned_sites.Items)
{
tripSites.Add(new Data.TripSite()
{
trip_id = currTrip.trip_id, site_id = Convert.ToInt32(site.Value)
});
}
db.TripSites.InsertAllOnSubmit(tripSites);
db.SubmitChanges();
DisplayMessage(false, "The field trip's info was updated!");
}
protected void rgSANAL_UpdateCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem item = e.Item as GridEditableItem;
int period_id = Convert.ToInt32(item.GetDataKeyValue("period_id"));
var period = db.RecordAnalysisPeriods.FirstOrDefault(p => p.period_id == period_id);
period.analyzed_by = (item.FindControl("rddlAnalyzedBy") as RadDropDownList).SelectedValue.ToString();
period.analyzed_dt = (item.FindControl("rdpAnalyzedDt") as RadDatePicker).SelectedDate;
period.approved_by = (item.FindControl("rddlApprovedBy") as RadDropDownList).SelectedValue.ToString();
period.approved_dt = (item.FindControl("rdpApprovedDt") as RadDatePicker).SelectedDate;
period.analysis_notes_va = (item.FindControl("reSANAL") as RadEditor).Content.FormatParagraphIn();
Data.PeriodChangeLog changeLog = new Data.PeriodChangeLog()
{
period_id = period.period_id,
edited_by_uid = user.ID,
edited_dt = DateTime.Now,
new_va = (item.FindControl("reSANAL") as RadEditor).Text.FormatParagraphIn()
};
db.PeriodChangeLogs.InsertOnSubmit(changeLog);
Data.PeriodDialog dialog = new Data.PeriodDialog()
{
period_id = period.period_id,
dialog_dt = DateTime.Now,
dialog_by = user.ID,
origin_va = "Admin",
comments_va = "The analysis was modified using the Manage Analyses interface."
};
db.PeriodDialogs.InsertOnSubmit(dialog);
db.SubmitChanges();
}
protected void rbEditStatus_Command(object sender, CommandEventArgs e)
{
if (hfStatusEdited.Value == "no")
{
period = db.RecordAnalysisPeriods.FirstOrDefault(p => p.period_id == Convert.ToInt32(Request.QueryString["period_id"]));
List <Data.PeriodDialog> dialogs = new List <Data.PeriodDialog>();
switch (period.status_va)
{
case "Analyzed":
dialogs = period.PeriodDialogs.Where(p => p.status_set_to_va == "Analyzed").ToList();
period.status_va = "Analyzing";
period.status_set_by_role_va = "Analyst";
break;
case "Approved":
dialogs = period.PeriodDialogs.Where(p => p.origin_va == "Approver").ToList();
period.status_va = "Analyzed";
period.status_set_by_role_va = "Analyst";
break;
}
db.PeriodDialogs.DeleteAllOnSubmit(dialogs);
pnlSetBackStatus.Visible = false;
pnlDialogs.Visible = false;
pnlConfirm.Visible = true;
db.SubmitChanges();
site = period.Record.Site;
PopulateRecordPeriods("confirm");
hfStatusEdited.Value = "yes";
}
}
public void DeleteInfo(object sender, CommandEventArgs e)
{
if (hfStatus.Value == "go")
{
if (e.CommandArgument == "deletehospital")
{
db.SHAHospitals.DeleteAllOnSubmit(db.SHAHospitals.Where(p => p.hospital_id == Hospital.hospital_id));
db.Hospitals.DeleteOnSubmit(Hospital);
}
else if (e.CommandArgument == "deletecontact")
{
db.SHAContacts.DeleteAllOnSubmit(db.SHAContacts.Where(p => p.contact_id == Contact.contact_id));
db.Contacts.DeleteOnSubmit(Contact);
}
else if (e.CommandArgument == "deletehospitalforsite")
{
db.SHAHospitals.DeleteOnSubmit(db.SHAHospitals.Where(p => p.hospital_id == Hospital.hospital_id && p.sha_site_id == Convert.ToInt32(Request.QueryString["sha_site_id"])).FirstOrDefault());
}
else if (e.CommandArgument == "deletecontactforsite")
{
db.SHAContacts.DeleteOnSubmit(db.SHAContacts.Where(p => p.contact_id == Contact.contact_id && p.sha_site_id == Convert.ToInt32(Request.QueryString["sha_site_id"])).FirstOrDefault());
}
db.SubmitChanges();
hfStatus.Value = "done";
}
ClientScript.RegisterStartupScript(Page.GetType(), "mykey", "CloseAndRebind();", true);
}
/// <summary>
/// Increases the reqID field in the lut_WSC table by one
/// </summary>
public void IncreaseRequestID(string requestid)
{
int req_id = Convert.ToInt32(requestid) + 1;
var wsc = db.WSCs.FirstOrDefault(p => p.wsc_id == WSCID);
wsc.reqID = req_id;
db.SubmitChanges();
}
protected void ReviewClicked(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(tbReviewerComments.Text))
{
ltlError.Text = "<p style='font-weight:bold;color:red;'>You must enter a comment for the approver!</p>";
}
else
{
tcp.ApprovalReady = true;
tcp.NoChanges = cbNoChanges.Checked;
tcp.ReviewerComments = tbReviewerComments.Text;
tcp.ReviewedBy = user.ID;
tcp.ReviewedDt = DateTime.Now;
db.SubmitChanges();
ScriptManager.RegisterStartupScript(this, GetType(), "close", "CloseModal();", true);
}
}
protected void btnNWISWebSend_Command(object sender, CommandEventArgs e)
{
SiteID = Convert.ToInt32(e.CommandArgument);
var era = db.ElemReportApproves.FirstOrDefault(p => p.site_id == SiteID && p.report_type_cd == "MANU");
era.publish_complete = "N";
db.SubmitChanges();
rgAllSites.Rebind();
}
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();
}
public void ProcessRequest(HttpContext context)
{
string user_id = context.Request.QueryString["user_id"];
string rms_record_id = context.Request.QueryString["rms_record_id"];
string all = context.Request.QueryString["all"];
if (!string.IsNullOrEmpty(rms_record_id))
{
var currRecord = db.Records.FirstOrDefault(p => p.rms_record_id == Convert.ToInt32(rms_record_id));
if (currRecord != null)
{
//Clear the lock, but only the "lock" type, not the "save" type
if (currRecord.RecordLock.lock_type != "Analyzing" || currRecord.RecordLock.lock_type != "Approving")
{
db.RecordLocks.DeleteOnSubmit(currRecord.RecordLock);
db.SubmitChanges();
}
else if (all == "true")
{
db.RecordLocks.DeleteOnSubmit(currRecord.RecordLock);
db.SubmitChanges();
}
}
}
if (!string.IsNullOrEmpty(user_id))
{
if (all == "true") //Delete all locks, no matter what
{
db.RecordLocks.DeleteAllOnSubmit(db.RecordLocks.Where(p => p.lock_uid == user_id));
}
else //Delete only "locks", not "saves"
{
db.RecordLocks.DeleteAllOnSubmit(db.RecordLocks.Where(p => p.lock_uid == user_id && p.lock_type == "Analyze" || p.lock_uid == user_id && p.lock_type == "Approve" || p.lock_uid == user_id && p.lock_type == "Reanalyze"));
}
db.SubmitChanges();
}
}
protected void rgHospitals_InsertCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem item = e.Item as GridEditableItem;
Data.Hospital h = new Data.Hospital();
try
{
h.hospital_nm = (item.FindControl("tbHospitalNm") as TextBox).Text;
h.street_addrs = (item.FindControl("tbStreetAddrs1") as TextBox).Text;
h.city = (item.FindControl("tbCity1") as TextBox).Text;
h.state = (item.FindControl("tbState1") as TextBox).Text;
h.zip = (item.FindControl("tbZip1") as TextBox).Text;
h.ph_no = (item.FindControl("tbPhoneNo1") as TextBox).Text;
h.dec_lat_va = Convert.ToDouble((item.FindControl("tbLat") as TextBox).Text);
h.dec_long_va = Convert.ToDouble((item.FindControl("tbLong") as TextBox).Text);
h.wsc_id = WSCID;
}
catch (Exception ex)
{
DisplayHospitalMessage(true, "You must complete all form fields!");
e.Canceled = true;
return;
}
try
{
db.Hospitals.InsertOnSubmit(h);
db.SubmitChanges();
DisplayHospitalMessage(false, "The hospital was added!");
}
catch (Exception ex)
{
DisplayHospitalMessage(true, "Unable to add hospital. Reason: " + ex.Message);
e.Canceled = true;
}
}
protected void rgOffices_UpdateCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem item = e.Item as GridEditableItem;
Literal ltlError = (Literal)item.FindControl("ltlError");
if (Page.IsValid)
{
int office_id = Convert.ToInt32(item.GetDataKeyValue("office_id"));
var office = db.Offices.FirstOrDefault(p => p.office_id == office_id);
string office_nm = (item.FindControl("rtbOfficeName") as RadTextBox).Text;
string street_address = (item.FindControl("rtbStreetAddress") as RadTextBox).Text;
string citystatezip = (item.FindControl("rtbCityStateZip") as RadTextBox).Text;
double latitude = (double)(item.FindControl("rntbLat") as RadNumericTextBox).Value;
double longitude = (double)(item.FindControl("rntbLong") as RadNumericTextBox).Value;
string phone_no = (item.FindControl("rtbPhoneNo") as RadTextBox).Text;
string data_chief_email = (item.FindControl("rtbDataChiefEmail") as RadTextBox).Text;
string reviewer_email = (item.FindControl("rtbReviewerEmail") as RadTextBox).Text;
string timezone = (item.FindControl("rddlTimeZone") as RadDropDownList).SelectedValue.ToString();
string new_rec = (item.FindControl("rrblNewRecord") as RadRadioButtonList).SelectedValue.ToString();
office.office_nm = office_nm;
office.street_addrs = street_address;
office.city_st_zip = citystatezip;
office.dec_lat_va = latitude;
office.dec_long_va = longitude;
office.ph_no = phone_no;
office.data_chief_email = data_chief_email;
office.reviewer_email = reviewer_email;
office.tz_cd = timezone;
if (new_rec == "Yes")
{
office.start_new_rec = true;
}
else
{
office.start_new_rec = false;
}
db.SubmitChanges();
ShowNotice();
}
else
{
ltlError.Text = "<span style='color:red;font-weight:bold;'>You must populate the required fields (those marked with an *).</span>";
}
}
public void ProcessRequest(HttpContext context)
{
int site_id = Convert.ToInt32(context.Request.QueryString["site_id"]);
Data.SHA sha = new Data.SHA()
{
site_id = site_id,
reviewed_by = user.ID,
reviewed_dt = DateTime.Now
};
db.SHAs.InsertOnSubmit(sha);
db.SubmitChanges();
context.Response.Redirect(String.Format("{0}SHAView.aspx?site_id={1}", Config.SafetyURL, site_id));
}
public void DeleteInfo(object sender, CommandEventArgs e)
{
if (hfStatus.Value == "go")
{
if (e.CommandArgument == "deletetrip")
{
var trip = db.Trips.FirstOrDefault(p => p.trip_id == ID);
db.TripSites.DeleteAllOnSubmit(trip.TripSites);
db.Trips.DeleteOnSubmit(trip);
}
db.SubmitChanges();
hfStatus.Value = "done";
}
ClientScript.RegisterStartupScript(Page.GetType(), "mykey", "CloseAndRebind();", true);
}
protected void rgCableways_DeleteCommand(object sender, GridCommandEventArgs e)
{
GridDataItem item = e.Item as GridDataItem;
if (e.Item.OwnerTableView.Name == "Cableways")
{
//The ability to delete cableways was removed
//!---This section of code not in use!!---!
try
{
int cableway_id = Convert.ToInt32(item.GetDataKeyValue("cableway_id"));
var deleteCW = db.Cableways.FirstOrDefault(p => p.cableway_id == cableway_id);
db.CablewayVisits.DeleteAllOnSubmit(deleteCW.CablewayVisits);
db.Cableways.DeleteOnSubmit(deleteCW);
db.SubmitChanges();
DisplayMessage(false, "The cableway was deleted!");
}
catch (Exception ex)
{
DisplayMessage(true, "Unable to delete cableway. Reason: " + ex.Message);
e.Canceled = true;
}
//!---to here---!
}
else
{
try
{
int cableway_visit_id = Convert.ToInt32(item.GetDataKeyValue("cableway_visit_id"));
var deleteVisit = db.CablewayVisits.FirstOrDefault(p => p.cableway_visit_id == cableway_visit_id);
db.CablewayVisits.DeleteOnSubmit(deleteVisit);
DumpMyFile(deleteVisit.cableway_id.ToString(), deleteVisit.visit_file_nm);
db.SubmitChanges();
DisplayMessage(false, "The cableway visit was deleted!");
}
catch (Exception ex)
{
DisplayMessage(true, "Unable to delete cableway visit. Reason: " + ex.Message);
e.Canceled = true;
}
}
}
protected void EditRecord(object sender, EventArgs e)
{
string error = GetErrorText();
if (string.IsNullOrEmpty(error))
{
//If updating a current record
if (record != null)
{
//Update the time-series ID
if (hfEditIDs.Value == "true")
{
db.RecordDDs.DeleteAllOnSubmit(record.RecordDDs);
db.SubmitChanges();
foreach (ButtonListItem item in rcblIDs.Items)
{
if (item.Selected)
{
//Using the selected IDs gu_id value, find the full details for the ID in the TS_ID_CACHE, and create a new entry in the Record DD table
var ts_id = db.vTS_ID_CACHEs.FirstOrDefault(p => p.gu_id == item.Value);
Data.RecordDD id;
id = new Data.RecordDD()
{
rms_record_id = record.rms_record_id,
iv_ts_id = ts_id.iv_ts_id,
dd_nu = ts_id.adaps_dd_nu,
gu_id = ts_id.gu_id
};
db.RecordDDs.InsertOnSubmit(id);
db.SubmitChanges();
}
}
}
//Update the record-type
record.record_type_id = Convert.ToInt32(rddlRecordTypes.SelectedValue);
//Update the category number
record.category_no = Convert.ToInt32(rddlCatNumber.SelectedValue);
record.cat_reason = rtbCatReason.Text;
//Update the operator, analyzer and approver
record.operator_uid = rddlOperator.SelectedValue;
record.analyzer_uid = rddlAnalyzer.SelectedValue;
record.approver_uid = rddlApprover.SelectedValue;
record.auditor_uid = rddlAuditor.SelectedValue;
//Update the responsible office
if (record.RecordAltOffice != null)
{
//First delete the alt office that might be there
db.RecordAltOffices.DeleteOnSubmit(record.RecordAltOffice);
db.SubmitChanges();
}
//If an alt office was selected other than the site assigned office, add it to the alt office table
if (rddlResponsibleOffice.SelectedValue != record.Site.office_id.ToString())
{
db.RecordAltOffices.InsertOnSubmit(new Data.RecordAltOffice()
{
rms_record_id = record.rms_record_id,
site_id = record.site_id,
alt_office_id = Convert.ToInt32(rddlResponsibleOffice.SelectedValue)
});
db.SubmitChanges();
}
//Update the threatened gage
var tg_newest = record.EndangeredGages.OrderByDescending(p => p.entered_dt).FirstOrDefault();
if ((bool)rcbThreatenedGage.Checked)
{
if (tg_newest != null)
{
//If there was a change to any of the threatened gage field values, then need to create a new record for it in the database table
if (tg_newest.remarks != tbRemarks.Text || tg_newest.years_of_record != rntbYearsOfRecord.Value || tg_newest.status != rcbStatus.SelectedValue.ToString() || tg_newest.sunset_dt != rdpSunsetDt.SelectedDate)
{
var tg_new = new Data.EndangeredGage();
tg_new.rms_record_id = record.rms_record_id;
tg_new.remarks = tbRemarks.Text;
tg_new.years_of_record = Convert.ToInt32(rntbYearsOfRecord.Value);
tg_new.status = rcbStatus.SelectedValue.ToString();
tg_new.sunset_dt = rdpSunsetDt.SelectedDate;
tg_new.entered_by = user.ID;
tg_new.entered_dt = DateTime.Now;
db.EndangeredGages.InsertOnSubmit(tg_new);
}
//Otherwise, do nothing
}
else //Adding to the threatened gage table for the first time
{
var tg_new = new Data.EndangeredGage();
tg_new.rms_record_id = record.rms_record_id;
tg_new.remarks = tbRemarks.Text;
tg_new.years_of_record = Convert.ToInt32(rntbYearsOfRecord.Value);
tg_new.status = rcbStatus.SelectedValue.ToString();
tg_new.sunset_dt = rdpSunsetDt.SelectedDate;
tg_new.entered_by = user.ID;
tg_new.entered_dt = DateTime.Now;
db.EndangeredGages.InsertOnSubmit(tg_new);
}
}
else //The checkbox was not checked
{
//But, there is history of threatened gage data for this record, what happens now?? - NEED SONYA OR BRIAN HELP!
if (tg_newest != null)
{
}
}
//Checkbox
record.not_used_fg = rcbRecordInactive.Checked;
if ((bool)record.not_used_fg) //If setting the record to inactive, make sure to delete any TS IDs tied to the record
{
var tsIDs = record.RecordDDs.ToList();
db.RecordDDs.DeleteAllOnSubmit(tsIDs);
}
db.SubmitChanges();
}
else //Create a new record
{
Data.Record new_record = new Data.Record();
new_record.site_id = site.site_id;
new_record.operator_uid = rddlOperator.SelectedValue;
new_record.analyzer_uid = rddlAnalyzer.SelectedValue;
new_record.approver_uid = rddlApprover.SelectedValue;
new_record.auditor_uid = rddlAuditor.SelectedValue;
new_record.not_used_fg = rcbRecordInactive.Checked;
new_record.record_type_id = Convert.ToInt32(rddlRecordTypes.SelectedValue);
new_record.category_no = Convert.ToInt32(rddlCatNumber.SelectedValue);
new_record.cat_reason = rtbCatReason.Text;
db.Records.InsertOnSubmit(new_record);
db.SubmitChanges();
//Add the time-series ID
if (hfEditIDs.Value == "true")
{
foreach (ButtonListItem item in rcblIDs.Items)
{
if (item.Selected)
{
//Using the selected IDs gu_id value, find the full details for the ID in the TS_ID_CACHE, and create a new entry in the Record DD table
var ts_id = db.vTS_ID_CACHEs.FirstOrDefault(p => p.gu_id == item.Value);
Data.RecordDD id;
id = new Data.RecordDD()
{
rms_record_id = new_record.rms_record_id,
iv_ts_id = ts_id.iv_ts_id,
dd_nu = ts_id.adaps_dd_nu,
gu_id = ts_id.gu_id
};
db.RecordDDs.InsertOnSubmit(id);
db.SubmitChanges();
}
}
}
//If an alt office was selected other than the site assigned office, add it to the alt office table
if (rddlResponsibleOffice.SelectedValue != site.office_id.ToString())
{
db.RecordAltOffices.InsertOnSubmit(new Data.RecordAltOffice()
{
rms_record_id = new_record.rms_record_id,
site_id = site.site_id,
alt_office_id = Convert.ToInt32(rddlResponsibleOffice.SelectedValue)
});
db.SubmitChanges();
}
//Insert the threatened gage
if ((bool)rcbThreatenedGage.Checked)
{
var tg_new = new Data.EndangeredGage();
tg_new.rms_record_id = new_record.rms_record_id;
tg_new.remarks = tbRemarks.Text;
tg_new.years_of_record = Convert.ToInt32(rntbYearsOfRecord.Value);
tg_new.status = rcbStatus.SelectedValue.ToString();
tg_new.sunset_dt = rdpSunsetDt.SelectedDate;
tg_new.entered_by = user.ID;
tg_new.entered_dt = DateTime.Now;
db.EndangeredGages.InsertOnSubmit(tg_new);
}
}
ScriptManager.RegisterStartupScript(this, GetType(), "close", "CloseModal();", true);
}
else
{
ltlError.Visible = true;
ltlError.Text = error;
}
}
protected void btnSubmitElemInfo_Command(object sender, CommandEventArgs e)
{
if (e.CommandArgument.ToString() == "editelement" & !string.IsNullOrEmpty(hfToggleElementEditMode.Value))
{
try {
//First confirm that there is element information to back up
if (!string.IsNullOrEmpty(currSiteElem.element_info))
{
//If element_info is not blank, then back up before updating
Data.SiteElementBackup backup = new Data.SiteElementBackup()
{
site_id = Convert.ToInt32(currSiteElem.site_id),
element_id = currSiteElem.element_id,
element_info = currSiteElem.element_info,
entered_by = currSiteElem.entered_by,
entered_dt = currSiteElem.entered_dt,
revised_by = currSiteElem.revised_by,
revised_dt = currSiteElem.revised_dt,
backup_by = user.ID,
backup_dt = DateTime.Now
};
db.SiteElementBackups.InsertOnSubmit(backup);
}
//Update the element info
currSiteElem.element_info = reElemInfo.Content.FormatParagraphIn();
currSiteElem.revised_by = user.ID;
currSiteElem.revised_dt = DateTime.Now;
//Run the stored procedure that updates the max revised date in Elem_Report_Sum
db.SP_Report_Update_Site_LastEdited(SiteID);
db.SubmitChanges();
DisplayMessage(false, "The element information was updated!", "element");
ltlElemRevisedInfo.Text = "Revised by: " + user.ID + " Date revised: " + System.DateTime.Now.ToString();
ltlElemInfo.Text = reElemInfo.Content.FormatParagraphOut();
}
catch (Exception ex)
{
DisplayMessage(true, ex.Message, "element");
}
}
hfToggleElementEditMode.Value = "";
lbToggleElementEditMode.Text = "enter element edit mode";
pnlEditElemInfo.Visible = false;
pnlStaticElemInfo.Visible = true;
}
protected void CreateEditAudit(object sender, CommandEventArgs e)
{
int audit_type_id, audit_results_id;
if (!string.IsNullOrEmpty(rddlAuditType.SelectedValue))
{
audit_type_id = Convert.ToInt32(rddlAuditType.SelectedValue);
}
else
{
audit_type_id = 0;
}
if (!string.IsNullOrEmpty(rddlAuditResults.SelectedValue))
{
audit_results_id = Convert.ToInt32(rddlAuditResults.SelectedValue);
}
else
{
audit_results_id = 0;
}
string audit_reason = rtbAuditReason.Text;
string audit_data = rtbDataAudited.Text;
string audit_findings = rtbAuditFindings.Text;
if (audit_type_id == 0 || audit_results_id == 0 || string.IsNullOrEmpty(audit_reason) || string.IsNullOrEmpty(audit_data) || string.IsNullOrEmpty(audit_findings))
{
pnlError.Visible = true;
ltlError.Text = "You must complete all form fields under the 'Audit the Period' section!";
}
else
{
DateTime?beg_dt, end_dt;
if (rdpBeginDt1.SelectedDate != null && hfAuditType.Value == "single")
{
beg_dt = rdpBeginDt1.SelectedDate;
end_dt = rdpEndDt1.SelectedDate;
}
else if (rdpBeginDt2.SelectedDate != null)
{
beg_dt = rdpBeginDt2.SelectedDate;
end_dt = rdpEndDt2.SelectedDate;
}
else
{
beg_dt = PeriodDate("begin");
end_dt = PeriodDate("end");
}
if (e.CommandArgument.ToString() == "Add")
{
Data.Audit new_audit = new Data.Audit()
{
audit_beg_dt = beg_dt,
audit_end_dt = end_dt,
audit_by = user.ID,
audit_dt = DateTime.Now,
audit_type_id = audit_type_id,
audit_results_id = audit_results_id,
audit_reason = audit_reason,
audit_data = audit_data,
audit_findings = audit_findings,
wsc_id = Convert.ToInt32(WSCID)
};
db.Audits.InsertOnSubmit(new_audit);
db.SubmitChanges();
foreach (RadListBoxItem item in rlbViewRecords.Items)
{
Data.AuditRecord new_audit_rec = new Data.AuditRecord()
{
rms_audit_id = new_audit.rms_audit_id,
rms_record_id = Convert.ToInt32(item.Value)
};
db.AuditRecords.InsertOnSubmit(new_audit_rec);
db.SubmitChanges();
}
rbSubmit.CommandArgument = new_audit.rms_audit_id.ToString();
//Send out emails to analysts and approvers
SendEmail("new", new_audit.rms_audit_id);
//Setup the rest of the page
pnlError.Visible = false;
pnlNotice.Visible = false;
pnlAuditPeriod.Visible = false;
ltlConfirm.Text = "Audit Period Created!";
ltlDone.Text = "To return and create a new audit period, click the 'Done' button at the bottom of the page.";
rbDone.CommandArgument = "stay";
pnlUploadDocs.Visible = true;
rlvAuditDocs.Visible = false;
ltlAlert.Text = "";
}
else
{
currAudit.audit_beg_dt = beg_dt;
currAudit.audit_end_dt = end_dt;
currAudit.audit_dt = DateTime.Now;
currAudit.audit_type_id = audit_type_id;
currAudit.audit_results_id = audit_results_id;
currAudit.audit_reason = audit_reason;
currAudit.audit_data = audit_data;
currAudit.audit_findings = audit_findings;
currAudit.wsc_id = Convert.ToInt32(WSCID);
db.AuditRecords.DeleteAllOnSubmit(currAudit.AuditRecords);
db.SubmitChanges();
foreach (RadListBoxItem item in rlbViewRecords.Items)
{
Data.AuditRecord new_audit_rec = new Data.AuditRecord()
{
rms_audit_id = currAudit.rms_audit_id,
rms_record_id = Convert.ToInt32(item.Value)
};
db.AuditRecords.InsertOnSubmit(new_audit_rec);
db.SubmitChanges();
}
rbSubmit.CommandArgument = currAudit.rms_audit_id.ToString();
//Send out emails to analysts and approvers
SendEmail("edit", currAudit.rms_audit_id);
//Setup the rest of the page
pnlError.Visible = false;
pnlNotice.Visible = false;
pnlAuditPeriod.Visible = false;
ltlConfirm.Text = "Audit Period Updated!";
ltlDone.Text = "When finished uploading documents, clicking the 'Done' button below will return you to the Audit Report.";
rbDone.CommandArgument = "leave";
pnlUploadDocs.Visible = true;
//Create the list of uploaded documents
rlvAuditDocs.Visible = true;
rlvAuditDocs.DataSource = currAudit.AuditDocuments.Select(p => new { rms_audit_document_id = p.rms_audit_document_id, document_nm = p.document_nm }).OrderBy(p => p.document_nm);
rlvAuditDocs.DataBind();
ltlAlert.Text = "";
}
}
}
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();
}
}
protected void ReviewSHA()
{
currSHA.reviewed_by = user.ID;
currSHA.reviewed_dt = DateTime.Now;
db.SubmitChanges();
SetupAdminPanel();
}
protected void rbEditDates_Command(object sender, CommandEventArgs e)
{
if (hfDatesEdited.Value == "no")
{
DateTime dtNewDate = default(DateTime);
if (date_type == "end1" | date_type == "beg2")
{
dtNewDate = DateTime.FromOADate(Convert.ToDouble(rsEndBeginDates.Value));
if (string.IsNullOrEmpty(ltlPeriodID1.Text))
{
period = db.RecordAnalysisPeriods.FirstOrDefault(p => p.period_id == Convert.ToInt32(ltlPeriodID2.Text));
period.period_beg_dt = dtNewDate;
Data.PeriodDialog dialog = new Data.PeriodDialog()
{
period_id = Convert.ToInt32(ltlPeriodID2.Text),
dialog_dt = DateTime.Now,
dialog_by = "admin",
origin_va = "Admin",
comments_va = "Period date modified using Modify Record Period Dates interface."
};
db.PeriodDialogs.InsertOnSubmit(dialog);
site = period.Record.Site;
}
else
{
var period1 = db.RecordAnalysisPeriods.FirstOrDefault(p => p.period_id == Convert.ToInt32(ltlPeriodID1.Text));
var period2 = db.RecordAnalysisPeriods.FirstOrDefault(p => p.period_id == Convert.ToInt32(ltlPeriodID2.Text));
period1.period_end_dt = dtNewDate;
period2.period_beg_dt = dtNewDate;
Data.PeriodDialog dialog1 = new Data.PeriodDialog()
{
period_id = Convert.ToInt32(ltlPeriodID1.Text),
dialog_dt = DateTime.Now,
dialog_by = "admin",
origin_va = "Admin",
comments_va = "Period date modified using Modify Record Period Dates interface."
};
db.PeriodDialogs.InsertOnSubmit(dialog1);
Data.PeriodDialog dialog2 = new Data.PeriodDialog()
{
period_id = Convert.ToInt32(ltlPeriodID2.Text),
dialog_dt = DateTime.Now,
dialog_by = "admin",
origin_va = "Admin",
comments_va = "Period date modified using Modify Record Period Dates interface."
};
db.PeriodDialogs.InsertOnSubmit(dialog2);
site = period1.Record.Site;
}
}
else
{
dtNewDate = DateTime.FromOADate(Convert.ToDouble(rsEndDate.Value));
period = db.RecordAnalysisPeriods.FirstOrDefault(p => p.period_id == Convert.ToInt32(ltlPeriodID2.Text));
period.period_end_dt = dtNewDate;
Data.PeriodDialog dialog = new Data.PeriodDialog()
{
period_id = Convert.ToInt32(ltlPeriodID2.Text),
dialog_dt = DateTime.Now,
dialog_by = "admin",
origin_va = "Admin",
comments_va = "Period date modified using Modify Record Period Dates interface."
};
db.PeriodDialogs.InsertOnSubmit(dialog);
site = period.Record.Site;
}
db.SubmitChanges();
pnlEditDate.Visible = false;
pnlConfirm.Visible = true;
PopulateRecordPeriods("confirm", "");
hfDatesEdited.Value = "yes";
}
}
