public void LoadComboBox()
{
try
{
List <EmpCombo> EList = new List <EmpCombo>();
using (var db = new LetranIntegratedSystemEntities())
{
var emp = (from a in db.LeaveBalances
join b in db.Employees on a.EmployeeID equals b.EmployeeID
select new { b.FirstName, b.LastName, b.EmployeeNo, b.EmployeeID }).ToList();
foreach (var i in emp)
{
EmpCombo ec = new EmpCombo();
ec.EmployeeID = i.EmployeeID;
ec.EmployeeNumber = i.EmployeeNo;
ec.EmployeeName = i.LastName.ToUpper() + ", " + i.FirstName.ToUpper();
EList.Add(ec);
}
cbEmployee.ItemsSource = EList.OrderBy(m => m.EmployeeName);
cbEmployee.DisplayMemberPath = "EmployeeName";
cbEmployee.SelectedValuePath = "EmployeeID";
}
}
catch (Exception)
{
throw;
}
}
public void LoadComboBox()
{
try
{
EList = new List <EmpCombo>();
db = new LetranIntegratedSystemEntities();
var emp = db.Employees.Where(m => m.Archive == false).ToList();
foreach (var i in emp)
{
EmpCombo ec = new EmpCombo();
ec.EmployeeID = i.EmployeeID;
ec.EmployeeNumber = i.EmployeeNo;
ec.EmployeeName = i.LastName.ToUpper() + ", " + i.FirstName.ToUpper();
EList.Add(ec);
}
cbEmployee.ItemsSource = EList.OrderBy(m => m.EmployeeName);
cbEmployee.DisplayMemberPath = "EmployeeName";
cbEmployee.SelectedValuePath = "EmployeeID";
cbType.ItemsSource = db.LeaveTypes.OrderBy(m => m.LeaveCode).ToList();
cbType.DisplayMemberPath = "LeaveDescription";
cbType.SelectedValuePath = "LeaveTypeID";
}
catch (Exception)
{
MessageBox.Show("Something went wrong!", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public void LoadComboBox()
{
try
{
db = new LetranIntegratedSystemEntities();
EList = new List <EmpCombo>();
var listbal = db.LeaveBalances.ToList();
var listemp = db.Employees.Where(m => m.EmployeeStatusID == 3 && m.Archive == false).ToList();
var x = (from a in listemp
where !listbal.Select(m => m.EmployeeID).Contains(a.EmployeeID)
select a).ToList();
foreach (var i in x)
{
EmpCombo ec = new EmpCombo();
ec.EmployeeID = i.EmployeeID;
ec.EmployeeNumber = i.EmployeeNo;
ec.EmployeeName = i.LastName.ToUpper() + ", " + i.FirstName.ToUpper();
EList.Add(ec);
}
cbEmp.ItemsSource = EList.OrderBy(m => m.EmployeeName);
cbEmp.DisplayMemberPath = "EmployeeName";
cbEmp.SelectedValuePath = "EmployeeID";
}
catch (Exception)
{
MessageBox.Show("Something went wrong.", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public void LoadComboBox()
{
try
{
db = new LetranIntegratedSystemEntities();
EList = new List <EmpCombo>();
var listbal = db.LeaveBalances.ToList();
var listemp = db.Employees.Where(m => m.EmployeeStatusID == 3 && m.Archive == false).ToList();
var x = (from a in listemp
where listbal.Select(m => m.EmployeeID).Contains(a.EmployeeID)
select a).ToList();
foreach (var i in x)
{
EmpCombo ec = new EmpCombo();
ec.EmployeeID = i.EmployeeID;
ec.EmployeeNumber = i.EmployeeNo;
ec.EmployeeName = i.LastName.ToUpper() + ", " + i.FirstName.ToUpper();
EList.Add(ec);
}
cbEmployee.ItemsSource = EList.OrderBy(m => m.EmployeeName);
cbEmployee.DisplayMemberPath = "EmployeeName";
cbEmployee.SelectedValuePath = "EmployeeID";
cbLeaveType.ItemsSource = db.LeaveTypes.OrderBy(m => m.LeaveDescription).ToList();
cbLeaveType.DisplayMemberPath = "LeaveDescription";
cbLeaveType.SelectedValuePath = "LeaveTypeID";
cbShift.Items.Add("Morning");
cbShift.Items.Add("Afternoon");
for (double i = 0.5; i <= 20; i = i + 0.5)
{
txtDays.Items.Add(i.ToString());
}
}
catch (Exception)
{
MessageBox.Show("Something went wrong.", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public void LoadComboBox()
{
try
{
EList = new List <EmpCombo>();
MList = new List <Month>();
db = new LetranIntegratedSystemEntities();
var emp = db.Employees.Where(m => m.Archive == false).ToList();
foreach (var i in emp)
{
EmpCombo ec = new EmpCombo();
ec.EmployeeID = i.EmployeeID;
ec.EmployeeNumber = i.EmployeeNo;
ec.EmployeeName = i.LastName.ToUpper() + ", " + i.FirstName.ToUpper();
EList.Add(ec);
}
cbEmployee.ItemsSource = EList.OrderBy(m => m.EmployeeName);
cbEmployee.DisplayMemberPath = "EmployeeName";
cbEmployee.SelectedValuePath = "EmployeeID";
for (int x = Convert.ToInt32(DateTime.Now.Year); x < (Convert.ToInt32(DateTime.Now.Year) + 10); x = x + 1)
{
cbYear.Items.Add(x);
}
for (int x = 0; x < 12; x++)
{
Month m = new Month();
m.MonthID = x;
m.MonthDescription = System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.MonthNames[x];
MList.Add(m);
}
cbMonth.ItemsSource = MList.OrderBy(m => m.MonthID);
cbMonth.DisplayMemberPath = "MonthDescription";
cbMonth.SelectedValuePath = "MonthID";
}
catch (Exception)
{
MessageBox.Show("Something went wrong!", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void LoadComboBox()
{
var db = new LetranIntegratedSystemEntities();
var emp = db.Employees.Where(m => m.Archive == false).ToList();
List <EmpCombo> EList = new List <EmpCombo>();
foreach (var i in emp)
{
EmpCombo ec = new EmpCombo();
ec.EmployeeID = i.EmployeeID;
ec.EmployeeNumber = i.EmployeeNo;
ec.EmployeeName = i.LastName.ToUpper() + ", " + i.FirstName.ToUpper();
EList.Add(ec);
}
cbEmp.ItemsSource = EList.OrderBy(m => m.EmployeeName);
cbEmp.DisplayMemberPath = "EmployeeName";
cbEmp.SelectedValuePath = "EmployeeID";
}
