public static bool IsOrganizationHoliday(int organizationId, DateTime date)
{
bool isHoliday = false;
using (SqlConnection connection = new SqlConnection(LoginUser.GetConnectionString(-1)))
{
connection.Open();
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = @"SELECT IsHoliday FROM CalendarEvents WHERE OrganizationID = @organizationId AND @date BETWEEN StartDateUtc AND EndDateUTC";
command.Parameters.AddWithValue("@organizationId", organizationId);
command.Parameters.AddWithValue("@date", date);
command.CommandType = CommandType.Text;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
isHoliday = (bool)reader["IsHoliday"];
}
reader.Close();
connection.Close();
}
return(isHoliday);
}
public static string ReadString(string key, string defaultValue)
{
string result = defaultValue;
using (SqlConnection connection = new SqlConnection(LoginUser.GetConnectionString(-1)))
{
connection.Open();
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = "SELECT SettingValue FROM SystemSettings WHERE (SettingKey=@SettingKey)";
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@SettingKey", key);
SqlDataReader reader = command.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
result = (string)reader[0];
}
reader.Close();
connection.Close();
}
return(result);
}
public static List <DateTime> GetSpecificDaysToPause(int triggerId)
{
List <DateTime> daysToPause = new List <DateTime>();
using (SqlConnection connection = new SqlConnection(LoginUser.GetConnectionString(-1)))
{
connection.Open();
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = @"SELECT DateToPause FROM SlaPausedDays WHERE SlaTriggerId = @triggerId";
command.Parameters.AddWithValue("@triggerId", triggerId);
command.CommandType = CommandType.Text;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
daysToPause.Add((DateTime)reader["DateToPause"]);
}
reader.Close();
connection.Close();
}
return(daysToPause);
}