public List <V_CLASS> GetClassBy(string keyText, string boxId, string subjectId, string timeIn, string timeEnd, string status, int pageNumber, int pageSize, out int count)
{
List <V_CLASS> list = new List <V_CLASS>();
object cTemp;
list = new V_CLASSSql().SelectFromStoreOutParam(AppSettingKeys.GET_CLASS_BY, out cTemp, keyText, boxId, subjectId, timeIn, timeEnd, status, pageNumber, pageSize);
count = (int)cTemp;
return(list);
}
public List <V_CLASS_DETAILS> GetInfoClass(string keyText, string boxId, string subjectId, string timeIn, string timeEnd, string status, int pageNumber, int pageSize, out int count)
{
List <V_CLASS> list = new List <V_CLASS>();
List <V_CLASS_DETAILS> result = new List <V_CLASS_DETAILS>();
object cTemp;
list = new V_CLASSSql().SelectFromStoreOutParam(AppSettingKeys.GET_CLASS_BY, out cTemp, keyText, boxId, subjectId, timeIn, timeEnd, status, pageNumber, pageSize);
count = (int)cTemp;
result = list.GroupBy(x => x.ScheduleId).Select(y => new V_CLASS_DETAILS
{
ScheduleId = y.Key,
Class = y.Where(t => t.ScheduleId == y.Key).ToList()
}).ToList();
return(result);
}
