public JsonResult SendRequest(int id)
        {
            int             myuserid  = Convert.ToInt32(Session["userid"].ToString());
            var             std       = db.Users.Where(p => p.Id == myuserid).FirstOrDefault();
            int             mystdntid = Convert.ToInt32(std.Std_Adv_Id);
            Student_Request stdreq    = new Student_Request();

            stdreq.Request_To_Id   = id;
            stdreq.Request_From_Id = mystdntid;
            stdreq.Is_Active       = true;
            stdreq.Date_Created    = DateTime.Now;
            stdreq.Is_Accepted     = false;
            stdreq.Is_Rejected     = false;
            db.Student_Request.Add(stdreq);
            db.SaveChanges();
            return(Json(new { success = true, msg = "Successfully sent" }, JsonRequestBehavior.AllowGet));
        }
        public JsonResult AcceptRequest(int id)
        {
            int mystdid = Convert.ToInt32(Session["StudentId"]);
            var Stdreq  = db.Student_Request.Where(p => p.Request_From_Id == id && p.Request_To_Id == mystdid).FirstOrDefault();

            db.Dispose();
            var std = new Student_Request()
            {
                ID = Stdreq.ID
            };

            db = new FYPEntities();
            db.Student_Request.Attach(std);

            std.Is_Active      = false;
            std.Is_Accepted    = true;
            std.Date_Accepeted = DateTime.Now;
            db.SaveChanges();
            db.Dispose();

            db = new FYPEntities();
            group grp = new group();

            grp.GroupName   = "Group " + Stdreq.Request_From_Id + " --" + Stdreq.Request_To_Id;
            grp.Is_Active   = true;
            grp.DateCreated = DateTime.Now;
            db.groups.Add(grp);
            db.SaveChanges();

            int grpid = grp.Id;

            var stdgrp = new Student_Group();

            stdgrp.Student_1_ID = Stdreq.Request_From_Id;
            stdgrp.Student_2_ID = Stdreq.Request_To_Id;
            stdgrp.Group_Id     = grpid;
            db.Student_Group.Add(stdgrp);
            db.SaveChanges();

            NotificationAdd(id);


            return(Json(new { success = true, msg = "Successfully sent" }, JsonRequestBehavior.AllowGet));
        }