public void GetBalance()
{
try
{
// db = new LetranIntegratedSystemEntities();
BList = new List <BalanceList>();
var x = db.GetHRiSLeaveBalances().OrderBy(m => m.EmployeeName).ToList();
foreach (var i in x)
{
BalanceList bl = new BalanceList();
bl.Department = i.Department;
bl.Designation = i.Designation;
bl.EmployeeID = i.EmployeeID;
bl.EmployeeName = i.EmployeeName.ToUpper();
bl.EmployeeNumber = i.EmployeeNo;
bl.LeaveBalanceID = i.LeaveBalanceID;
bl.SickLeaveBalance = i.SickLeaveBalance.Value;
bl.VacationLeaveBalance = i.VacationLeaveBalance.Value;
bl.ServiceIncentiveLeave = i.ServiceIncentiveLeave.Value;
//el.NickName = x.Nickname == null ? " " : x.Nickname;
BList.Add(bl);
}
dgBalances.ItemsSource = BList.OrderBy(m => m.EmployeeName);
}
catch (Exception)
{
MessageBox.Show("Something went wrong!", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void cbEmployee_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
using (var db = new LetranIntegratedSystemEntities())
{
BList = new List <BalanceList>();
var empid = Convert.ToInt32(cbEmployee.SelectedValue);
var x = db.GetHRiSLeaveBalances().Where(m => m.EmployeeID == empid).OrderBy(m => m.EmployeeName).FirstOrDefault();
BalanceList bl = new BalanceList();
if (x != null)
{
bl.Department = x.Department;
bl.Designation = x.Designation;
bl.EmployeeID = x.EmployeeID;
bl.EmployeeName = x.EmployeeName.ToUpper();
bl.EmployeeNumber = x.EmployeeNo;
bl.LeaveBalanceID = x.LeaveBalanceID;
bl.SickLeaveBalance = x.SickLeaveBalance.Value;
bl.VacationLeaveBalance = x.VacationLeaveBalance.Value;
bl.ServiceIncentiveLeave = x.ServiceIncentiveLeave.Value;
//el.NickName = x.Nickname == null ? " " : x.Nickname;
BList.Add(bl);
dgBalances.ItemsSource = BList.OrderBy(m => m.EmployeeName);
}
}
}
catch (Exception)
{
throw;
}
}