public List<ModeloNegocio.TeacherGrade> getAllTeacherGradeForUser(int iduser)
{
List<ModeloNegocio.TeacherGrade> lista = new List<ModeloNegocio.TeacherGrade>();
AccesoDatos.TeacherGrade teacherGradeAD = new AccesoDatos.TeacherGrade();
TeachersGrades = teacherGradeAD.getAllTeacherGradeForIdUser(iduser);
foreach (DataRow fila in TeachersGrades.Rows)
{
ModeloNegocio.TeacherGrade teacherGradeMN = new ModeloNegocio.TeacherGrade();
teacherGradeMN.Id = int.Parse(fila["id"].ToString());
teacherGradeMN.Grade = fila["grade"].ToString();
teacherGradeMN.Seccion = fila["seccion"].ToString();
if (DBNull.Value.Equals(fila["num_alumnos"]))
{
teacherGradeMN.Num_alumnos = 0;
}
else
{
teacherGradeMN.Num_alumnos = Convert.ToInt32(fila["num_alumnos"]);
}
lista.Add(teacherGradeMN);
}
return lista;
}
public List <ModeloNegocio.TeacherGrade> getAllTeacherGradeForUser(int iduser)
{
List <ModeloNegocio.TeacherGrade> lista = new List <ModeloNegocio.TeacherGrade>();
AccesoDatos.TeacherGrade teacherGradeAD = new AccesoDatos.TeacherGrade();
TeachersGrades = teacherGradeAD.getAllTeacherGradeForIdUser(iduser);
foreach (DataRow fila in TeachersGrades.Rows)
{
ModeloNegocio.TeacherGrade teacherGradeMN = new ModeloNegocio.TeacherGrade();
teacherGradeMN.Id = int.Parse(fila["id"].ToString());
teacherGradeMN.Grade = fila["grade"].ToString();
teacherGradeMN.Seccion = fila["seccion"].ToString();
if (DBNull.Value.Equals(fila["num_alumnos"]))
{
teacherGradeMN.Num_alumnos = 0;
}
else
{
teacherGradeMN.Num_alumnos = Convert.ToInt32(fila["num_alumnos"]);
}
lista.Add(teacherGradeMN);
}
return(lista);
}
public int getCountGradesForIdTeacher(int teacher_id)
{
DataTable valores; int valor;
AccesoDatos.TeacherGrade teacherGradeAD = new AccesoDatos.TeacherGrade();
valores = teacherGradeAD.getListGradesForIdTeacher(teacher_id);
valor = valores.Rows.Count;
return valor;
}
public int getCountGradesForIdTeacher(int teacher_id)
{
DataTable valores; int valor;
AccesoDatos.TeacherGrade teacherGradeAD = new AccesoDatos.TeacherGrade();
valores = teacherGradeAD.getListGradesForIdTeacher(teacher_id);
valor = valores.Rows.Count;
return(valor);
}
public int insertTeacherGrade(ModeloNegocio.TeacherGrade ObjTeacherGrade)
{
AccesoDatos.TeacherGrade TeacherGrade = new AccesoDatos.TeacherGrade();
return TeacherGrade.insertTeacherGrade(ObjTeacherGrade);
}
public ModeloNegocio.TeacherGrade getTeacherGradeId(int TeacherGrade_id)
{
AccesoDatos.TeacherGrade TeacherGrade = new AccesoDatos.TeacherGrade();
return TeacherGrade.getTeacherGradeId(TeacherGrade_id);
}
public DataTable getGradesForIdTeacher(int teacher_id)
{
AccesoDatos.TeacherGrade teacherGradeAD = new AccesoDatos.TeacherGrade();
return teacherGradeAD.getListGradesForIdTeacher(teacher_id);
}
public int getCountSeccForIdTeachers(int teacher_id)
{
AccesoDatos.TeacherGrade teacherGrade = new AccesoDatos.TeacherGrade();
return teacherGrade.getCountSeccForIdTeachers(teacher_id);
}
public DataTable getCountGradesForTeachers()
{
AccesoDatos.TeacherGrade teacherGradeAD = new AccesoDatos.TeacherGrade();
return teacherGradeAD.getCountGradesForTeachers();
}
//public ModeloNegocio.TeacherGrade getTeacherGradeId(int TeacherGrade_id)
//{
// AccesoDatos.TeacherGrade teacherGradeAD = new AccesoDatos.TeacherGrade();
// return teacherGradeAD.getTeacherGradeId(TeacherGrade_id);
//}
public bool deleteTeacherGrade(int idTeacher)
{
AccesoDatos.TeacherGrade teacherGradeAD = new AccesoDatos.TeacherGrade();
return teacherGradeAD.deleteTeacherGrade(idTeacher);
}
public DataTable getGradesForIdTeacher(int teacher_id)
{
AccesoDatos.TeacherGrade teacherGradeAD = new AccesoDatos.TeacherGrade();
return(teacherGradeAD.getListGradesForIdTeacher(teacher_id));
}
public int getCountSeccForIdTeachers(int teacher_id)
{
AccesoDatos.TeacherGrade teacherGrade = new AccesoDatos.TeacherGrade();
return(teacherGrade.getCountSeccForIdTeachers(teacher_id));
}
public DataTable getCountGradesForTeachers()
{
AccesoDatos.TeacherGrade teacherGradeAD = new AccesoDatos.TeacherGrade();
return(teacherGradeAD.getCountGradesForTeachers());
}
//public ModeloNegocio.TeacherGrade getTeacherGradeId(int TeacherGrade_id)
//{
// AccesoDatos.TeacherGrade teacherGradeAD = new AccesoDatos.TeacherGrade();
// return teacherGradeAD.getTeacherGradeId(TeacherGrade_id);
//}
public bool deleteTeacherGrade(int idTeacher)
{
AccesoDatos.TeacherGrade teacherGradeAD = new AccesoDatos.TeacherGrade();
return(teacherGradeAD.deleteTeacherGrade(idTeacher));
}
public ModeloNegocio.TeacherGrade getTeacherGradeId(int TeacherGrade_id)
{
AccesoDatos.TeacherGrade TeacherGrade = new AccesoDatos.TeacherGrade();
return(TeacherGrade.getTeacherGradeId(TeacherGrade_id));
}
public int insertTeacherGrade(ModeloNegocio.TeacherGrade ObjTeacherGrade)
{
AccesoDatos.TeacherGrade TeacherGrade = new AccesoDatos.TeacherGrade();
return(TeacherGrade.insertTeacherGrade(ObjTeacherGrade));
}
