// GET: Position_Information public ActionResult Create(string id) { var ID = int.Parse(id); var App = dbcontext.Application.FirstOrDefault(a => a.ID == ID).Applicant_ProfileId; var AppId = int.Parse(App); ViewBag.ApplicationApp = dbcontext.Applicant_Profile.FirstOrDefault(a => a.ID == AppId).Full_Name; ViewBag.ApplicationCode = dbcontext.Application.FirstOrDefault(a => a.ID == ID).Code; ViewBag.job_desc = dbcontext.job_title_cards.ToList().Select(m => new { Code = m.Code + "------[" + m.name + ']', ID = m.ID }); ViewBag.job_slot_desc = dbcontext.job_title_cards.ToList().Select(m => new { Code = m.num_slots + "------[" + m.name + ']', ID = m.ID }); ViewBag.Default_location = dbcontext.work_location.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.location_desc = dbcontext.work_location.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.Job_level_grade = dbcontext.job_level_setup.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.Organization_Chart = dbcontext.Organization_Chart.ToList().Select(m => new { Code = m.Code + "------[" + m.unit_Description + ']', ID = m.ID }); ViewBag.Employee_Profile = dbcontext.Employee_Profile.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.idemp = id; DateTime statis2 = Convert.ToDateTime("1/1/1900"); var com = dbcontext.Application.FirstOrDefault(m => m.ID == ID); var Application = new Position_Information_Rec { Application = com, ID = com.ID, From_date = statis2, To_date = statis2 }; return(View(Application)); }
public ActionResult Create(Position_Information_Rec model, string Command, string id2) { try { if (model.job_descId == null) { model.job_descId = "0"; } if (model.Default_location_descId == null) { model.Default_location_descId = "0"; } if (model.Location_descId == null) { model.Location_descId = "0"; } if (model.Job_level_gradeId == null) { model.Job_level_gradeId = "0"; } if (model.SlotdescId == null) { model.SlotdescId = "0"; } if (model.Organization_ChartId == null) { model.Organization_ChartId = "0"; } var App = dbcontext.Application.FirstOrDefault(a => a.ID == model.ID).Applicant_ProfileId; var AppId = int.Parse(App); ViewBag.ApplicationApp = dbcontext.Applicant_Profile.FirstOrDefault(a => a.ID == AppId).Full_Name; ViewBag.ApplicationCode = dbcontext.Application.FirstOrDefault(a => a.ID == model.ID).Code; ViewBag.job_desc = dbcontext.job_title_cards.ToList().Select(m => new { Code = m.Code + "------[" + m.name + ']', ID = m.ID }); ViewBag.job_slot_desc = dbcontext.job_title_cards.ToList().Select(m => new { Code = m.num_slots + "------[" + m.name + ']', ID = m.ID }); ViewBag.Default_location = dbcontext.work_location.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.location_desc = dbcontext.work_location.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.Job_level_grade = dbcontext.job_level_setup.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.Organization_Chart = dbcontext.Organization_Chart.ToList().Select(m => new { Code = m.Code + "------[" + m.unit_Description + ']', ID = m.ID }); ViewBag.idemp = id2; if (ModelState.IsValid) { Position_Information_Rec record = new Position_Information_Rec(); record.ApplicantId = int.Parse(id2); record.From_date = model.From_date; record.To_date = model.To_date; if (model.From_date > model.To_date) { TempData["Message"] = HR.Resource.Personnel.FromdatebiggerTodate; return(View(model)); } record.Years = model.Years; record.Months = model.Months; record.Working_System = model.Working_System; record.Position_Status = model.Position_Status; //if (model.SlotdescId != "0") //{ // var SlotdescId = int.Parse(model.SlotdescId); // var my_slot = dbcontext.Slots.FirstOrDefault(m => m.ID == SlotdescId); // my_slot.Employee_Profile = emp; // my_slot.EmployeeName = emp.Full_Name; // my_slot.EmployeeID = emp.ID.ToString(); // //my_slot.check_status = check_status.Canceled; // var job = dbcontext.job_title_cards.FirstOrDefault(m => m.ID == my_slot.job_title_cards.ID); // job.number_hired = job.number_hired + 1; // job.number_vacant = job.number_vacant - 1; // dbcontext.SaveChanges(); //} record.job_descId = model.job_descId; var job_descId = int.Parse(model.job_descId); record.job_title_cards = dbcontext.job_title_cards.FirstOrDefault(m => m.ID == job_descId); record.SlotdescId = model.SlotdescId; var SlotdescId = int.Parse(model.SlotdescId); record.job_title_cards = dbcontext.job_title_cards.FirstOrDefault(m => m.ID == SlotdescId); record.Default_location_descId = model.Default_location_descId; var Default_location_descId = int.Parse(model.Default_location_descId); record.work_location = dbcontext.work_location.FirstOrDefault(m => m.ID == Default_location_descId); record.Location_descId = model.Location_descId; var Location_descId = int.Parse(model.Location_descId); record.work_location = dbcontext.work_location.FirstOrDefault(m => m.ID == Location_descId); record.Job_level_gradeId = model.Job_level_gradeId; var Job_level_gradeId = int.Parse(model.Job_level_gradeId); record.Job_level_grade = dbcontext.Job_level_gradee.FirstOrDefault(m => m.ID == Job_level_gradeId); record.Organization_ChartId = model.Organization_ChartId; var Organization_ChartId = int.Parse(model.Organization_ChartId); record.Organization_Chart = dbcontext.Organization_Chart.FirstOrDefault(m => m.ID == Organization_ChartId); var pos = dbcontext.Position_Information_Rec.Add(record); dbcontext.SaveChanges(); if (Command == "Submit") { return(RedirectToAction("Edit", "Application", new { id = id2 })); } return(RedirectToAction("Index", "Application", new { id = id2 })); } else { return(View(model)); } } catch (DbUpdateException e) { TempData["Message"] = HR.Resource.Basic.thiscodeIsalreadyexists; return(View(model)); } catch (Exception e) { return(View(model)); } }
public ActionResult Edit(Position_Information_Rec model, string Command, string id2) { try { if (model.job_descId == null) { model.job_descId = "0"; } if (model.Default_location_descId == null) { model.Default_location_descId = "0"; } if (model.Location_descId == null) { model.Location_descId = "0"; } if (model.Job_level_gradeId == null) { model.Job_level_gradeId = "0"; } if (model.SlotdescId == null) { model.SlotdescId = "0"; } if (model.Organization_ChartId == null) { model.Organization_ChartId = "0"; } ViewBag.job_desc = dbcontext.job_title_cards.ToList().Select(m => new { Code = m.Code + "------[" + m.name + ']', ID = m.ID }); ViewBag.job_slot_desc = dbcontext.job_title_cards.ToList().Select(m => new { Code = m.num_slots + "------[" + m.name + ']', ID = m.ID }); ViewBag.Default_location = dbcontext.work_location.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.location_desc = dbcontext.work_location.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.Job_level_grade = dbcontext.job_level_setup.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.Organization_Chart = dbcontext.Organization_Chart.ToList().Select(m => new { Code = m.Code + "------[" + m.unit_Description + ']', ID = m.ID }); ViewBag.idemp = id2; var ID = int.Parse(id2); var record = dbcontext.Position_Information_Rec.FirstOrDefault(m => m.ApplicantId == ID); record.ApplicantId = int.Parse(id2); record.From_date = model.From_date; record.To_date = model.To_date; if (model.From_date > model.To_date) { TempData["Message"] = HR.Resource.Personnel.FromdatebiggerTodate; return(View(model)); } record.Years = model.Years; record.Months = model.Months; record.Working_System = model.Working_System; record.Position_Status = model.Position_Status; // var SlotdescId = int.Parse(model.SlotdescId); // var t = dbcontext.Select(a => a.SlotdescId); //if (model.SlotdescId == "0") //{ // ////remove // if (record.SlotdescId != "0") // { // var IDslot = int.Parse(record.SlotdescId); // var old_slot = dbcontext.Slots.FirstOrDefault(m => m.ID == IDslot); // old_slot.Employee_Profile = null; // old_slot.EmployeeID = null; // old_slot.EmployeeName = null; // dbcontext.SaveChanges(); // var job = dbcontext.job_title_cards.FirstOrDefault(m => m.ID == old_slot.job_title_cards.ID); // job.number_hired = job.number_hired - 1; // job.number_vacant = job.number_vacant + 1; // dbcontext.SaveChanges(); // } //} //else //{ // var IDslot = int.Parse(model.SlotdescId); // var new_slot = dbcontext.Slots.FirstOrDefault(m => m.ID == IDslot); //if (new_slot.EmployeeID == null) //{ // ///remove from old //if (record.SlotdescId != "0") //{ // var old_IDslot = int.Parse(record.SlotdescId); // var old_slot = dbcontext.Slots.FirstOrDefault(m => m.ID == old_IDslot); // old_slot.Employee_Profile = null; // old_slot.EmployeeID = null; // old_slot.EmployeeName = null; // dbcontext.SaveChanges(); // var jobb = dbcontext.job_title_cards.FirstOrDefault(m => m.ID == old_slot.job_title_cards.ID); // jobb.number_hired = jobb.number_hired - 1; // jobb.number_vacant = jobb.number_vacant + 1; // dbcontext.SaveChanges(); //} /////add to new //new_slot.Employee_Profile = emp; //new_slot.EmployeeName = emp.Full_Name; //new_slot.EmployeeID = emp.ID.ToString(); //var job = dbcontext.job_title_cards.FirstOrDefault(m => m.ID == new_slot.job_title_cards.ID); //job.number_hired = job.number_hired + 1; //job.number_vacant = job.number_vacant - 1; //dbcontext.SaveChanges(); //} //} record.job_descId = model.job_descId; var job_descId = int.Parse(model.job_descId); record.job_title_cards = dbcontext.job_title_cards.FirstOrDefault(m => m.ID == job_descId); record.SlotdescId = model.SlotdescId; var SlotdescId = int.Parse(model.SlotdescId); record.job_title_cards = dbcontext.job_title_cards.FirstOrDefault(m => m.ID == SlotdescId); record.Default_location_descId = model.Default_location_descId; var Default_location_descId = int.Parse(model.Default_location_descId); record.work_location = dbcontext.work_location.FirstOrDefault(m => m.ID == Default_location_descId); record.Location_descId = model.Location_descId; var Location_descId = int.Parse(model.Location_descId); record.work_location = dbcontext.work_location.FirstOrDefault(m => m.ID == Location_descId); record.Job_level_gradeId = model.Job_level_gradeId; var Job_level_gradeId = int.Parse(model.Job_level_gradeId); record.Job_level_grade = dbcontext.Job_level_gradee.FirstOrDefault(m => m.ID == Job_level_gradeId); record.Organization_ChartId = model.Organization_ChartId; var Organization_ChartId = int.Parse(model.Organization_ChartId); record.Organization_Chart = dbcontext.Organization_Chart.FirstOrDefault(m => m.ID == Organization_ChartId); dbcontext.SaveChanges(); if (Command == "Submit") { return(RedirectToAction("Edit", "Application", new { id = id2 })); } return(RedirectToAction("Index", "Application", new { id = id2 })); } catch (DbUpdateException e) { TempData["Message"] = HR.Resource.Basic.thiscodeIsalreadyexists; return(View(model)); } catch (Exception e) { return(View(model)); } }