public static DataTable GetAllEntitlementInfo(string rowConstraints = "")
{
using (SqlTableTracker entitlementsTracker = new SqlTableTracker(connection_string, table))
{
return(entitlementsTracker.Select(rowConstraints));
}
}
public static DataTable GetTable()
{
using (SqlTableTracker Databasetest = new SqlTableTracker(connection_string2, tableName))
{
DataTable table = Databasetest.Select();
DataView table_view = table.AsDataView();
return(table);
}
}
public static string getTable()
{
using (SqlTableTracker Databasetest = new SqlTableTracker(connection_string2, tableName))
{
DataTable table = Databasetest.Select();
DataManager dm = new DataManager(table);
String columns = dm.ExtractColumns("\t\t") + "\n" + dm.ExtractData("\t\t");
return(columns);
}
}
public static string getTable()
{
using (SqlTableTracker Databasetest = new SqlTableTracker(Leave.Modules.Holiday_Database_Connector.connection_string2, table))
{
DataTable table2 = Databasetest.Select();
DataManager dm = new DataManager(table2);
String columns = dm.ExtractColumns("\t\t") + "\n" + dm.ExtractData("\t\t");
return(columns);
}
}
public static DataTable GetEmployeeInfo(string rowConstraints = "")
{
using (SqlTableTracker employeeTracker = new SqlTableTracker(server, database, table)) {
return(employeeTracker.Select(rowConstraints));
}
}
public static DataTable GetAllLeaveInfo(string rowConstraints = "")
{
using (SqlTableTracker leaveListTracker = new SqlTableTracker(server, database, table)) {
return(leaveListTracker.Select(rowConstraints));
}
}
public static DataTable GetAllUserInfo(string rowConstraints = "")
{
using (SqlTableTracker usersTracker = new SqlTableTracker(server, database, table)) {
return(usersTracker.Select(rowConstraints));
}
}
public static DataTable GetLeaveTypes(string rowConstraints = "")
{
using (SqlTableTracker leaveTypesTracker = new SqlTableTracker(connectionString, table)) {
return(leaveTypesTracker.Select(rowConstraints));
}
}
public static DataTable FetchApplications(string rowConstraints = "")
{
using (SqlTableTracker leaveApplicationsTracker = new SqlTableTracker(server, database, table)) {
return(leaveApplicationsTracker.Select(rowConstraints));
}
}
public static DataTable GetLeavePeriods(string rowConstraints = "")
{
using (SqlTableTracker leavePeriodsTracker = new SqlTableTracker(server, database, table)) {
return(leavePeriodsTracker.Select(rowConstraints));
}
}
public static DataTable GetEntitlements(string rowConstraints = "")
{
using (SqlTableTracker entitlementsTracker = new SqlTableTracker(server, database, table)) {
return(entitlementsTracker.Select(rowConstraints));
}
}
public static DataTable GetAllAssignedLeaveInfo(string rowConstraints = "")
{
using (SqlTableTracker assignedLeavesTracker = new SqlTableTracker(server, database, table)) {
return(assignedLeavesTracker.Select(rowConstraints));
}
}
public static DataTable GetWorkDayInfo(string rowConstraints = "")
{
using (SqlTableTracker workDaysTracker = new SqlTableTracker(server, database, table)) {
return(workDaysTracker.Select(rowConstraints));
}
}