public static void DeleteSelected()
{
using (Leave.DataClients.SqlTableTracker Databasetest = new Leave.DataClients.SqlTableTracker(Leave.Modules.Holiday_Database_Connector.connection_string2, "LeaveTypes"))
{
for (int i = 0; i < SelectedItems.Count; i++)
{
Databasetest.Delete("LeaveType='" + SelectedItems[i] + "'");
}
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
try
{
using (Leave.DataClients.SqlTableTracker Databasetest = new Leave.DataClients.SqlTableTracker(Leave.Modules.Holiday_Database_Connector.connection_string2, "LeaveTypes"))
{
Databasetest.Insert("'" + LeaveType.Text + "'", "LeaveType");
}
Status.Content = "Success";
MainPage.page_container.Navigate(new leave_types());
}
catch (Exception ex) { Status.Content = "Failed"; }
}
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);
}
}
