public ActionResult Events()
{
EventsEventViewModel model = new EventsEventViewModel();
List <Event> events = new List <Event>();
using (var context = new NCContext.NCContext())
{
if (GlobalData.IsLoggedIn())
{
string str = GlobalData.GetEmail();
var student = context.Students.Where(x => x.Email == str).FirstOrDefault();
if (student != null)
{
model.StudentId = student.Id;
var eventssubscribed = context.EventsSubscribers.Where(x => x.StudentId == student.Id).ToList();
if (eventssubscribed.Count > 0)
{
foreach (var e_subscribed in eventssubscribed)
{
var evet = context.Events.Where(x => x.Id == e_subscribed.EventId).FirstOrDefault();
if (evet != null)
{
events.Add(evet);
}
}
}
}
}
model.SubscribedEvents = events;
model.Events = context.Events.ToList();
model.EventsSubscribers = context.EventsSubscribers.ToList();
}
return(View(model));
}
public ActionResult UnSubscribe(string Email, int EventId)
{
if (!string.IsNullOrEmpty(Email) && EventId > 0)
{
using (var context = new NCContext.NCContext())
{
var student = context.Students.Where(x => x.Email == Email).FirstOrDefault();
if (student != null)
{
var e_subscribed = context.EventsSubscribers.Where(x => x.EventId == EventId && x.StudentId == student.Id).FirstOrDefault();
if (e_subscribed != null)
{
context.EventsSubscribers.Remove(e_subscribed);
context.SaveChanges();
var evet = context.Events.Where(x => x.Id == EventId).FirstOrDefault();
var subject = "Event UnSubscribed";
var body = "Hi, you have UnSubscribed from Event: " + evet.Title;
SendEmail(Email, body, subject);
return(RedirectToAction("Events"));
}
}
}
}
return(RedirectToAction("Events"));
}
public ActionResult Category()
{
using (var Context = new NCContext.NCContext())
{
return(View(Context.EventCategories.ToList()));
}
}
public string ForgotPassword(string email)
{
string result = "";
try
{
string resetCode = Guid.NewGuid().ToString();
string verifyUrl = "/Account/ResetPassword/" + resetCode;
var link = Request.Url.AbsoluteUri.Replace(Request.Url.PathAndQuery, verifyUrl);
using (var context = new NCContext.NCContext())
{
var getuser = context.Students.Where(x => x.Email == email).FirstOrDefault();
if (getuser != null)
{
getuser.ResetPasswordCode = resetCode;
context.SaveChanges();
var subject = "Password Reset Request";
var body = "Hi " + getuser.FName + ", You recently requested to reset your password for your account. Click the link to reset it. "
+ link + " If you did not request a password reset, please ignore this email. Thank you";
SendEmail(email, body, subject);
result = "true";
}
else
{
result = "Email is not valid";
}
}
}
catch (Exception ex)
{
result = ex.Message;
}
return(result);
}
public string StatusChange(int Id, int status)
{
string result = "Internal Server Error";
if (status > 0 && Id > 0)
{
try
{
using (var context = new NCContext.NCContext())
{
var survey = context.Surveys.Where(x => x.Id == Id).FirstOrDefault();
if (survey != null)
{
survey.Status = status;
context.Entry(survey).State = EntityState.Modified;
context.SaveChanges();
var student = context.Students.Where(x => x.Id == survey.StudentId).FirstOrDefault();
var subject = "Event Subscribed";
var body = "Hi, thank you for giving your time and playing the survey as a result you win the cofee card.";
SendEmail(student.Email, body, subject);
result = "true";
}
}
}
catch (Exception ex)
{
result = ex.Message;
}
}
return(result);
}
public ActionResult Feedbacks()
{
using (var context = new NCContext.NCContext())
{
return(View(context.Feedbacks.ToList()));
}
}
public string AddEntry()
{
string result = "";
var email = GlobalData.GetEmail();
if (email != null)
{
using (var context = new NCContext.NCContext())
{
var student = context.Students.Where(x => x.Email == email).FirstOrDefault();
var num = context.Surveys.Where(x => x.StudentId == student.Id).FirstOrDefault();
if (num == null)
{
Survey survey = new Survey();
survey.StudentId = student.Id;
context.Surveys.Add(survey);
context.SaveChanges();
int id = survey.Id;
survey.SurveyNo = id;
context.SaveChanges();
return("true");
}
else
{
return("You already take survey");
}
}
}
return(result);
}
public ActionResult Student()
{
using (var context = new NCContext.NCContext())
{
return(View(context.Students.ToList()));
}
}
public ActionResult Promotions()
{
using (var context = new NCContext.NCContext())
{
return(View(context.Promotions.ToList()));
}
}
public ActionResult EditCategory(int Id)
{
using (var context = new NCContext.NCContext())
{
return(View(context.EventCategories.Where(x => x.Id == Id).FirstOrDefault()));
}
}
public ActionResult Login(string Email, string Password)
{
using (var context = new NCContext.NCContext())
{
if (!string.IsNullOrEmpty(Email) && !string.IsNullOrEmpty(Password))
{
var Isuser = context.Users.Where(x => x.Email.ToLower() == Email.ToLower() && x.Password == Password).FirstOrDefault();
if (Isuser != null)
{
if (Isuser.Role == "admin")
{
FormsAuthentication.SetAuthCookie(Email.ToLower(), true);
return(RedirectToAction("Dashboard", "Admin"));
}
else if (Isuser.Role == "student")
{
GlobalData.SetEmail(Email);
FormsAuthentication.SetAuthCookie(Email.ToLower(), true);
GlobalData.SetLoginStatus(true);
return(RedirectToAction("Index", "Index"));
}
}
}
}
ViewBag.error = "false";
GlobalData.SetLoginStatus(false);
GlobalData.SetEmail("");
return(View());
}
public string ChangeStatus(int Id, int status)
{
string result = "Internal Server Error";
if (status > 0 && Id > 0)
{
try
{
using (var context = new NCContext.NCContext())
{
var post = context.Posts.Where(x => x.Id == Id).FirstOrDefault();
if (post != null)
{
post.ApprovalStatus = status;
post.Date = DateTime.Now;
context.Entry(post).State = EntityState.Modified;
context.SaveChanges();
result = "true";
}
}
}
catch (Exception ex)
{
result = ex.Message;
}
}
return(result);
}
public ActionResult Annoucments()
{
using (var context = new NCContext.NCContext())
{
var list = context.Surveys.Where(x => x.Status == 1).Include(x => x.Student).ToList();
return(View(list));
}
}
public ActionResult Index()
{
using (var context = new NCContext.NCContext())
{
var promotions = context.Promotions.Where(x => x.Status == 1).ToList();
return(View(promotions));
}
}
public string EditCategory(EventCategory eventCategory)
{
using (var context = new NCContext.NCContext())
{
context.Entry(eventCategory).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
return("true");
}
}
public ActionResult Surveys()
{
using (var context = new NCContext.NCContext())
{
var list = context.Surveys.Include(x => x.Student).ToList();
return(View(list));
}
}
public ActionResult EditEvent(int Id)
{
using (var context = new NCContext.NCContext())
{
GetEditEventViewModels model = new GetEditEventViewModels();
model.Event = context.Events.Where(x => x.Id == Id).FirstOrDefault();
model.EventCategories = context.EventCategories.ToList();
return(View(model));
}
}
public string EditPromotion(Promotion promotion)
{
string result = "";
using (var context = new NCContext.NCContext())
{
context.Entry(promotion).State = EntityState.Modified;
context.SaveChanges();
result = "true";
}
return(result);
}
public string AddPromotion(Promotion promotion)
{
string result = "";
using (var context = new NCContext.NCContext())
{
context.Promotions.Add(promotion);
context.SaveChanges();
result = "true";
}
return(result);
}
public ActionResult EditPromotion(int Id)
{
Promotion promotion = new Promotion();
using (var context = new NCContext.NCContext())
{
if (Id > 0)
{
promotion = context.Promotions.Where(x => x.Id == Id).FirstOrDefault();
}
}
return(View(promotion));
}
public string EditPost(Post post)
{
if (post != null)
{
using (var context = new NCContext.NCContext())
{
context.Entry(post).State = EntityState.Modified;
context.SaveChanges();
return("true");
}
}
return("Internal Server Error");
}
public string DeleteStudent(int Id)
{
using (var context = new NCContext.NCContext())
{
var student = context.Students.Where(x => x.Id == Id).FirstOrDefault();
if (student != null)
{
context.Students.Remove(student);
context.SaveChanges();
return("true");
}
}
return("Internal Server Error");
}
public string Feedback(Feedback feedback)
{
string result = "";
if (feedback != null)
{
using (var context = new NCContext.NCContext())
{
context.Feedbacks.Add(feedback);
context.SaveChanges();
result = "true";
}
}
return(result);
}
public ActionResult EditPost(int Id)
{
GetEditPostViewModel model = new GetEditPostViewModel();
using (var context = new NCContext.NCContext())
{
var post = context.Posts.Where(x => x.Id == Id).FirstOrDefault();
if (post != null)
{
post.ApprovalStatus = 0;
model.Post = post;
model.EventCategories = context.EventCategories.ToList();
}
}
return(View(model));
}
public string DeletePromotion(int Id)
{
string result = "";
using (var context = new NCContext.NCContext())
{
var promotion = context.Promotions.Where(x => x.Id == Id).FirstOrDefault();
if (promotion != null)
{
context.Promotions.Remove(promotion);
context.SaveChanges();
result = "true";
}
}
return(result);
}
public string AddCategory(EventCategory eventCategory)
{
using (var context = new NCContext.NCContext())
{
if (eventCategory != null)
{
context.EventCategories.Add(eventCategory);
context.SaveChanges();
return("true");
}
else
{
return("Name Field is Required");
}
}
}
public string DeleteFeedback(int Id)
{
string result = "";
using (var context = new NCContext.NCContext())
{
var feedback = context.Feedbacks.Where(x => x.Id == Id).FirstOrDefault();
if (feedback != null)
{
context.Feedbacks.Remove(feedback);
context.SaveChanges();
result = "true";
}
}
return(result);
}
public string AddEvent(Event evnt)
{
using (var context = new NCContext.NCContext())
{
if (evnt != null)
{
context.Events.Add(evnt);
context.SaveChanges();
return("true");
}
else
{
return("All Fields are Required");
}
}
}
public ActionResult BlogPosts()
{
List <Post> posts = new List <Post>();
using (var context = new NCContext.NCContext())
{
var psts = context.Posts.Include(x => x.Student).Include(x => x.EventCategory).ToList();
foreach (var post in psts)
{
post.EventCategory = context.EventCategories.Where(x => x.Id == post.EventCategoryId).FirstOrDefault();
post.Student = context.Students.Where(x => x.Id == post.StudentId).FirstOrDefault();
posts.Add(post);
}
}
return(View(posts));
}
public string EditEvent(Event evnt)
{
if (evnt != null)
{
using (var context = new NCContext.NCContext())
{
context.Entry(evnt).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
return("true");
}
}
else
{
return("Internal Server Error");
}
}
