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); } }