public static int Save(BOHolidayDetails entry, bool adding)
{
tblHolidayDetails tblObj = new tblHolidayDetails();
DataRow newRow = tblObj.Table().NewRow();
newRow[tblHolidayDetails.HOLIDAYID_FIELD] = entry.HolidayID;
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;
}
if (adding)
{
return(tblObj.AddToTable(newRow));
}
else
{
return(tblObj.UpdateTable(newRow));
}
}
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);
}
private static BOHolidayDetails FillDataRecord(DataRow dr)
{
BOHolidayDetails itemObj = new BOHolidayDetails();
if (dr["HolidayID"] != DBNull.Value)
{
itemObj.HolidayID = Int32.Parse(dr["HolidayID"].ToString());
}
if (dr["HolidayType"] != DBNull.Value)
{
itemObj.HolidayType = dr["HolidayType"].ToString();
}
if (dr["HolidayDate"] != DBNull.Value)
{
itemObj.HolidayDate = DateTime.Parse(dr["HolidayDate"].ToString());
}
return(itemObj);
}
public static int Update(BOHolidayDetails entry)
{
return(tblHolidayDetailsDBManager.Save(entry, false));
}
public static int Save(BOHolidayDetails entry)
{
return(tblHolidayDetailsDBManager.Save(entry, true));
}
public static int Save(BOHolidayDetails entry, bool adding)
{
return(tblHolidayDetailsDBManager.Save(entry, adding));
}
