public bool Update(TB_SCHEDULES schedules)
{
return(new TB_SCHEDULESSql().Update(schedules));
}
public ActionResult Class_Detail(int id)
{
List <TB_SUBJECTS> subjects = new List <TB_SUBJECTS>();
List <TB_BOXES> boxes = new List <TB_BOXES>();
List <TB_USERS> users = new List <TB_USERS>();
List <TB_USERS> teachers = new List <TB_USERS>();
List <TB_USERS> studies = new List <TB_USERS>();
List <TB_USERS> students = new List <TB_USERS>();
List <TB_REGISTERS> register = new List <TB_REGISTERS>();
var detail = new V_CLASS();
var classes = new TB_SCHEDULES();
var details = new List <V_CLASS>();
try
{
subjects = Subjects_Service.GetAll();
boxes = Boxes_Service.GetAll();
users = User_Service.GetUserRegister(id.ToString());
int count = 0;
details = Classes_Service.GetClassBy("", "", "", "", "", "", 1, Int16.MaxValue, out count);
register = Registers_Service.GetAll();
studies = User_Service.GetStudiesBySchedule(id.ToString(), 1, Int16.MaxValue, out count);
foreach (var tmp in details)
{
if (id.Equals(tmp.ScheduleId))
{
detail = tmp;
}
}
foreach (var user in users)
{
if (user.UserType.Equals("TEACHER"))
{
teachers.Add(user);
}
}
foreach (var user in users)
{
if (user.UserType.Equals("STUDIES"))
{
students.Add(user);
}
}
classes = Schedules_Service.GetById(id);
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
List <TB_USERS> lst = new List <TB_USERS>();
foreach (var item in students)
{
if (studies.Where(x => x.UserId == item.UserId).ToList().Count == 0)
{
lst.Add(item);
}
}
ViewBag.Register = register;
ViewBag.subjects = subjects;
ViewBag.boxes = boxes;
ViewBag.teachers = teachers;
ViewBag.detail = detail;
ViewBag.studies = studies;
ViewBag.students = lst;
ViewBag.id = id;
return(PartialView(classes));
}
public bool Insert(TB_SCHEDULES schedules)
{
return(new TB_SCHEDULESSql().Insert(schedules));
}
