public List <EPGInfo> GetEPGForChannel(string idChannel)
{
IFormatProvider mmddFormat = new CultureInfo(String.Empty, false);
List <EPGInfo> infos = new List <EPGInfo>();
SqlBuilder sb = new SqlBuilder(Gentle.Framework.StatementType.Select, typeof(Program));
sb.AddConstraint(Operator.Equals, "idChannel", Int32.Parse(idChannel));
DateTime thisMorning = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
sb.AddConstraint(String.Format("startTime>='{0}'", thisMorning.ToString(GetDateTimeString(), mmddFormat)));
sb.AddOrderByField(true, "startTime");
SqlStatement stmt = sb.GetStatement(true);
IList programs = ObjectFactory.GetCollection(typeof(Program), stmt.Execute());
if (programs != null && programs.Count > 0)
{
foreach (Program prog in programs)
{
EPGInfo epg = new EPGInfo();
epg.startTime = prog.StartTime;
epg.endTime = prog.EndTime;
epg.title = prog.Title;
epg.description = prog.Description;
infos.Add(epg);
}
}
return(infos);
}
public List<EPGInfo> GetEPGForChannel(string idChannel)
{
IFormatProvider mmddFormat = new CultureInfo(String.Empty, false);
List<EPGInfo> infos = new List<EPGInfo>();
SqlBuilder sb = new SqlBuilder(Gentle.Framework.StatementType.Select, typeof (Program));
sb.AddConstraint(Operator.Equals, "idChannel", Int32.Parse(idChannel));
DateTime thisMorning = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
sb.AddConstraint(String.Format("startTime>='{0}'", thisMorning.ToString(GetDateTimeString(), mmddFormat)));
sb.AddOrderByField(true, "startTime");
SqlStatement stmt = sb.GetStatement(true);
IList programs = ObjectFactory.GetCollection(typeof (Program), stmt.Execute());
if (programs != null && programs.Count > 0)
{
foreach (Program prog in programs)
{
EPGInfo epg = new EPGInfo();
epg.startTime = prog.StartTime;
epg.endTime = prog.EndTime;
epg.title = prog.Title;
epg.description = prog.Description;
infos.Add(epg);
}
}
return infos;
}
