public ActionResult edit(FullProfile fullprofile) { using (MsInUsEntities connection = new MsInUsEntities()) { if (Session["UserName"] != null) { int id = Convert.ToInt32(Session["UserId"]); FullProfile fp = connection.FullProfiles.Where(m => m.Id == id).FirstOrDefault(); connection.FullProfiles.Remove(fp); connection.SaveChanges(); if (fullprofile.Toefl == false) { fullprofile.Ielts = true; } if (fullprofile.Toefl == null) { fullprofile.Toefl = false; fullprofile.Ielts = false; } fullprofile.personalScore = getscore(fullprofile); connection.FullProfiles.Add(fullprofile); connection.SaveChanges(); } } return(RedirectToAction("MyProfile", "Profiles")); }
public JsonResult searchCourses(string term, int?univid) { MsInUsEntities connection = new MsInUsEntities(); List <string> jsresult = connection.University_Deadlines.Where(m => (m.Univ_Id == univid && m.Course.ToLower().Contains(term.ToLower()))).Select(m => m.Course).Distinct().ToList(); return(Json(jsresult, JsonRequestBehavior.AllowGet)); }
public void initilization(FullProfile fullprofile) { using (MsInUsEntities dtbase = new MsInUsEntities()) { List <SelectListItem> items = new List <SelectListItem>(); foreach (var c in dtbase.CourseWorks) { items.Add(new SelectListItem() { Value = c.Course, Text = c.Course }); } fullprofile.itemslist = items; List <SelectListItem> day = new List <SelectListItem>(); for (int i = 1; i <= 31; i++) { day.Add(new SelectListItem() { Text = Convert.ToString(i), Value = Convert.ToString(i), Selected = (DateTime.Today.Day == i) }); } fullprofile.listday = day; List <SelectListItem> year = new List <SelectListItem>(); for (int p = DateTime.Today.Year - 2; p < DateTime.Today.Year + 6; p++) { year.Add(new SelectListItem() { Text = Convert.ToString(p), Value = Convert.ToString(p), Selected = (DateTime.Today.Year == p) }); } fullprofile.listyear = year; List <SelectListItem> month = new List <SelectListItem>(); foreach (var c in System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.MonthGenitiveNames) { month.Add(new SelectListItem() { Text = c, Value = c, Selected = (System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(DateTime.Today.Month) == c) }); } fullprofile.listMonth = month; List <SelectListItem> papersList = new List <SelectListItem>(); for (int i = 0; i < papers.Length; i++) { papersList.Add(new SelectListItem() { Text = papers[i], Value = papers[i] }); } fullprofile.listpapers = papersList; List <SelectListItem> termlist = new List <SelectListItem>(); for (int i = 0; i < term.Length; i++) { termlist.Add(new SelectListItem() { Text = term[i], Value = term[i] }); } fullprofile.listterm = termlist; } }
public ActionResult add(FullProfile fullprofile) { using (MsInUsEntities connection = new MsInUsEntities()) { try { if (Session["UserName"] != null) { fullprofile.Id = Convert.ToInt32(Session["UserId"]); if (fullprofile.Toefl == false) { fullprofile.Ielts = true; } else if (fullprofile.Toefl == null) { fullprofile.Toefl = false; } fullprofile.Ielts = false; fullprofile.personalScore = getscore(fullprofile); connection.FullProfiles.Add(fullprofile); connection.SaveChanges(); Session.Remove("AddProfile"); } } catch (System.Data.Entity.Validation.DbEntityValidationException e) { string msg = e.InnerException.Message; } } return(RedirectToAction("Index", "Home")); }
public ActionResult settings() { MsInUsEntities connection = new MsInUsEntities(); List <SelectListItem> year = new List <SelectListItem>(); for (int p = DateTime.Today.Year - 40; p < DateTime.Today.Year - 16; p++) { year.Add(new SelectListItem() { Text = Convert.ToString(p), Value = Convert.ToString(p), Selected = (DateTime.Today.Year - 14 == p) }); } UserProfile userprofile = new UserProfile(); FullProfile fullprofile = new FullProfile(); ProfilesController pc = new ProfilesController(); int id = Convert.ToInt32(Session["UserId"]); userprofile = connection.UserProfiles.Find(keyValues: id); if (userprofile.DOB != null) { userprofile.DOBMonth = System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(userprofile.DOB.Value.Month); userprofile.DOBYear = userprofile.DOB.Value.Year; userprofile.DOBday = userprofile.DOB.Value.Day; } pc.initilization(fullprofile); userprofile.FullProfile = fullprofile; userprofile.doBirthYear = year; return(View(userprofile)); }
public ActionResult changepassword(UserProfile userprofile) { try { MsInUsEntities connection = new MsInUsEntities(); int id = Convert.ToInt32(Session["UserId"]); UserProfile usobj = connection.UserProfiles.SingleOrDefault(m => m.Id == id); usobj.Password = MyEncryption.EncodePasswordToBase64(userprofile.Password); usobj.ConfirmPassword = MyEncryption.EncodePasswordToBase64(userprofile.ConfirmPassword); usobj.Email_IdRegister = usobj.Email_Id; connection.SaveChanges(); TempData["ConfirmationMessage"] = "Password Changed Successfully!"; } catch (System.Data.Entity.Validation.DbEntityValidationException e) { StreamWriter sw = new StreamWriter(@"D:\MasterStudy\MsInUsa\MsInUsa\Log\logs.txt", true); foreach (var c in e.EntityValidationErrors) { foreach (var ex in c.ValidationErrors) { sw.WriteLine(ex.ErrorMessage); } } sw.Close(); return(RedirectToAction("NotFound", "Error")); } return(RedirectToAction("changepassword", "Account")); }
public ActionResult settings(UserProfile userprofile) { try { if (userprofile != null) { string dateobj = userprofile.DOBMonth + "/" + userprofile.DOBday + "/" + userprofile.DOBYear; userprofile.DOB = DateTime.Parse(dateobj); using (MsInUsEntities connection = new MsInUsEntities()) { var userprofileobj = connection.UserProfiles.Find(userprofile.Id); userprofileobj.Email_IdRegister = userprofile.Email_Id; userprofileobj.ConfirmPassword = userprofile.Password; connection.Entry(userprofileobj).CurrentValues.SetValues(userprofile); connection.SaveChanges(); return(RedirectToAction("Myprofile", "Profiles")); } } } catch (System.Data.Entity.Validation.DbEntityValidationException e) { StreamWriter sw = new StreamWriter(@"D:\MasterStudy\MsInUsa\MsInUsa\Log\logs.txt", true); foreach (var c in e.EntityValidationErrors) { foreach (var ex in c.ValidationErrors) { sw.WriteLine(ex.ErrorMessage); } } sw.Close(); return(RedirectToAction("NotFound", "Error")); } return(View()); }
public JsonResult searchUniversities(string term) { MsInUsEntities connection = new MsInUsEntities(); //List<string> jsresult = connection.Universities_list.Where(m => (m.UnivName.ToLower().StartsWith(term.ToLower()) || m.NickName.ToLower().Contains(term.ToLower()))).Select(m => m.UnivName).ToList(); Dictionary <string, string> jsresult = connection.Universities_list.Where(m => m.UnivName.ToLower().Contains(term.ToLower())).ToDictionary(m => Convert.ToString(m.UnivId), m => m.UnivName); return(Json(jsresult, JsonRequestBehavior.AllowGet)); }
public ActionResult reviews(int?id) { if (id == null) { return(RedirectToAction("Index", "Universities")); } using (MsInUsEntities connection = new MsInUsEntities()) { Universities_list universities_list = connection.Universities_list.SingleOrDefault(m => m.UnivId == id); universities_list.universitycourses = connection.University_Deadlines.Where(m => m.Univ_Id == id).Select(m => m.Course).Distinct().ToList(); return(View(universities_list)); } }
public ActionResult compare(string universities, int?page) { if (universities != "") { ViewBag.sortparamUniv = universities; string[] univ = universities.Split(',').ToArray(); using (MsInUsEntities connection = new MsInUsEntities()){ IPagedList <Universities_list> universitylist = connection.Universities_list.Where(m => univ.Any(y => y == m.UnivId.ToString())).ToList().ToPagedList(page ?? 1, 5); // universities(m.UnivId.ToString())).ToList().ToPagedList(page ?? 1, 5); return(View(universitylist)); } } return(RedirectToAction("CompareUniversities", "Universities")); }
public ActionResult Myprofile() { MsInUsEntities dtbase = new MsInUsEntities(); FullProfile fullprofiles = new FullProfile(); ///initilization(fullprofiles); int id = Convert.ToInt32(Session["UserId"]); fullprofiles = dtbase.FullProfiles.FirstOrDefault(m => m.Id == id); if (dtbase.AdmitsRejects.Any(m => m.StudentId == id)) { fullprofiles.admitrejects = dtbase.AdmitsRejects.Where(m => m.StudentId == id).ToList(); } return(View(fullprofiles)); }
public ActionResult UniversitiesDeadlines(int?page, string sortby) { MsInUsEntities ms = new MsInUsEntities(); ViewBag.sortUniv = String.IsNullOrEmpty(sortby) ? "Univdesc" : ""; ViewBag.sortCourse = sortby == "Course" ? "Coursedesc" : "Course"; ViewBag.sortTerm = sortby == "Term" ? "Termdesc" : "Term"; ViewBag.sortDeadline = sortby == "Deadline" ? "Deadlinedesc" : "Deadline"; IEnumerable <University_Deadlines> univ = ms.University_Deadlines.Where(m => m.Deadline != null).ToList(); switch (sortby) { case "Univdesc": univ = univ.OrderByDescending(m => m.Universities_list.UnivName); break; case "Coursedesc": univ = univ.OrderByDescending(m => m.Course); break; case "Course": univ = univ.OrderBy(m => m.Course); break; case "Termdesc": univ = univ.OrderByDescending(m => m.Term); break; case "Term": univ = univ.OrderBy(m => m.Term); break; case "Deadline": univ = univ.OrderBy(m => m.Deadline); break; case "Deadlinedesc": univ = univ.OrderByDescending(m => m.Deadline); break; default: univ = univ.OrderBy(m => m.Universities_list.UnivName); break; } return(View(univ.ToPagedList(page ?? 1, 10))); }
public ActionResult Register(UserProfile userprofile) { if (userprofile != null) { using (MsInUsEntities msInUsConnection = new MsInUsEntities()) { int rowcount = msInUsConnection.UserProfiles.Count(); userprofile.Password = MyEncryption.EncodePasswordToBase64(userprofile.Password); userprofile.ConfirmPassword = MyEncryption.EncodePasswordToBase64(userprofile.ConfirmPassword); userprofile.Email_Id = userprofile.Email_IdRegister; msInUsConnection.UserProfiles.Add(userprofile); msInUsConnection.SaveChanges(); TempData["ConfirmationMessage"] = "Registered Successfully"; //Session.Add("Registration Message", "Registered Successfully"); if (rowcount < msInUsConnection.UserProfiles.Count()) { return(RedirectToAction("LogIn", "Account")); } } } return(RedirectToAction("NotFound", "Error")); }
public ActionResult LogIn(UserProfile userprofile) { //connects and checks with the user credentials using (MsInUsEntities msInUsConnection = new MsInUsEntities()) { if (!msInUsConnection.UserProfiles.Any(m => m.Email_Id == userprofile.Email_Id)) { TempData["ErrorLogin"] = "******"; return(RedirectToAction("LogIn", "Account")); } string userpassword = msInUsConnection.UserProfiles.First(m => m.Email_Id == userprofile.Email_Id).Password; if (userpassword != null && userprofile.Password == MyEncryption.DecodeFrom64(userpassword)) { removeUserSession(); Session.Add("UserName", msInUsConnection.UserProfiles.First(m => m.Email_Id == userprofile.Email_Id).FirstName); Session.Add("UserId", msInUsConnection.UserProfiles.First(m => m.Email_Id == userprofile.Email_Id).Id); return(RedirectToAction("Index", "Home")); } } TempData["ErrorLogin"] = "******"; return(RedirectToAction("LogIn", "Account")); }
public ActionResult Index(int?page, string sortby) { using (MsInUsEntities connection = new MsInUsEntities()){ ViewBag.sortUniv = String.IsNullOrEmpty(sortby) ? "Univdesc" : ""; ViewBag.sortRank = sortby == "Rank" ? "Rankdesc" : "Rank"; ViewBag.sortType = sortby == "Type" ? "Typedesc" : "Type"; List <Universities_list> universities_list = connection.Universities_list.OrderBy(m => m.UnivName).ToList(); ViewBag.count = universities_list.Count; switch (sortby) { case "Univdesc": universities_list = universities_list.OrderByDescending(m => m.UnivName).ToList(); break; case "Rank": universities_list = universities_list.OrderBy(m => m.Rank).ToList(); break; case "Rankdesc": universities_list = universities_list.OrderByDescending(m => m.Rank).ToList(); break; case "Type": universities_list = universities_list.OrderBy(m => m.UnivType).ToList(); break; case "Typedesc": universities_list = universities_list.OrderByDescending(m => m.UnivType).ToList(); break; default: break; } return(View(universities_list.ToPagedList(page ?? 1, 10))); } }
//Checks whether user is availble when registering public JsonResult isUserAvailable(string Email_IdRegister) { MsInUsEntities connection = new MsInUsEntities(); return(Json(!connection.UserProfiles.Any(m => m.Email_Id == Email_IdRegister), JsonRequestBehavior.AllowGet)); }