//- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
public static bool DeactivateCust(int dsc_cust_id)
{
using (DSC_OBS_DB_ENTITY db = new DSC_OBS_DB_ENTITY())
{
var customer = db.DSC_CUSTOMER.Single(cust_id => cust_id.dsc_cust_id == dsc_cust_id);
customer.dsc_cust_eff_end_date = DateTime.Today;
db.SaveChanges();
}
return true;
}
public ActionResult List(int dsc_cust_id)
{
try
{
using (DSC_OBS_DB_ENTITY db = new DSC_OBS_DB_ENTITY())
{
var customer = db.DSC_CUSTOMER.Single(cust_id => cust_id.dsc_cust_id == dsc_cust_id);
customer.dsc_cust_eff_end_date = null;
db.SaveChanges();
return View(List());
}
}
catch { return View(List()); }
}
public void save(OBS_QUEST_ANS_TYPES oBS_QUEST_ANS_TYPES_U)
{
using (DSC_OBS_DB_ENTITY db1 = new DSC_OBS_DB_ENTITY())
{
db1.OBS_QUEST_ANS_TYPES.Add(oBS_QUEST_ANS_TYPES_U);
db1.SaveChanges();
}
}
public ActionResult Edit([Bind(Include = "dsc_emp_id,dsc_assigned_lc_id,dsc_emp_perm_id,dsc_emp_wms_clock_nbr,dsc_emp_first_name,dsc_emp_last_name,dsc_emp_email_addr,dsc_emp_title,dsc_emp_adp_id,dsc_emp_hire_dt,dsc_emp_init_work_dt,dsc_emp_term_dt,dsc_emp_can_be_obs_yn,dsc_emp_temp_yn,dsc_emp_hourly_yn,dsc_emp_added_id,dsc_emp_added_dtm,dsc_emp_upd_uid,dsc_emp_upd_dtm")] DSC_EMPLOYEE formEmployee)
{
using (DSC_OBS_DB_ENTITY db = new DSC_OBS_DB_ENTITY())
{
//var employee = db.EMPLOYEEs.Single(x => x.dsc_emp_id == formEmployee.dsc_emp_id);
DSC_EMPLOYEE employee = formEmployee;
//if (!ModelState.IsValid) {
// return View(formEmployee);
//}
try {
employee = db.DSC_EMPLOYEE.Find(formEmployee.dsc_emp_id);
employee.dsc_emp_title = formEmployee.dsc_emp_title;
employee.dsc_emp_perm_id = formEmployee.dsc_emp_perm_id;
employee.dsc_assigned_lc_id = formEmployee.dsc_assigned_lc_id;
employee.dsc_emp_can_be_obs_yn = formEmployee.dsc_emp_can_be_obs_yn == "on" ? "Y" : "N";
employee.dsc_emp_hourly_yn = formEmployee.dsc_emp_hourly_yn == "on" ? "Y" : "N";
employee.dsc_emp_temp_yn = formEmployee.dsc_emp_temp_yn == "on" ? "Y" : "N";
//employee.dsc_emp_hire_dt = formEmployee.dsc_emp_hire_dt;
employee.dsc_emp_term_dt = formEmployee.dsc_emp_term_dt;
employee.dsc_emp_email_addr = formEmployee.dsc_emp_email_addr;
employee.dsc_emp_upd_dtm = DateTime.Now;
employee.dsc_emp_upd_uid = User.Identity.Name;
formEmployee = employee;
db.SaveChanges();
ViewBag.dsc_assigned_lc_id = new SelectList(db.DSC_LC.Where(x => x.dsc_lc_id > 0 && x.dsc_lc_eff_end_date.Equals(null)).ToList(), "dsc_lc_id", "dsc_lc_name", formEmployee.dsc_assigned_lc_id);
ViewBag.ConfMsg = "Employee Information Saved Successfully.";
}
catch(Exception ex){
ViewBag.ConfMsg = "ERROR: " + ex.Message;
}
return View(employee);
}
//==========================================================
//EMPLOYEE employeeFromFB = new EMPLOYEE();
//employeeFromFB = db.EMPLOYEEs.Find(formEmployee.dsc_emp_id);
//employeeFromFB.dsc_emp_perm_id = formEmployee.dsc_emp_perm_id;
//employeeFromFB.dsc_emp_title = formEmployee.dsc_emp_title;
//employeeFromFB.dsc_assigned_lc_id = formEmployee.dsc_assigned_lc_id;
//employeeFromFB.dsc_emp_hire_dt = formEmployee.dsc_emp_hire_dt;
//employeeFromFB.dsc_emp_term_dt = formEmployee.dsc_emp_term_dt;
//employeeFromFB.dsc_emp_can_be_obs_yn = formEmployee.dsc_emp_can_be_obs_yn;
//employeeFromFB.dsc_emp_hourly_yn = formEmployee.dsc_emp_hourly_yn;
//employeeFromFB.dsc_emp_temp_yn = formEmployee.dsc_emp_temp_yn;
//employeeFromFB.dsc_emp_upd_dtm = DateTime.Today;
//employeeFromFB.dsc_emp_upd_uid = User.Identity.Name;
//try
//{
// db.Entry(employeeFromFB).State = EntityState.Modified;
// db.SaveChanges();
// ViewBag.ConfMsg = "Success";
//}
//catch { }
// //return RedirectToAction("Index");
////if (ModelState.IsValid)
////{
//// db.Entry(employeeFromFB).State = EntityState.Modified;
//// db.SaveChanges();
//// ViewBag.ConfMsg = "Success";
//// //return RedirectToAction("Index");
////}
//ViewBag.dsc_assigned_lc_id = new SelectList(db.DSC_LC, "dsc_lc_id", "dsc_lc_name", formEmployee.dsc_assigned_lc_id);
//return View(employeeFromFB);
// ===========================================================================================
////using (DSC_OBS_DB_ENTITY db = new DSC_OBS_DB_ENTITY())
////{
//// var employee = db.EMPLOYEEs.Single(x => x.dsc_emp_id == formEmployee.dsc_emp_id);
//// employee.dsc_emp_title = formEmployee.dsc_emp_title;
//// db.SaveChanges();
//// formEmployee = employee;
//// ViewBag.
//// ViewBag.dsc_assigned_lc_id = new SelectList(db.DSC_LC.Where(x => x.dsc_lc_id>0).ToList(), "dsc_lc_id", "dsc_lc_name", formEmployee.dsc_assigned_lc_id);
//// return View(employee);
////}
////if (ModelState.IsValid) { }
//db.ObjectStateManager.ChangeObjectState(dbEmployee, EntityState.Modified);
//db.SaveChanges();
//return View(dbEmployee);
}
public ActionResult QuestionAddUpdatePost(FormCollection postedData, QuestionMDViewModel QuestionMDView,
[Bind(Prefix = "questn")] OBS_QUESTION questionHdr, string ans_type_list)
{
string posted_deleted_ids = postedData["obs_qat_Id_delList"];
if (questionHdr.obs_question_eff_end_dt < Convert.ToDateTime("01/01/2000")) { questionHdr.obs_question_eff_end_dt = Convert.ToDateTime("12/31/2060"); }
string posted_ans_type_list = postedData["ans_type_list"];//represents newly added selectable ans types
string posted_existing_ans_type_data = postedData["sel_ans_list"]; //represents existing assigned ans types that need to be modified
//string ans_type_list = "6~true~yes~no~maybe,10~false~1~2~3~4~5";
//ans_type_list format: at_id~default~sel_ans,
// 6~ true ~always~sometimes~never,
//obs_qat_id_delList = qat_id,qat_id,... list of answer types to be deleted
//-------- Save the Question Information ----
int defaultQATid = -1;
try
{
defaultQATid = Convert.ToInt32(postedData["defaultQATid"]);
}
catch { }
using (DSC_OBS_DB_ENTITY db = new DSC_OBS_DB_ENTITY())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
if(defaultQATid>0)
{
updateDefaultAnswerType(defaultQATid, "Y");
}
else if (questionHdr.obs_question_id > 0)
{
List<OBS_QUEST_ANS_TYPES> temp_OBS_QUEST_ANS_TYPES = db.OBS_QUEST_ANS_TYPES.Where(x => x.obs_question_id == questionHdr.obs_question_id).ToList();
foreach(OBS_QUEST_ANS_TYPES x in temp_OBS_QUEST_ANS_TYPES )
{
x.obs_qat_default_ans_type_yn = "N";
db.SaveChanges();
}
}
///////////////////////////////This section saves changes to existing answer types/////////////////////////////////
if (!string.IsNullOrEmpty(posted_existing_ans_type_data))
{
string[] split_ans_types_by = { "," };
string[] posted_single_ans_type_data = posted_existing_ans_type_data.Split(split_ans_types_by, StringSplitOptions.RemoveEmptyEntries);
foreach (string str in posted_single_ans_type_data)
{
List<string> selAnsList_from_form = new List<string>();
string[] splitterm = { "~" };
string[] ans_type_elements = str.Split(splitterm, StringSplitOptions.RemoveEmptyEntries);
int intQATid = Convert.ToInt32(ans_type_elements[0]);
short obs_ans_type_id = db.OBS_QUEST_ANS_TYPES.Single(x => x.obs_qat_id == intQATid).obs_ans_type_id;
for (int i = 1; i < ans_type_elements.Length; i++)
{
selAnsList_from_form.Add(ans_type_elements[i].Trim().ToUpper());
}
OBS_ANS_TYPE ans_type = db.OBS_ANS_TYPE.Single(item => item.obs_ans_type_id == obs_ans_type_id);
List<string> current_sel_ans_list = db.OBS_QUEST_SLCT_ANS.Where(item => item.obs_qat_id == intQATid && item.obs_qsa_eff_st_dt <= DateTime.Now && item.obs_qsa_eff_end_dt > DateTime.Now).Select(x => x.obs_qsa_text).ToList();
if (isEqualList(current_sel_ans_list, selAnsList_from_form, ans_type.obs_ans_type_category))
{//if we're here that means 2 lists are the same and we only need to change the order of selected answers list
short order = 1;
for (int i = 1; i < ans_type_elements.Length; i++)
{
string sel_ans_element = ans_type_elements[i];
OBS_QUEST_SLCT_ANS oBS_QUEST_SLCT_ANS = db.OBS_QUEST_SLCT_ANS.Single(item => item.obs_qat_id == intQATid && item.obs_qsa_text == sel_ans_element && item.obs_qsa_eff_st_dt <= DateTime.Now && item.obs_qsa_eff_end_dt > DateTime.Now);
oBS_QUEST_SLCT_ANS.obs_qsa_order = order;
db.SaveChanges();
order++;
}
}
else//if we're here, that means user passed a different list of selected answers and we need to delete the current one and add new
{
//List<OBS_QUEST_SLCT_ANS> oBS_QUEST_SLCT_ANS = db.OBS_QUEST_SLCT_ANS.Where(item => item.obs_qat_id == intQATid).ToList();
db.OBS_QUEST_SLCT_ANS.RemoveRange(db.OBS_QUEST_SLCT_ANS.Where(x => x.obs_qat_id == intQATid)); ;//update end effective date to todays date
short order = 1;
for (int i = 1; i < ans_type_elements.Length; i++)//now lets create a new record with updated selected answers
{
OBS_QUEST_SLCT_ANS UPDATED_oBS_QUEST_SLCT_ANS = new OBS_QUEST_SLCT_ANS();
UPDATED_oBS_QUEST_SLCT_ANS.obs_qat_id = intQATid;
UPDATED_oBS_QUEST_SLCT_ANS.obs_qsa_text = ans_type_elements[i].ToUpper();
UPDATED_oBS_QUEST_SLCT_ANS.obs_qsa_order = order;
UPDATED_oBS_QUEST_SLCT_ANS.obs_qsa_wt = 1;
UPDATED_oBS_QUEST_SLCT_ANS.obs_qsa_dflt_yn = "N";
UPDATED_oBS_QUEST_SLCT_ANS.obs_qsa_eff_st_dt = DateTime.Now;
UPDATED_oBS_QUEST_SLCT_ANS.obs_qsa_eff_end_dt = Convert.ToDateTime("12/31/2060");
db.OBS_QUEST_SLCT_ANS.Add(UPDATED_oBS_QUEST_SLCT_ANS);
order++;
}// end foreach
db.SaveChanges();
}
}//foreach (string str in posted_single_ans_type_data)
}//end of if (!string.IsNullOrEmpty(posted_existing_ans_type_data))
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//this section saves new question information or new question answer type
if (questionHdr.obs_question_id > 0)
{
OBS_QUESTION editedQuestion = db.OBS_QUESTION.Single(x => x.obs_question_id == questionHdr.obs_question_id);
if (!editedQuestion.obs_question_full_text.Equals(questionHdr.obs_question_full_text))
{
editedQuestion.obs_question_ver++;
}
editedQuestion.obs_question_full_text = questionHdr.obs_question_full_text;
editedQuestion.obs_question_desc = questionHdr.obs_question_desc;
editedQuestion.obs_question_eff_st_dt = questionHdr.obs_question_eff_st_dt;
editedQuestion.obs_question_eff_end_dt = questionHdr.obs_question_eff_end_dt;
editedQuestion.obs_question_upd_dtm = DateTime.Now;
editedQuestion.obs_question_upd_uid = User.Identity.Name;
db.SaveChanges();
}
else {
if (questionHdr.obs_question_eff_end_dt < Convert.ToDateTime("01/01/1900"))
{
questionHdr.obs_question_eff_end_dt = Convert.ToDateTime("12/31/2060");
}
if (questionHdr.obs_question_eff_st_dt < Convert.ToDateTime("01/01/1900"))
{
questionHdr.obs_question_eff_st_dt = DateTime.Now;
}
questionHdr.obs_question_ver = 1;
questionHdr.obs_question_added_uid = User.Identity.Name;
questionHdr.obs_question_added_dtm = DateTime.Now;
db.OBS_QUESTION.Add(questionHdr);
db.SaveChanges();
}
if (!String.IsNullOrEmpty(posted_ans_type_list))
{
string[] splitter = { "," };
string[] passed_sel_ans_info = posted_ans_type_list.Split(splitter, StringSplitOptions.RemoveEmptyEntries);//all passed selectable answers data
foreach (string s in passed_sel_ans_info)
{
string[] splitby = { "~" };
string[] single_sel_ans_info = s.Split(splitby, StringSplitOptions.RemoveEmptyEntries);//individual answer type data
OBS_QUEST_ANS_TYPES new_assigned_ans_type = new OBS_QUEST_ANS_TYPES();
new_assigned_ans_type.obs_ans_type_id = Convert.ToInt16(single_sel_ans_info[0]);
new_assigned_ans_type.obs_question_id = questionHdr.obs_question_id;
new_assigned_ans_type.obs_qat_default_ans_type_yn = single_sel_ans_info[1] == "true" ? "Y" : "N";
db.OBS_QUEST_ANS_TYPES.Add(new_assigned_ans_type);
db.SaveChanges();//at this point we've saved the OBS_QUEST_ANS_TYPES record.
OBS_QUEST_ANS_TYPES passed_quest_ans_record = db.OBS_QUEST_ANS_TYPES.Single(x => x.obs_qat_id == new_assigned_ans_type.obs_qat_id);
if (passed_quest_ans_record.obs_qat_default_ans_type_yn != new_assigned_ans_type.obs_qat_default_ans_type_yn && new_assigned_ans_type.obs_qat_default_ans_type_yn == "N")
{ //if existing record is default and we need to set it to N we need to do it here and we won't have to
//change any other records
passed_quest_ans_record.obs_qat_default_ans_type_yn = "N";
db.SaveChanges();
}
else if (passed_quest_ans_record.obs_qat_default_ans_type_yn != new_assigned_ans_type.obs_qat_default_ans_type_yn && new_assigned_ans_type.obs_qat_default_ans_type_yn == "Y")
{// if passed qat_id needs to be default one, we should first set existing default to N and then update passed to Y
try
{
int current_default_quest_id = db.OBS_QUEST_ANS_TYPES.Single(x => x.obs_question_id == passed_quest_ans_record.obs_question_id && x.obs_qat_id != passed_quest_ans_record.obs_qat_id && x.obs_qat_default_ans_type_yn == "Y").obs_question_id;
setExistingDefaultToN(current_default_quest_id);
}
catch { }
passed_quest_ans_record.obs_qat_default_ans_type_yn = "Y";
db.SaveChanges();
}
if (single_sel_ans_info.Count() > 2)//now we need to check if there's selectable answers for this question
{
short order = 1;
for (int i = 2; i < single_sel_ans_info.Count(); i++)
{
OBS_QUEST_SLCT_ANS new_sel_ans = new OBS_QUEST_SLCT_ANS();
new_sel_ans.obs_qat_id = new_assigned_ans_type.obs_qat_id;
new_sel_ans.obs_qsa_text = single_sel_ans_info[i];
new_sel_ans.obs_qsa_order = order;
new_sel_ans.obs_qsa_wt = 1;
new_sel_ans.obs_qsa_dflt_yn = "N";
new_sel_ans.obs_qsa_eff_st_dt = DateTime.Now;
new_sel_ans.obs_qsa_eff_end_dt = Convert.ToDateTime("12/31/2060");
db.OBS_QUEST_SLCT_ANS.Add(new_sel_ans);
db.SaveChanges();
order++;
}
}
}
}
///////////////////////////////////WE DELETE SEL ANS HERE///////////////////////////////////////////
if (!string.IsNullOrEmpty(posted_deleted_ids))
{
string[] qats_to_delete = posted_deleted_ids.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries);
foreach (string qat_to_delete in qats_to_delete)
{
deleteAssignedSelAns(Convert.ToInt32(qat_to_delete), db);
}
}
///////////////////////////////////END OF DELETING SEL ANS///////////////////////////////////////////
// ------- Save the Question Metadata Changes ----
string MDlistBefore = postedData["origTags"];
string MDlistAfter = postedData["qAssignedMD"];
List<string> originalMDList = new List<string>();
List<string> newMDList = new List<string>();
if (!String.IsNullOrEmpty(MDlistBefore)) { originalMDList = MDlistBefore.Split(',').ToList(); }
if (!String.IsNullOrEmpty(MDlistAfter)) { newMDList = MDlistAfter.Split(',').ToList(); }
string[] mdIDsToDelete = originalMDList.Except(newMDList).ToArray();
string[] mdIDsToAdd = newMDList.Except(originalMDList).ToArray();
//---- Soft Delete all Metadata tags that are no longer used by the question
foreach (string deleteId in mdIDsToDelete)
{
int tempId = Convert.ToInt32(deleteId);
//int joitemp = db.OBS_QUEST_ASSGND_MD.Where(x => x.obs_quest_md_id == Convert.ToInt32(deleteId) && x.obs_question_id == questionHdr.obs_question_id).Select(x => x.obs_qad_id);
OBS_QUEST_ASSGND_MD oBS_QUEST_ASSGND_MD = db.OBS_QUEST_ASSGND_MD.FirstOrDefault(x => x.obs_quest_md_id == tempId && x.obs_question_id == questionHdr.obs_question_id);
oBS_QUEST_ASSGND_MD.obs_qad_eff_end_dt = DateTime.Today;
//db.OBS_QUESTION_METADATA.Remove(oBS_QUESTION_METADATA); //No hard deletes
}
//---- Enable or Add the New metadata (MD) that will be assigned to the question ---
//-- Process each metadata entry to add for the selected question
foreach (string mdIdtoAdd in mdIDsToAdd)
{
try
{
int tempId = Convert.ToInt32(mdIdtoAdd);
//-- Look for an entry in OBS_QUEST_ASSGND_MD usign the Question Id and the metadata it.
OBS_QUEST_ASSGND_MD oBS_QUEST_ASSGND_MD = db.OBS_QUEST_ASSGND_MD.FirstOrDefault(x => x.obs_quest_md_id == tempId && x.obs_question_id == questionHdr.obs_question_id);
//-- If an entry is found in the junction table for that question, just enable it
if (oBS_QUEST_ASSGND_MD != null && tempId > 0)
{
oBS_QUEST_ASSGND_MD.obs_qad_eff_end_dt = Convert.ToDateTime("12/31/2060");
}
else
{ //-- If selected MD does not exist in the junction table for that question, add it.
oBS_QUEST_ASSGND_MD = new OBS_QUEST_ASSGND_MD();
oBS_QUEST_ASSGND_MD.obs_quest_md_id = tempId;
oBS_QUEST_ASSGND_MD.obs_question_id = questionHdr.obs_question_id;
oBS_QUEST_ASSGND_MD.obs_qad_eff_st_dt = DateTime.Today;
oBS_QUEST_ASSGND_MD.obs_qad_eff_end_dt = Convert.ToDateTime("12/31/2060");
db.OBS_QUEST_ASSGND_MD.Add(oBS_QUEST_ASSGND_MD);
}
}
catch { }
}
//---- Save All Changes ------
db.SaveChanges();
transaction.Commit();
}
catch (Exception e)
{
string notused = e.Message;
transaction.Rollback();
}
}
}
//ViewBag.ConfMsg = "Data Saved Successfully.";
return RedirectToAction("QuestionAddUpdate", new {id = questionHdr.obs_question_id});
//return RedirectToAction("Index", "Question");
//return View("Edit");
}
/*
* This method deletes assigned selected answers and all the selectable answers if needed
*/
public void deleteAssignedSelAns(int qat_id, DSC_OBS_DB_ENTITY ObsDB)
{
//first need to check if qat_id is already tied to any Form
if (ObsDB.OBS_COL_FORM_QUESTIONS.Where(x => x.obs_qat_id == qat_id).ToList().Count > 0)
{
//if answer type requires selectable answers, lets deactivate them first
short ans_type_id = ObsDB.OBS_QUEST_ANS_TYPES.Single(y => y.obs_qat_id == qat_id).obs_ans_type_id;
if (ObsDB.OBS_ANS_TYPE.Single(x => x.obs_ans_type_id == ans_type_id).obs_ans_type_has_fxd_ans_yn == "Y")
{
List<OBS_QUEST_SLCT_ANS> sel_answers = ObsDB.OBS_QUEST_SLCT_ANS.Where(x => x.obs_qat_id == qat_id && x.obs_qsa_eff_st_dt <= DateTime.Now && x.obs_qsa_eff_end_dt > DateTime.Now).ToList();
foreach (OBS_QUEST_SLCT_ANS sel_ans in sel_answers)
{
sel_ans.obs_qsa_eff_end_dt = DateTime.Now;
}
}
ObsDB.OBS_QUEST_ANS_TYPES.Single(x => x.obs_qat_id == qat_id).obs_qat_end_eff_dt = DateTime.Now;
}
else
{//ok, this qat id doesn't belong to any form. We can hard delete it
//but first we need to check if there are selectable answers for this answer type and delete them
short ans_type_id = ObsDB.OBS_QUEST_ANS_TYPES.Single(y => y.obs_qat_id == qat_id).obs_ans_type_id;
if (ObsDB.OBS_ANS_TYPE.Single(x=>x.obs_ans_type_id== ans_type_id).obs_ans_type_has_fxd_ans_yn=="Y")
{
ObsDB.OBS_QUEST_SLCT_ANS.RemoveRange(ObsDB.OBS_QUEST_SLCT_ANS.Where(x => x.obs_qat_id == qat_id));
}
ObsDB.OBS_QUEST_ANS_TYPES.Remove(ObsDB.OBS_QUEST_ANS_TYPES.Find(qat_id));
}
ObsDB.SaveChanges();
}
public ActionResult Activate(int id, string actionText)
{
if (actionText == "Activate")
{
using (DSC_OBS_DB_ENTITY db = new DSC_OBS_DB_ENTITY())
{
var customer = db.DSC_CUSTOMER.Single(cust_id => cust_id.dsc_cust_id == id);
customer.dsc_cust_eff_end_date = null;
db.SaveChanges();
}
return RedirectToAction("Index");
}
else if (actionText == "Deactivate")
{
using (DSC_OBS_DB_ENTITY db = new DSC_OBS_DB_ENTITY())
{
var customer = db.DSC_CUSTOMER.Single(cust_id => cust_id.dsc_cust_id == id);
customer.dsc_cust_eff_end_date = DateTime.Today;
db.SaveChanges();
}
return RedirectToAction("Index");
}
return RedirectToAction("Index");
}