public static CustomList <SalaryHead> GetAllSalaryHeadForMisc()
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList <SalaryHead> SalaryHeadCollection = new CustomList <SalaryHead>();
IDataReader reader = null;
const String sql = "EXEC GetAllSalaryHead";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
SalaryHead newSalaryHead = new SalaryHead();
newSalaryHead.SetDataMisc(reader);
SalaryHeadCollection.Add(newSalaryHead);
}
return(SalaryHeadCollection);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
}
}
public static CustomList <SalaryHead> GetAllSalaryHead()
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList <SalaryHead> SalaryHeadCollection = new CustomList <SalaryHead>();
IDataReader reader = null;
const String sql = "select * from SalaryHead";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
SalaryHead newSalaryHead = new SalaryHead();
newSalaryHead.SetData(reader);
SalaryHeadCollection.Add(newSalaryHead);
}
SalaryHeadCollection.InsertSpName = "spInsertSalaryHead";
SalaryHeadCollection.UpdateSpName = "spUpdateSalaryHead";
SalaryHeadCollection.DeleteSpName = "spDeleteSalaryHead";
return(SalaryHeadCollection);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
}
}