public void GetAllBiometrics() { // try // { db = new LetranIntegratedSystemEntities(); sof = new softrakEntities(); BList = new List <BiometricList>(); if (!String.IsNullOrEmpty(cbEmployee.Text)) { var biometricLogData = (from a in db.BiometricsLogDatas join b in db.Employees on a.EMPN equals b.bioid select new { a.Id, b.EmployeeNo, EmployeeName = b.LastName.ToUpper() + ", " + b.FirstName.ToUpper(), a.DTIME, a.MODE }).ToList(); foreach (var x in biometricLogData) { BiometricList bl = new BiometricList(); bl.AttendanceID = x.Id; bl.EmployeeNumber = x.EmployeeNo; bl.EmployeeName = x.EmployeeName; bl.BiometricDate = x.DTIME.Date; bl.DayOfWeek = x.DTIME.Date.DayOfWeek.ToString().ToUpper(); bl.Month = x.DTIME.Date.ToString("MMMM").ToUpper(); ////bl.BiometricTime = x.DTIME. ; //if (x.MODE == "I") //{ // bl.Type = "IN"; //} //else if (x.MODE == "BO") //{ // bl.Type = "BREAK OUT"; //} //else if (x.MODE == "BI") //{ // bl.Type = "BREAK IN"; //} //else if (x.MODE == "O") //{ // bl.Type = "OUT"; //} BList.Add(bl); } dgTurnstile.ItemsSource = BList.OrderByDescending(m => m.BiometricDate); } //} //catch (Exception) //{ // MessageBox.Show("Something went wrong.", "System Error!", MessageBoxButton.OK, MessageBoxImage.Warning); //} }
public void GetBiometrics() { //try //{ db = new LetranIntegratedSystemEntities(); sof = new softrakEntities(); BList = new List <BiometricList>(); if (!String.IsNullOrEmpty(cbEmployee.Text)) { string empno = Convert.ToString(cbEmployee.SelectedValue); DateTime startdate = Convert.ToDateTime(sdate.SelectedDate); DateTime enddate = Convert.ToDateTime(edate.SelectedDate); BList = new List <BiometricList>(); var attendance = db.GetEmployeeAttendanceByEmployeeNumber(Convert.ToString(sdate), Convert.ToString(edate), empno).OrderBy(m => m.DATE); var employee = db.Employees.Where(m => m.EmployeeNo == empno).FirstOrDefault(); foreach (var x in attendance) { BiometricList bl = new BiometricList(); bl.BiometricDate = Convert.ToDateTime(x.DATE); bl.DayOfWeek = x.DATE.Value.ToString("ddd"); bl.TimeIn = x.TIMEIN; bl.BreakOut = x.BREAKOUT; bl.BreakIn = x.BREAKIN; bl.TimeOut = x.TIMEOUT; bl.Remarks = x.REMARK; bl.EmployeeName = employee.LastName + ", " + employee.FirstName; bl.EmployeeNumber = Convert.ToString(empno); bl.StarDate = Convert.ToDateTime(sdate.SelectedDate); bl.EndDate = Convert.ToDateTime(edate.SelectedDate); bl.TimeinID = Convert.ToInt32(x.TimeinID); bl.BreakOutID = Convert.ToInt32(x.BreakoutID); bl.BreakInID = Convert.ToInt32(x.BreakinID); bl.TimeOutID = Convert.ToInt32(x.TimeoutID); BList.Add(bl); } dgTurnstile.ItemsSource = BList.OrderByDescending(m => m.BiometricDate); } else { MessageBox.Show("Employee cannot be empty.", "System Warning!", MessageBoxButton.OK, MessageBoxImage.Warning); } //} //catch (Exception) //{ // MessageBox.Show("Something went wrong.", "System Error!", MessageBoxButton.OK, MessageBoxImage.Warning); //} }
private void btnApproved_Click(object sender, RoutedEventArgs e) { try { db = new LetranIntegratedSystemEntities(); var x = ((OnProcessList)dgOnProcess.SelectedItem); Leave leaveapp = db.Leaves.Find(x.LeaveID); if (x.IsOverdue == true) { if (leaveapp != null) { var empid = db.Employees.Where(m => m.EmployeeNo == x.EmployeeNo).FirstOrDefault(); HRiS.Model.LeaveBalance leavebal = db.LeaveBalances.Where(m => m.EmployeeID == empid.EmployeeID).FirstOrDefault(); // APPROVED PART //leaveapp.LeaveApprovedStatusID = 2; //leaveapp.ApprovedBy = db.Employees.Where(m => m.EmployeeNo == App.EmployeeNumber).FirstOrDefault().EmployeeID; //leaveapp.ApprovedDate = DateTime.Now; // LEAVE DEDUCTION //EL if (leaveapp.LeaveType.LeaveTypeID == 1) { leavebal.VacationLeaveBalance = leavebal.VacationLeaveBalance - x.Days; //leavebal.EmergencyLeaveBalance = leavebal.EmergencyLeaveBalance - x.Days; } //SL else if (leaveapp.LeaveType.LeaveTypeID == 4) { //leavebal.SickLeaveBalance = leavebal.SickLeaveBalance - x.Days; } //VL else if (leaveapp.LeaveType.LeaveTypeID == 5) { //leavebal.VacationLeaveBalance = leavebal.VacationLeaveBalance - x.Days; } //SPL else if (leaveapp.LeaveType.LeaveTypeID == 7) { //leavebal.SoloParentLeaveBalance = leavebal.SoloParentLeaveBalance - x.Days; } //BL else if (leaveapp.LeaveType.LeaveTypeID == 10) { // leavebal.BereavementLeaveBalance = leavebal.BereavementLeaveBalance - x.Days; } db.SaveChanges(); //Transfer leave to Softrak using (var sof = new softrakEntities()) { LEAf sofleav = new LEAf(); sofleav.USERNAME = App.EmployeeUserName; sofleav.EMPN = leaveapp.Employee.EmployeeNo; sofleav.DATE_FROM = leaveapp.StartDate.Value; sofleav.DATE_TO = leaveapp.EndDate.Value; //sofleav.TYPE sofleav.CODE = leaveapp.LeaveType.LeaveCode; //sofleav.ENTRYDATE = leaveapp.FiledDate.Value; sofleav.CREDITS = Convert.ToDouble(leaveapp.Days.Value); sof.LEAVES.Add(sofleav); sof.SaveChanges(); } MessageBox.Show("Leave Approved", "System Success!", MessageBoxButton.OK, MessageBoxImage.Information); GetLeave(); } else { MessageBox.Show("Cannot find leave transaction.", "System Warning", MessageBoxButton.OK, MessageBoxImage.Warning); } } else { MessageBox.Show("Cannot approve leave.", "System Warning!", MessageBoxButton.OK, MessageBoxImage.Warning); } } catch (Exception) { MessageBox.Show("Something went wrong.", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error); } }