public List <IProfileTypeDto> GetAllProfileTypes() { List <IProfileTypeDto> profileTypes = new List <IProfileTypeDto>(); SqlConnection conn = webShopContext.GetConnection(); try { conn.Open(); string sql = "SELECT profile_type_id, profile_type_name FROM profiletype;"; SqlCommand cmd = new SqlCommand(sql, conn); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { profileTypes.Add( new ProfileTypeDto() { ProfileTypeID = rdr.GetInt32(0), ProfileTypeName = rdr.GetString(1), } ); } rdr.Close(); } catch (Exception e) { throw e; } conn.Close(); return(profileTypes); }
public List <ICategoryDto> GetAllCategories() { List <ICategoryDto> categories = new List <ICategoryDto>(); SqlConnection conn = webShopContext.GetConnection(); try { conn.Open(); string sql = "SELECT category_id, category_name FROM category;"; SqlCommand cmd = new SqlCommand(sql, conn); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { categories.Add( new CategoryDto() { CategoryId = rdr.GetInt32(0), CategoryName = rdr.GetString(1), } ); } rdr.Close(); } catch (Exception e) { throw e; } conn.Close(); return(categories); }
public IShoppingCartDto GetShoppingCartById(int id) { SqlConnection conn = webShopContext.GetConnection(); IShoppingCartDto shoppingCart = null; try { conn.Open(); string sql = "SELECT profile_id, product_id, amount FROM shoppingcart WHERE profile_id = @id;"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@id", id); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { shoppingCart = new ShoppingCartDto() { ProfileID = rdr.GetInt32(0), ProductID = rdr.GetInt32(1), Amount = rdr.GetInt32(2), }; } rdr.Close(); } catch (Exception e) { throw e; } conn.Close(); return(shoppingCart); }
public IProfileDto GetProfileById(int id) { SqlConnection conn = webShopContext.GetConnection(); IProfileDto profile = null; try { conn.Open(); string sql = "SELECT profile_id, email, first_name, insertion, last_name, zipcode, house_number, " + "house_number_addition, password, profile_type_id FROM profile WHERE profile_id = @id;"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@id", id); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { profile = new ProfileDto() { ID = rdr.GetInt32(0), Email = rdr.GetString(1), FirstName = rdr.GetString(2), Insertion = rdr.GetString(3), LastName = rdr.GetString(4), ZipCode = rdr.GetString(5), HouseNumber = rdr.GetInt32(6), HouseNumberAddition = rdr.GetString(7), Password = rdr.GetString(8), ProfileTypeID = rdr.GetInt32(9), }; } rdr.Close(); } catch (Exception e) { throw e; } conn.Close(); return(profile); }
public List <IProductDto> GetAllProducts() { List <IProductDto> products = new List <IProductDto>(); SqlConnection conn = webShopContext.GetConnection(); try { conn.Open(); string sql = "SELECT id, name, description, price, image_path, category_id FROM product;"; SqlCommand cmd = new SqlCommand(sql, conn); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { products.Add( new ProductDto() { ProductID = rdr.GetInt32(0), Name = rdr.GetString(1), Description = rdr.GetString(2), Price = rdr.GetDecimal(3), ImagePath = !rdr.IsDBNull(4) ? rdr.GetString(4) : null, CategoryID = rdr.GetInt32(5), } ); } rdr.Close(); } catch (Exception e) { throw e; } conn.Close(); return(products); }