public static User ModifyUser(User User) { bool check = true; using (var context = new HotSaleDBEntities()) { if (context.users.ToList().SingleOrDefault(x => x.Email == User.Email) != null) { var user = context.users.ToList().SingleOrDefault(x => x.ID == User.ID); user.Name = User.Name; user.Surname = User.Surname; user.Avatar = User.Avatar; user.watchlist = User.watchlist; context.SaveChanges(); check = false; } } if(check) { return new User(); } return User; }
public static User LoginUser(string Email, string Password) { User User = new User(); using (var context = new HotSaleDBEntities()) { var user = context.users.ToList().SingleOrDefault(x => x.Email == Email && x.Password == Password); if(user != null) { User.ID = user.ID; User.Email = user.Email; User.Password = user.Password; User.Name = user.Name; User.Surname = user.Surname; User.Avatar = user.Avatar; User.watchlist = user.watchlist; User.ItemWatchlist = new List<int>(); user.items.ToList().ForEach(item => { User.ItemWatchlist.Add(item.ID); }); User.ChatIds = new List<int>(); user.chats.ToList().ForEach(chat => { User.ItemWatchlist.Add(chat.ID); }); } } return User; }
public static User DeleteItemToWatchlist(int ID, string ItemInJson) { User User = new User(); using (var context = new HotSaleDBEntities()) { var user = context.users.ToList().SingleOrDefault(x => x.ID == ID); int index = user.watchlist.IndexOf(ItemInJson); int length = ItemInJson.Length; String startOfString = user.watchlist.Substring(0, index); String endOfString = user.watchlist.Substring(index + length); user.watchlist = startOfString + endOfString; context.SaveChanges(); User.ID = user.ID; User.Email = user.Email; User.Password = user.Password; User.Name = user.Name; User.Surname = user.Surname; User.Avatar = user.Avatar; User.watchlist = user.watchlist; User.ItemWatchlist = new List<int>(); user.items.ToList().ForEach(item => { User.ItemWatchlist.Add(item.ID); }); User.ChatIds = new List<int>(); user.chats.ToList().ForEach(chat => { User.ItemWatchlist.Add(chat.ID); }); } return User; }
public static User CreateUser(User User) { user user = new user(); user.Email = User.Email; user.Password = User.Password; user.Name = User.Name; user.Surname = User.Surname; user.watchlist = ""; bool check = true; using (var context = new HotSaleDBEntities()) { if (context.users.ToList().SingleOrDefault(x => x.Email == User.Email) == null) { context.users.Add(user); context.SaveChanges(); check = false; } } if(check) { return new User(); } return User; }
public static IList<User> AllUsers() { IList<User> Users = new List<User>(); using (var context = new HotSaleDBEntities()) { context.users.ToList().ForEach(user => { User User = new User(); User.ID = user.ID; User.Email = user.Email; User.Password = user.Password; User.Name = user.Name; User.Surname = user.Surname; User.Avatar = user.Avatar; User.watchlist = user.watchlist; User.ItemWatchlist = new List<int>(); user.items.ToList().ForEach(item => { User.ItemWatchlist.Add(item.ID); }); User.ChatIds = new List<int>(); user.chats.ToList().ForEach(chat => { User.ItemWatchlist.Add(chat.ID); }); Users.Add(User); }); } return Users; }
public static User AddItemToWatchlist(int ID, string ItemInJson) { User User = new User(); using (var context = new HotSaleDBEntities()) { var user = context.users.ToList().SingleOrDefault(x => x.ID == ID); if (user.watchlist != "") { user.watchlist += ","; } user.watchlist += ItemInJson; context.SaveChanges(); User.ID = user.ID; User.Email = user.Email; User.Password = user.Password; User.Name = user.Name; User.Surname = user.Surname; User.Avatar = user.Avatar; User.watchlist = user.watchlist; User.ItemWatchlist = new List<int>(); user.items.ToList().ForEach(item => { User.ItemWatchlist.Add(item.ID); }); User.ChatIds = new List<int>(); user.chats.ToList().ForEach(chat => { User.ItemWatchlist.Add(chat.ID); }); } return User; }