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));
}
}
