public static void AddEntitlementInfo(string values, string columnConstraints = "")
{
using (SqlTableTracker entitlementsTracker = new SqlTableTracker(connection_string, table))
{
entitlementsTracker.Insert(values, columnConstraints);
}
}
public static void AssignLeave(string values, string columns = "")
{
using (SqlTableTracker leaveListTracker = new SqlTableTracker(server, database, table)) {
leaveListTracker.Insert(values, columns);
}
}
public static void AddUserInfo(string values, string columns = "")
{
using (SqlTableTracker usersTracker = new SqlTableTracker(server, database, table)) {
usersTracker.Insert(values, columns);
}
}
public static void AddEntitlementType(string value)
{
using (SqlTableTracker entitlementTypesTracker = new SqlTableTracker(connectionString, table)) {
entitlementTypesTracker.Insert(value);
}
}
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 void Insert(string columns, string rowConstraints = "")
{
using (SqlTableTracker leavePeriodsTracker = new SqlTableTracker(server, database, table)) {
leavePeriodsTracker.Insert(columns, rowConstraints);
}
}
public static void AddEntitlements(string values, string columnConstraints = "")
{
using (SqlTableTracker entitlementsTracker = new SqlTableTracker(server, database, table)) {
entitlementsTracker.Insert(values, columnConstraints);
}
}
public static void Assign(string values, string columns = "")
{
using (SqlTableTracker assignedLeavesTracker = new SqlTableTracker(server, database, table)) {
assignedLeavesTracker.Insert(values, columns);
}
}
