public static AvailabilityEntity[] CheckAMAvailabilityRange(string componentName, DateTime startDate, DateTime endDate)
{
return CheckAvailabilityInternal(
"Data Source=.;Initial Catalog=CSM_PROD;Persist Security Info=True;User Id=sa;Password=DAD2install!",
string.Format("SELECT * FROM {0} WHERE {1} order by DATE", string.Format("{0}_AM", componentName), string.Format("{0} >= '{1}' AND {0} <= '{2}'", "DATE", startDate.ToSqlDateString(), endDate.ToSqlDateString())));
}
public static AvailabilityEntity[] CheckPMAvailabilityRange(DateTime startDate, DateTime endDate)
{
return CheckAvailabilityInternal(
Config.PMAvailabilityDbConnectionString,
string.Format(Config.PMAvailabilityCheckSqlTemplate, string.Format("{0} >= '{1}' AND {0} <= '{2}'", Config.PMAvailabilitySqlDateField, startDate.ToSqlDateString(), endDate.ToSqlDateString())));
}
public static AvailabilityEntity CheckPMAvailability(string componentName, DateTime date)
{
return CheckAvailabilityInternal(
Config.PMAvailabilityDbConnectionString,
string.Format(Config.PMAvailabilityCheckSqlTemplate, string.Format("{0}_PM", componentName), string.Format("DATE = '{0}'", date.ToSqlDateString()))).FirstOrDefault();
}
