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