public ActionResult Create() { var model = new EmployeeFormModel() { BDay = DateTime.Now }; model.InitMembers(GetSession); return(View(model)); }
public ActionResult Create(EmployeeFormModel model) { if (ModelState.IsValid) { var item = Mapper.Map <EmployeeFormModel, Employee>(model); GetSession.Save(item); return(RedirectToAction("List")); } model.InitMembers(GetSession); return(View(model)); }
public IActionResult Update(EmployeeFormModel EmployeeToBeEdited) { if (User.IsInRole("Admin") == false) { return(RedirectToAction("Index", "Home")); } FlightData.Models.Employee _employee = _employees.GetById(EmployeeToBeEdited.Id); FlightData.Models.Employee newEmployee = new FlightData.Models.Employee { Id = EmployeeToBeEdited.Id, FirstName = EmployeeToBeEdited.FirstName, LastName = EmployeeToBeEdited.LastName, Job = EmployeeToBeEdited.Job, TotalHours = EmployeeToBeEdited.TotalHours }; _employees.Update(_employee.Id, newEmployee); return(RedirectToAction("Index", "Employee")); }
public EmployeeFormModel GetEmployeeFormData(BaseViewModel model) { IUnitOfWork uwork = new UnitOfWork(); EmployeeFormModel formData = new EmployeeFormModel(); ICountryService countrySerivce = new CountryService(new CountryRepository(uwork)); // IDivisionService divisionService = new DivisionService(new DivisionRepository(uwork)); IDepartmentService departmentService = new DepartmentService(new DepartmentRepository(uwork)); IRoleService roleService = new RoleService(new RoleRepository(uwork)); IBranchService branchService = new BranchService(new BranchRepository(uwork)); IBankService bankService = new BankService(new BankRepository(uwork)); IBankBranchService bankBranchService = new BankBranchSerivce(new BankBranchRepository(uwork)); IBankAccountService banAccService = new BankAccountService(new BankAccountRepository(uwork)); ILanguageService langService = new LanguageService(new LanguageRepository(uwork)); IApplicationService appService = new ApplicationService(new ApplicationRepository(uwork)); basemodel.CurrentCulture = model.CurrentCulture; basemodel.CurrentUserID = model.CurrentUserID; var LastEmployee = GetEmployeeList(basemodel).LastOrDefault(); long NextID = LastEmployee == null ? 0 : LastEmployee.RegistrationID + 1; try { formData.countries = countrySerivce.GetAllCountryList(model).Where(c => c.IsActive == true).ToList(); // formData.divisions = divisionService.GetDivisionList(model); formData.departments = departmentService.GetAllDepartmentList(model).Where(c => c.IsActive == true).ToList(); formData.roles = roleService.GetAllRoleList(model).Where(c => c.IsActive == true).ToList(); formData.branches = branchService.GetAllBranchList(model).Where(c => c.IsActive == true).ToList(); formData.banks = bankService.GetAllBankList(model).Where(c => c.IsActive == true).ToList(); formData.bankbranches = bankBranchService.GetAllBankBranchList(model).Where(c => c.IsActive == true).ToList(); formData.bankAccountTypes = banAccService.GetAllBankAccountType(model).Where(c => c.IsActive == true).ToList(); formData.languages = langService.GetAllLanguageList(model).Where(c => c.IsActive == true).ToList(); //formData.EmployeeNo = Helper.GenerateUniqueID(appService.GetApplicationCode(model.ApplicationId), NextID.ToString()); } catch (Exception ex) { string message = LogException(ex, model.CurrentUserID); throw new Exception(message); } return(formData); }
// UPDATE public IActionResult Edit(int id) { if (User.IsInRole("Admin") == false) { return(RedirectToAction("Index", "Home")); } var employeeModel = _employees.GetById(id); var formData = new EmployeeFormModel { Id = id, FirstName = employeeModel.FirstName, LastName = employeeModel.LastName, Job = employeeModel.Job, EmployeeNumber = employeeModel.EmployeeNumber, TotalHours = employeeModel.TotalHours }; return(View(formData)); }
public async Task <IActionResult> Edit(int id, EmployeeFormModel model) => await this.HandleAsync(async() => await this.employeeService.Edit(id, this.mapper.Map <InputEmployeeServiceModel>(model)), success : RedirectToAction(nameof(Index)), failure : View(model));
public ActionResult UpdateEmployees() { ////----------------- //string filePaths = @"E:\Users\max\Desktop\Development\ON AIR SITES\New Sites Online_Alex\Zoglobek PORTAL\Source\Portal.Web.UI.Application\Public\userfiles\SOGPORTAL.xlsx"; //string strFile = @"E:\Users\max\Desktop\Development\ON AIR SITES\New Sites Online_Alex\Zoglobek PORTAL\Source\Portal.Web.UI.Application\Public\userfiles\SOGPORTAL.xlsx"; //string strTemp = Path.GetExtension(strFile).ToLower(); //if (strTemp == ".xls") //{ // strFile = Path.ChangeExtension(strFile, "xlsx"); //} //foreach (string myfile in filePaths) //{ // filename = Path.ChangeExtension(myfile, ".txt"); // System.IO.File.Move(myfile, filename); //} ////------------------ Log newLog = new Log(); newLog.id = Guid.NewGuid(); int added = 0; int deleted = 0; int updated = 0; int errors = 0; int warnings = 0; string result = ""; int logg = 0; string name = ""; try { var excel = new ExcelQueryFactory(); string[] ex_names = MvcApplication.Config("excel_name").Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries); //insert all employees from excel to temp list<> List <string> excel_emp_id = new List <string>(); for (int ex_name = 0; ex_name < ex_names.Length; ex_name++) { excel.FileName = ex_names[ex_name]; //employees from excel var result_employees = from c in excel.WorksheetNoHeader(0) select c; List <Employee> employees = new List <Employee>(); UpdateJobs(); UpdateDepartments(); //Dictionary Dictionary <string, long> dep_dict = new Dictionary <string, long>(); //existing Department from db List <Department> existing_deps = (List <Department>)GetSession.QueryOver <Department>().List(); foreach (Department dep in existing_deps) { dep_dict.Add(dep.Name, dep.Id); } //get all employees to dictinary Dictionary <string, long> emps_dict = new Dictionary <string, long>(); Dictionary <string, long> job_dict = new Dictionary <string, long>(); //existing Jobs from db List <JobTitle> existing_jobs = (List <JobTitle>)GetSession.QueryOver <JobTitle>().List(); foreach (JobTitle job in existing_jobs) { job_dict.Add(job.Name, job.Id); } Dictionary <string, string> users_managers = new Dictionary <string, string>(); //result_employees -> employees from excel int i = 0; foreach (var employee in result_employees) { //check for must feilds if (!string.IsNullOrEmpty(employee[1].ToString().Trim()) && !string.IsNullOrEmpty(employee[2].ToString().Trim()) && !string.IsNullOrEmpty(employee[13].ToString().Trim()) && !string.IsNullOrEmpty(employee[0].ToString().Trim())) { logg++; name = employee[0]; if (i > 0 && !string.IsNullOrEmpty(employee[0].ToString().Trim())) { //check for wanted feilds if (string.IsNullOrEmpty(employee[5].ToString().Trim()) || string.IsNullOrEmpty(employee[7].ToString().Trim())) { newLog.WarningLines = newLog.WarningLines + (i + 1) + ","; warnings++; } excel_emp_id.Add(employee[0].ToString().Trim()); if (employee[5] != "") { users_managers.Add(employee[0], employee[5]); } //if employee exists in DB if (GetSession.Get <Employee>(Convert.ToInt64(employee[0].ToString().Trim())) == null) { //add new employee string sBirthDate = employee[7].ToString().Trim() ?? ""; //string username = employee[9].ToString().Trim() == "" ? // "New User" : employee[9].ToString().Trim().Substring(0, employee[9].ToString().Trim().ToString().IndexOf('@')); string userName = employee[0].ToString().Trim(); EmployeeFormModel model = new EmployeeFormModel() { Id = Convert.ToInt64(employee[0].ToString().Trim()), Password = employee[0].ToString().Trim(), LastName = employee[2].ToString().Trim(), FirstName = employee[1].ToString().Trim(), Email = string.IsNullOrEmpty(employee[9].ToString().Trim()) ? "*****@*****.**" : employee[9].ToString().Trim(), Phone = employee[10].ToString().Trim(), Picture = employee[0].ToString().Trim() + ".jpg", Mobile = employee[11].ToString().Trim(), //Manager = GetSession.Get<Employee>(Convert.ToInt64(employee[5].ToString().Trim())), Range = employee[12].ToString().Trim(), BDay = (employee[7].ToString().Trim() != "") ? Convert.ToDateTime(sBirthDate) : DateTime.Now, IsActive = Convert.ToBoolean(Convert.ToInt32(employee[13].ToString().Trim())), JbTitle = GetSession.Get <JobTitle>(job_dict.FirstOrDefault(x => x.Key == employee[8].ToString().Trim()).Value), Department = GetSession.Get <Department>(dep_dict.FirstOrDefault(x => x.Key == employee[4].ToString().Trim()).Value), Username = userName }; var item = Mapper.Map <EmployeeFormModel, Employee>(model); GetSession.Save(item); added++; // string s = job_dict.FirstOrDefault(employee[3].ToString().Trim()).Key; } else { //update employee var item = GetSession.Get <Employee>(Convert.ToInt64(employee[0].ToString().Trim())); var model = Mapper.Map <Employee, EmployeeFormModel>(item); string sBirthDate = employee[7].ToString().Trim().ToString(); string userName = employee[0].ToString().Trim(); model.Password = employee[0].ToString().Trim(); model.LastName = employee[2].ToString().Trim(); model.FirstName = employee[1].ToString().Trim(); model.Email = string.IsNullOrEmpty(employee[9].ToString().Trim()) ? "*****@*****.**" : employee[9].ToString().Trim(); model.Phone = employee[10].ToString().Trim(); model.Mobile = employee[11].ToString().Trim(); model.Picture = employee[0].ToString().Trim() + ".jpg"; model.Range = employee[12].ToString().Trim(); //model.Manager = GetSession.Get<Employee>(Convert.ToInt64(employee[5].ToString().Trim())); model.IsActive = Convert.ToBoolean(Convert.ToInt32(employee[13].ToString().Trim())); model.BDay = (employee[7].ToString().Trim() != "") ? Convert.ToDateTime(sBirthDate) : DateTime.Now; model.JbTitle = GetSession.Get <JobTitle>(job_dict.FirstOrDefault(x => x.Key == employee[8].ToString().Trim()).Value); model.Department = GetSession.Get <Department>(dep_dict.FirstOrDefault(x => x.Key == employee[4].ToString().Trim()).Value); //model.Username = employee[9].ToString().Trim() == "" ? "" : employee[9].ToString().Trim().ToString().Substring(0, employee[9].ToString().Trim().ToString().IndexOf('@')); model.Username = userName; Mapper.Map <EmployeeFormModel, Employee>(model, item); GetSession.Update(item); updated++; } } i++; } else { newLog.ErrorLines = newLog.ErrorLines + (i + 1) + ","; errors++; i++; } } //TODO //update managers //UpdateManagers(users_managers); } // bring all existing employees List <Employee> current_employees = (List <Employee>)GetSession.QueryOver <Employee>().List(); foreach (Employee curr_emp in current_employees) { // if employee nof found in excel > disactivate this employee if (!excel_emp_id.Contains(curr_emp.Id.ToString())) { if (curr_emp.Username != MvcApplication.Config("admin.Username")) { var item = GetSession.Get <Employee>(curr_emp.Id); var model = Mapper.Map <Employee, EmployeeFormModel>(item); model.IsActive = false; Mapper.Map <EmployeeFormModel, Employee>(model, item); GetSession.Update(item); deleted++; } } #region 1 //if (curr_emp.Username == MvcApplication.Config("admin.Username")) //{ // var item = GetSession.Get<Employee>(curr_emp.Id); // var model = Mapper.Map<Employee, EmployeeFormModel>(item); // model.Username = "******"; // model.IsAdmin = true; // model.IsActive = true; // Mapper.Map<EmployeeFormModel, Employee>(model, item); // GetSession.Update(item); //} #endregion } } catch (Exception ex) { return(Content(ex.Data + ">>>>>" + ex.InnerException + ">>>>>" + ex.Message + " >>>>>>>> line" + logg + "name =" + name)); } result = string.Format("<h3>Update Results</h3><p>New : {0} </p><p>Processed : {1} </p><p>Deleted {2}</p><p>Errors {3}</p><p>Warnings {4}</p>", added, updated, deleted, errors, warnings); newLog.Logdate = DateTime.Now; newLog.UpdatedCount = updated; newLog.NewEmps = added.ToString(); GetSession.Save(newLog); TempData["warnings"] = newLog.WarningLines; return(RedirectToAction("ProssesResult", new { added = added, updated = updated, deleted = deleted, errors = errors, warningsL = newLog.WarningLines, warnings = warnings })); //return Content(result, "text/html"); }
public IActionResult Operate(EmployeeFormModel model, IFormFile image) { if (ModelState.IsValid) { if (model.Id == 0 || model.Id == null) { try { if (image != null) { string imageBase64Data = ImageOperations.GetBase64FromFile(image); model.Image = imageBase64Data; Employee employee = new Employee { ColorId = model.ColorId, Detail = model.Detail, Image = model.Image, Info = model.Info, Name = model.Name, Role = model.Role, ScreenOrder = model.ScreenOrder }; db.Add(employee); db.SaveChanges(); return(StatusCode(200, "Eklendi")); } else { ModelState.AddModelError("Error", "Lütfen Resim Ekleyiniz"); } } catch (Exception e) { ModelState.AddModelError("error", "Error! An error occurred while Employee creating"); } } else { var employee = db.Employee.Where(q => q.Id == model.Id).FirstOrDefault(); if (employee == null) { ModelState.AddModelError("error", "Unknown Request!"); } else { if (image != null) { string imageBase64Data = ImageOperations.GetBase64FromFile(image); employee.Image = imageBase64Data; } employee.Name = model.Name; employee.Info = model.Info; employee.Detail = model.Detail; employee.ColorId = model.ColorId; employee.Role = model.Role; db.Update(employee); db.SaveChanges(); return(StatusCode(200, "Güncellendi!")); } } } return(BadRequest(new { Message = "Some error(s) occurred!", StatusCode = 400, ModelState = ModelState.ToList() })); }