private bool insertAttendanceDetail(Apitoken apiToken, List <AttendanceDetail> attendanceDetail) { AttendanceDetail payrollHrpayrollAttDetail = new AttendanceDetail(); List <AttendanceDetail> attend = attendanceDetail; bool status = false; string employeeID = ""; try { if (attendanceDetail != null) { List <AttendanceDetail> att = attendanceDetail.GroupBy(x => x.EmployeeId).Select(g => g.First()).ToList(); foreach (AttendanceDetail attendanceDetailObj in att) { PayrollHrpayrollAttDetail payrollHrpayrollAttDetailObj = new PayrollHrpayrollAttDetail(); payrollHrpayrollAttDetailObj.CompanyId = apiToken.CompanyId; payrollHrpayrollAttDetailObj.DivisionId = apiToken.DivisionId; payrollHrpayrollAttDetailObj.DepartmentId = apiToken.DepartmentId; payrollHrpayrollAttDetailObj.AttendanceDate = attendanceDetailObj.AttendanceDate; employeeID = getEmployeeID(apiToken, attendanceDetailObj); payrollHrpayrollAttDetailObj.EmployeeId = employeeID == null || employeeID == "" ? attendanceDetailObj.EmployeeId : employeeID; payrollHrpayrollAttDetailObj.EmployeeName = attendanceDetailObj.EmployeeName; payrollHrpayrollAttDetailObj.ExpectedTimeIn = attendanceDetailObj.ExpectedTimeIn; payrollHrpayrollAttDetailObj.TimeIn = attendanceDetailObj.TimeIn; payrollHrpayrollAttDetailObj.ShiftType = attendanceDetailObj.ShiftType; payrollHrpayrollAttDetailObj.Absent = attendanceDetailObj.Absent; payrollHrpayrollAttDetailObj.Remarks = attendanceDetailObj.Remarks; payrollHrpayrollAttDetailObj.LatePeriod = attendanceDetailObj.LatePeriod; payrollHrpayrollAttDetailObj.Period = attendanceDetailObj.Period; payrollHrpayrollAttDetailObj.BranchCode = attendanceDetailObj.BranchCode; _DBContext.Entry(payrollHrpayrollAttDetailObj).State = EntityState.Added; } return(status = true); } } catch (Exception ex) { return(status = false); } return(status); }
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); }
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); }