public ActionResult Class()
{
ClassTeacherModel Model = new ClassTeacherModel();
SubjctViewBags();
var AY = Connection.tblAccadamicYears.Where(u => u.SchoolId == _session.School_Id).FirstOrDefault();
var STQlist = Connection.SMGT_getSchoolClassTeachersList(_session.School_Id,
AY.AccadamicYear).ToList();
Model.ClassTeacherList = STQlist.Select(x => new ClassTeacherModel
{
SchoolId = x.SchoolId,
TeacherId = x.TeacherId,
TeacherName = x.Name,
GradeId = x.GradeId,
GradeName = x.GradeName,
ClassId = x.ClassId,
ClassName = x.ClassName,
AccedamicYear = x.AccedamicYear,
CreatedBy = x.CreatedBy,
CreatedDate = x.CreatedDate,
ModifiedBy = x.ModifiedBy,
ModifiedDate = x.ModifiedDate,
IsActive = x.IsActive,
}).ToList();
return(View(Model));
}
public ActionResult DeleteClassTeacher(string tid, string gid, string classid, string Accyear, string sid)
{
ClassTeacherModel TModel = new ClassTeacherModel();
TModel.TeacherId = tid;
TModel.GradeId = gid;
TModel.ClassId = classid;
TModel.AccedamicYear = Accyear;
TModel.SchoolId = sid;
return(PartialView("DeleteClassTeacher", TModel));
}
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));
}
}
