public PartialViewResult Categories_edit(string cat_id, string arr)
{
//deserialize myArray
JavaScriptSerializer js = new JavaScriptSerializer();
var myojb = (List <TopicCheck>)js.Deserialize(arr, typeof(List <TopicCheck>));
var topicchecks = (List <TopicCheck>)Session["TopicChecked"];
foreach (var item in myojb)
{
if (topicchecks.Any(tc => item.topic_seq == tc.topic_seq))
{
var remove = topicchecks.Where(x => x.topic_seq == item.topic_seq).Single();
topicchecks.Remove(remove);
var topic = new TopicCheck();
topic.topic_seq = item.topic_seq;
topic.category_id = db.Topic_Category.Where(x => x.Topic_Seq == item.topic_seq).Select(x => x.Category_ID).FirstOrDefault().ToString();
topic.topic_name = db.Topics.Find(item.topic_seq).Topic_Name;
topic.topic_ind = item.topic_ind;
topicchecks.Add(topic);
}
}
var viewModel = new EmployeeEditModel();
viewModel.topicchecks = topicchecks;
if (cat_id != null)
{
var id = (string)js.Deserialize(cat_id, typeof(string));
viewModel.topicchecks = (from tc in viewModel.topicchecks
where tc.category_id == id
select tc).ToList();
}
return(PartialView("Categories_edit", viewModel));
}
public PartialViewResult Topics()
{
Session["Topic_Checked"] = new List <TopicCheck>();
var topicchecklist = (List <TopicCheck>)Session["Topic_Checked"];
var viewModel = new EmployeeAddModel();
foreach (var item in db.Topic_Category)
{
var t = new TopicCheck();
t.topic_seq = item.Topic_Seq;
t.topic_name = db.Topics.Find(item.Topic_Seq).Topic_Name;
t.category_id = item.Category_ID.ToString();
topicchecklist.Add(t);
}
viewModel.topic_check = topicchecklist;
viewModel.topic_category = db.Topic_Category.Include(x => x.Topic).ToList();
List <SelectListItem> selectListItems = new List <SelectListItem>();
foreach (Category category in db.Categories)
{
SelectListItem selectListItem = new SelectListItem
{
Text = category.Category_Name,
Value = category.Category_ID.ToString()
};
selectListItems.Add(selectListItem);
}
ViewBag.Categories = selectListItems;
return(PartialView("Topics", viewModel));
}
public ActionResult saveTopics(string id, string name, string surname, string email, string arr, string rolearr)
{
JavaScriptSerializer js = new JavaScriptSerializer();
var myojb = (List <TopicCheck>)js.Deserialize(arr, typeof(List <TopicCheck>));
var roleArr = (List <EmpRoleCheckEdit>)js.Deserialize(rolearr, typeof(List <EmpRoleCheckEdit>));
var _id = (string)js.Deserialize(id, typeof(string));
var _name = (string)js.Deserialize(name, typeof(string));
var _surname = (string)js.Deserialize(surname, typeof(string));
var _email = (string)js.Deserialize(email, typeof(string));
var topicchecks = (List <TopicCheck>)Session["TopicChecked"];
foreach (var item in myojb)
{
if (topicchecks.Any(tc => item.topic_seq == tc.topic_seq))
{
var remove = topicchecks.Where(x => x.topic_seq == item.topic_seq).Single();
topicchecks.Remove(remove);
var topic = new TopicCheck();
topic.topic_seq = item.topic_seq;
topic.category_id = db.Topic_Category.Where(x => x.Topic_Seq == item.topic_seq).Select(x => x.Category_ID).FirstOrDefault().ToString();
topic.topic_name = db.Topics.Find(item.topic_seq).Topic_Name;
topic.topic_ind = item.topic_ind;
topicchecks.Add(topic);
}
}
var viewModel = new EmployeeEditModel();
viewModel.topicchecks = topicchecks;
viewModel.emprolecheckeditlist = roleArr;
viewModel.person_id = _id;
viewModel.person_name = _name;
viewModel.person_surname = _surname;
viewModel.person_email = _email;
return(Edit(_id, viewModel));
}
public ActionResult Edit(string id)
{
//employee details
if (id == null)
{
TempData["Msg"] = "Please select an employee before selecting update.";
TempData["Show"] = true;
TempData["color"] = "alert-warning";
ModelState.AddModelError("person_id", "Please select an employee before selecting update.");
return(RedirectToAction("Index"));
}
var viewModel = new EmployeeEditModel();
viewModel.emprolecheckeditlist = new List <EmpRoleCheckEdit>();
viewModel.person_id = db.Registered_Person.Find(id).Person_ID;
viewModel.person_name = db.Registered_Person.Find(id).Person_Name;
viewModel.person_surname = db.Registered_Person.Find(id).Person_Surname;
viewModel.person_email = db.Registered_Person.Find(id).Person_Email;
//roles
var p_role = db.Person_Role.Where(
i => i.Person_ID == id).Include(x => x.Role).ToList();
foreach (var item in db.Roles)
{
var rolecheck = new EmpRoleCheckEdit();
rolecheck.role_id = item.Role_ID;
rolecheck.role_name = item.Role_Name;
foreach (var r in p_role)
{
if (item.Role_ID == r.Role_ID)
{
rolecheck.role_ind = true;
}
}
viewModel.emprolecheckeditlist.Add(rolecheck);
}
//topics
Session["TopicChecked"] = new List <TopicCheck>();
var topicchecks = (List <TopicCheck>)Session["TopicChecked"];
List <SelectListItem> selectListItems = new List <SelectListItem>();
foreach (Category category in db.Categories)
{
SelectListItem selectListItem = new SelectListItem
{
Text = category.Category_Name,
Value = category.Category_ID.ToString()
};
selectListItems.Add(selectListItem);
}
ViewBag.Categories = selectListItems;
TempData["Check1"] = false;
var trainer_topic = db.Trainer_Topic
.Where(i => i.Person_ID == id).ToList();
viewModel.topicchecks = new List <TopicCheck>();
foreach (var item in db.Topics)
{
var topiccheck = new TopicCheck();
topiccheck.topic_seq = item.Topic_Seq;
topiccheck.topic_name = item.Topic_Name;
topiccheck.category_id = db.Topic_Category.Where(x => x.Topic_Seq == item.Topic_Seq).Select(x => x.Category_ID).FirstOrDefault().ToString();
foreach (var tt in trainer_topic)
{
if (item.Topic_Seq == tt.Topic_Seq)
{
topiccheck.topic_ind = true;
}
}
topicchecks.Add(topiccheck);
}
if (!viewModel.emprolecheckeditlist.Where(x => x.role_id == 7).Where(y => y.role_ind == true).Any())
{
TempData["Check1"] = "hidden";
}
viewModel.topicchecks = topicchecks;
ViewBag.Person_Type = new SelectList(db.Person_Type, "Person_Type1", "Person_Type1", 2);
TempData["Show"] = false;
return(View(viewModel));
}
