public string updateSalary(string salaryMonth, FileStream salaryDetailFileStream, sys_employeeEntities db) { //FileStream salaryFileStream = HelperCommon.saveSalaryDetail(salaryMonth, salaryDetailFileStream); string salaryFilePath = salaryDetailFileStream.Name; FileInfo salaryFileInfo = new FileInfo(salaryFilePath); string salaryFileName = Path.GetFileNameWithoutExtension(salaryDetailFileStream.Name); string employeeId = String.Format("{0}{1}", "vis", salaryFileName.Substring(0, 3)); string employeeName = salaryFileName.Substring(4); if (!salaryFileInfo.Extension.Equals(".pdf") || !DataBaseCommon.isEmployeeExist(employeeId, employeeName, db)) { salaryDetailFileStream.Flush(); salaryDetailFileStream.Close(); File.Delete(salaryFileName); throw new Exception("PDFファイルではないまた社員存在しません"); } salaryDetailFileStream.Flush(); salaryDetailFileStream.Close(); string salaryId = string.Format("{0}{1}", employeeId, salaryMonth.Substring(0, 7).Replace("/", "")); string salaryDetailFilePath = salaryFilePath.Substring(salaryFilePath.IndexOf(ConstantCommon.SALARYFOLDERPATH)); if (DataBaseCommon.isSalaryExist(salaryId, db)) { updateSalaryDetailFilePath(salaryId, salaryDetailFilePath, db); } else { addSalaryDetailFilePath(employeeId, salaryMonth, salaryDetailFilePath, db); } return(salaryFileInfo.Name); }
public ActionResult EmployeeAdd() { ViewBag.Message = "Your application description page."; List <SelectListItem> authorities = HelperCommon.convertToListItem(DataBaseCommon.getAuthority()); List <SelectListItem> managers = HelperCommon.convertToListItem(DataBaseCommon.getManager()); List <SelectListItem> customers = HelperCommon.convertToListItem(DataBaseCommon.getCustomer()); TempData["authorities"] = authorities; TempData["managers"] = managers; TempData["customers"] = customers; if (TempData["ViewData"] != null) { ViewData = (ViewDataDictionary)TempData["ViewData"]; } if (TempData["SuccessMessage"] != null) { ViewData["SuccessMessage"] = (string)TempData["SuccessMessage"]; TempData["SuccessMessage"] = null; } if (TempData["EmployeeAddInput"] != null) { var model = TempData["EmployeeAddInput"]; return(View("~/Views/Admin/EmployeeAdd.cshtml")); } return(View("~/Views/Admin/EmployeeAdd.cshtml")); }
// 社員追加 public void addEmployee(EmployeeAddInput employee) { try { using (sys_employeeEntities db = new sys_employeeEntities()) { if (DataBaseCommon.isDuplicateEmployee(employee.Id, db)) { throw new Exception("社員Idが重複発生です"); } if (DataBaseCommon.isDuplicateUsername(employee.UserName, db)) { throw new Exception("社員Usernameが重複発生です"); } var path = ""; var avatarFile = employee.AvatarFile; if (avatarFile != null && avatarFile.ContentLength > 0) { path = HelperCommon.saveAvatarFile(avatarFile, employee.Id); } employee employeeEntity = new employee(); employeeEntity.employeeId = employee.Id; employeeEntity.managerId = employee.ManagerId; employeeEntity.userName = employee.UserName; employeeEntity.passWord = HelperCommon.hashPassword(employee.PassWord); employeeEntity.authorityId = employee.AuthorityId; employeeEntity.dateOfBirth = DateTime.Parse(employee.DateOfBirth); employeeEntity.address = employee.Address; employeeEntity.personalNumber = employee.PersonalNumber; employeeEntity.name = employee.Name; employeeEntity.kataName = employee.KataName; employeeEntity.telephoneNumber = employee.TelephoneNumber; employeeEntity.mailAddress = employee.MailAddress; employeeEntity.customerId = employee.CustomerId; employeeEntity.accountBankInfo = employee.AccountBankInfo; employeeEntity.avatarFilePath = path; employeeEntity.depentdentFamily = employee.DepentdentFamily; employeeEntity.entryDate = employee.EntryDate; employeeEntity.description = employee.Description; db.employee.Add(employeeEntity); db.SaveChanges(); } } catch (Exception e) { throw e; } }
public ActionResult EmployeeDetail(string id) { ViewBag.Message = "Your contact page."; List <SelectListItem> authorities = HelperCommon.convertToListItem(DataBaseCommon.getAuthority()); List <SelectListItem> managers = HelperCommon.convertToListItem(DataBaseCommon.getManager()); List <SelectListItem> customers = HelperCommon.convertToListItem(DataBaseCommon.getCustomer()); TempData["authorities"] = authorities; TempData["managers"] = managers; TempData["customers"] = customers; EmployeeUpdateInput employee; if (TempData["ViewData"] != null) { ViewData = (ViewDataDictionary)TempData["ViewData"]; } if (TempData["SuccesMessage"] != null) { ViewData["SuccesMessage"] = (string)TempData["SuccesMessage"]; } if (TempData["EmployeeUpdateInput"] != null) { employee = (EmployeeUpdateInput)TempData["EmployeeUpdateInput"]; } else { EmployeeService employeeService = new EmployeeService(); employee = employeeService.getEmployeeUpdate(id); } HelperCommon.setSelected(authorities, employee.AuthorityId); HelperCommon.setSelected(managers, employee.ManagerId); HelperCommon.setSelected(customers, employee.CustomerId); return(View("~/Views/Admin/EmployeeDetail.cshtml", employee)); }
public ActionResult Index() { EmployeeService employeeService = new EmployeeService(); List <SelectListItem> customers = HelperCommon.convertToListItem(DataBaseCommon.getCustomer()); List <SelectListItem> authorities = HelperCommon.convertToListItem(DataBaseCommon.getAuthority()); authorities.Insert(0, new SelectListItem { Text = "", Value = "" }); ViewBag.authorities = authorities; ViewBag.customers = customers; if (TempData["ViewData"] != null) { ViewData = (ViewDataDictionary)TempData["ViewData"]; } if (TempData["employees"] != null) { ViewData["employees"] = TempData["employees"]; } else { List <EmployeeSearchOutput> employees = employeeService.getEmployees(); ViewData["employees"] = employees; } if (TempData["employeeSearchInput"] != null) { var model = TempData["employeeSearchInput"]; return(View("~/Views/Admin/Index.cshtml", model)); } return(View("~/Views/Admin/Index.cshtml")); }
// 社員情報編集 public EmployeeUpdateInput updateEmployee(EmployeeUpdateInput employeeUpdateInput) { try { using (sys_employeeEntities db = new sys_employeeEntities()) { var path = ""; var avatarFile = employeeUpdateInput.AvatarFile; if (avatarFile != null && avatarFile.ContentLength > 0) { path = HelperCommon.saveAvatarFile(employeeUpdateInput.AvatarFile, employeeUpdateInput.Id); } var query = (from e in db.employee where e.employeeId == employeeUpdateInput.Id select e).First(); if (!query.userName.Equals(employeeUpdateInput.UserName)) { if (DataBaseCommon.isDuplicateUsername(employeeUpdateInput.UserName, db)) { throw new Exception("社員Usernameが存在です"); } } employee employeeUpdate = (employee)query; employeeUpdate.employeeId = employeeUpdateInput.Id; employeeUpdate.name = employeeUpdateInput.Name; employeeUpdate.kataName = employeeUpdateInput.KataName; employeeUpdate.authorityId = employeeUpdateInput.AuthorityId; employeeUpdate.telephoneNumber = employeeUpdateInput.TelephoneNumber; employeeUpdate.dateOfBirth = DateTime.Parse(employeeUpdateInput.DateOfBirth); employeeUpdate.address = employeeUpdateInput.Address; employeeUpdate.mailAddress = employeeUpdateInput.MailAddress; employeeUpdate.customerId = employeeUpdateInput.CustomerId; employeeUpdate.managerId = employeeUpdateInput.ManagerId; employeeUpdate.personalNumber = employeeUpdateInput.PersonalNumber; employeeUpdate.accountBankInfo = employeeUpdateInput.AccountBankInfo; employeeUpdate.entryDate = employeeUpdateInput.EntryDate; employeeUpdate.leavingDate = employeeUpdateInput.LeavingDate; employeeUpdate.depentdentFamily = employeeUpdateInput.DepentdentFamily; employeeUpdate.userName = employeeUpdateInput.UserName; if (!employeeUpdate.passWord.Equals(employeeUpdateInput.PassWord)) { employeeUpdate.passWord = HelperCommon.hashPassword(employeeUpdateInput.PassWord); } employeeUpdate.description = employeeUpdateInput.Description; if (!path.Equals("")) { employeeUpdate.avatarFilePath = path; } db.SaveChanges(); } } catch (Exception e) { throw e; } return(employeeUpdateInput); }