public static BOHolidayDetails GetItem(Int32 id)
{
BOHolidayDetails itemObj = null;
tblHolidayDetails tblObj = new tblHolidayDetails();
DataTable dt = tblObj.GetAllData(tblHolidayDetails.PRIMARYKEY_FIELD1 + " = " + id);
if (dt.Rows.Count > 1)
throw new Exception("More than one row returned");
if (dt.Rows.Count == 1)
itemObj = FillDataRecord(dt.Rows[0]);
return itemObj;
}
public static BOHolidayDetailsList GetAllList(int startIndex, int length, string whereClause)
{
BOHolidayDetailsList itemObjs = null;
tblHolidayDetails tblObj = new tblHolidayDetails();
DataTable dt = tblObj.GetAllData(startIndex, length, whereClause, null);
if (dt.Rows.Count > 0)
{
itemObjs = new BOHolidayDetailsList();
foreach(DataRow dr in dt.Rows)
{
itemObjs.Add(FillDataRecord(dr));
}
}
return itemObjs;
}
public static BOHolidayDetailsList GetAllList()
{
BOHolidayDetailsList itemObjs = null;
tblHolidayDetails tblObj = new tblHolidayDetails();
DataTable dt = tblObj.GetAllData();
if (dt.Rows.Count > 0)
{
itemObjs = new BOHolidayDetailsList();
foreach(DataRow dr in dt.Rows)
{
itemObjs.Add(FillDataRecord(dr));
}
}
return itemObjs;
}
public static BOHolidayDetailsList GetAllList(int startIndex, int length, string whereClause)
{
BOHolidayDetailsList itemObjs = null;
tblHolidayDetails tblObj = new tblHolidayDetails();
DataTable dt = tblObj.GetAllData(startIndex, length, whereClause, null);
if (dt.Rows.Count > 0)
{
itemObjs = new BOHolidayDetailsList();
foreach (DataRow dr in dt.Rows)
{
itemObjs.Add(FillDataRecord(dr));
}
}
return(itemObjs);
}
public static BOHolidayDetailsList GetAllList()
{
BOHolidayDetailsList itemObjs = null;
tblHolidayDetails tblObj = new tblHolidayDetails();
DataTable dt = tblObj.GetAllData();
if (dt.Rows.Count > 0)
{
itemObjs = new BOHolidayDetailsList();
foreach (DataRow dr in dt.Rows)
{
itemObjs.Add(FillDataRecord(dr));
}
}
return(itemObjs);
}
public static BOHolidayDetails GetItem(Int32 id)
{
BOHolidayDetails itemObj = null;
tblHolidayDetails tblObj = new tblHolidayDetails();
DataTable dt = tblObj.GetAllData(tblHolidayDetails.PRIMARYKEY_FIELD1 + " = " + id);
if (dt.Rows.Count > 1)
{
throw new Exception("More than one row returned");
}
if (dt.Rows.Count == 1)
{
itemObj = FillDataRecord(dt.Rows[0]);
}
return(itemObj);
}
