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