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