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