public static BOEmployeeList GetEmployeeDetails()
{
BOEmployeeList itemObjs = null;
var ds = spGetEmployeeDetails.ExecuteDataset();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
itemObjs = new BOEmployeeList();
foreach (DataRow dr in ds.Tables[0].Rows)
{
itemObjs.Add(FillData(FillDataRecord(dr), dr));
}
}
return itemObjs;
}
public static BOEmployeeList GetEmployeeDetails()
{
BOEmployeeList itemObjs = null;
var ds = spGetEmployeeDetails.ExecuteDataset();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
itemObjs = new BOEmployeeList();
foreach (DataRow dr in ds.Tables[0].Rows)
{
itemObjs.Add(FillData(FillDataRecord(dr), dr));
}
}
return(itemObjs);
}
public static BOEmployeeList GetAllList(int startIndex, int length, string whereClause)
{
BOEmployeeList itemObjs = null;
tblEmployee tblObj = new tblEmployee();
DataTable dt = tblObj.GetAllData(startIndex, length, whereClause, null);
if (dt.Rows.Count > 0)
{
itemObjs = new BOEmployeeList();
foreach(DataRow dr in dt.Rows)
{
itemObjs.Add(FillDataRecord(dr));
}
}
return itemObjs;
}
public static BOEmployeeList GetAllList()
{
BOEmployeeList itemObjs = null;
tblEmployee tblObj = new tblEmployee();
DataTable dt = tblObj.GetAllData();
if (dt.Rows.Count > 0)
{
itemObjs = new BOEmployeeList();
foreach(DataRow dr in dt.Rows)
{
itemObjs.Add(FillDataRecord(dr));
}
}
return itemObjs;
}
public static BOEmployeeList GetAllList(int startIndex, int length, string whereClause)
{
BOEmployeeList itemObjs = null;
tblEmployee tblObj = new tblEmployee();
DataTable dt = tblObj.GetAllData(startIndex, length, whereClause, null);
if (dt.Rows.Count > 0)
{
itemObjs = new BOEmployeeList();
foreach (DataRow dr in dt.Rows)
{
itemObjs.Add(FillDataRecord(dr));
}
}
return(itemObjs);
}
public static BOEmployeeList GetAllList()
{
BOEmployeeList itemObjs = null;
tblEmployee tblObj = new tblEmployee();
DataTable dt = tblObj.GetAllData();
if (dt.Rows.Count > 0)
{
itemObjs = new BOEmployeeList();
foreach (DataRow dr in dt.Rows)
{
itemObjs.Add(FillDataRecord(dr));
}
}
return(itemObjs);
}
