public long FindUserId(string userName) { using (AspProjectEntities asp = new AspProjectEntities()) { long id = asp.Users.Where(u => u.UserName == userName).Select(u => u.UserID).SingleOrDefault(); return(id); } }
public void AddProduct(Product p) { using (var db = new AspProjectEntities()) { db.Products.Add(p); db.SaveChanges(); } }
public bool FindIfUserExist(string userName) { using (AspProjectEntities asp = new AspProjectEntities()) { foreach (var user in asp.Users) { if (user.UserName == userName) { return(false); } } return(true); } }
public void ChangeProductStateToBoughtGuest(long id) { using (AspProjectEntities asp = new AspProjectEntities()) { var p = asp.Products.Where(prod => prod.State == (int)state.cart && prod.ProductID == id).FirstOrDefault(); if (p != null) { p.OwnerID = null; p.State = (int)state.bought; asp.Entry(p).State = EntityState.Modified; asp.SaveChanges(); } } }
public void ChangeProductStateToAvailable() { using (AspProjectEntities asp = new AspProjectEntities()) { Product p = asp.Products.Where(prod => prod.State == (int)state.cart).SingleOrDefault(); if (p != null) { p.State = (int)state.upload; p.UserID = null; asp.Entry(p).State = EntityState.Modified; asp.SaveChanges(); } } }
public User FindUser(string userName, string password) { using (AspProjectEntities asp = new AspProjectEntities()) { foreach (User user in asp.Users) { if (user.UserName == userName && user.Password == password) { return(user); } } return(null); } }
public void ChangeProductStateToCart(long ID, long uID) { using (AspProjectEntities asp = new AspProjectEntities()) { Product p = asp.Products.Where(prod => prod.ProductID == ID && prod.State == (int)state.upload).FirstOrDefault(); if (p != null) { p.DateAddedToCart = DateTime.Now; p.UserID = uID; p.State = (int)state.cart; asp.Entry(p).State = EntityState.Modified; asp.SaveChanges(); } } }
public void ChangeProductStateAddedToCart() { var date = DateTime.Now.AddMinutes(-20); using (AspProjectEntities asp = new AspProjectEntities()) { var prod = asp.Products.Where(p => p.State == (int)state.cart && date > p.DateAddedToCart).ToList(); foreach (var p in prod) { p.UserID = null; p.State = (int)state.upload; asp.Entry(p).State = EntityState.Modified; asp.SaveChanges(); } } }
public UsersModel FindUserModelByUserName(string uName) { using (AspProjectEntities asp = new AspProjectEntities()) { UsersModel user = (from u in asp.Users where u.UserName == uName select new UsersModel { userName = u.UserName, password = u.Password, birthDate = u.BirthDate, email = u.Email, firstName = u.FirstName, lastName = u.LastName }).SingleOrDefault(); return(user); } }
public UsersModel FindUserModelByID(long ID) { using (AspProjectEntities asp = new AspProjectEntities()) { var u = (from use in asp.Users where use.UserID == ID select new UsersModel { firstName = use.FirstName, lastName = use.LastName, birthDate = use.BirthDate, email = use.Email, password = use.Password, userName = use.UserName }).SingleOrDefault(); return(u); } }
public void AddUser(UsersModel user) { User newUser = new User() { FirstName = user.firstName, LastName = user.lastName, BirthDate = user.birthDate, Email = user.email, UserName = user.userName, Password = user.password }; using (var db = new AspProjectEntities()) { db.Users.Add(newUser); db.SaveChanges(); } }
public void ChangeProductStateToBoughtUser(long uID) { using (AspProjectEntities asp = new AspProjectEntities()) { var p = asp.Products.Where(prod => prod.State == (int)state.cart && prod.UserID == uID).ToList(); foreach (var item in p) { if (item != null) { item.State = (int)state.bought; item.OwnerID = item.UserID; item.UserID = null; asp.Entry(item).State = EntityState.Modified; asp.SaveChanges(); } } } }
public List <ProductsModel> ProductsInCart(long uID) { using (AspProjectEntities asp = new AspProjectEntities()) { var products = (from p in asp.Products where p.State == (int)state.cart && p.UserID == uID select new ProductsModel { title = p.Title, price = p.Price, shortDescription = p.ShortDescription, longDescription = p.LongDescription, image1 = p.Picture1, image2 = p.Picture2, image3 = p.Picture3, date = p.Date, status = (state)p.State, ID = p.ProductID, userID = (long)p.UserID }).ToList(); return(products); } }
public IEnumerable <ProductsModel> SortByDate() { using (AspProjectEntities asp = new AspProjectEntities()) { var products = (from p in asp.Products orderby p.Date ascending where p.State == (int)state.upload select new ProductsModel { title = p.Title, price = (long)p.Price, shortDescription = p.ShortDescription, longDescription = p.LongDescription, image1 = p.Picture1, image2 = p.Picture2, image3 = p.Picture3, date = p.Date, status = (state)p.State, ID = p.ProductID }).ToList(); return(products); } }
public ProductsModel FindProductModelByID(long ID) { FindUserRepository find = new FindUserRepository(); using (AspProjectEntities asp = new AspProjectEntities()) { var product = (from p in asp.Products where p.ProductID == ID select new ProductsModel { title = p.Title, price = p.Price, shortDescription = p.ShortDescription, longDescription = p.LongDescription, date = p.Date, ownerID = (long)p.OwnerID, ID = p.ProductID, image1 = p.Picture1, image2 = p.Picture2, image3 = p.Picture3 }).SingleOrDefault(); return(product); } }