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