public static BOMailSummary GetItem(Int32 id)
{
BOMailSummary itemObj = null;
tblMailSummary tblObj = new tblMailSummary();
DataTable dt = tblObj.GetAllData(tblMailSummary.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 BOMailSummaryList GetAllList(int startIndex, int length, string whereClause)
{
BOMailSummaryList itemObjs = null;
tblMailSummary tblObj = new tblMailSummary();
DataTable dt = tblObj.GetAllData(startIndex, length, whereClause, null);
if (dt.Rows.Count > 0)
{
itemObjs = new BOMailSummaryList();
foreach(DataRow dr in dt.Rows)
{
itemObjs.Add(FillDataRecord(dr));
}
}
return itemObjs;
}
public static BOMailSummaryList GetAllList()
{
BOMailSummaryList itemObjs = null;
tblMailSummary tblObj = new tblMailSummary();
DataTable dt = tblObj.GetAllData();
if (dt.Rows.Count > 0)
{
itemObjs = new BOMailSummaryList();
foreach(DataRow dr in dt.Rows)
{
itemObjs.Add(FillDataRecord(dr));
}
}
return itemObjs;
}
public static BOMailSummaryList GetAllList(int startIndex, int length, string whereClause)
{
BOMailSummaryList itemObjs = null;
tblMailSummary tblObj = new tblMailSummary();
DataTable dt = tblObj.GetAllData(startIndex, length, whereClause, null);
if (dt.Rows.Count > 0)
{
itemObjs = new BOMailSummaryList();
foreach (DataRow dr in dt.Rows)
{
itemObjs.Add(FillDataRecord(dr));
}
}
return(itemObjs);
}
public static BOMailSummaryList GetAllList()
{
BOMailSummaryList itemObjs = null;
tblMailSummary tblObj = new tblMailSummary();
DataTable dt = tblObj.GetAllData();
if (dt.Rows.Count > 0)
{
itemObjs = new BOMailSummaryList();
foreach (DataRow dr in dt.Rows)
{
itemObjs.Add(FillDataRecord(dr));
}
}
return(itemObjs);
}
public static BOMailSummary GetItem(Int32 id)
{
BOMailSummary itemObj = null;
tblMailSummary tblObj = new tblMailSummary();
DataTable dt = tblObj.GetAllData(tblMailSummary.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);
}
