public static CustomList <OutOfOfficeInfo> GetExistingEntry(string fromDate, string toDate, string empKey)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList <OutOfOfficeInfo> OutOfOfficeInfoCollection = new CustomList <OutOfOfficeInfo>();
IDataReader reader = null;
try
{
String sql = "EXEC spGetOutOfOfficeEntry '" + fromDate + "','" + toDate + "','" + empKey + "'";
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
OutOfOfficeInfo newOutOfOfficeInfo = new OutOfOfficeInfo();
newOutOfOfficeInfo.SetData(reader);
newOutOfOfficeInfo.EmpCode = reader.GetString("EmpCode");
newOutOfOfficeInfo.EmpName = reader.GetString("EmpName");
OutOfOfficeInfoCollection.Add(newOutOfOfficeInfo);
}
return(OutOfOfficeInfoCollection);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
}
}
public static CustomList <OutOfOfficeInfo> GetAllOutOfOfficeInfo()
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList <OutOfOfficeInfo> OutOfOfficeInfoCollection = new CustomList <OutOfOfficeInfo>();
IDataReader reader = null;
const String sql = "select *from OutOfOfficeInfo";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
OutOfOfficeInfo newOutOfOfficeInfo = new OutOfOfficeInfo();
newOutOfOfficeInfo.SetData(reader);
OutOfOfficeInfoCollection.Add(newOutOfOfficeInfo);
}
OutOfOfficeInfoCollection.InsertSpName = "spInsertOutOfOfficeInfo";
OutOfOfficeInfoCollection.UpdateSpName = "spUpdateOutOfOfficeInfo";
OutOfOfficeInfoCollection.DeleteSpName = "spDeleteOutOfOfficeInfo";
return(OutOfOfficeInfoCollection);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
}
}
public static CustomList <OutOfOfficeInfo> GetAllOutOutOfOfficeEntry(string date)
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList <OutOfOfficeInfo> OutOfOfficeInfoCollection = new CustomList <OutOfOfficeInfo>();
StringBuilder searchArg = new StringBuilder();
searchArg = (StringBuilder)HttpContext.Current.Session[StaticInfo.SearchArg];
if (searchArg == null)
{
return(OutOfOfficeInfoCollection);
}
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 spGetOutOfOfficeEntryEmpList " + search + "";
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
OutOfOfficeInfo newOutOfOfficeInfo = new OutOfOfficeInfo();
newOutOfOfficeInfo.SetData(reader);
newOutOfOfficeInfo.EmpName = reader.GetString("EmpName");
newOutOfOfficeInfo.PunchCardNo = reader.GetString("PunchCardNo");
newOutOfOfficeInfo.IsDefault = reader.GetBoolean("IsDefault");
OutOfOfficeInfoCollection.Add(newOutOfOfficeInfo);
}
return(OutOfOfficeInfoCollection);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
}
}