public async Task <bool> SaveUser(UserItem userItem) { using (ciamContext db = new ciamContext()) { Users user = db.Users.Where (x => x.Id == userItem.Id).FirstOrDefault(); if (user == null) { user = new Users() { Email = userItem.Email, Password = userItem.Password, First_name = userItem.First_name, Last_name = userItem.Last_name, Token = userItem.Token }; db.Users.Add(user); } else { user.Email = userItem.Email; user.Password = userItem.Password; user.First_name = userItem.First_name; user.Last_name = userItem.Last_name; user.Token = userItem.Token; } return(await db.SaveChangesAsync() >= 1); } }
//check if email exist and is active //returns bool public async Task <bool> CheckUser(string Email) { using (ciamContext db = new ciamContext()) { return(null != db.Users.Where(x => x.Email == Email && x.Verified == true).FirstOrDefault()); } }
public async Task <bool> LoginUser(UserItem userItem) { using (ciamContext db = new ciamContext()) { return(null != db.Users.Where (x => x.Email == userItem.Email && x.Password == userItem.Password).FirstOrDefault()); } }
public async Task <bool> DeleteUser(int userId) { using (ciamContext db = new ciamContext()) { Users user = db.Users.Where(x => x.Id == userId).FirstOrDefault(); if (user != null) { db.Users.Remove(user); } return(await db.SaveChangesAsync() >= 1); } }
//check if email exist and is active //returns bool public async Task <bool> ConfirmMail(string token) { Console.WriteLine(token); using (ciamContext db = new ciamContext()) { //change use x.Token instead of -> x.Email (OBS need to put in token in database) Users user = db.Users.Where(x => x.Token == token).FirstOrDefault(); if (user != null) { user.Verified = true; } return(await db.SaveChangesAsync() >= 1); } }
public async Task <List <UserItem> > GetUsers() { using (ciamContext db = new ciamContext()) { return(await(from a in db.Users.AsNoTracking() select new UserItem { Id = a.Id, Email = a.Email, Password = a.Password, First_name = a.First_name, Last_name = a.Last_name, Token = a.Token, Verified = a.Verified }).ToListAsync()); } }