public ActionResult SetFinalStatus(int id)
{
try
{
DissertationViewModel dissertation = Dissertation.GetDissertationById(id);
dissertation.SaveStatus();
Certificate cert = new Certificate();
cert.StudentId = dissertation.StudentId;
cert.SubjectId = dissertation.SubjectId;
int certId = cert.Save();
var user = UserManager.FindById(dissertation.StudentId);
UserManager.AddToRole(user.Id, "Teacher");
var callbackUrl = Url.Action("Certificates", "Teacher", new { certId = certId }, protocol: Request.Url.Scheme);
string email = dissertation.Student.Email;
string body = string.Format("Dear {0} {1}, Your research was approved by administrator:</br> Follow the <a href='{2}'>link</a> to generate a certificate", dissertation.Student.Name, dissertation.Student.SurName, callbackUrl);
string subject = "SortIt.Research approved";
SendMailModel.SendMail(email, body, subject);
return(Json("Research approved"));
}
catch (Exception ex)
{
return(Json("Fail!", JsonRequestBehavior.AllowGet));
}
}
internal List<DissertationViewModel> getDissertationBySubject(int subjectId)
{
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand("sp_UserGetDissertationBySubject", sqlConnection))
{
try
{
sqlConnection.Open();
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@SubjectId", subjectId);
SqlDataReader rdr = command.ExecuteReader();
List<DissertationViewModel> dissertationList = new List<DissertationViewModel>();
while (rdr.Read())
{
DissertationViewModel dissertation = new DissertationViewModel();
dissertation.Id = Convert.ToInt32(rdr["Id"]);
dissertation.StudentId = rdr["StudentId"].ToString();
dissertation.Attachement = rdr["Attachement"].ToString();
dissertation.SubjectId = Convert.ToInt32(rdr["SubjectId"]);
dissertation.CreateDate = Convert.ToDateTime(rdr["CreateDate"]);
dissertation.Accepted = Convert.ToBoolean(rdr["Accepted"]==DBNull.Value? false:rdr["Accepted"]);
//dissertation.Category = rdr["Category"].ToString();
dissertation.Design = rdr["Design"].ToString();
dissertation.Title = rdr["Title"].ToString();
dissertation.ShortDescription = rdr["ShortDescription"].ToString();
dissertation.Status = rdr["Status"].ToString();
dissertationList.Add(dissertation);
}
return dissertationList;
}
catch (Exception ex)
{
throw ex;
}
}
}
}
