/// <summary>
/// dto to Data Access Conversion
/// </summary>
/// <param name="employee">dto Employee</param>
/// <returns>Data Access Employee</returns>
public static Employee DtoToDataAccess(DtoEmployee employee)
{
var e = new Employee
{
id = employee.Id,
name = employee.Name,
surname = employee.Surname,
email = employee.Email,
phoneNumber = employee.PhoneNumber,
icePhoneNumber = employee.IcePhoneNumber,
personalIdentityNumber = employee.PersonalIdentityNumber,
identityCardNumber = employee.IdentityCardNumber,
city = employee.City,
street = employee.Street,
postalCode = employee.PostalCode,
houseNumber = employee.HouseNumber,
apartmentNumber = employee.ApartmentNumber,
description = employee.Description,
supervisorID = employee.SupervisorId,
positionID = employee.Position.Id,
password = AuthenticationLogic.HashPassword(employee.Password, employee)
};
return(e);
}
public DtoEmployee Login(string account, string pwd)
{
DtoEmployee result = null;
var model = BllEmployeeRepository.GetByAccount(account, (int)StatusEnum.效);
if (model != null)
{
if (model.Bem_Password._EqualsByOrdinalIgnoreCase(Encrypt.GetMD5Pwd(pwd)))
{
result = model;
try
{
string ip = "";
string cityName = "";
ip = clsCommon.GetIP();
if (ip.HasValue())
{
cityName = clsCommon.CityName_ByBaidu(ip);
}
if (ip.HasValue() || cityName.HasValue())
{
var old = BllEmployeeRepository.GetEntity(model.Bem_Id);
old.Bem_LastLoginArea = cityName;
old.Bem_LastLoginIp = ip;
old.Bem_LastLoginTime = DateTime.Now;
BllEmployeeRepository.Update(old);
}
}
catch (Exception)
{
}
}
}
return(result);
}
public List <DtoEmployee> loginEmployee(DtoEmployee emp)
{
Entities_Visit ctx;
using (ctx = new Entities_Visit())
{
var listEmployee = (from empl in ctx.EMPLOYEE
join rol in ctx.ROLE on empl.ROL_ID equals rol.ROL_ID
where empl.EMP_MAIL == emp.sEmp_mail && empl.EMP_PASSWORD == emp.sEmp_password && empl.EMP_STATE == true
select new DtoEmployee()
{
iRol_id = (int)empl.ROL_ID,
sRol_name = rol.ROL_NAME,
iBra_buis_id = (int)empl.BRA_BUIS_ID,
sEmp_document = empl.EMP_DOCUMENT,
sEmp_name = empl.EMP_NAME,
sEmp_surname = empl.EMP_SURNAME,
sEmp_phone = empl.EMP_PHONE,
sEmp_phone2 = empl.EMP_PHONE,
sEmp_cell_phone = empl.EMP_CELL_PHONE,
sEmp_cell_phone2 = empl.EMP_CELL_PHONE2,
sEmp_addres = empl.EMP_ADDRES,
sEmp_mail = empl.EMP_MAIL,
sEmp_mail2 = empl.EMP_MAIL2
}
).ToList();
return(listEmployee);
}
}
public bool InsertUpdateEmployee(DtoEmployee emp)
{
Entities_Visit ctx;
bool bResult = false;
using (ctx = new Entities_Visit())
{
try
{
var query = ctx.PR_INSET_UPDATE_EMPLOYEE
(
emp.iRol_id, emp.iBra_buis_id, emp.sEmp_document, emp.sEmp_name, emp.sEmp_surname,
emp.sEmp_phone, emp.sEmp_phone2, emp.sEmp_cell_phone, emp.sEmp_cell_phone, emp.sEmp_addres,
emp.sEmp_mail, emp.sEmp_mail2, emp.sEmp_password, emp.bemp_state, emp.sEmp_permission, emp.sEmp_photo
);
// int result =Int32.Parse(query.ToString());
bResult = true;
}
catch (Exception e)
{
bResult = false;
}
}
return(bResult);
}
public ActionResult AjouterOrModifierEmp(VMListeEmp vmEmp)
{
if (ModelState.IsValid)
{
DtoEmployee dtoEmp = new DtoEmployee();
if (vmEmp.id_emp != 0)
{
dtoEmp.id_dep = vmEmp.id_dep;
dtoEmp.id_emp = vmEmp.id_emp;
dtoEmp.nom_emp = vmEmp.nom_emp;
dtoEmp.prenom_emp = vmEmp.prenom_emp;
dtoEmp.Salaire_emp = vmEmp.Salaire_emp;
dtoEmp.tele_emp = vmEmp.tele_emp;
dtoEmp.date_recrute_emp = vmEmp.date_recrute_emp;
BusComp.ModifierEmployee(dtoEmp);
}
else
{
dtoEmp.id_dep = vmEmp.id_dep;
dtoEmp.id_emp = vmEmp.id_emp;
dtoEmp.nom_emp = vmEmp.nom_emp;
dtoEmp.prenom_emp = vmEmp.prenom_emp;
dtoEmp.Salaire_emp = vmEmp.Salaire_emp;
dtoEmp.tele_emp = vmEmp.tele_emp;
dtoEmp.date_recrute_emp = vmEmp.date_recrute_emp;
BusComp.AjouterEmployee(dtoEmp);
}
TempData["SuccessMessageDeprt"] = "Done !";
return(RedirectToAction("ListeEmp"));
}
else
{
return(RedirectToAjouterOrModifierEmp(vmEmp.id_emp));
}
}
public ActionResult Login(string account, string pwd)
{
bool success = false;
string msg = "";
EmployeeBll employeeBll = new EmployeeBll();
DtoEmployee employee = employeeBll.Login(account, pwd);
CookieUserModel user = null;
if (employee != null)
{
success = true;
msg = "登录成功";
user = new CookieUserModel();
user.UserId = employee.Bem_Id;
user.UserName = employee.Bem_Name;
user.RoleId = employee.Bro_Id;
user.RoleName = employee.Bro_Name;
user.Grades = employee.Bem_Grades;
user.GradesList = CustomEnumHelper.ParseBinaryAnd(typeof(GradeEnum), employee.Bem_Grades).Keys.ToList();
}
else
{
msg = "登录失败";
}
LoginCookieHelper.SetCurrentUser(user);
return(Json(new JsonSimpleResponse()
{
State = success, ErrorMsg = msg
}));
}
// PUT api/employee/5
public HttpResponseMessage PutEmployee(int id, DtoEmployee emp)
{
var employee = new Employee()
{
Id = emp.Id,
FirstName = emp.FirstName,
LastName = emp.LastName,
Email = emp.Email,
Password = emp.Password
};
if (ModelState.IsValid && id == employee.Id)
{
db.Entry(employee).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (Exception)
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
/// <summary>
/// View Model to DTO Conversion
/// </summary>
/// <param name="employee">View Model Employee</param>
/// <returns>DTO Employee</returns>
public static DtoEmployee ViewModelToDto(Employee employee)
{
var e = new DtoEmployee
{
Id = employee.Id,
Name = employee.Name,
Surname = employee.Surname,
Email = employee.Email,
PhoneNumber = employee.PhoneNumber,
IcePhoneNumber = employee.IcePhoneNumber,
PersonalIdentityNumber = employee.PersonalIdentityNumber,
IdentityCardNumber = employee.IdentityCardNumber,
City = employee.City,
Street = employee.Street,
PostalCode = employee.PostalCode,
HouseNumber = employee.HouseNumber,
ApartmentNumber = employee.ApartmentNumber,
Description = employee.Description,
SupervisorId = employee.SupervisorId,
Position = PositionConverter.ViewModelToDto(employee.Position),
SportTypes = new List <DtoSportType>(),
Password = employee.Password
};
foreach (var st in employee.SportTypes)
{
e.SportTypes.Add(SportTypeConverter.ViewModelToDto(st));
}
return(e);
}
public CtrlNotification(DtoEmployee empl, String sFrom, String sSubject)
{
this.sHtml = ArmStructureHtml(empl.sEmp_name + " " + empl.sEmp_surname, empl.iEmp_id);
this.sToMail = empl.sEmp_mail;
this.sFrom = sFrom;
this.sSubject = sSubject;
}
/// <summary>
/// Hashes password
/// </summary>
/// <param name="password">Unhashed password</param>
/// <param name="emp">Employeee whose password it is</param>
/// <returns>Hashed password</returns>
public static string HashPassword(string password, DtoEmployee emp)
{
SHA256 sha256 = new SHA256Managed();
var saltedPassword = GetSaltedPassword(password, emp);
var bytes = sha256.ComputeHash(Encoding.UTF8.GetBytes(saltedPassword));
var hash = Convert.ToBase64String(bytes);
return(hash);
}
public IActionResult Edit(DtoEmployee employee, string oldPassHash)
{
if (ModelState.IsValid && (oldPassHash == null || _service.Read(employee.Id).PassHash == oldPassHash))
{
_service.Update(employee.Id, employee);
return(new ContentResult {
Content = employee.ToString(), StatusCode = 200
});
}
return(BadRequest(ModelState));
}
public void ModifierEmployee(DtoEmployee emp)
{
var empUp = context.Employees.Find(emp.id_emp);
empUp.id_dep = emp.id_dep;
empUp.id_emp = emp.id_emp;
empUp.nom_emp = emp.nom_emp;
empUp.prenom_emp = emp.prenom_emp;
empUp.Salaire_emp = emp.Salaire_emp;
empUp.tele_emp = emp.tele_emp;
empUp.date_recrute_emp = emp.date_recrute_emp;
context.SaveChanges();
}
public void AjouterEmployee(DtoEmployee emp)
{
Employee empl = new Employee
{
id_dep = emp.id_dep,
id_emp = emp.id_emp,
nom_emp = emp.nom_emp,
prenom_emp = emp.prenom_emp,
Salaire_emp = emp.Salaire_emp,
tele_emp = emp.tele_emp,
date_recrute_emp = emp.date_recrute_emp
};
Ajouter(empl);
}
public IActionResult Add(DtoEmployee employee, Guid directorId, Guid departmentDirectorId)
{
if (ModelState.IsValid)
{
if (directorId != default(Guid))
{
employee.Director = _service.Read(directorId);
}
if (departmentDirectorId != default(Guid))
{
employee.DepartmentDirector = _service.Read(departmentDirectorId);
}
_service.Create(employee);
return(new ContentResult {
Content = employee.ToString(), StatusCode = 200
});
}
return(BadRequest(ModelState));
}
public List <DtoEmployee> ListEmployeeSelect(DtoEmployee emp)
{
Entities_Visit ctx;
using (ctx = new Entities_Visit())
{
List <DtoEmployee> list = new List <DtoEmployee>();
DtoEmployee objEmployee;
try
{
var query = ctx.PR_SEARCH_EMPLOYEE_SELECTION(emp.bemp_state, emp.iBra_buis_id, emp.sEmp_name, emp.sEmp_surname, emp.sEmp_document, emp.sEmp_mail, emp.sRol_name);
foreach (var employee in query)
{
objEmployee = new DtoEmployee();
objEmployee.iEmp_id = (int)employee.EMP_ID;
objEmployee.iRol_id = (int)employee.ROL_ID;
objEmployee.iBra_buis_id = (int)employee.BRA_BUIS_ID;
objEmployee.sRol_name = employee.ROL_NAME;
objEmployee.sEmp_document = employee.EMP_DOCUMENT;
objEmployee.sEmp_name = employee.EMP_NAME;
objEmployee.sEmp_surname = employee.EMP_SURNAME;
objEmployee.sEmp_phone = employee.EMP_PHONE;
objEmployee.sEmp_phone2 = employee.EMP_PHONE;
objEmployee.sEmp_cell_phone = employee.EMP_CELL_PHONE;
objEmployee.sEmp_cell_phone2 = employee.EMP_CELL_PHONE2;
objEmployee.sEmp_addres = employee.EMP_ADDRES;
objEmployee.sEmp_mail = employee.EMP_MAIL;
objEmployee.sEmp_mail2 = employee.EMP_MAIL2;
objEmployee.sEmp_password = employee.EMP_PASSWORD;
objEmployee.sEmp_password = employee.EMP_PASSWORD;
objEmployee.sEmp_permission = employee.EMP_PER;
list.Add(objEmployee);
}
list.ToList();
}
catch (Exception e)
{
}
return(list);
}
}
public List <DtoEmployee> ResetPasswordEmployee(DtoEmployee emp)
{
Entities_Visit ctx;
using (ctx = new Entities_Visit())
{
var listEmployee = (from empl in ctx.EMPLOYEE
where empl.EMP_MAIL == emp.sEmp_mail && empl.EMP_STATE == true
select new DtoEmployee()
{
iEmp_id = empl.EMP_ID,
bemp_state = empl.EMP_STATE,
sEmp_name = empl.EMP_NAME,
sEmp_surname = empl.EMP_SURNAME,
sEmp_mail = empl.EMP_MAIL
}
).ToList();
return(listEmployee);
}
}
public List <DtoEmployee> ListEmployeeUpdate(DtoEmployee emp)
{
Entities_Visit ctx;
List <DtoEmployee> list = null;
using (ctx = new Entities_Visit())
{
try
{
list = (from empl in ctx.EMPLOYEE
join rol in ctx.ROLE on empl.ROL_ID equals rol.ROL_ID
where empl.EMP_STATE == true && empl.EMP_DOCUMENT == emp.sEmp_document || empl.EMP_MAIL == emp.sEmp_mail
select new DtoEmployee()
{
iEmp_id = empl.EMP_ID,
iRol_id = empl.ROL_ID,
iBra_buis_id = empl.BRA_BUIS_ID,
sRol_name = rol.ROL_NAME,
sEmp_document = empl.EMP_DOCUMENT,
sEmp_name = empl.EMP_NAME,
sEmp_surname = empl.EMP_SURNAME,
sEmp_phone = empl.EMP_PHONE,
sEmp_phone2 = empl.EMP_PHONE2,
sEmp_cell_phone = empl.EMP_CELL_PHONE,
sEmp_cell_phone2 = empl.EMP_CELL_PHONE2,
sEmp_addres = empl.EMP_ADDRES,
sEmp_mail = empl.EMP_MAIL,
sEmp_mail2 = empl.EMP_MAIL2,
sEmp_password = empl.EMP_PASSWORD,
sEmp_permission = empl.EMP_PER
}).ToList();
return(list);
}
catch (Exception e)
{
}
return(list);
}
}
public List <DtoEmployee> UpdateEmployeePassword(DtoEmployee emp)
{
Entities_Visit ctx;
using (ctx = new Entities_Visit())
{
var objEmployee = (from empl in ctx.EMPLOYEE
where empl.EMP_ID == emp.iEmp_id
select empl).FirstOrDefault();
objEmployee.EMP_PASSWORD = emp.sEmp_password;
ctx.SaveChanges();
var ListEmployee = (from empl in ctx.EMPLOYEE
where empl.EMP_PASSWORD == emp.sEmp_password
orderby empl.EMP_NAME
select new DtoEmployee()
{
sEmp_name = empl.EMP_NAME,
sEmp_surname = empl.EMP_SURNAME,
}).ToList();
return(ListEmployee);
}
}
public bool DeleteEmployee(DtoEmployee emp)
{
Entities_Visit ctx = new Entities_Visit();
bool bResult = false;
using (ctx = new Entities_Visit())
{
try
{
var query = ctx.PR_UPADTE_STATE_EMPLOYEE
(
emp.iEmp_id, emp.sEmp_document
);
string result = query.ToString();
bResult = true;
}
catch (Exception e)
{
bResult = false;
}
}
return(bResult);
}
// POST api/employee
public HttpResponseMessage PostEmployee(DtoEmployee emp)
{
var employee = new Employee()
{
Id = emp.Id,
FirstName = emp.FirstName,
LastName = emp.LastName,
Email = emp.Email,
Password = emp.Password
};
if (ModelState.IsValid)
{
db.Employees.Add(employee);
db.SaveChanges();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, employee);
response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = employee.Id }));
return(response);
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
/// <summary>
/// DTO to View Model Conversion
/// </summary>
/// <param name="d">DTO Employee</param>
/// <returns>View Model Employee</returns>
public static Employee DtoToViewModel(DtoEmployee d)
{
var e = new Employee
{
Id = d.Id,
Name = d.Name,
Surname = d.Surname,
Email = d.Email,
PhoneNumber = d.PhoneNumber,
IcePhoneNumber = d.IcePhoneNumber,
PersonalIdentityNumber = d.PersonalIdentityNumber,
IdentityCardNumber = d.IdentityCardNumber,
City = d.City,
Street = d.Street,
PostalCode = d.PostalCode,
HouseNumber = d.HouseNumber,
ApartmentNumber = d.ApartmentNumber,
Position = PositionConverter.DtoToViewModel(d.Position),
Description = d.Description,
SupervisorName = d.SupervisorName,
SupervisorId = d.SupervisorId,
SportTypes = new ObservableCollection <SportType>(),
Password = d.Password
};
foreach (var st in d.SportTypes)
{
e.SportTypes.Add(SportTypeConverter.DtoToViewModel(st));
}
e.SportTypesString += e.SportTypes[0];
for (var i = 1; i < e.SportTypes.Count; ++i)
{
e.SportTypesString += ", " + e.SportTypes[i];
}
return(e);
}
/// <summary>
/// Data Access to dto Conversion
/// </summary>
/// <param name="d">Data Access Employee</param>
/// <returns>dto Employee</returns>
public static DtoEmployee DataAccsessToDto(Employee d)
{
var e = new DtoEmployee
{
Id = d.id,
Name = d.name,
Surname = d.surname,
Email = d.email,
PhoneNumber = d.phoneNumber,
IcePhoneNumber = d.icePhoneNumber,
PersonalIdentityNumber = d.personalIdentityNumber,
IdentityCardNumber = d.identityCardNumber,
City = d.city,
Street = d.street,
PostalCode = d.postalCode,
HouseNumber = d.houseNumber,
ApartmentNumber = d.apartmentNumber,
Position = PositionConverter.DataAccsessToDto(d.Position),
Description = d.description,
SupervisorName = d.supervisorID == null ? string.Empty : d.Employee2.name + " " + d.Employee2.surname,
SupervisorId = d.supervisorID,
SportTypes = new List <DtoSportType>(),
Password = d.password
};
foreach (var st in d.SportType)
{
e.SportTypes.Add(SportTypeConverter.DataAccsessToDto(st));
}
e.SportTypesString += e.SportTypes[0];
for (var i = 1; i < e.SportTypes.Count; ++i)
{
e.SportTypesString += ", " + e.SportTypes[i];
}
return(e);
}
private static string GetSaltedPassword(string password, DtoEmployee emp)
{
return(emp.Email + password);
}
/// <summary>
/// Adding or Updating Employee in a database
/// </summary>
/// <param name="employee">Business Object Employee</param>
/// <returns>True if succeeded and false otherwise</returns>
public async Task <bool> SaveEmployee(DtoEmployee employee)
{
try
{
using (var data = Context)
{
var e =
await
(from item in data.Employee where employee.Id == item.id select item).FirstOrDefaultAsync();
// Updating Employee
if (e != null)
{
e.name = employee.Name;
e.surname = employee.Surname;
e.street = employee.Street;
e.postalCode = employee.PostalCode;
e.phoneNumber = employee.PhoneNumber;
e.personalIdentityNumber = employee.PersonalIdentityNumber;
e.identityCardNumber = employee.IdentityCardNumber;
e.icePhoneNumber = employee.IcePhoneNumber;
e.houseNumber = employee.HouseNumber;
e.email = employee.Email;
e.city = employee.City;
e.apartmentNumber = employee.ApartmentNumber;
e.description = employee.Description;
e.positionID = employee.Position.Id;
e.supervisorID = employee.SupervisorId;
e.password = AuthenticationLogic.HashPassword(employee.Password, employee);
e.SportType.Clear();
foreach (var item in employee.SportTypes)
{
var st = data.SportType.First(s => s.id == item.Id);
e.SportType.Add(st);
}
}
// Adding new Employee
else
{
if (await(from item in data.Employee
where
employee.PersonalIdentityNumber == item.personalIdentityNumber ||
employee.IdentityCardNumber == item.identityCardNumber
select item).AnyAsync())
{
return(false);
}
var emp = EmployeeConverter.DtoToDataAccess(employee);
foreach (var item in employee.SportTypes)
{
var st = data.SportType.First(s => s.id == item.Id);
emp.SportType.Add(st);
}
data.Employee.Add(emp);
}
await data.SaveChangesAsync();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public void AddWorkedTime(DtoEmployee employee, int workedTime) => WorkedTime.Add(employee, workedTime);
