public static CustomList <WHCalendar> GetAllWHCalendar(string fromDate, string toDate, string dayType)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList <WHCalendar> WHCalendarCollection = new CustomList <WHCalendar>();
IDataReader reader = null;
String sql = "EXEC spGetCalendarInfo '" + fromDate + "','" + toDate + "','" + dayType + "'";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
WHCalendar newWHCalendar = new WHCalendar();
newWHCalendar.SetData(reader);
WHCalendarCollection.Add(newWHCalendar);
}
return(WHCalendarCollection);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
}
}
public static CustomList <WHCalendar> GetAllEmpWHCalendar()
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList <WHCalendar> WHCalendarCollection = new CustomList <WHCalendar>();
string search = String.Empty;
StringBuilder searchArg;
searchArg = (StringBuilder)HttpContext.Current.Session[StaticInfo.SearchArg];
if (searchArg != null) //return WHCalendarCollection;
{
search = searchArg.ToString();
search = search.Length > 0 ? search.Substring(0, search.Length - 1) : string.Empty;
}
IDataReader reader = null;
String sql = "EXEC spGetEmpForSearch1" + search;
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
WHCalendar newWHCalendar = new WHCalendar();
newWHCalendar.SetDataForWHCalendar(reader);
WHCalendarCollection.Add(newWHCalendar);
}
return(WHCalendarCollection);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
}
}
