//protected override void SetData(IDataRecord reader)
//{
// _RowID = reader.GetInt32("RowID");
// _EmployeeCode = reader.GetString("EmployeeCode");
// _PTime = reader.GetString("PTime");
// _WorkDate = reader.GetDateTime("WorkDate");
// _PunchCardNo = reader.GetString("PunchCardNo");
// _PunchType = reader.GetString("PunchType");
// _DeviceID = reader.GetString("DeviceID");
// _AddedBy = reader.GetString("AddedBy");
// _DateAdded = reader.GetDateTime("DateAdded");
// SetUnchanged();
//}
//public static CustomList<2012-6> GetAll2012-6()
//{
// ConnectionManager conManager = new ConnectionManager(ConnectionName.OTS);
// CustomList<2012-6> 2012-6Collection = new CustomList<2012-6>();
// IDataReader reader = null;
// const String sql = "select *from [2012-6]";
// try
// {
// conManager.OpenDataReader(sql, out reader);
// while (reader.Read())
// {
// 2012-6 new2012-6 = new 2012-6();
// new2012-6.SetData(reader);
// 2012-6Collection.Add(new2012-6);
// }
// 2012-6Collection.InsertSpName = "spInsert2012-6";
// 2012-6Collection.UpdateSpName = "spUpdate2012-6";
// 2012-6Collection.DeleteSpName = "spDelete2012-6";
// return 2012-6Collection;
// }
// catch(Exception ex)
// {
// throw (ex);
// }
// finally
// {
// if (reader != null && !reader.IsClosed)
// reader.Close();
// }
//}
public static CustomList <ATT_IO> GetAllATT_IO()
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList <ATT_IO> ATT_IOCollection = new CustomList <ATT_IO>();
IDataReader reader = null;
const String sql = "Select * From ATT_IO";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
ATT_IO newATT_IO = new ATT_IO();
newATT_IO.SetData(reader);
ATT_IOCollection.Add(newATT_IO);
}
ATT_IOCollection.InsertSpName = "spInsertATT_IO";
ATT_IOCollection.UpdateSpName = "spUpdateATT_IO";
ATT_IOCollection.DeleteSpName = "spDeleteATT_IO";
return(ATT_IOCollection);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
}
}
public static CustomList <ATT_IO> GetAllAttForManualProcess(string date)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList <ATT_IO> ATT_IOCollection = new CustomList <ATT_IO>();
StringBuilder searchArg = new StringBuilder();
searchArg = (StringBuilder)HttpContext.Current.Session[StaticInfo.SearchArg];
if (searchArg == null)
{
return(ATT_IOCollection);
}
string search = String.Empty;
search = searchArg.ToString();
search = search + "@Date=" + "'" + date + "',";
search = search.Length > 0 ? search.Substring(0, search.Length - 1) : string.Empty;
IDataReader reader = null;
try
{
String sql = "EXEC spGetAllEmpForManualAttandanceProcess " + search + "";
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
ATT_IO newAtt_IO = new ATT_IO();
newAtt_IO.SetDataAtt(reader);
ATT_IOCollection.Add(newAtt_IO);
}
return(ATT_IOCollection);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
}
}
