private int versionForm(oCollectionForm colForm, string form_questions_from_gui, string isPublished, int id)
{
int cft_id = 0;
colForm.previous_vers_cft_id=id;//represents previous version cft_id
ViewBag.exception = "";
using (var transaction = db.Database.BeginTransaction())
{
try
{
//first we need to save OBS_COLLECT_FORM_TMPLT table data
OBS_COLLECT_FORM_TMPLT template_to_save = new OBS_COLLECT_FORM_TMPLT();
OBS_COLLECT_FORM_TMPLT prev_form = db.OBS_COLLECT_FORM_TMPLT.Find(colForm.previous_vers_cft_id);
template_to_save.dsc_cust_id = prev_form.dsc_cust_id;
template_to_save.obs_type_id = prev_form.obs_type_id;
template_to_save.dsc_lc_id = prev_form.dsc_lc_id;
template_to_save.obs_cft_nbr = (short)colForm.cft_Nbr;
template_to_save.obs_cft_ver = (short)colForm.cft_Version;
template_to_save.obs_cft_title = prev_form.obs_cft_title;
template_to_save.obs_cft_subtitle = colForm.cft_SubTitle;
template_to_save.obs_cft_eff_end_dt = (colForm.cft_eff_end_dt == null) || (colForm.cft_eff_end_dt < Convert.ToDateTime("01/01/2000")) ? Convert.ToDateTime("12/31/2060") : colForm.cft_eff_end_dt;
template_to_save.obs_cft_added_dtm = DateTime.Now;
template_to_save.obs_cft_added_uid = User.Identity.Name;
template_to_save.obs_cft_last_saved_dtm = DateTime.Now;
template_to_save.obs_cft_upd_dtm = DateTime.Now;
template_to_save.obs_cft_upd_uid = User.Identity.Name;
if (isPublished == "true")
{
//if (colForm.cft_eff_st_dt != null && (colForm.cft_eff_st_dt < Convert.ToDateTime("01/01/2000")))
if (colForm.cft_eff_st_dt != null)
{
template_to_save.obs_cft_eff_st_dt = colForm.cft_eff_st_dt;
if(prev_form.obs_cft_eff_end_dt > colForm.cft_eff_st_dt)
{
if (prev_form.obs_cft_eff_st_dt == (DateTime)colForm.cft_eff_st_dt)
{
prev_form.obs_cft_eff_end_dt = (DateTime)colForm.cft_eff_st_dt;
}
else
{
prev_form.obs_cft_eff_end_dt = ((DateTime)colForm.cft_eff_st_dt).AddSeconds(-1);
}
}
}
else
{
Session.Add("errorMessage", "ERROR:Can't publish this form. Effective start date is required");
return -1;
}
template_to_save.obs_cft_pub_by_uid = User.Identity.Name;
template_to_save.obs_cft_pub_dtm = DateTime.Now;
}
else if (!(colForm.cft_eff_st_dt == null || (colForm.cft_eff_st_dt < Convert.ToDateTime("01/01/2000"))))
{
template_to_save.obs_cft_eff_st_dt = colForm.cft_eff_st_dt;
}
db.OBS_COLLECT_FORM_TMPLT.Add(template_to_save);
db.SaveChanges();
cft_id = template_to_save.obs_cft_id;
//now we need to save all the form questions
string[] splitterm = { "," };
string[] parsed_questions = form_questions_from_gui.Split(splitterm, StringSplitOptions.RemoveEmptyEntries);
short order_counter = 1;
foreach (string question in parsed_questions)
{
//now lets first save split the string we received from the gui
// string format should be: order,qat_id,section_text
string[] question_items = question.Split(new string[] { "~" }, StringSplitOptions.RemoveEmptyEntries);
short order = order_counter;
int qat_id = Convert.ToInt32(question_items[0]);
int form_section_id = getSectionID(question_items[1]);
OBS_COL_FORM_QUESTIONS new_form_question = new OBS_COL_FORM_QUESTIONS();
new_form_question.obs_cft_id = cft_id;
new_form_question.obs_form_section_id = form_section_id;
new_form_question.obs_qat_id = qat_id;
new_form_question.obs_col_form_quest_order = order;
new_form_question.obs_col_form_quest_wgt = 1;
new_form_question.obs_col_form_quest_na_yn = question_items[2];
db.OBS_COL_FORM_QUESTIONS.Add(new_form_question);
db.SaveChanges();
order_counter++;
}//end of foreach
transaction.Commit();
return cft_id;
}//end of try
catch (Exception e)
{
Session.Add("errorMessage", e.Message);
transaction.Rollback();
return -1;
}
}//end of using (var transaction = db.Database.BeginTransaction())
}
private int saveForm(oCollectionForm colForm, string form_questions_from_gui, string isPublished, int id)
{
int cft_id = id;
if (cft_id <= 0 && db.OBS_COLLECT_FORM_TMPLT.Where(item => item.obs_cft_title == colForm.cft_Title).Count() > 0)
{//we need to check if title passed from user is unique. if it already exists, we need to return the error message back to the screen
Session.Add("errorMessage", "ERROR: The Question Id is either invalid or the Form Title Already Exist.");
return -1;
}
using (var transaction = db.Database.BeginTransaction())
{
try
{
if (cft_id > 0)//this means we are editing an existing form
{
OBS_COLLECT_FORM_TMPLT template_to_edit = db.OBS_COLLECT_FORM_TMPLT.Find(cft_id);
if (colForm.cft_Version == 1)
{
template_to_edit.dsc_cust_id = Convert.ToInt32(colForm.cft_Cust);
template_to_edit.obs_type_id = Convert.ToInt32(colForm.cft_obsType);
template_to_edit.dsc_lc_id = Convert.ToInt32(colForm.cft_LC);
template_to_edit.obs_cft_title = colForm.cft_Title;
}
template_to_edit.obs_cft_eff_end_dt = (colForm.cft_eff_end_dt == null) || (colForm.cft_eff_end_dt < Convert.ToDateTime("01/01/2000")) ? Convert.ToDateTime("12/31/2060") : colForm.cft_eff_end_dt;
template_to_edit.obs_cft_last_saved_dtm = DateTime.Now;
template_to_edit.obs_cft_upd_dtm = DateTime.Now;
template_to_edit.obs_cft_upd_uid = User.Identity.Name;
template_to_edit.obs_cft_subtitle = colForm.cft_SubTitle;
if (isPublished == "true")
{
//if (colForm.cft_eff_st_dt != null && (colForm.cft_eff_st_dt < Convert.ToDateTime("01/01/2000")))
if (colForm.cft_eff_st_dt != null)
{
template_to_edit.obs_cft_eff_st_dt = colForm.cft_eff_st_dt;
if (colForm.previous_vers_cft_id > 0)
{
OBS_COLLECT_FORM_TMPLT prev_form = db.OBS_COLLECT_FORM_TMPLT.Find(colForm.previous_vers_cft_id);
if (prev_form.obs_cft_eff_end_dt > colForm.cft_eff_st_dt)
{
if (prev_form.obs_cft_eff_st_dt == (DateTime)colForm.cft_eff_st_dt)
{
prev_form.obs_cft_eff_end_dt = (DateTime)colForm.cft_eff_st_dt;
}
else
{
prev_form.obs_cft_eff_end_dt = ((DateTime)colForm.cft_eff_st_dt).AddSeconds(-1);
}
}
}// end ofif (colForm.previous_vers_cft_id > 0)
}
else
{
Session.Add("errorMessage", "ERROR:Can't publish this form. Effective start date is required");
return -1;
}
template_to_edit.obs_cft_pub_by_uid = User.Identity.Name;
template_to_edit.obs_cft_pub_dtm = DateTime.Now;
}
else if (!(colForm.cft_eff_st_dt == null || (colForm.cft_eff_st_dt < Convert.ToDateTime("01/01/2000"))))
{
template_to_edit.obs_cft_eff_st_dt = colForm.cft_eff_st_dt;
}
else
{
template_to_edit.obs_cft_eff_st_dt = null;
}
List<OBS_COL_FORM_QUESTIONS> old_form_questions = db.OBS_COL_FORM_QUESTIONS.Where(x => x.obs_cft_id == cft_id).ToList();
db.OBS_COL_FORM_QUESTIONS.RemoveRange(old_form_questions);
//foreach (OBS_COL_FORM_QUESTIONS old_form_question in old_form_questions)
//{
// db.OBS_COL_FORM_QUESTIONS.Remove(old_form_question)
//}
db.SaveChanges();
}
else//this means we're saving new form
{
//first we need to save OBS_COLLECT_FORM_TMPLT table data
OBS_COLLECT_FORM_TMPLT template_to_save = new OBS_COLLECT_FORM_TMPLT();
template_to_save.dsc_cust_id = Convert.ToInt32(colForm.cft_Cust);
template_to_save.obs_type_id = Convert.ToInt32(colForm.cft_obsType);
template_to_save.dsc_lc_id = Convert.ToInt32(colForm.cft_LC);
short cft_number = 1;
if (db.OBS_COLLECT_FORM_TMPLT.Count() > 0)
{ // Verify that at least one form exists in the database
cft_number = (short)(db.OBS_COLLECT_FORM_TMPLT.Max(x => x.obs_cft_nbr) + 1);
}
template_to_save.obs_cft_nbr = cft_number;
template_to_save.obs_cft_ver = 1;
template_to_save.obs_cft_title = colForm.cft_Title;
template_to_save.obs_cft_subtitle = colForm.cft_SubTitle;
template_to_save.obs_cft_eff_end_dt = (colForm.cft_eff_end_dt == null) || (colForm.cft_eff_end_dt < Convert.ToDateTime("01/01/2000")) ? Convert.ToDateTime("12/31/2060") : colForm.cft_eff_end_dt;
template_to_save.obs_cft_added_dtm = DateTime.Now;
template_to_save.obs_cft_added_uid = User.Identity.Name;
template_to_save.obs_cft_last_saved_dtm = DateTime.Now;
template_to_save.obs_cft_upd_dtm = DateTime.Now;
template_to_save.obs_cft_upd_uid = User.Identity.Name;
if (isPublished == "true")
{
if (colForm.cft_eff_st_dt != null && (colForm.cft_eff_st_dt > Convert.ToDateTime("01/01/2000")))
{
template_to_save.obs_cft_eff_st_dt = colForm.cft_eff_st_dt;
}
else
{
Session.Add("errorMessage", "ERROR:Can't publish this form. Effective start date is required");
return -1;
}
template_to_save.obs_cft_pub_by_uid = User.Identity.Name;
template_to_save.obs_cft_pub_dtm = DateTime.Now;
}
else if (!(colForm.cft_eff_st_dt == null || (colForm.cft_eff_st_dt < Convert.ToDateTime("01/01/2000"))))
{
template_to_save.obs_cft_eff_st_dt = colForm.cft_eff_st_dt;
}
db.OBS_COLLECT_FORM_TMPLT.Add(template_to_save);
db.SaveChanges();
cft_id = template_to_save.obs_cft_id;
//now we need to query OBS_COLLECT_FORM_TMPLT table to find CFT ID we just created
//int cft_id = db.OBS_COLLECT_FORM_TMPLT.Single(item => item.obs_cft_nbr == cft_number && item.obs_cft_ver == 1).obs_cft_id;
}//end of else(saving new form header form)
//now we need to save all the form questions
string[] splitterm = { "," };
string[] parsed_questions = form_questions_from_gui.Split(splitterm, StringSplitOptions.RemoveEmptyEntries);
short order_counter = 1;
foreach (string question in parsed_questions)
{
//now lets first save split the string we received from the gui
// string format should be: order,qat_id,section_text
string[] question_items = question.Split(new string[] { "~" }, StringSplitOptions.RemoveEmptyEntries);
short order = order_counter;
int qat_id = Convert.ToInt32(question_items[0]);
int form_section_id = getSectionID(question_items[1]);
OBS_COL_FORM_QUESTIONS new_form_question = new OBS_COL_FORM_QUESTIONS();
new_form_question.obs_cft_id = cft_id;
new_form_question.obs_form_section_id = form_section_id;
new_form_question.obs_qat_id = qat_id;
new_form_question.obs_col_form_quest_order = order;
new_form_question.obs_col_form_quest_wgt = 1;
new_form_question.obs_col_form_quest_na_yn = question_items[2];
db.OBS_COL_FORM_QUESTIONS.Add(new_form_question);
db.SaveChanges();
order_counter++;
}//end of foreach
transaction.Commit();
return cft_id;
}//end of try
catch (Exception e)
{
Session.Add("errorMessage", e.Message);
transaction.Rollback();
return -1;
}
}//end of using (var transaction = db.Database.BeginTransaction())
}
