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); }