public ActionResult List()
{
var courseDal = new Course_DAL();
var response = courseDal.list();
return(View(response));
}
public ActionResult Register(FormCollection frmController)
{
Course_DAL course_DAL = new Course_DAL();
Student_DAL student_DAL = new Student_DAL();
int id_course = int.Parse(frmController["CourseName"]);
string student_name = frmController["txtStudentName"];
Student_Ent student_Ent = new Student_Ent();
student_Ent.StudentName = student_name;
//Add Student to SQL
if (!(student_DAL.Add(student_Ent)))
{
ViewBag.Courses = course_DAL.GetCourses();
ViewBag.Message = "Có Lỗi Xảy Ra !";
return(View());
}
int id_student = student_DAL.GetID_byName(student_name);
if (!course_DAL.Add_Register(id_course, id_student))
{
ViewBag.Courses = course_DAL.GetCourses();
ViewBag.Message = "Có Lỗi Xảy Ra !";
return(View());
}
ViewBag.Courses = course_DAL.GetCourses();
ViewBag.Message = "Successfully !";
return(View());
}
public ActionResult Create(Course_Ent course_Ent, string TeacherName)
{
Course_DAL course_DAL = new Course_DAL();
//Teacher_DAL teacher_DAL = new Teacher_DAL();
if (!course_DAL.Check_Exist(course_Ent.CourseID))
{
Teacher_DAL teacher_DAL = new Teacher_DAL();
ViewBag.Teachers = teacher_DAL.GetTeachers();
ViewBag.Message = "ID Tồn Tại !";
return(View());
}
Teacher_Ent teacher = new Teacher_Ent();
teacher.TeacherID = int.Parse(TeacherName);
//teacher.TeacherName = teacher_DAL.GetName(teacher.TeacherID);
course_Ent.Teacher = teacher;
if (!(course_DAL.Add_Course(course_Ent)))
{
Teacher_DAL teacher_DAL = new Teacher_DAL();
ViewBag.Teachers = teacher_DAL.GetTeachers();
ViewBag.Message = "Có Lỗi Xảy Ra !";
return(View());
}
return(RedirectToAction("Course", "Course"));
}
public async Task <ActionResult> Add(CourseViewModel model)
{
if (ModelState.IsValid)
{
var newModel = new T_Course
{
CourseID = Guid.NewGuid(),
Name = model.Name,
Code = model.Code,
CreateDate = DateTime.Now,
ModificationDate = DateTime.Now,
LogicalErasure = false
};
var courseDal = new Course_DAL();
var response = courseDal.Add(newModel);
if (response != null)
{
return(RedirectToAction("List"));
}
ModelState.AddModelError("", "Error al Crear El Curso");
}
return(View(model));
}
public ActionResult ProgramList()
{
var courseDal = new Course_DAL();
var courses = courseDal.InscriptionStudent(User.Identity.GetUserId());
return(View(courses));
}
public ActionResult Courses()
{
var courseDal = new Course_DAL();
var courses = courseDal.InstanceOfCourses(User.Identity.GetUserId());
return(View(courses));
}
public ActionResult Register()
{
Course_DAL course_DAL = new Course_DAL();
ViewBag.Courses = course_DAL.GetCourses();
return(View());
}
public ActionResult Delete(int id)
{
Teacher_DAL teacher_DAL = new Teacher_DAL();
ViewBag.Teachers = teacher_DAL.GetTeachers();
Course_DAL course_DAL = new Course_DAL();
return(View(course_DAL.GetCourse_Ent(id)));
}
public ActionResult Delete_Accept(int id)
{
Course_DAL course_DAL = new Course_DAL();
if (!course_DAL.Delete(id))
{
Teacher_DAL teacher_DAL = new Teacher_DAL();
ViewBag.Teachers = teacher_DAL.GetTeachers();
ViewBag.Message = "Có Lỗi Xảy Ra !";
return(View(course_DAL.GetCourse_Ent(id)));
}
return(RedirectToAction("Course", "Course"));
}
public ActionResult Program()
{
var courseDal = new Course_DAL();
var courses = courseDal.InstanceOfCourses();
ViewBag.courses = courses.Select(i => new SelectListItem()
{
Text = $"Curso:{i.CourseName}, Profesor:{i.teacherName}, Programación: {i.Date.ToShortDateString()} desde las {i.StartTime} hasta las {i.FinalTime}",
Value = i.InstanceOfCourseID.ToString()
});
return(View(new InscriptionStudentViewModel()
{
InstanceOfCourse = new InstanceOfCourseViewModel()
}));
}
public async Task <ActionResult> addClass(InstanceOfCourseViewModel model)
{
var courseDal = new Course_DAL();
if (ModelState.IsValid)
{
DateTime dateTime = DateTime.ParseExact(model.StartTime,
"hh:mm tt", CultureInfo.InvariantCulture);
TimeSpan span = dateTime.TimeOfDay;
TimeSpan span2 = dateTime.AddHours(3).TimeOfDay;
var newModel = new T_InstanceOfCourse
{
InstanceOfCourseID = Guid.NewGuid(),
TeacherID = User.Identity.GetUserId(),
Date = model.Date,
StartTime = span,
FinalTime = span2,
CourseID = Guid.Parse(model.CourseID),
CreateDate = DateTime.Now,
ModificationDate = DateTime.Now,
LogicalErasure = false
};
try
{
var response = courseDal.AddClassTeacher(newModel);
if (response != null)
{
return(RedirectToAction("Courses"));
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.Message);
}
}
var courses = courseDal.list();
ViewBag.courses = courses.Select(i => new SelectListItem()
{
Text = i.Name, Value = i.CourseID.ToString()
});
return(View(model));
}
public ActionResult Program(InscriptionStudentViewModel model)
{
var courseDal = new Course_DAL();
if (ModelState.IsValid)
{
var newModel = new T_InscriptionStudent
{
InscriptionStudentID = Guid.NewGuid(),
Assistance = false,
Observation = string.Empty,
StudentID = User.Identity.GetUserId(),
InstanceOfCourseID = model.InstanceOfCourse.InstanceOfCourseID,
CreateDate = DateTime.Now,
ModificationDate = DateTime.Now,
LogicalErasure = false
};
try
{
var response = courseDal.AddInscription(newModel);
if (response != null)
{
return(RedirectToAction("ProgramList"));
}
}
catch (Exception ex)
{
ModelState.AddModelError("", "Operacion no valida, recuerde que solo puede agregar hasta 4 materias");
ModelState.AddModelError("", "Operacion no valida, No se puede agreagar materias repetidas");
ModelState.AddModelError("", ex.Message);
}
}
var courses = courseDal.InstanceOfCourses();
ViewBag.courses = courses.Select(i => new SelectListItem()
{
Text = $"{i.CourseName}-{i.teacherName} {i.Date}-{i.StartTime}/{i.FinalTime}",
Value = i.InstanceOfCourseID.ToString()
});
return(View(model));
}
public ActionResult addClass()
{
var courseDal = new Course_DAL();
var courses = courseDal.list();
ViewBag.courses = courses.Select(i => new SelectListItem()
{
Text = i.Name, Value = i.CourseID.ToString()
});
DateTime dateTime = DateTime.Now;
TimeSpan span = dateTime.TimeOfDay;
return(View(new InstanceOfCourseViewModel()
{
InstanceOfCourseID = Guid.NewGuid(),
Date = dateTime,
// StartTime = span.ToString("hh:mm tt")
}));
}
public ActionResult Edit(Course_Ent course_Ent, string TeacherName)
{
Course_DAL course_DAL = new Course_DAL();
//Teacher_DAL teacher_DAL = new Teacher_DAL();
Teacher_Ent teacher = new Teacher_Ent();
teacher.TeacherID = int.Parse(TeacherName);
//teacher.TeacherName = teacher_DAL.GetName(teacher.TeacherID);
course_Ent.Teacher = teacher;
if (!(course_DAL.Edit(course_Ent)))
{
Teacher_DAL teacher_DAL = new Teacher_DAL();
ViewBag.Teachers = teacher_DAL.GetTeachers();
ViewBag.Message = "Có Lỗi Xảy Ra !";
return(View());
}
return(RedirectToAction("Course", "Course"));
}
public ActionResult Course()
{
Course_DAL course_DAL = new Course_DAL();
return(View(course_DAL.GetCourses()));
}
