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