public List<Drinks> GetAllDrinksType(string type) { List<Drinks> aDrinksList = new List<Drinks>(); SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT * FROM DrinksTBL WHERE Type='"+type+"'"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Drinks aDrinks = new Drinks(); aDrinks.Id = int.Parse(reader["Id"].ToString()); aDrinks.Type = reader["Type"].ToString(); aDrinks.Name = reader["Name"].ToString(); aDrinks.Origin = reader["OriginCountry"].ToString(); aDrinks.Price = decimal.Parse(reader["Price"].ToString()); aDrinks.Quantity = reader["Quantity"].ToString(); aDrinks.Review = reader["Review"].ToString(); aDrinks.Image = reader["Image"].ToString(); aDrinksList.Add(aDrinks); } reader.Close(); connection.Close(); return aDrinksList; }
protected void saveButton_Click(object sender, EventArgs e) { try { Drinks newDrinks = new Drinks(); newDrinks.Name = nameTextBox.Text; newDrinks.Type = typeTextBox.Text; newDrinks.Flavors = flavorTextBox.Text; newDrinks.Price = decimal.Parse(priceTextBox.Text); newDrinks.Origin = countryTextBox.Text; newDrinks.Quantity = weightTextBox.Text; newDrinks.Review = reviewTextBox.Text; newDrinks.Image = "../Images/DrinksImages/" + imageDropDownList.SelectedValue; outPutLabel.Text = aDrinksGateway.SaveDrinks(newDrinks); ClearAllTextBox(); resultLabel.Text = ""; } catch (Exception) { outPutLabel.Text = "Save Faild!"; } }
public Drinks GetDrinksById(int id) { Drinks aDrinks = new Drinks(); SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT * FROM DrinksTBL WHERE Id='"+id+"'"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { aDrinks.Id = int.Parse(reader["Id"].ToString()); aDrinks.Type = reader["Type"].ToString(); aDrinks.Name = reader["Name"].ToString(); aDrinks.Origin = reader["OriginCountry"].ToString(); aDrinks.Price = decimal.Parse(reader["Price"].ToString()); aDrinks.Quantity = reader["Quantity"].ToString(); aDrinks.Review = reader["Review"].ToString(); aDrinks.Image = reader["Image"].ToString(); } reader.Close(); connection.Close(); return aDrinks; }
public string SaveDrinks(Drinks aDrinks) { SqlConnection connection = new SqlConnection(connectionString); string query = "INSERT INTO DrinksTBL VALUES('" + aDrinks.Name + "','" + aDrinks.Type + "','" + aDrinks.Flavors + "','" + aDrinks.Price + "','" + aDrinks.Origin + "','" + aDrinks.Quantity + "','" + aDrinks.Review + "','" + aDrinks.Image + "')"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); int rowAffected = command.ExecuteNonQuery(); connection.Close(); if (rowAffected > 0) { return "Saved Successful!"; } else { return "Save Faild!"; } }