private void Button_Click(object sender, RoutedEventArgs e) { lastTable = Holiday_Database_Connector.GetTable().AsDataView(); holiday_table.ItemsSource = lastTable; foreach (DataGridColumn column in holiday_table.Columns) { column.Width = new DataGridLength(1.0, DataGridLengthUnitType.Star); } }
private void Search_Click(object sender, RoutedEventArgs e) { DateTime?startdate = startDate.SelectedDate; DateTime?enddate = EndDate.SelectedDate; lastTable = Holiday_Database_Connector.SearchByDate(startdate.ToString(), enddate.ToString()).AsDataView(); holiday_table.ItemsSource = lastTable; foreach (DataGridColumn column in holiday_table.Columns) { column.Width = new DataGridLength(1.0, DataGridLengthUnitType.Star); } }
private void Button_Click_1(object sender, RoutedEventArgs e) { StringBuilder command = new StringBuilder(); for (int i = 0; i < holiday_table.SelectedItems.Count; i++) { if (i > 0) { command.Append(" OR "); } command.Append("(Name = '" + (holiday_table.SelectedItems[i] as DataRowView)[0] + "')"); } Holiday_Database_Connector.DeleteTable(command.ToString()); lastTable = Holiday_Database_Connector.GetTable().AsDataView(); holiday_table.ItemsSource = lastTable; foreach (DataGridColumn column in holiday_table.Columns) { column.Width = new DataGridLength(1.0, DataGridLengthUnitType.Star); } }
private void ViewClicked(object sender, RoutedEventArgs e) { using (Leave.DataClients.SqlTableTracker test = new Leave.DataClients.SqlTableTracker(Leave.Modules.Holiday_Database_Connector.connection_string2, "Employees" + ",LeaveList")) { if (generateComboBox.Text != "Employee") { if (pastEmployee != "Yes") { /* * DataTable Table2 = test.SelectSpecific("EmployeeID,EmployeeName", "Designation ='" + jobTitleComboBox.Text + "'" + " and PastEmployee='" + pastEmployee + "'"); * String command = "LeaveType,LeavingDate,JoiningDate,Balance,DaysCount"; * StringBuilder rowconstraints = new StringBuilder("EmployeeID in("); * int i = 0; * * foreach (DataRow row in Table2.Rows) * { * if (i == 0) * { * rowconstraints.Append(row["EmployeeID"].ToString()); * i++; * } * else * rowconstraints.Append("," + row["EmployeeID"].ToString()); * * } * rowconstraints.Append(")"); * MessageBox.Show(rowconstraints.ToString()); * DataTable finalTable = Table2.Copy(); * * * //Holiday_Database_Connector.ResizeMyTable(Table);*/ if (jobTitleComboBox.Text != "All") { if (leaveTypeComboBox.Text != "All") { Table.ItemsSource = test.SelectSpecific("Employees.EmployeeName,LeaveType,LeavingDate,JoiningDate,Balance,DaysCount", "Employees.EmployeeID=LeaveList.EmployeeID" + " and Designation ='" + jobTitleComboBox.Text + "'" + " and PastEmployee ='No'" + " and LeaveType='" + leaveTypeComboBox.Text + "'").AsDataView(); } else { Table.ItemsSource = test.SelectSpecific("Employees.EmployeeName,LeaveType,LeavingDate,JoiningDate,Balance,DaysCount", "Employees.EmployeeID=LeaveList.EmployeeID" + " and Designation ='" + jobTitleComboBox.Text + "'" + " and PastEmployee ='No'").AsDataView(); } } else { if (leaveTypeComboBox.Text != "All") { Table.ItemsSource = test.SelectSpecific("Employees.EmployeeName,LeaveType,LeavingDate,JoiningDate,Balance,DaysCount", "Employees.EmployeeID=LeaveList.EmployeeID" + " and PastEmployee ='No'" + " and LeaveType='" + leaveTypeComboBox.Text + "'").AsDataView(); } else { Table.ItemsSource = test.SelectSpecific("Employees.EmployeeName,LeaveType,LeavingDate,JoiningDate,Balance,DaysCount", "Employees.EmployeeID=LeaveList.EmployeeID" + " and PastEmployee ='No'").AsDataView(); } } Holiday_Database_Connector.ResizeMyTable(Table); } else { if (jobTitleComboBox.Text != "All") { if (leaveTypeComboBox.Text != "All") { Table.ItemsSource = test.SelectSpecific("Employees.EmployeeName,LeaveType,LeavingDate,JoiningDate,Balance,DaysCount", "Employees.EmployeeID=LeaveList.EmployeeID" + " and Designation ='" + jobTitleComboBox.Text + "'" + " and LeaveType='" + leaveTypeComboBox.Text + "'").AsDataView(); } else { Table.ItemsSource = test.SelectSpecific("Employees.EmployeeName,LeaveType,LeavingDate,JoiningDate,Balance,DaysCount", "Employees.EmployeeID=LeaveList.EmployeeID" + " and Designation ='" + jobTitleComboBox.Text + "'").AsDataView(); } } else { if (leaveTypeComboBox.Text != "All") { Table.ItemsSource = test.SelectSpecific("Employees.EmployeeName,LeaveType,LeavingDate,JoiningDate,Balance,DaysCount", "Employees.EmployeeID=LeaveList.EmployeeID" + " and LeaveType='" + leaveTypeComboBox.Text + "'").AsDataView(); } else { Table.ItemsSource = test.SelectSpecific("Employees.EmployeeName,LeaveType,LeavingDate,JoiningDate,Balance,DaysCount", "Employees.EmployeeID=LeaveList.EmployeeID").AsDataView(); } Holiday_Database_Connector.ResizeMyTable(Table); } } } else { Table.ItemsSource = test.SelectSpecific("Employees.EmployeeName,LeaveType,LeavingDate,JoiningDate,Balance,DaysCount", "Employees.EmployeeID=LeaveList.EmployeeID" + " and EmployeeName='" + employeeTextBox.Text + "'").AsDataView(); } Holiday_Database_Connector.ResizeMyTable(Table); } }
private void Button_Click(object sender, RoutedEventArgs e) { holiday_table.ItemsSource = Holiday_Database_Connector.GetTable(); }
public Holidays() { InitializeComponent(); holiday_table.ItemsSource = Holiday_Database_Connector.GetTable(); }
public LeaveManagement() { bool executionEnded = false; bool validOptionSelected; DataManager dataManager = new DataManager(); do { Console.Clear(); validOptionSelected = false; try { switch (GetUserChoice("Entitlements", "Reports", "Configure", "Leave List", "Assign Leave", "Exit")) { case 1: do { Console.Clear(); try { switch (GetUserChoice("Add", "View", "Back")) { case 1: validOptionSelected = true; Console.WriteLine("Entitlements will be added here."); Console.Write("Press any key to continue ..."); Console.ReadKey(); break; case 2: validOptionSelected = true; DataManager dm = new DataManager(Entitlements.GetAllEntitlementInfo()); Console.WriteLine(dm.ExtractColumns("\t\t") + "\n" + dm.ExtractData("\t\t")); Console.Write("Press any key to continue ..."); Console.ReadKey(); break; case 3: validOptionSelected = true; break; default: Console.WriteLine("Wrong Input!"); Thread.Sleep(1000); break; } } catch (FormatException e) { Console.WriteLine("Wrong Input!"); Thread.Sleep(1000); } catch (Exception e) { Console.WriteLine("Wrong Input!"); Thread.Sleep(1000); } } while(!validOptionSelected); break; /* * switch (GetUserChoice("Leave Type", "Employee")) * { * case 1: * Console.WriteLine("Enter Job Title"); * Console.WriteLine(Leave_Console.ReportsDatabaseConnector.getTable(Console.ReadLine())); * break; * } * break; * [[ */ case 2: do { Console.Clear(); try { switch (GetUserChoice("Usage Reports by Leave Type", "Back")) { case 1: validOptionSelected = true; Console.WriteLine(Leave_Console.ReportsDatabaseConnector.getTable()); Console.WriteLine("Press any key to continue"); Console.ReadKey(); break; case 2: validOptionSelected = true; break; default: Console.WriteLine("Wrong Input!"); Thread.Sleep(1000); break; } } catch (FormatException e) { Console.WriteLine("Wrong Input!"); Thread.Sleep(1000); } catch (Exception e) { Console.WriteLine("Wrong Input!"); Thread.Sleep(1000); } } while(!validOptionSelected); break; case 3: do { Console.Clear(); try { switch (GetUserChoice("Leave Periods", "Leave Types", "Work Week", "Holidays", "Back")) { case 1: validOptionSelected = true; Console.WriteLine("Leave Periods will be displayed here."); Console.Write("Press any key to continue ..."); Console.ReadKey(); break; case 2: validOptionSelected = true; switch (GetUserChoice("View", "Add", "Delete")) { case 1: Console.WriteLine(Leave_Console.Leave_Type_Database_Connector.getTable()); break; case 2: Leave_Console.Leave_Type_Database_Connector.add(Console.ReadLine()); break; case 3: Leave_Console.Leave_Type_Database_Connector.Delete(Console.ReadLine()); break; } Console.Write("Press any key to continue ..."); Console.ReadKey(); break; case 3: validOptionSelected = true; switch (GetUserChoice("View", "Change")) { case 1: Console.WriteLine(Work_Week_Database_Connector.getTable()); break; case 2: Console.WriteLine("Enter The Work day you want to change :"); String day = Console.ReadLine(); Console.WriteLine("Enter Work Day type"); String workDayType = Console.ReadLine(); Leave.Modules.Work_Week_Database_Connector.Change(day, workDayType); break; default: Console.WriteLine("Wrong Input"); break; } Console.Write("Press any key to continue ..."); Console.ReadKey(); break; case 4: validOptionSelected = true; switch (GetUserChoice("View", "Add", "Delete")) { case 1: validOptionSelected = true; Console.WriteLine(Holiday_Database_Connector.getTableAll()); break; case 2: validOptionSelected = true; Work_Week_Database_Connector.addTable(); break; case 3: validOptionSelected = true; Console.WriteLine("Enter The Name of the Holiday that you want to delete:"); string name = Console.ReadLine(); try { Holiday_Database_Connector.DeleteTable(name); } catch (Exception e) { Console.WriteLine("Invalid input"); } break; default: Console.WriteLine("Wrong Input!"); Thread.Sleep(1000); break; } Console.Write("Press any key to continue ..."); Console.ReadKey(); break; case 5: validOptionSelected = true; break; default: Console.WriteLine("Wrong Input!"); Thread.Sleep(1000); break; } } catch (FormatException e) { Console.WriteLine("Wrong Input!"); Thread.Sleep(1000); } catch (Exception e) { Console.WriteLine("Wrong Input!"); Thread.Sleep(1000); } } while(!validOptionSelected); break; case 4: do { Console.Clear(); try { switch (GetUserChoice("Back")) { case 1: validOptionSelected = true; break; default: Console.WriteLine("Wrong Input!"); Thread.Sleep(1000); break; } } catch (FormatException e) { Console.WriteLine("Wrong Input!"); Thread.Sleep(1000); } catch (Exception e) { Console.WriteLine("Wrong Input!"); Thread.Sleep(1000); } } while(!validOptionSelected); break; case 5: do { Console.Clear(); try { switch (GetUserChoice("Back")) { case 1: validOptionSelected = true; break; default: Console.WriteLine("Wrong Input!"); Thread.Sleep(1000); break; } } catch (FormatException e) { Console.WriteLine("Wrong Input!"); Thread.Sleep(1000); } catch (Exception e) { Console.WriteLine("Wrong Input!"); Thread.Sleep(1000); } } while(!validOptionSelected); break; case 6: executionEnded = true; break; default: Console.WriteLine("Wrong Input!"); Thread.Sleep(1000); break; } } catch (FormatException e) { Console.WriteLine("Wrong Input!"); Thread.Sleep(1000); } catch (Exception e) { Console.WriteLine(e.Message); Thread.Sleep(1000); } } while(!executionEnded); }