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