public ActionResult DeleteClassroom(ClassroomModel form)
{
appClassroom = new ClassroomApplication();
try
{
string msgReturn = appClassroom.DeleteListClassroom(form.idClassroom);
int number;
bool result = int.TryParse(msgReturn, out number);
if (result)
{
ViewBag.MessageType = MessageType.Success;
ViewBag.Message = Message.SuccessDeleteClassroom;
}
else
{
ViewBag.MessageType = MessageType.Error;
ViewBag.Message = Message.ErrorUnknown;
}
return(Json(new { msg = ViewBag.Message, type = ViewBag.MessageType }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { msg = ex.Message, type = MessageType.Success }, JsonRequestBehavior.AllowGet));
}
}
public List <ClassroomModel> ListClassroom(int idLoginAccess)
{
appClassroom = new ClassroomApplication();
List <ClassroomModel> listClassroom = new List <ClassroomModel>();
try
{
foreach (DataRow linha in appClassroom.QuerieAllClassroom(idLoginAccess).Rows)
{
ClassroomModel obj = new ClassroomModel();
obj.idClassroom = Convert.ToInt32(linha["idClassroom"]);
obj.nameClassroom = Convert.ToString(linha["nameClassroom"]);
obj.shiftClassroom = Convert.ToString(linha["shiftClassroom"]);
obj.totalStudentsModel = Convert.ToInt32(linha["totalStudents"]);
listClassroom.Add(obj);
}
return(listClassroom);
}
catch (Exception)
{
throw;
}
}
public ClassroomModel LoadDataClassroom(int idClassroom)
{
appClassroom = new ClassroomApplication();
ClassroomModel classroomModel = new ClassroomModel();
classroomModel.listClassroomStudent = new List <ClassroomStudent>();
classroomModel.listTeachingPlan = new List <TeachingPlan>();
try
{
foreach (DataRow linha in appClassroom.QuerieClassroom(idClassroom).Rows)
{
if (!linha["idClassroom"].ToString().Equals(""))
{
classroomModel.idClassroom = Convert.ToInt32(linha["idClassroom"]);
classroomModel.nameClassroom = Convert.ToString(linha["nameClassroom"]);
classroomModel.shiftClassroom = Convert.ToString(linha["shiftClassroom"]);
}
else if (!linha["idStudent"].ToString().Equals(""))
{
ClassroomStudent classroomStudent = new ClassroomStudent();
classroomStudent.Student = new Student();
classroomStudent.idStudent = Convert.ToInt32(linha["idStudent"]);
classroomStudent.Student.registrationNumber = Convert.ToString(linha["registrationNumber"]);
classroomStudent.Student.nameStudent = Convert.ToString(linha["nameStudent"]);
classroomModel.listClassroomStudent.Add(classroomStudent);
}
else if (!linha["idTeachingPlan"].ToString().Equals(""))
{
TeachingPlan teachingPlan = new TeachingPlan();
teachingPlan.idTeachingPlan = Convert.ToInt32(linha["idTeachingPlan"]);
teachingPlan.activityDescription = Convert.ToString(linha["activityDescription"]);
classroomModel.listTeachingPlan.Add(teachingPlan);
}
}
return(classroomModel);
}
catch (Exception)
{
throw;
}
}
public ActionResult UpdateClassroom(ClassroomModel form)
{
classroomModel = new ClassroomModel();
appClassroom = new ClassroomApplication();
try
{
string msgReturn = appClassroom.UpdateListClassroom(form);
int number;
bool result = int.TryParse(msgReturn, out number);
if (result)
{
ViewBag.MessageType = MessageType.Success;
ViewBag.Message = Message.SuccessUpdateClassroom;
}
else if (msgReturn.Contains("O aluno") && msgReturn.Contains("já está cadastrado em outra turma"))
{
ViewBag.MessageType = MessageType.Error;
ViewBag.Message = msgReturn;
}
else if (msgReturn.Contains("Não é possível inserir uma linha de chave duplicada"))
{
ViewBag.MessageType = MessageType.Error;
ViewBag.Message = Message.ErrorDuplicateClassroom;
}
else
{
ViewBag.MessageType = MessageType.Error;
ViewBag.Message = Message.ErrorUnknown;
}
return(Json(new { msg = ViewBag.Message, type = ViewBag.MessageType }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { msg = ex.Message, type = MessageType.Success }, JsonRequestBehavior.AllowGet));
}
}
