public async Task <List <PayrollEmployees> > Post([FromBody] JObject jObject)
{
List <PayrollEmployees> list = new List <PayrollEmployees>();
//APIToken apiToken = new APIToken();
//apiToken.CompanyId = "ABRAAJ";
//apiToken.DivisionId = "DEFAULT";
//apiToken.DepartmentId = "DEFAULT";
PayrollEmployees payrollEmployees = jObject["payrollEmp"].ToObject <PayrollEmployees>();
APIToken apiToken = jObject["apiToken"].ToObject <APIToken>();
try
{
var empDetails = await _DBContext.PayrollEmployees.Where(x => x.CompanyId == apiToken.CompanyId &&
x.DivisionId == apiToken.DivisionId &&
x.DepartmentId == apiToken.DepartmentId &&
x.EmployeeId == payrollEmployees.EmployeeId &&
x.EmployeePassword == payrollEmployees.EmployeePassword).ToListAsync();
if (empDetails != null)
{
list = empDetails;
}
}
catch (Exception dd)
{
}
return(list);
}
//checks if the user exists on the db
public bool ValidateUserLogin(string vCompany, string vUsername, string vOldPwd)
{
bool vValidUser = false;
string vconvertedPwrd = DataAccess.doConvertPwd(vOldPwd);
PayrollEmployees payrollEmployeesObj = new PayrollEmployees()
{
CompanyId = vCompany,
EmployeeId = vUsername,
EmployeePassword = vconvertedPwrd
};
var emp = JsonConvert.SerializeObject(payrollEmployeesObj);
var response = client.PostAsync("http://localhost:3295/api/ChangePassword",
new StringContent(emp, Encoding.UTF8, "application/json"));
response.Wait();
var result = response.Result;
if (result.IsSuccessStatusCode)
{
Uri employeeUrl = result.Headers.Location;
var statusMessage = result.Content.ReadAsStringAsync().Result;
List <PayrollEmployees> employeeList = JsonConvert.DeserializeObject <List <PayrollEmployees> >(statusMessage);
if (employeeList.Count > 0)
{
vValidUser = true;;
}
}
return(vValidUser);
}
public bool Post([FromBody] UserInfo user)
{
bool status = false;
//UserInfo user = new UserInfo()
//{
// CompanyId = "ABRAAJ",
// DepartmentId = "DEFAULT",
// DivisionId = "DEFAULT",
// EmployeeId = "Admin",
// //Password = "******"
//};
if (user != null)
{
PayrollEmployees payrollEmployees = _DBContext.PayrollEmployees
.Where(a => a.CompanyId == user.CompanyId &&
a.DivisionId == user.DivisionId &&
a.DepartmentId == user.DepartmentId &&
a.EmployeeId == user.EmployeeId).FirstOrDefault();
if (payrollEmployees != null)
{
status = true;
}
}
return(status);
}
public PayrollEmployees Get()
{
PayrollEmployees user = new PayrollEmployees();
try
{
user = _DBContext.PayrollEmployees.Where(x => x.EmployeeId == "Admin").FirstOrDefault();
}
catch (Exception es)
{
//throw;
}
return(user);
}
public string Post([FromBody] Employees employees)
{
string message = "no";
if (employees != null)
{
//PayrollEmployees payrollEmployees = jObject["payrollEmp"].ToObject<PayrollEmployees>();
//string apiToken = jObject["apiToken"].ToString();
Apitoken apitoken = new Apitoken();
string password = validatePassword(employees.EmployeePassword);
try
{
apitoken = _DBContext.ApiToken.Where(a => a.Token == employees.apiToken).FirstOrDefault();
}
catch (Exception ex)
{
}
if (apitoken != null)
{
try
{
PayrollEmployees empDetails = _DBContext.PayrollEmployees
.Where(x => x.CompanyId == apitoken.CompanyId &&
x.DivisionId == apitoken.DivisionId &&
x.DepartmentId == apitoken.DepartmentId &&
x.EmployeeId == employees.EmployeeId &&
x.EmployeePassword == password &&
x.EmployeeTypeId == "user").FirstOrDefault();
if (empDetails != null)
{
message = "yes";
}
}
catch (Exception dd)
{
}
}
else
{
message = "Invalid Token";
}
}
;
return(message);
}
private void btnChangePwd_Click(object sender, EventArgs e)
{
bool status = ValidateUser();
string convertedPwrd = "";
string oldconvertedPwrd = "";
if (status)
{
vcmbxCompany = cmbCompanyChpwrd.Text.ToString();
vtxtUsername = txtUsernameCh.Text.ToString();
vtxtOldPwd = txtOldPwd.Text.ToString();
vtxtNewPwd = txtNewPwd.Text.ToString();
vtxtCnfmPwd = txtCnfmPwd.Text.ToString();
convertedPwrd = DataAccess.doConvertPwd(vtxtCnfmPwd);
oldconvertedPwrd = DataAccess.doConvertPwd(vtxtOldPwd);
try
{
//DataAccess.UpdateData("PayrollEmployees", CompanyID, DivisionID, DepartmentID, "EmployeeID", username, "EmployeePassword", convertedPwrd, "EmployeePasswordDate", changeDate, "EmployeePasswordOld", dconvertedPwrd);
PayrollEmployees payrollEmployeesObj = new PayrollEmployees()
{
CompanyId = vcmbxCompany,
EmployeeId = vtxtUsername,
EmployeePassword = convertedPwrd,
EmployeePasswordOld = oldconvertedPwrd,
EmployeePasswordDate = changeDate,
};
var emp = JsonConvert.SerializeObject(payrollEmployeesObj);
var response = client.PutAsync("http://localhost:3295/api/ChangePassword",
new StringContent(emp, Encoding.UTF8, "application/json"));
response.Wait();
var result = response.Result;
}
catch (Exception ex)
{
}
//DialogResult result = MessageBox.Show("Password Successfully changed", "Password Change", MessageBoxButtons.OK);
//if (result == DialogResult.OK)
//{
// this.Hide();
// LoginPage.ShowDialog();
//}
}
}
public string Post([FromBody] Employees employees)
{
string message = "no";
if (employees != null)
{
Apitoken apitoken = new Apitoken();
string password = validatePassword(employees.EmployeePassword);
try
{
apitoken = _DBContext.ApiToken.Where(a => a.Token == employees.apiToken).FirstOrDefault();
if (apitoken != null)
{
PayrollEmployees empDetails = _DBContext.PayrollEmployees
.Where(x => x.CompanyId == apitoken.CompanyId &&
x.DivisionId == apitoken.DivisionId &&
x.DepartmentId == apitoken.DepartmentId &&
x.EmployeeId == employees.EmployeeId &&
x.EmployeePassword == password &&
x.EmployeeTypeId == "User").FirstOrDefault();
if (empDetails != null)
{
return(message = "yes");
}
else
{
return(message = "invalid user");
}
}
else
{
return(message = "Invalid Token");
}
}
catch (Exception dd)
{
}
}
;
return(message);
}
public string getEmployeeID(Apitoken apiToken, AttendanceDetail attendanceDetail)
{
string employeeID = "";
try
{
PayrollEmployees empl = _DBContext.PayrollEmployees.Where(x => x.CompanyId == apiToken.CompanyId &&
x.DivisionId == apiToken.DivisionId &&
x.DepartmentId == apiToken.DepartmentId &&
x.EmployeeBiometricID == attendanceDetail.EmployeeId).AsNoTracking().
FirstOrDefault();
employeeID = empl.EmployeeId;
}
catch (Exception ex)
{
}
return(employeeID);
}
