public static void UpdateEntitlementInfo(string changes, string rowConstraints = "")
{
using (SqlTableTracker entitlementsTracker = new SqlTableTracker(connection_string, table))
{
entitlementsTracker.Update(changes, rowConstraints);
}
}
public static void DeleteEntitlementInfo(string rowConstraints = "")
{
using (SqlTableTracker entitlementsTracker = new SqlTableTracker(connection_string, table))
{
entitlementsTracker.Delete(rowConstraints);
}
}
public static DataTable GetSpecificEntitlementInfo(string columns, string rowConstraints = "")
{
using (SqlTableTracker entitlementsTracker = new SqlTableTracker(connection_string, table))
{
return(entitlementsTracker.SelectSpecific(columns, rowConstraints));
}
}
public static void AddEntitlementInfo(string values, string columnConstraints = "")
{
using (SqlTableTracker entitlementsTracker = new SqlTableTracker(connection_string, table))
{
entitlementsTracker.Insert(values, columnConstraints);
}
}
public static void Change(String day, string change)
{
using (SqlTableTracker Databasetest = new SqlTableTracker(connection_string2, tableName))
{
Databasetest.Update("WorkDayType='" + change + "'", "Name='" + day + "'");
}
}
public static DataTable GetAllEntitlementInfo(string rowConstraints = "")
{
using (SqlTableTracker entitlementsTracker = new SqlTableTracker(connection_string, table))
{
return(entitlementsTracker.Select(rowConstraints));
}
}
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 void DeleteTable(String command)
{
using (SqlTableTracker Databasetest = new SqlTableTracker(connection_string2, tableName))
{
Databasetest.Delete(command);
}
}
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 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 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 GetSpecificEmployeeInfo(string columns, string rowConstraints = "")
{
using (SqlTableTracker employeeTracker = new SqlTableTracker(server, database, table)) {
return(employeeTracker.SelectSpecific(columns, rowConstraints));
}
}
public static void AssignLeave(string values, string columns = "")
{
using (SqlTableTracker leaveListTracker = new SqlTableTracker(server, database, table)) {
leaveListTracker.Insert(values, columns);
}
}
public static void Delete(string rowConstraints = "")
{
using (SqlTableTracker leaveListTracker = new SqlTableTracker(server, database, table)) {
leaveListTracker.Delete(rowConstraints);
}
}
public static DataTable FetchApplications(string rowConstraints = "")
{
using (SqlTableTracker leaveApplicationsTracker = new SqlTableTracker(server, database, table)) {
return(leaveApplicationsTracker.Select(rowConstraints));
}
}
public static DataTable GetLeaveTypes(string rowConstraints = "")
{
using (SqlTableTracker leaveTypesTracker = new SqlTableTracker(server, database, table)) {
return(leaveTypesTracker.SelectSorted(rowConstraints, "LeaveType"));
}
}
public static void SendApplication(string employeeID, string leaveType, DateTime leavingDate, DateTime joiningDate, string description)
{
using (SqlTableTracker leaveApplicationsTracker = new SqlTableTracker(server, database, table)) {
leaveApplicationsTracker.Insert(employeeID + ", '" + leaveType + "', '" + new DateString(leavingDate) + "', '" + new DateString(joiningDate) + "', '" + description + "'");
}
}
public static DataTable GetAllLeaveInfo(string rowConstraints = "")
{
using (SqlTableTracker leaveListTracker = new SqlTableTracker(server, database, table)) {
return(leaveListTracker.Select(rowConstraints));
}
}
public static void AddUserInfo(string values, string columns = "")
{
using (SqlTableTracker usersTracker = new SqlTableTracker(server, database, table)) {
usersTracker.Insert(values, columns);
}
}
public static void UpdateUserInfo(string changes, string rowConstraints = "")
{
using (SqlTableTracker usersTracker = new SqlTableTracker(server, database, table)) {
usersTracker.Update(changes, rowConstraints);
}
}
public static void RemoveEntitlementType(string rowConstraints = "")
{
using (SqlTableTracker entitlementTypesTracker = new SqlTableTracker(connectionString, table)) {
entitlementTypesTracker.Delete(rowConstraints);
}
}
public static DataTable GetAllUserInfo(string rowConstraints = "")
{
using (SqlTableTracker usersTracker = new SqlTableTracker(server, database, table)) {
return(usersTracker.Select(rowConstraints));
}
}
public static void AddEntitlementType(string value)
{
using (SqlTableTracker entitlementTypesTracker = new SqlTableTracker(connectionString, table)) {
entitlementTypesTracker.Insert(value);
}
}
public static void Update(string changes, string rowConstraints = "")
{
using (SqlTableTracker leavePeriodsTracker = new SqlTableTracker(server, database, table)) {
leavePeriodsTracker.Update(changes, rowConstraints);
}
}
public static void RejectApplications(string rowConstraints = "")
{
using (SqlTableTracker leaveApplicationsTracker = new SqlTableTracker(server, database, table)) {
leaveApplicationsTracker.Delete(rowConstraints);
}
}
public static DataTable GetEndingDate(string rowConstraints = "")
{
using (SqlTableTracker leavePeriodsTracker = new SqlTableTracker(connectionString, table)) {
return(leavePeriodsTracker.SelectSpecific("EndingDate", rowConstraints));
}
}
public static void DeleteUserInfo(string rowConstraints = "")
{
using (SqlTableTracker usersTracker = new SqlTableTracker(server, database, table)) {
usersTracker.Delete(rowConstraints);
}
}
public static DataTable GetLeaveTypes(string rowConstraints = "")
{
using (SqlTableTracker leaveTypesTracker = new SqlTableTracker(connectionString, table)) {
return(leaveTypesTracker.Select(rowConstraints));
}
}
public static DataTable FetchDetails(string columns, string rowConstraints = "")
{
using (SqlTableTracker leaveApplicationsTracker = new SqlTableTracker(server, database, table)) {
return(leaveApplicationsTracker.SelectSpecificSorted(columns, rowConstraints, columns));
}
}
