public static Dictionary <string, string> getPersonalDocuments(string employeeId)
{
Dictionary <string, string> documents = new Dictionary <string, string>();
var directoryPath = HttpContext.Current.Server.MapPath("~/Content/EmployeeInformation/" + "/" + employeeId + "/" + employeeId);
using (sys_employeeEntities db = new sys_employeeEntities())
{
var query = (from e in db.employee
where e.employeeId == employeeId
select e).First();
if (!Directory.Exists(directoryPath))
{
Directory.CreateDirectory(directoryPath);
query.personalDocumentPath = directoryPath.Substring(directoryPath.IndexOf("Content\\EmployeeInformation\\"));
}
documents.Add("name", query.name);
db.SaveChanges();
}
string[] files = Directory.GetFiles(directoryPath);
foreach (string file in files)
{
FileInfo f = new FileInfo(file);
string pathLink = f.FullName.Substring(f.FullName.IndexOf("\\Content\\EmployeeInformation\\"));
documents.Add(f.Name, pathLink);
}
return(documents);
}
private bool updateSalaryDetailFilePath(string salaryId, string salaryDetailFilePath, sys_employeeEntities db)
{
var query = (from s in db.salary
where s.salaryId == salaryId
select s).First();
salary salary = (salary)query;
salary.salaryDetailFilePath = salaryDetailFilePath;
db.SaveChanges();
return(false);
}
// 社員追加
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;
}
}
private bool addSalaryDetailFilePath(string employeeId, string salaryMonth, string salaryDetailFilePath, sys_employeeEntities db)
{
string salaryId = string.Format("{0}{1}", employeeId, salaryMonth.Substring(0, 7).Replace("/", ""));
salary salary = new salary();
salary.salaryId = salaryId;
salary.employeeId = employeeId;
salary.paymentDate = string.Format("{0}/{1}", salaryMonth.Substring(0, 7), "15");
salary.salaryDetailFilePath = salaryDetailFilePath;//fileName.Substring(fileName.IndexOf(ConstantCommon.SALARYFOLDERPATH));
salary.description = "";
db.salary.Add(salary);
db.SaveChanges();
return(false);
}
public void ChangePassword(string employeeId, string password, string newPassword)
{
string hashPassword = HelperCommon.hashPassword(password);
using (sys_employeeEntities db = new sys_employeeEntities())
{
var query = (from e in db.employee
where e.employeeId.Equals(employeeId) && e.passWord.Equals(hashPassword)
select e).FirstOrDefault();
if (query == null)
{
throw new Exception("パスワードが間違いで、再入力ください");
}
query.passWord = HelperCommon.hashPassword(newPassword);
db.SaveChanges();
}
}
// 社員情報編集
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);
}