public ActionResult OnGet(string id, string query) { this.Breadcrumb = new LinkedList <Tuple <string, string> >(); Breadcrumb.AddLast(Tuple.Create("Home", "/home")); if (!string.IsNullOrEmpty(query)) { Breadcrumb.AddLast(Tuple.Create <string, string>("Search", "/search?query=" + query)); } string userEmail = this.HttpContext.User.Identity.Name; if (string.IsNullOrEmpty(userEmail)) { return(Redirect("~/login")); } this.CurrentUser = context.Set <Models.User>().Where(entry => entry.Email.Equals(userEmail)).FirstOrDefault(); if (this.CurrentUser == null) { return(Redirect("~/login")); } else { context.Entry(this.CurrentUser).Collection(u => u.Favorites).Load(); context.Entry(this.CurrentUser).Collection(u => u.CertDetails).Load(); context.Entry(this.CurrentUser).Collection(u => u.EducationDetails).Load(); context.Entry(this.CurrentUser).Collection(u => u.ProjectDetails).Load(); context.Entry(this.CurrentUser).Collection(u => u.SkillDetails).Load(); context.Entry(this.CurrentUser).Collection(u => u.WorkDetails).Load(); this.Template = context.Set <Template>().Where(t => t.ID.Equals(new Guid(id))).FirstOrDefault(); Breadcrumb.AddLast(Tuple.Create <string, string>(this.Template.Title, null)); return(Page()); } }
public virtual void Delete(T entity) { using (var context = new Models.AppContext()) { if (context.Entry(entity).State == EntityState.Detached) { context.Set <T>().Attach(entity); } context.Set <T>().Remove(entity); context.SaveChanges(); } }
public List <Email> GetEmails(Contact contact, Models.AppContext context) { try { List <Email> emails = new List <Email>(); if (Emails != null) { foreach (Email email in Emails) { var entityEmail = context.Set <Email>().FirstOrDefault(e => e.ID == email.ID); if (entityEmail == null) { emails.Add(new Email() { EmailName = email.EmailName, Contact = contact }); } } } return(emails); } catch (Exception e) { throw; } }
public List <PhoneNumber> GetPhoneNumbers(Contact contact, Models.AppContext context) { try { List <PhoneNumber> phoneNumbers = new List <PhoneNumber>(); if (PhoneNumbers != null) { foreach (PhoneNumber phoneNumber in PhoneNumbers) { var entityPhoneNumber = context.Set <PhoneNumber>().FirstOrDefault(e => e.ID == phoneNumber.ID); if (entityPhoneNumber == null) { phoneNumbers.Add(new PhoneNumber() { Number = phoneNumber.Number, Contact = contact }); } } } return(phoneNumbers); } catch (Exception) { throw; } }
public IActionResult OnGet(string id) { string userEmail = this.HttpContext.User.Identity.Name; if (string.IsNullOrEmpty(userEmail)) { return(Redirect("~/login")); } else { this.CurrentUser = context.Set <Models.User>().Where(entry => entry.Email.Equals(userEmail)).FirstOrDefault(); context.Entry(this.CurrentUser).Collection(u => u.Templates).Load(); Template template = this.context.Set <Template>().Where(temp => temp.ID.Equals(new Guid(id))).FirstOrDefault(); if (template == null || !this.CurrentUser.Templates.Any(t => t.ID.Equals(template.ID))) { return(Redirect("/templates")); } this.Template = template; Breadcrumb.AddLast(Tuple.Create <string, string>(template.Title, null)); } return(Page()); }
public virtual void Create(T entity) { using (var context = new Models.AppContext()) { context.Set <T>().Add(entity); context.SaveChanges(); } }
public virtual List <T> GetWhere(Expression <Func <T, bool> > expression) //zeby mzona bylo uzyc lambdy { using (var context = new Models.AppContext()) { var query = context.Set <T>().Where(expression); return(query.ToList()); } }
public ActionResult OnGet() { this.Breadcrumb = new LinkedList <Tuple <string, string> >(); Breadcrumb.AddLast(Tuple.Create <string, string>("Home", null)); string userEmail = this.HttpContext.User.Identity.Name; if (string.IsNullOrEmpty(userEmail)) { return(Redirect("~/login")); } else { this.CurrentUser = _context.Set <Models.User>().Where(entry => entry.Email.Equals(userEmail)).FirstOrDefault(); return(Page()); } }
public void RemovePhoneNumbers(Models.AppContext context) { try { if (PhoneNumberRemoveIds != null) { foreach (var id in PhoneNumberRemoveIds) { var phoneNumber = context.Set <PhoneNumber>().FirstOrDefault(e => e.ID == id); context.Set <PhoneNumber>().Remove(phoneNumber); } } } catch (Exception e) { throw; } }
public void RemoveEmails(Models.AppContext context) { try { if (EmailRemoveIds != null) { foreach (var id in EmailRemoveIds) { var email = context.Set <Email>().FirstOrDefault(e => e.ID == id); context.Set <Email>().Remove(email); } } } catch (Exception e) { throw; } }
public ActionResult OnGet() { this.Breadcrumb = new LinkedList <Tuple <string, string> >(); Breadcrumb.AddLast(Tuple.Create <string, string>("Home", "/home")); Breadcrumb.AddLast(Tuple.Create <string, string>("Favourites", null)); // TODO can this email be spoofed? string userEmail = this.HttpContext.User.Identity.Name; if (string.IsNullOrEmpty(userEmail)) { return(Redirect("~/login")); } else { this.CurrentUser = _context.Set <User>().Where(entry => entry.Email.Equals(userEmail)).FirstOrDefault(); _context.Entry(this.CurrentUser).Collection(u => u.Favorites).Load(); return(Page()); } }
public ActionResult OnGet() { this.Success = string.Empty; this.Error = string.Empty; string userEmail = this.HttpContext.User.Identity.Name; if (string.IsNullOrEmpty(userEmail)) { return(Redirect("~/login")); } this.CurrentUser = context.Set <Models.User>().Where(entry => entry.Email.Equals(userEmail)).FirstOrDefault(); if (this.CurrentUser == null) { return(Redirect("~/login")); } else { context.Entry(this.CurrentUser).Collection(u => u.UserInfo).Load(); return(Page()); } }
public ActionResult OnGet(string query) { this.Breadcrumb = new LinkedList <Tuple <string, string> >(); Breadcrumb.AddLast(Tuple.Create("Home", "/home")); Breadcrumb.AddLast(Tuple.Create <string, string>("Search", null)); string userEmail = this.HttpContext.User.Identity.Name; if (string.IsNullOrEmpty(userEmail)) { return(Redirect("~/login")); } this.CurrentUser = context.Set <User>().Where(entry => entry.Email.Equals(userEmail)).FirstOrDefault(); if (this.CurrentUser == null) { return(Redirect("~/login")); } else { string[] keys = (string.IsNullOrEmpty(query) ? new string[0] : query.Split(" ")); List <KeyValuePair <int, Template> > rank = new List <KeyValuePair <int, Template> >(); foreach (Template t in context.Set <Template>()) { rank.Add(new KeyValuePair <int, Template>(keys.Sum( key => (t.Keywords.ToLower().Contains(key.ToLower()) ? 1 : 0) + (t.Description.ToLower().Contains(key.ToLower()) ? 1 : 0) + (t.Title.ToLower().Contains(key.ToLower()) ? 1 : 0)), t)); } rank.Sort((x, y) => y.Key.CompareTo(x.Key)); this.Templates = rank.Where(l => l.Key > 0).Select(l => l.Value).ToList(); return(Page()); } }
public IActionResult GetContacts() { if (!ModelState.IsValid) { return(BadRequest(ModelState.Values.SelectMany(e => e.Errors))); } var contacts = _context.Set <Contact>() .Include(e => e.Emails) .Include(e => e.PhoneNumbers) .ToList(); return(Json(contacts)); }
public async Task <IActionResult> OnGet(string email, string guid) { if (!string.IsNullOrEmpty(HttpContext.User.Identity.Name)) { return(Redirect("/Home")); } Models.User user = _context.Set <Models.User>().Where(entry => entry.Email.Equals(email)).FirstOrDefault(); if (user != null && user.VerifyString.Equals(new Guid(guid))) { user.Verified = true; _context.Update(user); await _context.SaveChangesAsync(); return(RedirectToPage("/user/login")); } else { // TODO make bad page return(RedirectToPage("")); } }
public void Create(T entity) { context.Set <T>().Add(entity); context.SaveChanges(); }
public async Task CreateAsync(T entity) { await Context.Set <T>().AddAsync(entity); await Context.SaveChangesAsync(); }
private Models.User GetUser(string userEmail) { return(_context.Set <User>().Where(entry => entry.Email.Equals(userEmail)).First()); }