//insert data, will be hit by Signup Page
public Boolean insertData(CustomModels.CustomEmployee employeeDetails)
{
try
{
DbModels.EmployeeDetails emp = new DbModels.EmployeeDetails()
{
EmpName = employeeDetails.EmpName,
Username = employeeDetails.Username,
EmpPhone = employeeDetails.EmpPhone,
EmpAddress = employeeDetails.EmpAddress,
EmpRole = employeeDetails.EmpRole,
EmpPassword = employeeDetails.EmpPassword,
EmpProjectId = employeeDetails.EmpProjectId,
AdminFlag = employeeDetails.AdminFlag,
EmpFlag = employeeDetails.EmpFlag
};
_employeesContext.EmployeeDetails.Add(emp);
_employeesContext.SaveChanges();
return(true);
}
catch (SqlException sqle)
{
return(false);
}
}
//Checks user credentials, returns the object containing details of employee if it exists
public CustomModels.CustomEmployee checkUser(CustomModels.CustomEmployee customEmployee)
{
CustomModels.CustomEmployee ce = null;
DbModels.EmployeeDetails employee = _employeesContext.EmployeeDetails.Where(x => x.Username == customEmployee.Username && x.EmpPassword == customEmployee.EmpPassword).FirstOrDefault();
if (employee != null)
{
ce = new CustomModels.CustomEmployee
{
EmpName = employee.EmpName,
Username = employee.Username,
EmpPhone = employee.EmpPhone,
EmpRole = employee.EmpRole,
EmpProjectId = employee.EmpProjectId,
EmpFlag = employee.EmpFlag,
AdminFlag = employee.AdminFlag
};
return(ce);
}
return(ce);
}
//Delete employee and the token for signature matching
public int deleteEmp(string usn, string token)
{
if (_businessLogic.checkUserAuthentication(token))
{
DbModels.EmployeeDetails emp = _employeesContext.EmployeeDetails.Where(x => x.Username == usn).FirstOrDefault();
if (emp != null)
{
_employeesContext.EmployeeDetails.Remove(emp);
_employeesContext.SaveChanges();
return(1);
}
else
{
return(0);
}
}
else
{
return(2);
}
}
