/// <summary>
/// Add a record to the Elem_Site_Element_Backup table
/// </summary>
protected void BackupElement()
{
var oldElem = currSite.SiteElements.FirstOrDefault(p => p.element_id == element_id);
Data.SiteElementBackup backup = new Data.SiteElementBackup();
backup.site_id = currSite.site_id;
backup.element_id = element_id;
if (element_id == 28 || element_id == 17)
{
backup.element_info = oldElem.element_info.FormatElementInfo(element_id, currSite.site_id);
}
else
{
backup.element_info = oldElem.element_info;
}
backup.revised_by = oldElem.revised_by;
backup.revised_dt = oldElem.revised_dt;
backup.entered_by = oldElem.entered_by;
backup.entered_dt = oldElem.entered_dt;
backup.backup_by = user.ID;
backup.backup_dt = DateTime.Now;
db.SiteElementBackups.InsertOnSubmit(backup);
db.SubmitChanges();
}
protected void btnSubmitElemInfo_Command(object sender, CommandEventArgs e)
{
if (e.CommandArgument == "editelement" & !string.IsNullOrEmpty(hfToggleElementEditMode.Value))
{
var elem_temp = db.SiteElements.FirstOrDefault(p => p.element_id == Config.SiteHazardElem && p.site_id == SiteID);
try
{
//First confirm that there is element information to back up
if (!string.IsNullOrEmpty(elem_temp.element_info))
{
//If element_info is not blank, then back up before updating
Data.SiteElementBackup backup = new Data.SiteElementBackup()
{
site_id = Convert.ToInt32(elem_temp.site_id),
element_id = elem_temp.element_id,
element_info = elem_temp.element_info,
entered_by = elem_temp.entered_by,
entered_dt = elem_temp.entered_dt,
revised_by = elem_temp.revised_by,
revised_dt = elem_temp.revised_dt,
backup_by = user.ID,
backup_dt = DateTime.Now
};
db.SiteElementBackups.InsertOnSubmit(backup);
}
//Update the element info
elem_temp.element_info = reElemInfo.Content;
elem_temp.revised_by = user.ID;
elem_temp.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;
ReviewSHA();
}
catch (Exception ex)
{
DisplayMessage(true, ex.Message, "element");
}
}
hfToggleElementEditMode.Value = "";
lbToggleElementEditMode.Text = "enter element edit mode";
pnlEditElemInfo.Visible = false;
pnlStaticElemInfo.Visible = true;
}
