/// <summary> /// ////Report to job /// </summary> /// <param name="record"> jobs</param> /// <param name="flag"> list of display column</param> /// <returns></returns> public ActionResult viewReport(List <job_title_cards> record, Boolean[] flag) { var model = new reportJobVm { jobs = record, my_list = flag }; try { return(View(model)); } catch (Exception) { return(View(model)); } }
public ActionResult job_title(Report_JobVM record, FormCollection model) { try { List <job_title_cards> jobForReport = new List <job_title_cards>(); ///////////////////////////////////// var Alljobs = dbcontext.job_title_cards.ToList(); ViewBag.jobs = Alljobs.Select(m => new { Code = m.Code + "------[" + m.name + ']', ID = m.ID }); ViewBag.codes = Alljobs.Select(m => new { m.Code }); ViewBag.names = Alljobs.Select(m => new { m.name }); ViewBag.nationality = dbcontext.Nationality.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.parent = Alljobs.Select(m => new { Code = m.Code + "------[" + m.name + ']', ID = m.ID }); // ViewBag.sub_class = dbcontext.Job_title_sub_class.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.chart = dbcontext.Organization_Chart.ToList().Select(m => new { Code = m.Code + "------[" + m.unit_Description + ']', ID = m.ID }); ViewBag.job_setup = dbcontext.Nationality.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ///////////////////////////////////// var nationality = model["nationality"].Split(char.Parse(",")); var job_setup = model["job_setup"].Split(char.Parse(",")); /// var name = model["name"].Split(char.Parse(",")); var working_system = model["working_system_List"].Split(char.Parse(",")); var chart = model["chart"].Split(char.Parse(",")); var parent = model["parent"].Split(char.Parse(",")); //var gender = model["gender_list"].Split(char.Parse(",")); /// var sub_class = model["sub_class"].Split(char.Parse(","));/////// var parmanet = model["parmet_List"].Split(char.Parse(",")); var validity = model["validity_list"].Split(char.Parse(",")); var List_Display = model["List_Display"].Split(char.Parse(",")); ////////parent////// foreach (var item in parent) { if (item != "") { var parentID = int.Parse(item); var newRecord = Alljobs.FirstOrDefault(m => m.ID == parentID); if (newRecord != null && !jobForReport.Contains(newRecord)) { jobForReport.Add(newRecord); } } } /////job level////// foreach (var item in job_setup) { // var joblevelID = int.Parse(item); if (item != "") { var newRecord = Alljobs.FirstOrDefault(m => m.joblevelsetupID == item); if (newRecord != null && !jobForReport.Contains(newRecord)) { jobForReport.Add(newRecord); } } } /////organiztion chart////// foreach (var item in chart) { // var joblevelID = int.Parse(item); if (item != "") { var newRecord = Alljobs.FirstOrDefault(m => m.Organization_unit_codeID == item); if (newRecord != null && !jobForReport.Contains(newRecord)) { jobForReport.Add(newRecord); } } } /////nationality////// foreach (var item in nationality) { if (item != "") { var newRecord = Alljobs.FirstOrDefault(m => m.nationalityID == item); if (newRecord != null && !jobForReport.Contains(newRecord)) { jobForReport.Add(newRecord); } } } /////working_system////// foreach (var item in working_system) { if (item != "") { var workingsystemID = int.Parse(item); var newRecord = Alljobs.FirstOrDefault(m => m.working_system.GetHashCode() == workingsystemID); if (newRecord != null && !jobForReport.Contains(newRecord)) { jobForReport.Add(newRecord); } } } /////validity////// foreach (var item in validity) { if (item != "") { var validityID = int.Parse(item); var newRecord = Alljobs.FirstOrDefault(m => m.validity.GetHashCode() == validityID); if (newRecord != null && !jobForReport.Contains(newRecord)) { jobForReport.Add(newRecord); } } } /////parment////// foreach (var item in parmanet) { if (item != "") { var parmentID = int.Parse(item); var newRecord = Alljobs.FirstOrDefault(m => m.parment.GetHashCode() == parmentID); if (newRecord != null && !jobForReport.Contains(newRecord)) { jobForReport.Add(newRecord); } } } /////gender////// //foreach (var item in gender) //{ // if (item != "") // { // var genderID = int.Parse(item); // var newRecord = Alljobs.FirstOrDefault(m => m.gender.GetHashCode() == genderID); // if (newRecord != null && !jobForReport.Contains(newRecord)) // { // jobForReport.Add(newRecord); // } // } //} ///////////fromage////// var newRecord2 = Alljobs.FirstOrDefault(m => m.from_age == record.fromAge); if (newRecord2 != null && !jobForReport.Contains(newRecord2)) { jobForReport.Add(newRecord2); } ///////////toage//////// newRecord2 = Alljobs.FirstOrDefault(m => m.to_age == record.toAge); if (newRecord2 != null && !jobForReport.Contains(newRecord2)) { jobForReport.Add(newRecord2); } ///////////numslot//////// newRecord2 = Alljobs.FirstOrDefault(m => m.num_slots == record.numSlot); if (newRecord2 != null && !jobForReport.Contains(newRecord2)) { jobForReport.Add(newRecord2); } var flag1 = new Boolean[15]; for (var i = 0; i < 15; i++) { flag1[i] = false; } foreach (var item in List_Display) { if (item != "") { var index = int.Parse(item); flag1[index] = true; } } ///////////////////////// ////////////////////////// ////////////////////////// foreach (var item in jobForReport) { if (item.parent_job != null) { var id = int.Parse(item.parent_job); item.parent_job = Alljobs.FirstOrDefault(m => m.ID == id).name; } } var report = new reportJobVm { jobs = jobForReport, my_list = flag1 }; return(View("viewReport", report)); } catch (Exception) { return(View(record)); } }