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); }