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);
        }
示例#2
0
        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);
        }