public JsonResult AddClassTeacher(ClassTeacherModel Model)
{
try
{
string result = "Error";
var AY = Connection.tblAccadamicYears.Where(u => u.SchoolId == _session.School_Id).FirstOrDefault();
// List<tblClass> ClassesList = Connection.tblClasses.Where(r => r.SchoolId == "CKC" && r.GradeId == GradeId).ToList();
int countt = Connection.tblClassTeachers.Count(u => u.TeacherId == Model.TeacherId &&
u.AccedamicYear == AY.AccadamicYear &&
u.IsActive == "Y");
int Ccount = Connection.tblClassTeachers.Count(u => u.ClassId == Model.ClassId &&
u.AccedamicYear == AY.AccadamicYear && u.GradeId == Model.GradeId && u.SchoolId == _session.School_Id && u.IsActive == "Y");
if (countt != 0)
{
result = "TExits";
//ViewBag.TeacherId = Model.TeacherID.ToString();
}
else if (Ccount != 0)
{
result = "CExits";
}
else
{
tblClassTeacher NewQ = new tblClassTeacher();
NewQ.CreatedBy = _session.User_Id;
NewQ.CreatedDate = DateTime.Now;
NewQ.IsActive = "Y";
NewQ.AccedamicYear = AY.AccadamicYear;
NewQ.SchoolId = AY.SchoolId;
NewQ.GradeId = Model.GradeId;
NewQ.ClassId = Model.ClassId;
NewQ.TeacherId = Model.TeacherId;
Connection.tblClassTeachers.Add(NewQ);
Connection.SaveChanges();
result = "Success";
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
catch (Exception Ex)
{
Errorlog.ErrorManager.LogError("Teacher Controller - AddClassTeacher(ClassTeacherModel Model)", Ex);
return(Json("Exception", JsonRequestBehavior.AllowGet));
}
}
public JsonResult DeleteClassTeacher(ClassTeacherModel Model)
{
try
{
tblClassTeacher TCtable = Connection.tblClassTeachers.SingleOrDefault(
x => x.TeacherId == Model.TeacherId &&
x.GradeId == Model.GradeId &&
x.ClassId == Model.ClassId &&
x.AccedamicYear == Model.AccedamicYear &&
x.SchoolId == Model.SchoolId);
TCtable.IsActive = "D";
Connection.SaveChanges();
return(Json("Sucses", JsonRequestBehavior.AllowGet));
}
catch
{
return(Json("Error", JsonRequestBehavior.AllowGet));
}
}
