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