public EmployeeLoginOutput Login(EmployeeLoginInput employeeLoginInput)
{
EmployeeLoginOutput employeeLoginOutput = new EmployeeLoginOutput();
try
{
string passWord = HelperCommon.hashPassword(employeeLoginInput.PassWord);
using (sys_employeeEntities db = new sys_employeeEntities())
{
var query = (from e in db.employee
join c in db.customer
on e.customerId equals c.customerId into ecGroup
from ec in ecGroup.DefaultIfEmpty()
where e.userName.Equals(employeeLoginInput.UserName) && e.passWord.Equals(passWord)
select new
{
e.employeeId,
e.name,
e.kataName,
e.mailAddress,
e.telephoneNumber,
e.entryDate,
customerName = ec.name,
e.address,
e.accountBankInfo,
e.personalNumber,
e.dateOfBirth,
e.authorityId,
e.avatarFilePath
}).FirstOrDefault();
if (query == null)
{
throw new Exception("ユーザネームまたパスワードが違います");
}
employeeLoginOutput.Id = query.employeeId;
employeeLoginOutput.Name = query.name;
employeeLoginOutput.KataName = query.kataName;
employeeLoginOutput.Email = query.mailAddress;
employeeLoginOutput.TelephoneNumber = query.telephoneNumber;
employeeLoginOutput.EntryDate = query.entryDate;
employeeLoginOutput.CustomerName = query.customerName;
employeeLoginOutput.Address = query.address;
employeeLoginOutput.AccountBankInfo = query.accountBankInfo;
employeeLoginOutput.PersonalNunber = query.personalNumber;
employeeLoginOutput.DateOfBirth = query.dateOfBirth.GetValueOrDefault().ToString("yyyy/MM/dd");
employeeLoginOutput.AuthorityId = query.authorityId;
employeeLoginOutput.AvatarFilePath = query.avatarFilePath;
}
}
catch (Exception e)
{
throw e;
}
return(employeeLoginOutput);
}
// 社員追加
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 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);
}
