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());
}