public static int Save(BOHolidayDetailsList entryList, bool adding)
{
tblHolidayDetails tblObj = new tblHolidayDetails();
DataTable dt = tblObj.Table();
int i = 0;
foreach (BOHolidayDetails entry in entryList)
{
DataRow newRow = tblObj.Table().NewRow();
newRow[tblHolidayDetails.HOLIDAYTYPE_FIELD] = entry.HolidayType;
if (entry.HolidayDate.Equals(new DateTime()))
{
newRow[tblHolidayDetails.HOLIDAYDATE_FIELD] = DBNull.Value;
}
else
{
newRow[tblHolidayDetails.HOLIDAYDATE_FIELD] = entry.HolidayDate;
}
dt.Rows.Add(newRow);
i++;
}
//if(adding): Commented out at the moment. KS 28th Aug 2012
return(tblObj.AddToTable(dt));
//else
//return tblObj.UpdateTable(dt);
}
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 int Save(BOHolidayDetailsList list, bool adding)
{
return tblHolidayDetailsDBManager.Save(list,adding);
}
public static int Save(BOHolidayDetailsList entryList, bool adding)
{
tblHolidayDetails tblObj = new tblHolidayDetails();
DataTable dt = tblObj.Table();
int i = 0;
foreach(BOHolidayDetails entry in entryList)
{
DataRow newRow = tblObj.Table().NewRow();
newRow[tblHolidayDetails.HOLIDAYTYPE_FIELD] = entry.HolidayType;
if(entry.HolidayDate.Equals(new DateTime()))
newRow[tblHolidayDetails.HOLIDAYDATE_FIELD] = DBNull.Value;
else
newRow[tblHolidayDetails.HOLIDAYDATE_FIELD] = entry.HolidayDate;
dt.Rows.Add(newRow);
i++;
}
//if(adding): Commented out at the moment. KS 28th Aug 2012
return tblObj.AddToTable(dt);
//else
//return tblObj.UpdateTable(dt);
}
public static int Save(BOHolidayDetailsList list, bool adding)
{
return(tblHolidayDetailsDBManager.Save(list, adding));
}
