public static CustomList <AttendanceManualModification> GetEmpAttManualApproved(string fromDate, string toDate) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <AttendanceManualModification> DailyAttendanceCollection = new CustomList <AttendanceManualModification>(); string search = String.Empty; search = CommonHelper.CreateSearchString(); IDataReader reader = null; try { String sql = "EXEC spGetEmpAttManual '" + fromDate + "','" + toDate + "','" + search + "'"; conManager.OpenDataReader(sql, out reader); while (reader.Read()) { AttendanceManualModification newAttendance = new AttendanceManualModification(); newAttendance.SetDataManulApp(reader); DailyAttendanceCollection.Add(newAttendance); } return(DailyAttendanceCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
public static CustomList <AttendanceManualModification> GetAllAttendanceManualModification() { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <AttendanceManualModification> AttendanceManualModificationCollection = new CustomList <AttendanceManualModification>(); IDataReader reader = null; const String sql = "select *from AttendanceManualModification"; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { AttendanceManualModification newAttendanceManualModification = new AttendanceManualModification(); newAttendanceManualModification.SetData(reader); AttendanceManualModificationCollection.Add(newAttendanceManualModification); } AttendanceManualModificationCollection.InsertSpName = "spInsertAttendanceManualModification"; AttendanceManualModificationCollection.UpdateSpName = "spUpdateAttendanceManualModification"; AttendanceManualModificationCollection.DeleteSpName = "spDeleteAttendanceManualModification"; return(AttendanceManualModificationCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }