protected override void Dispose(bool disposing) { if (disposing) { db.Dispose(); } base.Dispose(disposing); }
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)); }
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)); } }
public ActionResult AcceptRequests(int id) { var user = new User { Id = id }; //db.sp_Accept_SignUp(id); db.Users.Attach(user); try { user.Is_Active = true; user.Is_Pending = false; user.Status = "Active"; db.SaveChanges(); db.Dispose(); notification notifc = new notification(); notifc.Notification_Msg = "Your Sign Up Request Is Accepted"; notifc.N_To = id; // NotificationAdd(id); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } db = new FYPEntities(); var usr = db.Users.Where(p => p.Id == id).FirstOrDefault(); if (usr.Is_Student == true) { //student data update in students table int stdid = Convert.ToInt32(usr.Std_Adv_Id); var student = new Student() { ID = stdid }; db.Students.Attach(student); student.IsPending = false; student.IsActive = true; db.SaveChanges(); //student data update in user in roles table var roles = db.Roles.Where(p => p.Role_Name == "Student").FirstOrDefault(); User_IN_Roles uir = new User_IN_Roles(); uir.Role_Id = roles.Id; uir.User_Id = id; uir.Is_Active = true; uir.Status = "Active"; uir.Date_Created = DateTime.Now; uir.Created_By = 1; db.User_IN_Roles.Add(uir); db.SaveChanges(); } else { //advisor data update in students table int advid = Convert.ToInt32(usr.Std_Adv_Id); var advisor = new Advisor() { Id = advid }; db.Advisors.Attach(advisor); advisor.IsBlock = false; advisor.IsActive = true; db.SaveChanges(); //student data update in user in roles table var roles = db.Roles.Where(p => p.Role_Name == "Advisor").FirstOrDefault(); User_IN_Roles uir = new User_IN_Roles(); uir.Role_Id = roles.Id; uir.User_Id = id; uir.Is_Active = true; uir.Status = "Active"; uir.Date_Created = DateTime.Now; uir.Created_By = 1; db.User_IN_Roles.Add(uir); db.SaveChanges(); } return(RedirectToAction("AcceptSignUp", "Admin")); }