public ActionResult Create(string id) { ViewBag.Educate_category = dbcontext.Educate_category.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.Educate_Title = dbcontext.Educate_Title.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.Main_Educate_body = dbcontext.Main_Educate_body.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.Sub_educational_body = dbcontext.Sub_educational_body.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.Name_of_educational_qualification = dbcontext.Name_of_educational_qualification.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.Qualification_Major = dbcontext.Qualification_Major.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.GradeEducate = dbcontext.GradeEducate.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.Employee_Profile = dbcontext.Employee_Profile.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.idemp = id; var stru = dbcontext.StructureModels.FirstOrDefault(m => m.All_Models == ChModels.Personnel); var model = dbcontext.Employee_Qualification_Profile.ToList(); var count = 0; if (model.Count() == 0) { count = 1; } else { var te = model.LastOrDefault().ID; count = te + 1; } var ID = int.Parse(id); var emp = dbcontext.Employee_Profile.FirstOrDefault(m => m.ID == ID); DateTime statis = Convert.ToDateTime("1/1/1900");//emp.ID.ToString() var EmployeeQualification = new Employee_Qualification_Profile { Employee_Profile = emp, Employee_ProfileId = id, Code = stru.Structure_Code + count.ToString(), Qualification_start_date = statis, Qualification_end_date = statis, Allowance_value = 0.0 }; return(View(EmployeeQualification)); }
public ActionResult Create(Employee_Qualification_Profile model, string command) { try { ViewBag.Employee_Profile = dbcontext.Employee_Profile.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.Educate_category = dbcontext.Educate_category.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.Educate_Title = dbcontext.Educate_Title.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.Main_Educate_body = dbcontext.Main_Educate_body.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.Sub_educational_body = dbcontext.Sub_educational_body.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.Name_of_educational_qualification = dbcontext.Name_of_educational_qualification.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.Qualification_Major = dbcontext.Qualification_Major.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.GradeEducate = dbcontext.GradeEducate.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); var empId = int.Parse(model.Employee_ProfileId); var EmpObj = dbcontext.Employee_Profile.FirstOrDefault(a => a.ID == empId); Employee_Qualification_Profile record = new Employee_Qualification_Profile(); var empid = EmpObj.Code + "------" + EmpObj.Name; record.Employee_ProfileId = model.Employee_ProfileId == null ? model.Employee_ProfileId = EmpObj.ID.ToString() : model.Employee_ProfileId; ViewBag.idemp = model.Employee_ProfileId; record.Employee_Profile = EmpObj; record.Code = model.Code; if (ModelState.IsValid) { if (model.Educate_categoryId == "0" || model.Educate_categoryId == null) { ModelState.AddModelError("", HR.Resource.Personnel.EducatecategoryCodemustenter); return(View(model)); } if (model.Educate_TitleId == "0" || model.Educate_TitleId == null) { ModelState.AddModelError("", HR.Resource.Personnel.EducateTitleCodemustenter); return(View(model)); } if (model.Main_Educate_bodyId == "0" || model.Main_Educate_bodyId == null) { ModelState.AddModelError("", HR.Resource.Personnel.MainEducatebodyCodemustenter); return(View(model)); } if (model.Sub_educational_bodyId == "0" || model.Sub_educational_bodyId == null) { ModelState.AddModelError("", HR.Resource.Personnel.SubeducationalbodyCodemustenter); return(View(model)); } if (model.Name_of_educational_qualificationId == "0" || model.Name_of_educational_qualificationId == null) { ModelState.AddModelError("", HR.Resource.Personnel.NameofeducationalqualificationCodemustenter); return(View(model)); } if (model.Qualification_MajorId == "0" || model.Qualification_MajorId == null) { ModelState.AddModelError("", HR.Resource.Personnel.QualificationMajorCodemustenter); return(View(model)); } if (model.GradeEducateId == "0" || model.GradeEducateId == null) { ModelState.AddModelError("", HR.Resource.Personnel.GradeEducateCodemustenter); return(View(model)); } if (model.Employee_ProfileId == "0" || model.Employee_ProfileId == null) { ModelState.AddModelError("", HR.Resource.Personnel.EmployeeProfileCodemustenter); return(View(model)); } // var prof = int.Parse(model.Employee_ProfileId); // var emp = dbcontext.Employee_Profile.FirstOrDefault(m => m.ID == prof); // var record = dbcontext.Employee_Qualification_Profile.FirstOrDefault(m => m.ID == emp.Employee_Qualification_Profile.ID); record.Related_to_job = model.Related_to_job; record.Qualification_start_date = model.Qualification_start_date; record.Qualification_end_date = model.Qualification_end_date; if (model.Qualification_start_date > model.Qualification_end_date) { TempData["Message"] = HR.Resource.Personnel.QualificationstartdatebiggerQualificationenddate; return(View(model)); } record.Years = model.Years; record.Months = model.Months; record.Extra_education_years = model.Extra_education_years; record.Allowance_value = model.Allowance_value; //record.Employee_ProfileId = model.Employee_ProfileId; //var Employee_ProfileId = int.Parse(model.Employee_ProfileId); record.Educate_categoryId = model.Educate_categoryId; var Educate_categoryId = int.Parse(model.Educate_categoryId); record.Educate_category = dbcontext.Educate_category.FirstOrDefault(m => m.ID == Educate_categoryId); record.Educate_TitleId = model.Educate_TitleId; var Educate_TitleId = int.Parse(model.Educate_TitleId); record.Educate_Title = dbcontext.Educate_Title.FirstOrDefault(m => m.ID == Educate_TitleId); record.Main_Educate_bodyId = model.Main_Educate_bodyId; var Main_Educate_bodyId = int.Parse(model.Main_Educate_bodyId); record.Main_Educate_body = dbcontext.Main_Educate_body.FirstOrDefault(m => m.ID == Main_Educate_bodyId); record.Sub_educational_bodyId = model.Sub_educational_bodyId; var Sub_educational_bodyId = int.Parse(model.Sub_educational_bodyId); record.Sub_educational_body = dbcontext.Sub_educational_body.FirstOrDefault(m => m.ID == Sub_educational_bodyId); record.Name_of_educational_qualificationId = model.Name_of_educational_qualificationId; var Name_of_educational_qualificationId = int.Parse(model.Name_of_educational_qualificationId); record.Name_of_educational_qualification = dbcontext.Name_of_educational_qualification.FirstOrDefault(m => m.ID == Name_of_educational_qualificationId); record.Qualification_MajorId = model.Qualification_MajorId; var Qualification_MajorId = int.Parse(model.Qualification_MajorId); record.Qualification_Major = dbcontext.Qualification_Major.FirstOrDefault(m => m.ID == Qualification_MajorId); record.GradeEducateId = model.GradeEducateId; var GradeEducateId = int.Parse(model.GradeEducateId); record.GradeEducate = dbcontext.GradeEducate.FirstOrDefault(m => m.ID == GradeEducateId); dbcontext.Employee_Qualification_Profile.Add(record); dbcontext.SaveChanges(); if (command == "Submit") { return(RedirectToAction("edit", "Employee_Profile", new { id = int.Parse(record.Employee_ProfileId) })); } return(RedirectToAction("Index", new { id = model.Employee_ProfileId })); } else { return(View(model)); } } catch (DbUpdateException e) { TempData["Message"] = HR.Resource.Basic.thiscodeIsalreadyexists; return(View(model)); } catch (Exception e) { return(View(model)); } }