public static DataTable GetAllDistributedLeaveInfo(string rowConstraints = "")
{
using (SqlTableTracker leaveListTracker = new SqlTableTracker(server, database, table + ", Employees, Entitlements")) {
DataManager dm = new DataManager(leaveListTracker.SelectSpecific("DISTINCT LeaveList.EmployeeID, EmployeeName, LeaveList.LeaveType, LeavingDate, JoiningDate, Entitlements.Balance, DaysCount, Comment", (rowConstraints.Length == 0 ? "" : rowConstraints + " AND ") + "Employees.EmployeeID = LeaveList.EmployeeID AND LeaveList.EmployeeID = Entitlements.EmployeeID AND LeaveList.LeaveType = Entitlements.LeaveType"));
return(dm.Trim( ));
}
}
public static DataTable GetSpecificEntitlementInfo(string columns, string rowConstraints = "")
{
using (SqlTableTracker entitlementsTracker = new SqlTableTracker(connection_string, table))
{
return(entitlementsTracker.SelectSpecific(columns, rowConstraints));
}
}
public static DataTable GetSpecificDistributedLeaveInfo(string columns, string rowConstraints = "")
{
using (SqlTableTracker leaveListTracker = new SqlTableTracker(server, database, table + ", Employees, Entitlements")) {
if (rowConstraints.Length > 0)
{
rowConstraints += " AND ";
}
return(leaveListTracker.SelectSpecific(columns, rowConstraints + "Employees.EmployeeID = LeaveList.EmployeeID AND LeaveList.EmployeeID = Entitlements.EmployeeID AND LeaveList.LeaveType = Entitlements.LeaveType"));
}
}
public static DataTable GetSpecificEmployeeInfo(string columns, string rowConstraints = "")
{
using (SqlTableTracker employeeTracker = new SqlTableTracker(server, database, table)) {
return(employeeTracker.SelectSpecific(columns, rowConstraints));
}
}
public static DataTable GetEndingDate(string rowConstraints = "")
{
using (SqlTableTracker leavePeriodsTracker = new SqlTableTracker(connectionString, table)) {
return(leavePeriodsTracker.SelectSpecific("EndingDate", rowConstraints));
}
}
public static DataTable GetSpecificAssignedLeaveInfo(string columns, string rowConstraints = "")
{
using (SqlTableTracker assignedLeavesTracker = new SqlTableTracker(server, database, table)) {
return(assignedLeavesTracker.SelectSpecific(columns, rowConstraints));
}
}
public static DataTable GetSpecificDistributedEntitlementInfo(string columns, string rowConstraints = "")
{
using (SqlTableTracker entitlementsTracker = new SqlTableTracker(connectionString, table + ", Employees")) {
return(entitlementsTracker.SelectSpecific(columns, "Entitlements.EmployeeID = Employees.EmployeeID" + (rowConstraints.Length == 0 ? "" : " AND " + rowConstraints)));
}
}
public static DataTable GetAllDistributedEntitlementInfo(string rowConstraints = "")
{
using (SqlTableTracker entitlementsTracker = new SqlTableTracker(connectionString, table + ", Employees")) {
return(entitlementsTracker.SelectSpecific("Entitlements.EmployeeID, EmployeeName, LeaveType, EntitlementType, ValidFrom, ValidTo, Balance", "Entitlements.EmployeeID = Employees.EmployeeID AND " + rowConstraints));
}
}
