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"; } }