public ActionResult Edit(Air_ports model) { try { var record = dbcontext.Air_ports.FirstOrDefault(m => m.ID == model.ID); ViewBag.country = dbcontext.Country.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); ViewBag.area = new List <Area>(); ViewBag.state = new List <the_states>(); if (record.countryid > 0) { ViewBag.area = dbcontext.Area.Where(m => m.Countryid == record.countryid.ToString()).ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); } if (record.areaid > 0) { ViewBag.state = dbcontext.the_states.Where(m => m.Areaid == record.areaid.ToString()).ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); } if (model.the_statesid == "0" || model.the_statesid == null) { ModelState.AddModelError("", HR.Resource.Basic.StateCodemustenter); return(View(model)); } record.Name = model.Name; record.Description = model.Description; record.countryid = model.countryid; record.areaid = model.areaid; record.Code = model.Code; record.the_statesid = model.the_statesid; var the_statesid = int.Parse(model.the_statesid); record.the_states = dbcontext.the_states.FirstOrDefault(m => m.ID == the_statesid); dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("air port", HR.Models.user.Action.edit, 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, 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")); } catch (DbUpdateException) { TempData["Message"] = HR.Resource.Basic.thiscodeIsalreadyexists; return(View(model)); } catch (Exception e) { return(View(model)); } }
public ActionResult Deletemethod(int id) { var record = dbcontext.Cours.FirstOrDefault(m => m.ID == id); var quli = dbcontext.CourceQualification.Where(m => m.Course_Code == record.ID.ToString()).ToList(); var center = dbcontext.Course_Centers.Where(m => m.Course_Code == record.ID.ToString()).ToList(); var skill = dbcontext.Course_Skills.Where(m => m.Course_Code == record.ID.ToString()).ToList(); var type = dbcontext.Course_TrainingType.Where(m => m.Course_Code == record.ID.ToString()).ToList(); try { dbcontext.Cours.Remove(record); if (quli.Count > 0) { dbcontext.CourceQualification.RemoveRange(quli); } if (center.Count > 0) { dbcontext.Course_Centers.RemoveRange(center); } if (skill.Count > 0) { dbcontext.Course_Skills.RemoveRange(skill); } if (type.Count > 0) { dbcontext.Course_TrainingType.RemoveRange(type); } dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("course carde", HR.Models.user.Action.delete, 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, 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")); } catch (DbUpdateException) { TempData["Message"] = HR.Resource.Basic.youcannotdeletethisRow; return(View(record)); } catch (Exception e) { return(View(record)); } }
public ActionResult Deletemethod(int id) { try { var record = dbcontext.Educate_category.FirstOrDefault(m => m.ID == id); dbcontext.Educate_category.Remove(record); dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("qulification category", HR.Models.user.Action.delete, 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, 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")); } catch (Exception e) { return(View()); } }
public ActionResult create(FormCollection form, CourceQualification model) { try { ViewBag.quli_name = dbcontext.Name_of_educational_qualification.ToList().Select(m => new { Code = m.Code + "-[" + m.Name + ']', ID = m.ID }); ViewBag.course = dbcontext.Cours.ToList().Select(m => new { Code = m.Course_Code + "-[" + m.Course_Desc + ']', ID = m.ID }); ViewBag.spe1 = dbcontext.Qualification_Major.ToList().Select(m => new { Code = m.Code + "-[" + m.Name + ']', ID = m.ID }); //================================ var quli_name = form["quli_id"].Split(','); var spec = form["spec_id"].Split(','); for (var i = 0; i < quli_name.Length; i++) { if (quli_name[i] != "") { var ID = int.Parse(quli_name[i]); var quli = dbcontext.Name_of_educational_qualification.FirstOrDefault(m => m.ID == ID); var ID_spe = int.Parse(spec[i]); var spe = dbcontext.Qualification_Major.FirstOrDefault(m => m.ID == ID_spe); var Cource_Qualification = new CourceQualification { quli_name_des = quli.Code + "-" + quli.Name, QualificationName_Code = quli.ID.ToString(), quli_spec_des = spe.Code + "-" + quli.Name, QualificationSpecialty_Code = spe.ID.ToString(), Course_Code = model.Course_Code, Created_By = User.Identity.Name, Created_Date = DateTime.Now.Date }; dbcontext.CourceQualification.Add(Cource_Qualification); dbcontext.SaveChanges(); } } //================================ //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("course qulifications carde", 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, 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")); } catch (DbUpdateException e) { TempData["Message"] = HR.Resource.Basic.thiscodeIsalreadyexists; return(View()); } catch (Exception e) { return(View()); } }
public ActionResult Create(External_compaines model) { try { if (ModelState.IsValid) { External_compaines record = new External_compaines(); record.Name = model.Name; record.Description = model.Description; record.Code = model.Code; record.oil_sector = model.oil_sector; record.address = model.address; if (model.oil_sector == true) { record.Company_type = model.Company_type; } else { record.Company_type = Company_type.None; } dbcontext.External_compaines.Add(record); dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("external companies", 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, 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")); } else { return(View(model)); } } catch (DbUpdateException) { TempData["Message"] = HR.Resource.Basic.thiscodeIsalreadyexists; return(View(model)); } catch (Exception e) { return(View(model)); } }
public ActionResult Create(Header model, FormCollection form) { try { ViewBag.salaryitem = dbcontext.salary_code.ToList().Select(m => new { Code = m.SalaryCodeID + "-[" + m.SalaryCodeDesc + ']', ID = m.ID }); var new_Record = model.SalaryItemCollectionGroup_Header; new_Record.EligibilityType = model.Eligibility.GetHashCode(); new_Record.GroupPurpose = model.group_purpose.GetHashCode(); new_Record.CodeGroupType = model.code_group_type.GetHashCode(); new_Record.Created_By = User.Identity.Name; new_Record.Created_Date = DateTime.Now.Date; var Header = dbcontext.SalaryCodeGroup_Header.Add(new_Record); dbcontext.SaveChanges(); /////////////////// var ID_item = form["ID_item"].Split(','); var value = form["value"].Split(','); var sort = form["sort"].Split(','); for (var i = 0; i < ID_item.Length; i++) { if (ID_item[i] != "") { var ID = int.Parse(ID_item[i]); var item = dbcontext.salary_code.FirstOrDefault(m => m.ID == ID); var new_details = new SalaryCodeGroup_Detail { salary_codeID = item.ID, CodeGroupID = Header.CodeGroupID, Created_By = User.Identity.Name, Created_Date = DateTime.Now.Date, SalaryCodeID = item.SalaryCodeID, SortIndex = int.Parse(sort[i]), DefaultValue = int.Parse(value[i]) }; dbcontext.SalaryCodeGroup_Detail.Add(new_details); dbcontext.SaveChanges(); } } //////////////// //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("Salary item group card", 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, 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")); } catch (Exception) { return(View(model)); } }
public ActionResult Edit(Qualification_Major model) { ViewBag.titleee = dbcontext.Educate_Title.ToList().Select(m => new { Code = m.Code + "----" + m.Name, ID = m.ID }); if (model.Educate_Titleid > 0) { ViewBag.name = dbcontext.Name_of_educational_qualification.Where(m => m.Educate_Titleid == model.Educate_Titleid).ToList().Select(m => new { Code = m.Code + "----" + m.Name, ID = m.ID }); } else { ViewBag.name = new List <Name_of_educational_qualification>(); } try { if (model.Name_of_educational_qualificationid <= 0) { ModelState.AddModelError("", HR.Resource.Basic.requiredName_of_educational_qualification); return(View(model)); } var record = dbcontext.Qualification_Major.FirstOrDefault(m => m.ID == model.ID); record.Name = model.Name; record.Description = model.Description; record.Name_of_educational_qualificationid = model.Name_of_educational_qualificationid; record.Educate_Titleid = model.Educate_Titleid; record.Code = model.Code; record.Name_of_educational_qualification = dbcontext.Name_of_educational_qualification.FirstOrDefault(m => m.ID == model.Name_of_educational_qualificationid); dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("qulification specialty", HR.Models.user.Action.edit, 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, 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")); } catch (DbUpdateException) { TempData["Message"] = HR.Resource.Basic.thiscodeIsalreadyexists; return(View(model)); } catch (Exception e) { return(View(model)); } }
public ActionResult Create(Job_title_sub_class model) { try { ViewBag.Job_title_class = dbcontext.Job_title_class.ToList().Select(m => new { ID = m.ID, Code = m.Code + "->" + m.Name }); if (ModelState.IsValid) { Job_title_sub_class record = new Job_title_sub_class(); record.Name = model.Name; record.Description = model.Description; record.Code = model.Code; record.Job_title_classId = model.Job_title_classId; var ID = int.Parse(model.Job_title_classId); record.JOB_TYPE_ALLWANCE_PERCENTAGE = model.JOB_TYPE_ALLWANCE_PERCENTAGE; record.Dedicated_ALLWANCE_VALUE = model.Dedicated_ALLWANCE_VALUE; record.Exchanging_ALLWANCE_VALUE = model.Exchanging_ALLWANCE_VALUE; record.Job_title_class = dbcontext.Job_title_class.FirstOrDefault(m => m.ID == ID); dbcontext.Job_title_sub_class.Add(record); dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("job title sub class", 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, 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")); } else { return(View(model)); } } catch (DbUpdateException) { TempData["Message"] = HR.Resource.Basic.thiscodeIsalreadyexists; return(View(model)); } catch (Exception e) { return(View(model)); } }
public ActionResult Edit(Job_level_class model, string command) { try { var record = dbcontext.Job_level_class.FirstOrDefault(m => m.ID == model.ID); record.Name = model.Name; record.Description = model.Description; record.Code = model.Code; record.max_annual_increase_percentage = model.max_annual_increase_percentage; record.max_basic_salary = model.max_basic_salary; record.max_incentive_amount = model.max_incentive_amount; record.max_incentive_percentage = model.max_incentive_percentage; record.max_monthly_allowance = model.max_monthly_allowance; record.mid_basic_salary = model.mid_basic_salary; record.min_basic_salary = model.min_basic_salary; record.min_working_years = model.min_working_years; record.representation_allowance_value = model.representation_allowance_value; record.dedicated_allowence = model.dedicated_allowence; dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("job level class", HR.Models.user.Action.edit, 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, 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(); } //=================================================================================== var spe = dbcontext.Special_Allwonce_History.FirstOrDefault(m => m.selectedID == record.ID && m.type_allowance == type_allowance.job_level_class); if (command == "Submit") { return(RedirectToAction("allowance", new { id = record.ID, type = 1 })); } ; return(RedirectToAction("index")); } catch (DbUpdateException) { TempData["Message"] = HR.Resource.Basic.thiscodeIsalreadyexists; return(View(model)); } catch (Exception e) { return(View(model)); } }
public ActionResult delete_method(string id) { var ID = int.Parse(id); var model = dbcontext.Budget.FirstOrDefault(m => m.ID == ID); var details = new List <int>(); foreach (var item in model.Budget_details) { details.Add(item.ID); } try { var j = model.justification; var s = model.status; dbcontext.Budget.Remove(model); dbcontext.SaveChanges(); foreach (var item in details) { var d = dbcontext.Budget_details.FirstOrDefault(m => m.ID == item); dbcontext.Budget_details.Remove(d); dbcontext.SaveChanges(); } dbcontext.status.Remove(s); dbcontext.justification.Remove(j); dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("budget card", HR.Models.user.Action.delete, 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, 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")); } catch (DbUpdateException e) { TempData["Message"] = HR.Resource.organ.youcannotdeletethisRow; return(View(model)); } catch (Exception e) { return(View()); } }
public ActionResult Create(Sponsor model) { try { if (ModelState.IsValid) { Sponsor record = new Sponsor(); record.Name = model.Name; record.Description = model.Description; record.Code = model.Code; record.IBAN = model.IBAN; record.Others1 = model.Others1; record.Others2 = model.Others2; record.Others3 = model.Others3; record.sponsorid = model.sponsorid; record.corporation = model.corporation; dbcontext.Sponsor.Add(record); dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("sponsors", 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, 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")); } else { return(View(model)); } } catch (DbUpdateException) { TempData["Message"] = HR.Resource.Basic.thiscodeIsalreadyexists; return(View(model)); } catch (Exception e) { return(View(model)); } }
public ActionResult create(FormCollection form, Course_Skills model) { try { ViewBag.centers = dbcontext.Skill.ToList().Select(m => new { Code = m.Code + "-[" + m.Name + ']', ID = m.ID }); ViewBag.course = dbcontext.Cours.ToList().Select(m => new { Code = m.Course_Code + "-[" + m.Course_Desc + ']', ID = m.ID }); //================================ var center_D = form["center_id"].Split(','); for (var i = 0; i < center_D.Length; i++) { if (center_D[i] != "") { var ID = int.Parse(center_D[i]); var CENTER = dbcontext.Skill.FirstOrDefault(m => m.ID == ID); var Cource_cen = new Course_Skills { Course_Code = model.Course_Code, skill_des = CENTER.Code + "-" + CENTER.Name, Skill_Code = CENTER.ID.ToString(), Created_By = User.Identity.Name, Created_Date = DateTime.Now.Date }; dbcontext.Course_Skills.Add(Cource_cen); dbcontext.SaveChanges(); } } //================================ //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("course skills carde", 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, 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")); } catch (DbUpdateException e) { TempData["Message"] = HR.Resource.Basic.thiscodeIsalreadyexists; return(View()); } catch (Exception e) { return(View()); } }
public ActionResult Create(work_location model) { try { ViewBag.Shiftdaystatus = dbcontext.Shiftdaystatus.ToList().Select(m => new { Code = m.Code + "-[" + m.Name + ']', ID = m.ID }); if (ModelState.IsValid) { work_location record = new work_location(); record.Name = model.Name; record.Description = model.Description; record.Code = model.Code; record.Location_name = model.Location_name; record.Defaultdaystatuscode = model.Defaultdaystatuscode; record.Absencedaystatus = model.Absencedaystatus; var location = dbcontext.work_location.Add(record); dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("work locations", 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, 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")); } else { return(View(model)); } } catch (DbUpdateException e) { TempData["Message"] = HR.Resource.Basic.thiscodeIsalreadyexists; return(View(model)); } catch (Exception e) { return(View(model)); } }
public ActionResult Create(Country model, string command) { try { if (ModelState.IsValid) { Country record = new Country(); record.Name = model.Name; record.Description = model.Description; record.Code = model.Code; var re = dbcontext.Country.Add(record); dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("country", 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, 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(); } //=================================================================================== if (command == "Submit") { return(RedirectToAction("Create", "Area", new { id = re.ID })); } return(RedirectToAction("Index")); } else { return(View(model)); } } catch (DbUpdateException) { TempData["Message"] = HR.Resource.Basic.thiscodeIsalreadyexists; return(View(model)); } catch (Exception e) { var type = e.GetType().ToString(); return(View(model)); } }
public ActionResult Create(Organization_Unit_Type model) { try { ViewBag.Organization_Unit_Schema = dbcontext.Organization_Unit_Schema.ToList().Select(m => new { ID = m.ID, Code = m.Code + "->" + m.Name }); ViewBag.Organization_Unit_Level = dbcontext.Organization_Unit_Level.ToList().Select(m => new { ID = m.ID, Code = m.Code + "->" + m.Name }); if (ModelState.IsValid) { Organization_Unit_Type record = new Organization_Unit_Type(); record.Name = model.Name; record.Description = model.Description; record.Code = model.Code; record.Organization_Unit_LevelID = model.Organization_Unit_LevelID; record.Organization_Unit_SchemaID = model.Organization_Unit_SchemaID; dbcontext.Organization_Unit_Type.Add(record); dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("organization unit level", 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, 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")); } else { return(View(model)); } } catch (DbUpdateException) { TempData["Message"] = HR.Resource.Basic.thiscodeIsalreadyexists; return(View(model)); } catch (Exception e) { return(View(model)); } }
public ActionResult Create(Sub_educational_body model) { try { ViewBag.main = dbcontext.Main_Educate_body.ToList().Select(m => new { Code = m.Code + "----" + m.Name, ID = m.ID }); if (ModelState.IsValid) { Sub_educational_body record = new Sub_educational_body(); record.Name = model.Name; record.Description = model.Description; record.Main_Educate_bodyid = model.Main_Educate_bodyid; record.Code = model.Code; record.Main_Educate_body = dbcontext.Main_Educate_body.FirstOrDefault(m => m.ID == model.Main_Educate_bodyid); dbcontext.Sub_educational_body.Add(record); dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("qulification sub provider", 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, 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")); } else { return(View(model)); } } catch (DbUpdateException) { TempData["Message"] = "this code Is already exists"; return(View(model)); } catch (Exception e) { return(View(model)); } }
public ActionResult Create(Documents model) { try { ViewBag.Document_Group = dbcontext.Document_Group.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); if (ModelState.IsValid) { Documents record = new Documents(); record.Name = model.Name; record.Description = model.Description; record.Document_Groupid = model.Document_Groupid; record.Code = model.Code; var id = int.Parse(model.Document_Groupid); record.Document_Group = dbcontext.Document_Group.FirstOrDefault(m => m.ID == id); dbcontext.Documents.Add(record); dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("documents", 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, 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")); } else { return(View(model)); } } catch (DbUpdateException) { TempData["Message"] = HR.Resource.Basic.thiscodeIsalreadyexists; return(View(model)); } catch (Exception e) { return(View(model)); } }
public ActionResult Edit(Area model, string command) { try { ViewBag.country = dbcontext.Country.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); if (model.Countryid == "0" || model.Countryid == null) { ModelState.AddModelError("", HR.Resource.Basic.countryCodemustenter1); return(View(model)); } var record = dbcontext.Area.FirstOrDefault(m => m.ID == model.ID); record.Name = model.Name; record.Description = model.Description; record.Countryid = model.Countryid; record.Code = model.Code; var countryid = int.Parse(model.Countryid); record.Country = dbcontext.Country.FirstOrDefault(m => m.ID == countryid); dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("region", HR.Models.user.Action.edit, 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, 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(); } //=================================================================================== if (command == "Submit") { return(RedirectToAction("Create", "State", new { id = record.ID })); } return(RedirectToAction("index")); } catch (DbUpdateException) { TempData["Message"] = HR.Resource.Basic.thiscodeIsalreadyexists; return(View(model)); } catch (Exception e) { return(View(model)); } }
public ActionResult Create(Currency model) { try { if (ModelState.IsValid) { Currency record = new Currency(); record.Name = model.Name; record.Description = model.Description; record.Code = model.Code; record.Native = model.Native; record.Nmmber_of_decimal_places = model.Nmmber_of_decimal_places; record.symbol = model.symbol; dbcontext.Currency.Add(record); dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("currency", 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, 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")); } else { return(View(model)); } } catch (DbUpdateException) { TempData["Message"] = HR.Resource.Basic.thiscodeIsalreadyexists; return(View(model)); } catch (Exception e) { return(View(model)); } }
public ActionResult Create(Exchange_Rate model) { try { ViewBag.country = dbcontext.Currency.ToList().Select(m => new { Code = m.Code + "------[" + m.Name + ']', ID = m.ID }); if (ModelState.IsValid) { Exchange_Rate record = new Exchange_Rate(); record.CurrencyID = model.CurrencyID; record.Currency = dbcontext.Currency.FirstOrDefault(m => m.ID == model.CurrencyID); record.Year = model.Year; record.months = model.months; dbcontext.Exchange_Rate.Add(record); dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("exchange rate", 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, 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")); } else { return(View(model)); } } catch (DbUpdateException) { TempData["Message"] = HR.Resource.Basic.thiscodeIsalreadyexists; return(View(model)); } catch (Exception e) { return(View(model)); } }
public ActionResult Create(ClassRoom model) { try { ViewBag.branches = dbcontext.TrainingCenters_Branch_Contact.ToList().Select(m => new { Code = m.Branch_Code + "-[" + m.Contact_Method_Detail + ']', ID = m.ID }); ViewBag.centers = dbcontext.TrainingCenter.ToList().Select(m => new { Code = m.TrainingCenters_Code + "-[" + m.TrainingCenters_Desc + ']', ID = m.ID }); ViewBag.class_group = dbcontext.ClassRoom_Group.ToList().Select(m => new { Code = m.ClassRoom_Group_Code + "-[" + m.ClassRoom_Group_Desc + ']', ID = m.ID }); if (ModelState.IsValid) { model.Created_By = User.Identity.Name; model.Created_Date = DateTime.Now.Date; dbcontext.ClassRoom.Add(model); dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("class room", 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, 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")); } else { return(View(model)); } } catch (DbUpdateException e) { TempData["Message"] = HR.Resource.Basic.thiscodeIsalreadyexists; return(View(model)); } catch (Exception e) { return(View(model)); } }
public ActionResult Create(TrainingCenter model, string command) { try { if (ModelState.IsValid) { model.Created_By = User.Identity.Name; model.Created_Date = DateTime.Now.Date; var tra_center = dbcontext.TrainingCenter.Add(model); dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("training center", 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, 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(); } //=================================================================================== if (command == "Submit") { return(RedirectToAction("Create", "Postalcode", new { id = tra_center.ID })); } 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)); } }
public ActionResult Edit(FormCollection form, EvaluationElements model) { try { ViewBag.competitions = reposatorycomp.GetAll().Select(m => new { Code = m.Code + "-->" + m.Name, ID = m.ID }); model.Evalution_and_competencies = reposatoryelement.Find2(model.ID).Evalution_and_competencies; if (ModelState.IsValid) { var flag = reposatoryelement.Editone(form, model); if (flag) { TempData["Message"] = HR.Resource.pers_2.addedSuccessfully; //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("evaluation elements", HR.Models.user.Action.edit, 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, 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")); } else { TempData["Message"] = HR.Resource.pers_2.Faild; return(View(model)); } } else { TempData["Message"] = HR.Resource.pers_2.Faild; return(View(model)); } } catch (Exception) { TempData["Message"] = HR.Resource.pers_2.Faild; return(View(model)); } }
public ActionResult Edit(Name_of_educational_qualification model, string command) { try { ViewBag.titleee = dbcontext.Educate_Title.ToList().Select(m => new { Code = m.Code + "----" + m.Name, ID = m.ID }); var record = dbcontext.Name_of_educational_qualification.FirstOrDefault(m => m.ID == model.ID); record.Name = model.Name; record.Description = model.Description; record.Educate_Titleid = model.Educate_Titleid; record.Code = model.Code; record.Educate_Title = dbcontext.Educate_Title.FirstOrDefault(m => m.ID == model.Educate_Titleid); dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("qulification name", HR.Models.user.Action.edit, 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, 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(); } //=================================================================================== if (command == "sub") { return(RedirectToAction("link", "Name_of_educational_qualification", new { id = record.ID, tag = "0" })); } if (command == "Submit1") { return(RedirectToAction("Create", "QualificationMajor", new { id = record.ID })); } return(RedirectToAction("index")); } catch (DbUpdateException) { TempData["Message"] = HR.Resource.Basic.thiscodeIsalreadyexists; return(View(model)); } catch (Exception e) { return(View(model)); } }
public ActionResult Edit(HR.Models.EvaluationElementCompetenies model) { try { if (ModelState.IsValid) { var flag = reposatoryEvaluationElementCompetenies.Editone(model); if (flag) { TempData["Message"] = HR.Resource.pers_2.addedSuccessfully; //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("evaluation elements competencies", HR.Models.user.Action.edit, 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, 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")); } else { TempData["Message"] = HR.Resource.pers_2.Faild; return(View(model)); } } else { TempData["Message"] = HR.Resource.pers_2.Faild; return(View(model)); } } catch (Exception) { TempData["Message"] = HR.Resource.pers_2.Faild; return(View(model)); } }
public ActionResult Create(Military_Service_Rank model) { try { if (ModelState.IsValid) { Military_Service_Rank record = new Military_Service_Rank(); record.Name = model.Name; record.Description = model.Description; record.Code = model.Code; dbcontext.Military_Service_Rank.Add(record); dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("milirity service rank", 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, 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")); } else { return(View(model)); } } catch (DbUpdateException) { TempData["Message"] = "this code Is already exists"; return(View(model)); } catch (Exception e) { return(View(model)); } }
public ActionResult method_delete(string id) { var ID = int.Parse(id); var model = dbcontext.EOS_Request.FirstOrDefault(m => m.ID == ID); var status = model.status; var inter = model.Answer_EOS_interview; var check = model.Check_List; try { dbcontext.check_list_EOS.RemoveRange(check); dbcontext.status.Remove(status); dbcontext.Answer_EOS.RemoveRange(inter); dbcontext.SaveChanges(); dbcontext.EOS_Request.Remove(model); dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("EOS transaction", HR.Models.user.Action.delete, 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 (DbUpdateException) { TempData["Message"] = HR.Resource.organ.youcannotdeletethisRow; return(View(model)); } catch (Exception e) { TempData["Message"] = HR.Resource.organ.youcannotdeletethisRow; return(View(model)); } }
public ActionResult Deletemethod(string id) { try { ViewBag.Type = dbcontext.Checktype.ToList().Select(m => new { Code = m.Code + "-----" + m.Name, ID = m.ID }); ViewBag.check_request_status = dbcontext.check_request_status.ToList().Select(m => new { Code = m.Code + "-----" + m.Name, ID = m.ID }); var ID = int.Parse(id); var request = dbcontext.check_Request.FirstOrDefault(m => m.ID == ID); var statue_ID = int.Parse(request.check_request_change_statusID); var request_statue = dbcontext.check_request_change_status.FirstOrDefault(m => m.ID == statue_ID); var model = new Check_Request_VM { check_Request = request, check_request_change_status = request_statue }; dbcontext.check_Request.Remove(request); dbcontext.check_request_change_status.Remove(request_statue); dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("check request transaction", HR.Models.user.Action.delete, 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, 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")); } catch (Exception e) { return(View()); } }
public ActionResult method_delete(string id) { var ID = int.Parse(id); var request = dbcontext.personnel_transaction.FirstOrDefault(m => m.ID == ID); try { var status = request.status; dbcontext.personnel_transaction.Remove(request); dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("personnel transaction", HR.Models.user.Action.delete, 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(); } //================================================================================== //dbcontext.status.Remove(status); //dbcontext.SaveChanges(); return(RedirectToAction("index")); } catch (DbUpdateException) { TempData["Message"] = HR.Resource.Basic.youcannotdeletethisRow; return(View(request)); } catch (Exception e) { return(View(Request)); } }
public ActionResult method_delete(int id) { var model_header = dbcontext.Discipline_PunishmentTransaction.FirstOrDefault(m => m.ID == id); var model_details = dbcontext.Discipline_PunishmentTransaction_Detail.Where(m => m.Transaction_Number == model_header.Transaction_Number).ToList(); var status = dbcontext.status.FirstOrDefault(m => m.ID == model_header.stat_ID); try { dbcontext.Discipline_PunishmentTransaction_Detail.RemoveRange(model_details); dbcontext.Discipline_PunishmentTransaction.Remove(model_header); dbcontext.status.Remove(status); dbcontext.SaveChanges(); //=================================check for alert================================== var get_result_check = HR.Controllers.check.check_alert("punishment transaction", HR.Models.user.Action.delete, 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, 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 (DbUpdateException) { TempData["Message"] = HR.Resource.organ.youcannotdeletethisRow; return(View(model_header)); } catch (Exception e) { TempData["Message"] = HR.Resource.organ.youcannotdeletethisRow; return(View(model_header)); } }