public JsonResult SendRequesttoAdvisor(int id) { int mystudntid = Convert.ToInt32(Session["StudentID"]); var groupid = db.Student_Group.Where(p => p.Student_1_ID == mystudntid || p.Student_2_ID == mystudntid).FirstOrDefault(); var stdadvreq = new Student_Advisor_Request(); stdadvreq.Advisor_Id = id; stdadvreq.Student_Id = mystudntid; stdadvreq.Group_Id = groupid.Group_Id; stdadvreq.Is_Active = true; stdadvreq.Date_Created = DateTime.Now; stdadvreq.Is_Accepted = false; db.Student_Advisor_Request.Add(stdadvreq); db.SaveChanges(); return(Json(new { msg = "Success", success = true }, JsonRequestBehavior.AllowGet)); }
public JsonResult AcceptstudentRequest(int id) { int advisorid = Convert.ToInt32(Session["AdvisorId"]); var adv = db.Advisors.Where(p => p.Id == advisorid).FirstOrDefault(); int slots = Convert.ToInt32(adv.Advisors_Slot); if (slots > 0 && CheckStudentAdvisorGroup(id) == false) { var stdadvreq = new Student_Advisor_Request() { Id = id }; db.Student_Advisor_Request.Attach(stdadvreq); stdadvreq.Is_Accepted = true; stdadvreq.Date_Accepted = DateTime.Now; stdadvreq.Is_Active = false; db.SaveChanges(); db.Dispose(); db = new FYPEntities(); var advisorslotupdate = new Advisor() { Id = advisorid }; db.Advisors.Attach(advisorslotupdate); advisorslotupdate.Advisors_Slot = slots - 1; db.SaveChanges(); NotificationAdd(id); return(Json(new { msg = "Successfull", success = true }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { msg = "Unable To Accept 0 Slots Available or Student Already in Group", success = true }, JsonRequestBehavior.AllowGet)); } }