public void Add(UserRatingList value)
{
using (var connection = new SqlConnection(_connectionString))
{
var cmd = connection.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "AddStoreRating";
cmd.Parameters.AddWithValue(@"ID_User", value.IDUser);
cmd.Parameters.AddWithValue(@"ID_Store", value.IDStore);
cmd.Parameters.AddWithValue(@"Assortment_Rating", value.AssortmentRating);
cmd.Parameters.AddWithValue(@"Price_Level_Rating", value.PriceLevelRating);
cmd.Parameters.AddWithValue(@"Service_Rating", value.ServiceRating);
connection.Open();
cmd.ExecuteNonQuery();
}
}
public UserRatingList GetByID(int userID, int storeID)
{
UserRatingList rating = new UserRatingList();
using (var connection = new SqlConnection(_connectionString))
{
var cmd = connection.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SelectStoreRating";
cmd.Parameters.AddWithValue(@"ID_User", userID);
cmd.Parameters.AddWithValue(@"ID_Store", storeID);
connection.Open();
var reader = cmd.ExecuteReader();
while (reader.Read())
{
rating.IDUser = (int)reader["ID_User"];
rating.IDStore = (int)reader["ID_Store"];
rating.AssortmentRating = (int)reader["Assortment_Rating"];
rating.PriceLevelRating = (int)reader["Price_Level_Rating"];
rating.ServiceRating = (int)reader["Service_Rating"];
}
}
return(rating);
}
public void Add(UserRatingList value)
{
userRatingListDAL.Add(value);
}
