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 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 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 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 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 EditCategory(EventCategory eventCategory) { using (var context = new NCContext.NCContext()) { context.Entry(eventCategory).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); return("true"); } }
public string AddPromotion(Promotion promotion) { string result = ""; using (var context = new NCContext.NCContext()) { context.Promotions.Add(promotion); context.SaveChanges(); result = "true"; } return(result); }
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 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 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 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"); } }
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 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 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 ResetPassword(GetResetPasswordViewModel model) { if (!string.IsNullOrEmpty(model.NewPassword)) { using (var context = new NCContext.NCContext()) { var user = context.Students.Where(a => a.ResetPasswordCode == model.Resetpasswordcode).FirstOrDefault(); if (user != null) { var u = context.Users.Where(x => x.Email == user.Email).FirstOrDefault(); u.Password = model.NewPassword; user.Password = model.NewPassword; user.ResetPasswordCode = ""; context.SaveChanges(); return("true"); } } return("Something wrong happned"); } return("Something wrong happned"); }
public ActionResult Signup(Student student) { using (var context = new NCContext.NCContext()) { if (student != null) { if (!string.IsNullOrEmpty(student.Email) && !string.IsNullOrEmpty(student.Password) && !string.IsNullOrEmpty(student.FName) && !string.IsNullOrEmpty(student.LName)) { var isuser = context.Users.Where(x => x.Email == student.Email).FirstOrDefault(); if (isuser == null) { User user = new User(); user.Email = student.Email; user.Role = "student"; user.Password = student.Password; context.Students.Add(student); context.Users.Add(user); context.SaveChanges(); FormsAuthentication.SetAuthCookie(student.Email.ToLower(), true); return(RedirectToAction("Login", "Account")); } else { ViewBag.error = "exist"; return(View()); } } else { return(View()); } } else { return(View()); } } }
public string AddPost(Post post) { if (post != null) { using (var context = new NCContext.NCContext()) { var email = GlobalData.GetEmail(); if (!string.IsNullOrEmpty(email)) { var student = context.Students.Where(x => x.Email == email).FirstOrDefault(); if (student != null) { post.Date = DateTime.Now; post.StudentId = student.Id; context.Posts.Add(post); context.SaveChanges(); return("true"); } } } } return("Server Error"); }
public string DeleteCategory(int Id) { if (Id > 0) { using (var context = new NCContext.NCContext()) { var category = context.EventCategories.Where(x => x.Id == Id).FirstOrDefault(); if (category != null) { context.EventCategories.Remove(category); context.SaveChanges(); return("true"); } else { return("Internal Server Error"); } } } else { return("Internal Server Error"); } }
public ActionResult Subscribe(string Email, int EventId) { if (!(string.IsNullOrEmpty(Email)) && EventId > 0) { EventsSubscribers eventsSubscribers = new EventsSubscribers(); using (var context = new NCContext.NCContext()) { var student = context.Students.Where(x => x.Email == Email).FirstOrDefault(); if (student != null) { eventsSubscribers.StudentId = student.Id; eventsSubscribers.EventId = EventId; context.EventsSubscribers.Add(eventsSubscribers); context.SaveChanges(); var evet = context.Events.Where(x => x.Id == EventId).FirstOrDefault(); var subject = "Event Subscribed"; var body = "Hi, you have Successfuly subscribed the Event " + evet.Title; SendEmail(Email, body, subject); return(RedirectToAction("Events")); } } } return(RedirectToAction("Events")); }
public string DeleteEvent(int Id) { if (Id > 0) { using (var context = new NCContext.NCContext()) { var evnt = context.Events.Where(x => x.Id == Id).FirstOrDefault(); if (evnt != null) { context.Events.Remove(evnt); context.SaveChanges(); return("true"); } else { return("Internal Server Error"); } } } else { return("Internal Server Error"); } }