public ActionResult DeleteStudentexcactivities(StudentExtraCModel Model)
{
try
{
tblStudentExtraCurricularActivity Tble = Connection.tblStudentExtraCurricularActivities.Find(Model.StudentId, Model.SchoolId, Model.ActivityCode);
Connection.tblStudentExtraCurricularActivities.Remove(Tble);
Connection.SaveChanges();
var item = Connection.tblStudentExtraCurricularActivities.FirstOrDefault(i => i.SchoolId == Model.SchoolId && i.ActivityCode == Model.ActivityCode);
//tblStudentExtraCurricularActivity Tblew = Connection.tblStudentExtraCurricularActivities.Find(item.ActivityCode);
//Connection.tblStudentExtraCurricularActivities.Remove(Tblew);
// Connection.SaveChanges();
string s = Model.SchoolId + "!" + Model.StudentId;
return(Json(s, JsonRequestBehavior.AllowGet));
//return RedirectToAction("Index");
}
catch
{
return(Json("Error", JsonRequestBehavior.AllowGet));
}
}
public ActionResult Deletescexc(string SchoolId, string StudentId, string ActivityCode)
{
StudentExtraCModel Model = new StudentExtraCModel();
Model.ActivityCode = ActivityCode;
Model.SchoolId = SchoolId;
Model.StudentId = StudentId;
return(PartialView("DeleteStudentEXactvity", Model));
}
public JsonResult AddStudentExcActivity(StudentExtraCModel Model)
{
try
{
string result = "Error";
// var count2 = Connection.tblStudentExtraCurricularActivities.Count();
// Model.HouseId = count2.ToString();
if (Model.ActivityCode != null && Model.SchoolIdE != null && Model.StudentIdE != null)
{
var count = Connection.tblStudentExtraCurricularActivities.Count(u => u.ActivityCode == Model.ActivityCode && u.SchoolId == Model.SchoolIdE && u.StudentId == Model.StudentIdE);
if (count == 0)
{
// Model.SchoolId = Schoold;
tblStudentExtraCurricularActivity newscg = new tblStudentExtraCurricularActivity();
newscg.CreatedBy = USession.User_Id;
newscg.CreatedDate = DateTime.Now;
newscg.SchoolId = Model.SchoolIdE;
newscg.StudentId = Model.StudentIdE;
newscg.ActivityCode = Model.ActivityCode;
newscg.IsActive = "Y";
Connection.tblStudentExtraCurricularActivities.Add(newscg);
Connection.SaveChanges();
result = "sessioncheck" + "!" + Model.SchoolIdE + "!" + Model.StudentIdE;
// ViewBag.SchoolId = Model.SchoolId;
}
else
{
result = "Exits";
}
}
else
{
result = "fill";
}
//ShowTeacherQualificatoin();
return(Json(result, JsonRequestBehavior.AllowGet));
}
catch (Exception Ex)
{
Errorlog.ErrorManager.LogError("Teacher Controller - AddQualification(QualificationModel Model)", Ex);
return(Json("Exception", JsonRequestBehavior.AllowGet));
}
}
public ActionResult ShowEditExtra(string StudentId, string SchoolId)
{
StudentExtraCModel TModel = new StudentExtraCModel();
tblStudent TCtable = Connection.tblStudents.SingleOrDefault(x => x.StudentId == StudentId && x.SchoolId == SchoolId);
tblSchool schl = Connection.tblSchools.SingleOrDefault(x => x.SchoolId == SchoolId);
// TModel.IsActive = TCtable.IsActive;
string SchoolName = schl.SchoolName;
TModel.StudentId = TCtable.StudentId;
TModel.StudentName = TCtable.studentName;
TModel.SchoolName = SchoolName;
var StudentSextra = Connection.SMGTloadScholExtraCadd(SchoolId, "%").ToList();
List <tblExtraCurricularActivity> result = StudentSextra.Select(x => new tblExtraCurricularActivity
{
ActivityCode = x.ActivityCode,
ActivityName = x.ActivityName
}).ToList();
ViewBag.studentextrac = new SelectList(StudentSextra, "ActivityCode", "ActivityName");
TModel.SchoolId = TCtable.SchoolId;
return(PartialView("EditStudentEXtra", TModel));
}