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