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 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"; }
/// <summary> /// Run the stored procedure for updating the max revised date of Elem_Report_Sum /// </summary> protected void UpdateMaxRevisedDate() { db.SP_Report_Update_Site_LastEdited(currSite.site_id); }