public void InitializeCustomControls()
{
MEAPSDbEntities context = new MEAPSDbEntities();
List <ComboBoxItem> cbListEmp = new List <ComboBoxItem>();
foreach (Employee item in context.Employees)
{
ComboBoxItem cbiEmp = new ComboBoxItem();
cbiEmp.Content = item.EmpId;
cbiEmp.Tag = item.EmpId;
cbListEmp.Add(cbiEmp);
}
cbEmp.ItemsSource = cbListEmp;
cbEmp.ItemsSource = cbListEmp;
for (int i = 0; i < 24; i++)
{
cbInHrs.Items.Add(i);
cbOutHrs.Items.Add(i);
}
for (int i = 0; i < 60; i++)
{
cbInMins.Items.Add(i);
cbOutMins.Items.Add(i);
}
dataGrid.ItemsSource = context.Attendances.ToList();
dataGrid.Items.Refresh();
}
private void btnUpload_Click(object sender, RoutedEventArgs e)
{
string filepath = txtPath.Text;
DataTable csvFileData = new DataTable();
if (chkClear.IsChecked == true)
{
MEAPSDbEntities context = new MEAPSDbEntities();
context.Database.ExecuteSqlCommand("TRUNCATE TABLE [CSVDatas]");
LogString("Cleared old records.");
}
LogString("Converting CSV to DataTable...");
try
{
csvFileData = CsvToDb.CsvToDataTable.ConvertCsvtoDataTable(filepath);
}
catch (Exception ex)
{
LogString(ex.Message);
}
LogString("Inserting DataTable to Database...");
try
{
CsvToDb.DataTabletoDB.InsertDataIntoSQLServerUsingSQLBulkCopy(csvFileData);
}
catch (Exception ex)
{
LogString(ex.Message);
}
LogString("Done!");
}
private void btnLeaveStatTruncate_Click(object sender, RoutedEventArgs e)
{
MEAPSDbEntities context = new MEAPSDbEntities();
context.Database.ExecuteSqlCommand("TRUNCATE TABLE[LeaveStatuses]");
context.SaveChanges();
RefreshDataGrids();
}
private void InitializeComboBoxes()
{
//initialize employee list
MEAPSDbEntities context = new MEAPSDbEntities();
List <ComboBoxItem> cbListEmp = new List <ComboBoxItem>();
foreach (Employee item in context.Employees)
{
ComboBoxItem cbiEmp = new ComboBoxItem();
cbiEmp.Content = item.EmpId;
cbiEmp.Tag = item.EmpId;
cbListEmp.Add(cbiEmp);
}
cbAEEmp.ItemsSource = cbListEmp;
cbLEEmp.ItemsSource = cbListEmp;
cbReportEmp.ItemsSource = cbListEmp;
//initialize time selectors
for (int i = 0; i < 24; i++)
{
cbInHrs.Items.Add(i);
cbOutHrs.Items.Add(i);
}
for (int i = 0; i < 60; i++)
{
cbInMins.Items.Add(i);
cbOutMins.Items.Add(i);
}
cbInHrs.SelectedIndex = 9;
cbInMins.SelectedIndex = 50;
cbOutHrs.SelectedIndex = 17;
cbOutMins.SelectedIndex = 25;
//initialize year selectors
int lastyear = Int32.Parse(System.DateTime.Now.Year.ToString()) + 5;
int firstyear = Int32.Parse(System.DateTime.Now.Year.ToString()) - 5;
for (int i = firstyear; i <= lastyear; i++)
{
cbLeaveStatMonthlyYear.Items.Add(i);
cbReportYears.Items.Add(i);
}
cbLeaveStatMonthlyYear.SelectedIndex = 5;
cbReportMonths.SelectedIndex = 1;
cbReportYears.SelectedIndex = 5;
try
{
cbAEEmp.SelectedIndex = 0;
cbLEEmp.SelectedIndex = 0;
cbLeaveType.SelectedIndex = 0;
cbReportEmp.SelectedIndex = 0;
}
catch (Exception)
{
}
}
private void btnAEDel_Click(object sender, RoutedEventArgs e)
{
ExceptionAttendance ae = (ExceptionAttendance)dataGridExcepHolidays.SelectedItem;
MEAPSDbEntities context = new MEAPSDbEntities();
ExceptionAttendance deletable = context.ExceptionAttendances.SingleOrDefault(x => ((x.EmpId == ae.EmpId) && (x.Date == ae.Date)));
context.ExceptionAttendances.Remove(deletable);
context.SaveChanges();
RefreshDataGrids();
}
private void btnLEDel_Click(object sender, RoutedEventArgs e)
{
LeaveApplication la = (LeaveApplication)dataGridLeaveApp.SelectedItem;
MEAPSDbEntities context = new MEAPSDbEntities();
LeaveApplication deletable = context.LeaveApplications.SingleOrDefault(x => x.Date == la.Date);
context.LeaveApplications.Remove(deletable);
context.SaveChanges();
RefreshDataGrids();
}
private void btnHolidaysDel_Click(object sender, RoutedEventArgs e)
{
Holiday h = (Holiday)dataGridHolidays.SelectedItem;
MEAPSDbEntities context = new MEAPSDbEntities();
Holiday deletable = context.Holidays.SingleOrDefault(x => x.Date == h.Date);
context.Holidays.Remove(deletable);
context.SaveChanges();
RefreshDataGrids();
}
private void btnEmpDelSelected_Click(object sender, RoutedEventArgs e)
{
MEAPSDbEntities context = new MEAPSDbEntities();
Employee em = (Employee)dataGridEmployees.SelectedItem;
Employee deletable = context.Employees.SingleOrDefault(x => x.EmpId == em.EmpId);
context.Employees.Remove(deletable);
context.SaveChanges();
RefreshDataGrids();
}
private void btnTEDel_Click(object sender, RoutedEventArgs e)
{
TimeException te = (TimeException)dataGridExcepTime.SelectedItem;
MEAPSDbEntities context = new MEAPSDbEntities();
TimeException deletable = context.TimeExceptions.SingleOrDefault(x => x.Date == te.Date);
context.TimeExceptions.Remove(deletable);
context.SaveChanges();
RefreshDataGrids();
}
private void btnHolidaysAdd_Click(object sender, RoutedEventArgs e)
{
MEAPSDbEntities context = new MEAPSDbEntities();
Holiday h = new Holiday();
h.Date = (DateTime)calHolidays.SelectedDate;
h.Comment = txtHolidayComment.Text;
context.Holidays.Add(h);
context.SaveChanges();
RefreshDataGrids();
}
private void btnDel_Click(object sender, RoutedEventArgs e)
{
Attendance at = (Attendance)dataGrid.SelectedItem;
MEAPSDbEntities context = new MEAPSDbEntities();
Attendance deletable = context.Attendances.SingleOrDefault(x => x.SISOId == at.SISOId);
context.Attendances.Remove(deletable);
context.SaveChanges();
dataGrid.ItemsSource = context.Attendances.ToList();
dataGrid.Items.Refresh();
}
private void btnAEAdd_Click(object sender, RoutedEventArgs e)
{
MEAPSDbEntities context = new MEAPSDbEntities();
ExceptionAttendance ae = new ExceptionAttendance();
ComboBoxItem EmpId = (ComboBoxItem)cbAEEmp.SelectedItem;
ae.EmpId = Convert.ToInt32(EmpId.Content);
ae.Date = Convert.ToDateTime(dtAEDate.Text);
ae.Remarks = txtAERemarks.Text;
context.ExceptionAttendances.Add(ae);
context.SaveChanges();
RefreshDataGrids();
}
private void btnLEAdd_Click(object sender, RoutedEventArgs e)
{
LeaveApplication la = new LeaveApplication();
la.Date = Convert.ToDateTime(dtLEDate.Text);
la.EmployeeEmpId = Int32.Parse(cbLEEmp.Text);
la.Type = cbLeaveType.Text;
la.Remarks = txtLERemarks.Text;
MEAPSDbEntities context = new MEAPSDbEntities();
context.LeaveApplications.Add(la);
context.SaveChanges();
RefreshDataGrids();
}
private void btnTEAdd_Click(object sender, RoutedEventArgs e)
{
MEAPSDbEntities context = new MEAPSDbEntities();
TimeException te = new TimeException();
te.Date = Convert.ToDateTime(dtTEDate.Text);
string entryTime = cbInHrs.Text + ":" + cbInMins.Text;
string exitTime = cbOutHrs.Text + ":" + cbOutMins.Text;
te.InTime = TimeSpan.Parse(entryTime);
te.OutTime = TimeSpan.Parse(exitTime);
context.TimeExceptions.Add(te);
context.SaveChanges();
RefreshDataGrids();
}
private void btnEmpAdd_Click(object sender, RoutedEventArgs e)
{
MEAPSDbEntities context = new MEAPSDbEntities();
Employee em = new Employee();
em.EmpId = Int32.Parse(txtEmpId.Text);
em.Name = txtEmpName.Text;
em.Dept = txtDept.Text;
em.CL = Double.Parse(txtCL.Text);
em.ML = Double.Parse(txtML.Text);
em.EL = Double.Parse(txtEL.Text);
em.LWP = Double.Parse(txtLWP.Text);
em.JoiningDate = Convert.ToDateTime(dtJoiningDate.Text);
context.Employees.Add(em);
context.SaveChanges();
RefreshDataGrids();
}
private void btnEmpUpdate_Click(object sender, RoutedEventArgs e)
{
MEAPSDbEntities context = new MEAPSDbEntities();
Employee em = (Employee)dataGridEmployees.SelectedItem;
Employee updatable = context.Employees.SingleOrDefault(x => x.EmpId == em.EmpId);
updatable.EmpId = int.Parse(txtEmpId.Text);
updatable.Name = txtEmpName.Text;
updatable.Dept = txtDept.Text;
updatable.CL = Double.Parse(txtCL.Text);
updatable.ML = Double.Parse(txtML.Text);
updatable.EL = Double.Parse(txtEL.Text);
updatable.JoiningDate = Convert.ToDateTime(dtJoiningDate.Text);
updatable.LWP = Double.Parse(txtLWP.Text);
context.SaveChanges();
RefreshDataGrids();
}
private void Window_Closing(object sender, System.ComponentModel.CancelEventArgs e)
{
MEAPSDbEntities context = new MEAPSDbEntities();
TabCtrl t = context.TabCtrls.First();
MessageBoxResult result = MessageBox.Show("Save position?", "Confirmation", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
t.selectedIndex = tabCtrlMain.SelectedIndex.ToString();
}
else
{
t.selectedIndex = "0";
}
context.SaveChanges();
Application.Current.Shutdown();
}
public MainWindow()
{
InitializeComponent();
RefreshDataGrids();
MEAPSDbEntities context = new MEAPSDbEntities();
TabCtrl t = context.TabCtrls.FirstOrDefault();
if (t == null)
{
t = new TabCtrl();
t.selectedIndex = "0";
context.TabCtrls.Add(t);
context.SaveChanges();
}
btnLaunchViewer.Visibility = Visibility.Hidden;
tabCtrlMain.SelectedIndex = Int32.Parse(t.selectedIndex);
}
private void btnAdd_Click(object sender, RoutedEventArgs e)
{
Attendance at = new Attendance();
string entryTime = cbInHrs.Text + ":" + cbInMins.Text;
string exitTime = cbOutHrs.Text + ":" + cbOutMins.Text;
ComboBoxItem EmpId = (ComboBoxItem)cbEmp.SelectedItem;
at.Employee_EmpId = Convert.ToInt32(EmpId.Content);
at.InTime = TimeSpan.Parse(entryTime);
at.OutTime = TimeSpan.Parse(exitTime);
at.Date = Convert.ToDateTime(dtDate.Text);
MEAPSDbEntities context = new MEAPSDbEntities();
context.Attendances.Add(at);
context.SaveChanges();
dataGrid.ItemsSource = context.Attendances.ToList();
dataGrid.Items.Refresh();
}
//end of global declarations
private void RefreshDataGrids()
{
MEAPSDbEntities context = new MEAPSDbEntities();
dataGridEmployees.ItemsSource = context.Employees.ToList();
dataGridEmployees.Items.Refresh();
dataGridHolidays.ItemsSource = context.Holidays.ToList();
dataGridHolidays.Items.Refresh();
dataGridExcepHolidays.ItemsSource = context.ExceptionAttendances.ToList();
dataGridExcepHolidays.Items.Refresh();
dataGridExcepTime.ItemsSource = context.TimeExceptions.ToList();
dataGridExcepTime.Items.Refresh();
dataGridLeaveApp.ItemsSource = context.LeaveApplications.ToList();
dataGridLeaveApp.Items.Refresh();
dataGridLeaveStat.ItemsSource = context.LeaveStatuses.ToList();
dataGridLeaveStat.Items.Refresh();
InitializeComboBoxes();
}
private void btnShowMessage_Click(object sender, RoutedEventArgs e)
{
int c = 0;
if (rdChoice1.IsChecked == true)
{
c = 1;
}
if (rdChoice2.IsChecked == true)
{
c = 2;
}
int EmpId = Int32.Parse(cbReportEmp.Text);
MEAPSDbEntities context = new MEAPSDbEntities();
Employee em = context.Employees.SingleOrDefault(x => x.EmpId == EmpId);
switch (c)
{
case 1:
string result = "Employee Id: " + em.EmpId + "\nEmployee Name: " + em.Name + "\nRemaining CL: " + em.CL + "\nRemaining ML: " + em.ML + "\nRemaining EL: " + em.EL + "\nLeaves without Pay: " + em.LWP;
MessageBoxResult res = MessageBox.Show(result, "Result", MessageBoxButton.OK, MessageBoxImage.Information);
break;
case 2:
double sumCL = 0, sumML = 0, sumEL = 0, sumLWP = 0;
if (dataGridLeaveStat.Items.Count <= 1)
{
MessageBoxResult alertbox = MessageBox.Show("Please generate daily attendance reports first.", "Warning", MessageBoxButton.OK, MessageBoxImage.Exclamation);
}
else
{
List <LeaveStatus> ls_emp = (from x in context.LeaveStatuses where x.EmployeeEmpId == em.EmpId select x).ToList();
if (cbReportMonths.SelectedIndex == 0)
{
List <LeaveStatus> ls_emp_mon = (from x in ls_emp where x.Date.Year == int.Parse(cbReportYears.Text) select x).ToList();
sumCL = ls_emp_mon.Sum(x => ((x.FCL ?? 0) + (0.5 * (x.HCL ?? 0)) + (0.25 * ((x.QCL_In ?? 0) + (x.QCL_Out ?? 0)))));
sumML = ls_emp_mon.Sum(x => ((x.FML ?? 0) + (0.5 * (x.HML ?? 0))));
sumEL = ls_emp_mon.Sum(x => (x.EL ?? 0));
sumLWP = ls_emp_mon.Sum(x => x.LWP);
string result2 = "Employee Id: " + em.EmpId + "\nEmployee Name: " + em.Name + "\nTotal CL: " + sumCL + "\nTotal ML: " + sumML + "\nTotal EL: " + sumEL + "\nTotal Leaves without Pay: " + sumLWP;
MessageBoxResult res2 = MessageBox.Show(result2, "Result", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
int month = cbReportMonths.SelectedIndex;
List <LeaveStatus> ls_emp_mon = (from x in ls_emp where x.Date.Month == month && x.Date.Year == int.Parse(cbReportYears.Text) select x).ToList();
sumCL = ls_emp_mon.Sum(x => ((x.FCL ?? 0) + (0.5 * (x.HCL ?? 0)) + (0.25 * ((x.QCL_In ?? 0) + (x.QCL_Out ?? 0)))));
sumML = ls_emp_mon.Sum(x => ((x.FML ?? 0) + (0.5 * (x.HML ?? 0))));
sumEL = ls_emp_mon.Sum(x => (x.EL ?? 0));
sumLWP = ls_emp_mon.Sum(x => x.LWP);
string result2 = "Employee Id: " + em.EmpId + "\nEmployee Name: " + em.Name + "\nTotal CL: " + sumCL + "\nTotal ML: " + sumML + "\nTotal EL: " + sumEL + "\nTotal Leaves without Pay: " + sumLWP;
MessageBoxResult res2 = MessageBox.Show(result2, "Result", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
break;
default:
break;
}
}