public objFinYears Select_Obj(IDataReader idr)
{
objFinYears o = new objFinYears();
bool rtNull = true;
if (idr != null)
{
while (idr.Read())
{
rtNull = false;
if (idr["status"] != DBNull.Value)
{
o.FinYrId = Convert.ToInt32(idr["finyrId"]);
o.StartDate = Convert.ToDateTime(idr["startDate"]);
o.EndDate = Convert.ToDateTime(idr["endDate"]);
o.Status = Convert.ToBoolean(idr["status"]);
}
}
}
if (rtNull)
{
o = null;
}
return(o);
}
public bool isLock(DateTime inputDate)
{
objFinYears o = new objFinYears();
IDataReader idr = db.SelectForStatus(inputDate, true);
o = Select_Obj(idr);
if (o != null)
{
return(o.Status);
}
else
{
return(false);
}
}
public void UpdateFinYear(objFinYears i)
{
db.Update(i.FinYrId, i.StartDate, i.EndDate, i.Status);
}
public void AddFinYear(objFinYears i)
{
db.Add(i.FinYrId, i.StartDate, i.EndDate, i.Status);
}
