public ActionResult edit(string id) { try { 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.cost = dbcontext.CostCenter.ToList().Select(m => new { Code = m.CostCenterCode + "->" + m.CostCenterDesc, ID = m.ID }); ViewBag.shift = dbcontext.Shift_setup.ToList().Select(m => new { Code = m.Code + "->" + m.Name, ID = m.ID }); var ID = int.Parse(id); var model = dbcontext.personnel_transaction.FirstOrDefault(m => m.ID == ID); var vm = new TRANS_VM { personnel_transaction = model }; if (model.Employee != null) { vm.selected_employee = model.Employee.ID; } else { vm.selected_employee = 0; } return(View(vm)); } catch (Exception e) { return(View()); } }
public bool add_new_postion(TRANS_VM mmodel) { try { ////////////////////////////////////////////// ///////////////add new position/////////////// ///////////////////////////////////////////// var stru = dbcontext.StructureModels.FirstOrDefault(m => m.All_Models == ChModels.Personnel); var model = dbcontext.Position_Information.ToList(); var count = 0; if (model.Count() == 0) { count = 1; } else { var te = model.LastOrDefault().ID; count = te + 1; } var emp = dbcontext.Employee_Profile.FirstOrDefault(m => m.ID == mmodel.selected_employee); /////// Position_Transaction_Information information = new Position_Transaction_Information(); information.Position_transaction = mmodel.personnel_transaction.Position_transaction; information.Position_transaction_no = mmodel.personnel_transaction.Position_Transaction_number; information.Transaction_Type = mmodel.personnel_transaction.Transaction_Type_; information.Fixed_basic_salary_by = mmodel.personnel_transaction.Fixed_basic_salary_by; information.Activity_number = mmodel.personnel_transaction.Activity_number; information.Position_transaction = mmodel.personnel_transaction.Position_transaction; information.Memo_number = mmodel.personnel_transaction.Memo_number; information.Resolution_number = mmodel.personnel_transaction.Resolution_number; information.Approved_by = mmodel.personnel_transaction.Approved_by; information.Recommended_by = mmodel.personnel_transaction.Recommended_by; information.Approved_date = mmodel.personnel_transaction.Approved_date; information.Memo_date = mmodel.personnel_transaction.Memo_date; information.Resolution_date = mmodel.personnel_transaction.Resolution_date; var info = dbcontext.Position_Transaction_Information.Add(information); dbcontext.SaveChanges(); /////// Position_Information record = new Position_Information(); record.Code = stru.Structure_Code + count; record.Primary_Position = true; record.From_date = mmodel.personnel_transaction.From_date; record.To_date = mmodel.personnel_transaction.To_date; record.Years = mmodel.personnel_transaction.Years; record.Months = mmodel.personnel_transaction.Months; record.End_of_service_date = mmodel.personnel_transaction.End_of_service_date; record.Last_working_date = mmodel.personnel_transaction.Last_working_date; record.Commnets = mmodel.personnel_transaction.Commnets; record.working_system = mmodel.personnel_transaction.working_system; record.Position_status = mmodel.personnel_transaction.Position_status; record.EOS_reasons = mmodel.personnel_transaction.EOS_reasons; record.Employee_ProfileId = mmodel.selected_employee.ToString(); record.Employee_Profile = dbcontext.Employee_Profile.FirstOrDefault(m => m.ID == mmodel.selected_employee); record.job_descId = mmodel.personnel_transaction.job_descId; var job_descId = int.Parse(mmodel.personnel_transaction.job_descId); record.job_title_cards = dbcontext.job_title_cards.FirstOrDefault(m => m.ID == job_descId); record.SlotdescId = mmodel.personnel_transaction.SlotdescId; if (mmodel.personnel_transaction.SlotdescId != "0") { var SlotdescId = int.Parse(mmodel.personnel_transaction.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(); dbcontext.SaveChanges(); var job = dbcontext.job_title_cards.FirstOrDefault(m => m.ID == my_slot.job_title_cards.ID);////update vacant and hired number job.number_hired = job.number_hired + 1; job.number_vacant = job.number_vacant - 1; dbcontext.SaveChanges(); } record.Default_location_descId = mmodel.personnel_transaction.Default_location_descId; var Default_location_descId = int.Parse(mmodel.personnel_transaction.Default_location_descId); record.work_location = dbcontext.work_location.FirstOrDefault(m => m.ID == Default_location_descId); record.Location_descId = mmodel.personnel_transaction.Location_descId; var Location_descId = int.Parse(mmodel.personnel_transaction.Location_descId); record.work_location = dbcontext.work_location.FirstOrDefault(m => m.ID == Location_descId); record.Job_level_gradeId = mmodel.personnel_transaction.Job_level_gradeId; var Job_level_gradeId = int.Parse(mmodel.personnel_transaction.Job_level_gradeId); record.Job_level_grade = dbcontext.Job_level_gradee.FirstOrDefault(m => m.ID == Job_level_gradeId); record.Organization_ChartId = mmodel.personnel_transaction.Organization_ChartId; var Organization_ChartId = int.Parse(mmodel.personnel_transaction.Organization_ChartId); record.Organization_Chart = dbcontext.Organization_Chart.FirstOrDefault(m => m.ID == Organization_ChartId); record.Position_Transaction_Information = info; var pos = dbcontext.Position_Information.Add(record); dbcontext.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public ActionResult status(employeestate model) { var sta = dbcontext.status.FirstOrDefault(m => m.ID == model.status.ID); var record = dbcontext.personnel_transaction.FirstOrDefault(m => m.ID == model.opertion_id); if (model.check_status == check_status.Approved) { sta.approved_by = User.Identity.GetUserName(); sta.approved_bydate = model.status.approved_bydate; record.check_status = check_status.Approved; record.name_state = nameof(check_status.Approved); dbcontext.SaveChanges(); var go = new TRANS_VM { personnel_transaction = record, selected_employee = model.empid }; ///////////////update old position////////// var old_position = dbcontext.Position_Information.FirstOrDefault(m => m.Primary_Position == true && m.Employee_ProfileId == go.selected_employee.ToString()); old_position.Primary_Position = false; old_position.To_date = go.personnel_transaction.Last_working_date; dbcontext.SaveChanges(); //old_slot = new Slots(); var slot_id = int.Parse(old_position.SlotdescId); var old_slot = dbcontext.Slots.FirstOrDefault(m => m.ID == slot_id); ////var emp = dbcontext.Employee_Profile.FirstOrDefault(m => m.ID == old_slot.Employee_Profile.ID); var job = dbcontext.job_title_cards.FirstOrDefault(m => m.ID == old_slot.job_title_cards.ID);////update vacant and hired number job.number_hired = job.number_hired - 1; job.number_vacant = job.number_vacant + 1; dbcontext.SaveChanges(); old_slot.Employee_Profile = null; dbcontext.SaveChanges(); old_slot.EmployeeName = null; old_slot.EmployeeID = null; dbcontext.SaveChanges(); add_new_postion(go); } //else if (model.check_status == check_status.Canceled) //{ // sta.cancaled_by = model.status.cancaled_by; // sta.cancaled_bydate = model.status.cancaled_bydate; // record.check_status = check_status.Canceled; // record.name_state = nameof(check_status.Canceled); // dbcontext.SaveChanges(); //} //else if (model.check_status == check_status.created) //{ // sta.created_by = model.status.created_by; // sta.created_bydate = model.status.created_bydate; // record.check_status = check_status.created; // record.name_state = nameof(check_status.created); // dbcontext.SaveChanges(); //} else if (model.check_status == check_status.Rejected) { sta.Rejected_by = User.Identity.GetUserName(); sta.Rejected_bydate = model.status.Rejected_bydate; record.check_status = check_status.Rejected; record.name_state = nameof(check_status.Rejected); dbcontext.SaveChanges(); } else if (model.check_status == check_status.Return_To_Review) { sta.return_to_reviewby = User.Identity.GetUserName(); sta.return_to_reviewdate = model.status.return_to_reviewdate; record.check_status = check_status.Return_To_Review; record.name_state = nameof(check_status.Return_To_Review); dbcontext.SaveChanges(); } //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("personnel transaction process", HR.Models.user.Action.Create, HR.Models.user.type_field.form); if (get_result_check != null) { var inbox = new Models.user.Alert_inbox { send_from_user_id = User.Identity.Name, send_to_user_id = get_result_check.send_to_ID_user, title = get_result_check.Subject + model.check_status, Subject = get_result_check.Message }; if (get_result_check.until != null) { if (get_result_check.until.Value.Year != 0001) { inbox.until = get_result_check.until; } } ApplicationDbContext dbcontext = new ApplicationDbContext(); dbcontext.Alert_inbox.Add(inbox); dbcontext.SaveChanges(); } //=================================================================================== return(RedirectToAction("index")); }
public ActionResult edit(TRANS_VM model) { try { 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.cost = dbcontext.CostCenter.ToList().Select(m => new { Code = m.CostCenterCode + "->" + m.CostCenterDesc, ID = m.ID }); ViewBag.shift = dbcontext.Shift_setup.ToList().Select(m => new { Code = m.Code + "->" + m.Name, ID = m.ID }); if (model.selected_employee == 0) { TempData["Message"] = HR.Resource.pers_2.youmustchooseemployee; return(View(model)); } else if (model.personnel_transaction.job_descId == "0" || model.personnel_transaction.job_descId == null) { TempData["Message"] = HR.Resource.pers_2.youmustchoosejobtitle; return(View(model)); } else if (model.personnel_transaction.SlotdescId == "0" || model.personnel_transaction.job_descId == null) { TempData["Message"] = HR.Resource.pers_2.youmustchooseslot; return(View(model)); } var record = dbcontext.personnel_transaction.FirstOrDefault(m => m.ID == model.personnel_transaction.ID); //////////////////////////////////////////////// //////////////////////////////////////////////// //////////////////////////////////////////////// record.Activity_number = model.personnel_transaction.Activity_number; record.Approved_by = model.personnel_transaction.Approved_by; record.Approved_date = model.personnel_transaction.Approved_date; // record.check_status = model.personnel_transaction.status.statu; record.Commnets = model.personnel_transaction.Commnets; record.date = model.personnel_transaction.transaction_date.ToShortDateString(); record.Fixed_basic_salary_by = model.personnel_transaction.Fixed_basic_salary_by; record.Default_location_descId = model.personnel_transaction.Default_location_descId; record.Effective_date = model.personnel_transaction.Effective_date; record.End_of_service_date = model.personnel_transaction.End_of_service_date; record.EOS_reasons = model.personnel_transaction.EOS_reasons; record.From_date = model.personnel_transaction.From_date; record.Last_working_date = model.personnel_transaction.Last_working_date; record.Memo_date = model.personnel_transaction.Memo_date; record.Memo_number = model.personnel_transaction.Memo_number; record.Months = model.personnel_transaction.Months; record.Number = model.personnel_transaction.Number; record.Position_status = model.personnel_transaction.Position_status; record.Position_transaction = model.personnel_transaction.Position_transaction; record.Recommended_by = model.personnel_transaction.Recommended_by; record.Resolution_date = model.personnel_transaction.Resolution_date; record.Resolution_number = model.personnel_transaction.Resolution_number; record.SlotdescId = model.personnel_transaction.SlotdescId; record.To_date = model.personnel_transaction.To_date; record.transaction_date = model.personnel_transaction.transaction_date; record.Transaction_type = model.personnel_transaction.Transaction_type; record.Transaction_Type_ = model.personnel_transaction.Transaction_Type_; record.cost_center_id = model.personnel_transaction.cost_center_id; record.shift_id = model.personnel_transaction.shift_id; if (model.personnel_transaction.Location_descId != "0") { var ID = int.Parse(model.personnel_transaction.Location_descId); record.work_location = dbcontext.work_location.FirstOrDefault(m => m.ID == ID); record.Location_descId = record.work_location.ID.ToString(); } else { record.work_location = null; record.Location_descId = "0"; } record.Years = model.personnel_transaction.Years; var tt = (int)record.Transaction_type; var t = (transaction_type)(int)record.Transaction_type; record.name_type = t.ToString(); if (model.selected_employee > 0) { var emp = dbcontext.Employee_Profile.FirstOrDefault(m => m.ID == model.selected_employee); record.Employee = emp; record.statID = emp.ID; } else { record.Employee = null; } if (model.personnel_transaction.job_descId != "0") { record.Job_level_gradeId = model.personnel_transaction.Job_level_gradeId; var ID = int.Parse(model.personnel_transaction.job_descId); record.job_title_cards = dbcontext.job_title_cards.FirstOrDefault(m => m.ID == ID); } else { record.job_descId = "0"; record.job_title_cards = null; } if (model.personnel_transaction.Job_level_gradeId != "0") { var ID = int.Parse(model.personnel_transaction.Job_level_gradeId); record.job_level_setup = dbcontext.job_level_setup.FirstOrDefault(m => m.ID == ID); record.Job_level_gradeId = model.personnel_transaction.Job_level_gradeId; } else { record.Job_level_gradeId = "0"; record.job_title_cards = null; } if (model.personnel_transaction.Location_descId != "0") { var ID = int.Parse(model.personnel_transaction.Location_descId); record.work_location = dbcontext.work_location.FirstOrDefault(m => m.ID == ID); record.Location_descId = record.work_location.ID.ToString(); } else { record.work_location = null; record.Location_descId = "0"; } if (model.personnel_transaction.Organization_ChartId != "0") { var ID = int.Parse(model.personnel_transaction.Organization_ChartId); record.Organization_Chart = dbcontext.Organization_Chart.FirstOrDefault(m => m.ID == ID); record.Organization_ChartId = model.personnel_transaction.Organization_ChartId; } else { record.Organization_Chart = null; record.Organization_ChartId = "0"; } //////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////// dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("personnel transaction", HR.Models.user.Action.edit, type_field.form); if (get_result_check != null) { var inbox = new Models.user.Alert_inbox { send_from_user_id = User.Identity.GetUserId(), send_to_user_id = get_result_check.send_to_ID_user, title = get_result_check.Subject, Subject = get_result_check.Message }; if (get_result_check.until != null) { if (get_result_check.until.Value.Year != 0001) { inbox.until = get_result_check.until; } } dbcontext.Alert_inbox.Add(inbox); dbcontext.SaveChanges(); } //================================================================================== return(RedirectToAction("index")); } catch (Exception e) { return(View(model)); } }
public ActionResult create() { try { 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.cost = dbcontext.CostCenter.ToList().Select(m => new { Code = m.CostCenterCode + "->" + m.CostCenterDesc, ID = m.ID }); ViewBag.shift = dbcontext.Shift_setup.ToList().Select(m => new { Code = m.Code + "->" + m.Name, ID = m.ID }); //ViewBag.Employee_Profile var all_e = new List <Employee_Profile>(); var empll = dbcontext.Employee_Profile.Where(m => m.Active == true).ToList(); foreach (var item in empll) { if (item.Employee_Positions_Profile.Count() > 0) { all_e.Add(item); } } if (all_e.Count() > 0) { ViewBag.Employee_Profile = all_e.Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); } else { ViewBag.Employee_Profile = new List <Employee_Profile>(); } ///////////////////// //////////////////// /////////////////// var stru = dbcontext.StructureModels.FirstOrDefault(m => m.All_Models == ChModels.Personnel); var model = dbcontext.personnel_transaction.ToList(); var count = 0; if (model.Count() == 0) { count = 1; } else { var te = model.LastOrDefault().ID; count = te + 1; } DateTime statis = Convert.ToDateTime(DateTime.Now.ToShortDateString()).Date; ViewBag.da = statis; var vm = new personnel_transaction { Number = stru.Structure_Code + count, End_of_service_date = statis, Position_Transaction_number = stru.Structure_Code + count, From_date = statis, Last_working_date = statis, To_date = statis, Position_transaction = statis, Approved_date = statis, Memo_date = statis, Resolution_date = statis, job_descId = "0", Job_level_gradeId = "0", Location_descId = "0", Default_location_descId = "0", Organization_ChartId = "0", SlotdescId = "0", Transaction_type = transaction_type.assignment, transaction_date = DateTime.Now.Date, Effective_date = DateTime.Now.Date , cost_center_id = 0, shift_id = 0 }; var mymodel = new TRANS_VM { personnel_transaction = vm, selected_employee = 0 }; // var PositionInformation = new Position_Information(); return(View(mymodel)); } catch (Exception e) { return(View()); } }
public ActionResult create(TRANS_VM model) { try { if (model.personnel_transaction.job_descId == null) { model.personnel_transaction.job_descId = "0"; } if (model.personnel_transaction.Default_location_descId == null) { model.personnel_transaction.Default_location_descId = "0"; } if (model.personnel_transaction.Location_descId == null) { model.personnel_transaction.Location_descId = "0"; } if (model.personnel_transaction.Job_level_gradeId == null) { model.personnel_transaction.Job_level_gradeId = "0"; } if (model.personnel_transaction.SlotdescId == null) { model.personnel_transaction.SlotdescId = "0"; } if (model.personnel_transaction.Organization_ChartId == null) { model.personnel_transaction.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.Employee_Profile = dbcontext.Employee_Profile.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.cost = dbcontext.CostCenter.ToList().Select(m => new { Code = m.CostCenterCode + "->" + m.CostCenterDesc, ID = m.ID }); ViewBag.shift = dbcontext.Shift_setup.ToList().Select(m => new { Code = m.Code + "->" + m.Name, ID = m.ID }); if (ModelState.IsValid) { if (model.selected_employee == 0) { TempData["Message"] = HR.Resource.pers_2.youmustchooseemployee; return(View(model)); } else if (model.personnel_transaction.job_descId == "0" || model.personnel_transaction.job_descId == null) { TempData["Message"] = HR.Resource.pers_2.youmustchoosejobtitle; return(View(model)); } else if (model.personnel_transaction.SlotdescId == "0" || model.personnel_transaction.job_descId == null) { TempData["Message"] = HR.Resource.pers_2.youmustchooseslot; return(View(model)); } var mymodel = new personnel_transaction(); mymodel = model.personnel_transaction; ///////////////status//////////////////////// mymodel.check_status = check_status.created; mymodel.ss = mymodel.check_status.GetTypeCode().ToString(); var Date = Convert.ToDateTime("1/1/1900"); var s = new status { statu = check_status.created, Type = Models.Infra.Type.employee_record, approved_bydate = Date, cancaled_bydate = Date, created_bydate = DateTime.Now.Date, Rejected_bydate = Date, return_to_reviewdate = Date }; s.created_by = User.Identity.GetUserName(); var st = dbcontext.status.Add(s); dbcontext.SaveChanges(); mymodel.status = st; mymodel.date = mymodel.transaction_date.ToShortDateString(); mymodel.name_state = nameof(check_status.created); var tt = (int)mymodel.Transaction_type; var t = (transaction_type)(int)mymodel.Transaction_type; mymodel.name_type = t.ToString(); if (model.selected_employee > 0) { var emp = dbcontext.Employee_Profile.FirstOrDefault(m => m.ID == model.selected_employee); mymodel.Employee = emp; mymodel.statID = emp.ID; } else { mymodel.Employee = null; } if (model.personnel_transaction.job_descId != "0") { mymodel.Job_level_gradeId = model.personnel_transaction.Job_level_gradeId; var ID = int.Parse(model.personnel_transaction.job_descId); mymodel.job_title_cards = dbcontext.job_title_cards.FirstOrDefault(m => m.ID == ID); } else { mymodel.job_descId = "0"; mymodel.job_title_cards = null; } if (model.personnel_transaction.Job_level_gradeId != "0") { var ID = int.Parse(model.personnel_transaction.Job_level_gradeId); mymodel.job_level_setup = dbcontext.job_level_setup.FirstOrDefault(m => m.ID == ID); mymodel.Job_level_gradeId = model.personnel_transaction.Job_level_gradeId; } else { mymodel.Job_level_gradeId = "0"; mymodel.job_title_cards = null; } if (model.personnel_transaction.Location_descId != "0") { var ID = int.Parse(model.personnel_transaction.Location_descId); mymodel.work_location = dbcontext.work_location.FirstOrDefault(m => m.ID == ID); mymodel.Location_descId = mymodel.work_location.ID.ToString(); } else { mymodel.work_location = null; mymodel.Location_descId = "0"; } if (model.personnel_transaction.Organization_ChartId != "0") { var ID = int.Parse(model.personnel_transaction.Organization_ChartId); mymodel.Organization_Chart = dbcontext.Organization_Chart.FirstOrDefault(m => m.ID == ID); mymodel.Organization_ChartId = model.personnel_transaction.Organization_ChartId; } else { mymodel.Organization_Chart = null; mymodel.Organization_ChartId = "0"; } mymodel.name_state = nameof(check_status.created); dbcontext.personnel_transaction.Add(mymodel); //var record = dbcontext.Position_Information.FirstOrDefault(m => m.ID == emp.Employee_Positions_Profile.ID); //record.Primary_Position = model.Primary_Position; //record.From_date = model.From_date; //record.To_date = model.To_date; //record.Years = model.Years; //record.Months = model.Months; //record.End_of_service_date = model.End_of_service_date; //record.Last_working_date = model.Last_working_date; //record.Commnets = model.Commnets; //record.working_system = model.working_system; //record.Position_status = model.Position_status; //record.EOS_reasons = model.EOS_reasons; //record.Employee_ProfileId = model.Employee_ProfileId; //var Employee_ProfileId = int.Parse(model.Employee_ProfileId); //record.Code = model.Code; //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(); //Position_Transaction_Information information = new Position_Transaction_Information(); //information.Position_transaction = model.Position_transaction; //information.Position_transaction_no = model.Position_transaction_no; //information.Transaction_Type = model.Transaction_Type; //information.Fixed_basic_salary_by = model.Fixed_basic_salary_by; //information.Activity_number = model.Activity_number; information.Position_transaction = model.Position_transaction; //information.Memo_number = model.Memo_number; //information.Resolution_number = model.Resolution_number; //information.Approved_by = model.Approved_by; //information.Recommended_by = model.Recommended_by; //information.Approved_date = model.Approved_date; //information.Memo_date = model.Memo_date; //information.Resolution_date = model.Resolution_date; dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("personnel transaction", HR.Models.user.Action.Create, type_field.form); if (get_result_check != null) { var inbox = new Models.user.Alert_inbox { send_from_user_id = User.Identity.GetUserId(), send_to_user_id = get_result_check.send_to_ID_user, title = get_result_check.Subject, Subject = get_result_check.Message }; if (get_result_check.until != null) { if (get_result_check.until.Value.Year != 0001) { inbox.until = get_result_check.until; } } dbcontext.Alert_inbox.Add(inbox); dbcontext.SaveChanges(); } //================================================================================== //if (command == "Submit") //{ // return RedirectToAction("edit", "Employee_Profile", new { id = int.Parse(record.Employee_ProfileId) }); //} return(RedirectToAction("Index")); } else { return(View(model)); } } catch (DbUpdateException e) { TempData["Message"] = HR.Resource.Basic.thiscodeIsalreadyexists; return(View(model)); } catch (Exception e) { return(View(model)); } }