public ClassroomStudent GetClassroomCard(int cardId)
{
ClassroomStudent classroomStudent = null;
using (var ds = new DataSeed()) {
classroomStudent = ds.GetClassroomCardByCardId(cardId);
}
return(classroomStudent);
}
internal void Create(ClassroomStudent newData)
{
ClassroomStudent exists = _repo.Find(newData);
if (exists != null)
{
throw new Exception("Student already enrolled");
}
_repo.Create(newData);
}
public ClassroomStudent LeaveHallwayCard(int cardId, bool status)
{
ClassroomStudent classroomStudent = null;
using (var ds = new DataSeed())
{
classroomStudent = ds.LeaveHallwayTimeForStudent(cardId, status);
}
return(classroomStudent);
}
internal string Delete(ClassroomStudent cs)
{
ClassroomStudent exists = _repo.Find(cs);
if (exists == null)
{
throw new Exception("Invalid Id Combination");
}
_repo.Delete(exists.Id);
return("Successfully Deleted");
}
public ActionResult <String> Edit([FromBody] ClassroomStudent cs)
{
try
{
return(Ok(_ss.Delete(cs)));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
public ActionResult <String> Create([FromBody] ClassroomStudent newData)
{
try
{
_ss.Create(newData);
return(Ok("Success"));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
public ClassroomStudent LeaveClassroomCard(int cardId, bool status)
{
ClassroomStudent classroomStudent = null;
using (var ds = new DataSeed())
{
var isUpdate = ds.LeaveClassroomTimeForStudent(cardId, status);
if (isUpdate)
{
classroomStudent = GetClassroomCard(cardId);
}
}
return(classroomStudent);
}
internal ClassroomStudent Create(ClassroomStudent newData)
{
string sql = @"
INSERT INTO classroomstudents
(studentId, classroomId)
VALUES
(@StudentId, @ClassroomId);
SELECT LAST_INSERT_ID();
";
int id = _db.ExecuteScalar <int>(sql, newData);
newData.Id = id;
return(newData);
}
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;
}
}
internal ClassroomStudent Find(ClassroomStudent cs)
{
string sql = "SELECT * FROM classroomstudents WHERE (studentId = @StudentId AND classroomId = @ClassroomId)";
return(_db.QueryFirstOrDefault(sql, cs));
}
