TvDatabase.TvBusinessLayer.GetSchedule C# (CSharp) Method

    public Schedule GetSchedule(int idChannel, string programName, DateTime startTime, DateTime endTime,
                                int scheduleType)
    {
      SqlBuilder sb = new SqlBuilder(StatementType.Select, typeof (Schedule));
      sb.AddConstraint(Operator.Equals, "idChannel", idChannel);
      sb.AddConstraint(Operator.Equals, "programName", programName);
      sb.AddConstraint(Operator.Equals, "startTime", startTime);
      sb.AddConstraint(Operator.Equals, "endTime", endTime);
      sb.AddConstraint(Operator.Equals, "scheduleType", scheduleType);
      SqlStatement stmt = sb.GetStatement(true);
      Log.Info(stmt.Sql);
      IList<Schedule> schedules = ObjectFactory.GetCollection<Schedule>(stmt.Execute());
      if (schedules == null)
      {
        return null;
      }
      if (schedules.Count == 0)
      {
        return null;
      }
      return schedules[0];
    }