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