public static Chat CreateChat(int UserOneID, int UserTwoID) { chat chat = new chat(); using (var context = new HotSaleDBEntities()) { chat.user1 = context.users.ToList().SingleOrDefault(x => x.ID == UserOneID); chat.user2 = context.users.ToList().SingleOrDefault(x => x.ID == UserTwoID); context.chats.Add(chat); context.SaveChanges(); context.users.ToList().SingleOrDefault(x => x.ID == UserOneID).chats.Add(chat); context.users.ToList().SingleOrDefault(x => x.ID == UserTwoID).chats.Add(chat); context.SaveChanges(); } Chat Chat = new Chat(); Chat.ID = chat.ID; Chat.UserFirst = new User(); Chat.UserFirst.ID = chat.user1.ID; Chat.UserFirst.Name = chat.user1.Name; Chat.UserFirst.Surname = chat.user1.Surname; Chat.UserFirst.Avatar = chat.user1.Avatar; Chat.UserSecond = new User(); Chat.UserSecond.ID = chat.user2.ID; Chat.UserSecond.Name = chat.user2.Name; Chat.UserSecond.Surname = chat.user2.Surname; Chat.UserSecond.Avatar = chat.user2.Avatar; Chat.Messages = new List<Messages>(); return Chat; }
public static Messages AddMessage(int ChatID, string Sender, string Message) { message mssg = new message(); using (var context = new HotSaleDBEntities()) { mssg.Message1 = Message; mssg.Sender = Sender; mssg.chat = context.chats.ToList().SingleOrDefault(x => x.ID == ChatID); mssg.Chat_ID = ChatID; context.messages.Add(mssg); context.SaveChanges(); context.chats.ToList().SingleOrDefault(x => x.ID == ChatID).messages.Add(mssg); context.SaveChanges(); } return new Messages() { ID = mssg.ID, Sender = Sender, Message = Message }; }
public static IList<Chat> GetChats(List<int> ChatIDs) { IList<Chat> Chats = new List<Chat>(); using (var context = new HotSaleDBEntities()) { context.chats.ToList().ForEach(chat => { ChatIDs.ForEach(id => { if(chat.ID == id) { Chat Chat = new Chat(); Chat.ID = id; Chat.UserFirst = new User(); Chat.UserFirst.ID = chat.user1.ID; Chat.UserFirst.Name = chat.user1.Name; Chat.UserFirst.Surname = chat.user1.Surname; Chat.UserFirst.Avatar = chat.user1.Avatar; Chat.UserSecond = new User(); Chat.UserSecond.ID = chat.user2.ID; Chat.UserSecond.Name = chat.user2.Name; Chat.UserSecond.Surname = chat.user2.Surname; Chat.UserSecond.Avatar = chat.user2.Avatar; chat.messages.ToList().ForEach(mssg => { Messages Mssg = new Messages(); Mssg.ID = mssg.ID; Mssg.Message = mssg.Message1; Mssg.Sender = mssg.Sender; Chat.Messages.Add(Mssg); }); Chats.Add(Chat); } }); }); } return Chats; }
public static user Testing() { user user = new user(); user.Email = "test"; user.Password = "******"; user.Name = "test"; user.Surname = "test"; user.watchlist = ""; using (var context = new HotSaleDBEntities()) { context.users.Add(user); context.SaveChanges(); } user User; using (var context = new HotSaleDBEntities()) { User = context.users.ToList().SingleOrDefault(x => x.Email == user.Email); } return User; }
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; }
public static IList<Item> GetItems() { IList<Item> Items = new List<Item>(); using (var context = new HotSaleDBEntities()) { context.items.ToList().ForEach(item => { Item Item = new Item(); Item.ID = item.ID; Item.Class = item.Class; Item.SubClass = item.SubClass; Item.Price = item.Price; Item.Photo = item.Photo; Item.Params = item.Params; Items.Add(Item); }); } return Items; }
public static void DeleteItem(int UsrId,int ItmID) { using (var context = new HotSaleDBEntities()) { context.items.Load(); context.items.Remove(context.items.ToList().SingleOrDefault(x => x.ID == ItmID)); context.SaveChanges(); context.users.Load(); context.users.ToList().SingleOrDefault(x => x.ID == UsrId).items.ToList().ForEach(item => { if(item.ID == ItmID) { context.users.ToList().SingleOrDefault(x => x.ID == UsrId).items.ToList().Remove(context.users.ToList().SingleOrDefault(x => x.ID == UsrId).items.SingleOrDefault(x => x.ID == ItmID)); } }); context.SaveChanges(); } }
public static Item AddItem(int UsrID ,Item Item) { item item = new item(); item.Class = Item.Class; item.SubClass = Item.SubClass; item.Photo = Item.Photo; item.Price = Item.Price; item.Params = Item.Params; item.User_ID = UsrID; using (var context = new HotSaleDBEntities()) { item.user = context.users.ToList().SingleOrDefault(x => x.ID == UsrID); context.items.Add(item); context.SaveChanges(); context.users.ToList().SingleOrDefault(x => x.ID == UsrID).items.Add(item); context.SaveChanges(); Item.ID = item.ID; } return Item; }