public void AddRatingToRecipe(Rating rate, Recipe r, User u)
{
SqlConnection con = CreateConnection();
try
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "AddRatingToRecipe";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@recipeID", r.Id);
cmd.Parameters.AddWithValue("@userID", u.Id);
cmd.Parameters.AddWithValue("@rating", rate);
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
throw /*ex*/;
}
finally
{
if (con != null)
{
con.Close();
}
}
}
public void Add(User u)
{
SqlConnection con = CreateConnection();
try
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "AddUser";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@username", u.UserName);
cmd.Parameters.AddWithValue("@password", u.Password);
cmd.ExecuteNonQuery();
}
catch(SqlException ex)
{
throw /*ex*/;
}
finally
{
if(con != null)
{
con.Close();
}
}
}
public void GetById()
{
SqlUserManager sqm = new SqlUserManager();
User u = new User();
int id = 9;
u = sqm.GetUserById(id);
Assert.AreEqual(id, u.Id);
}
public void AddTestUser()
{
SqlUserManager sqm = new SqlUserManager();
User u = new User();
u.Id = 12;
u.Password = "******";
string tempUserName = DateTime.Now.ToString();
u.UserName = tempUserName;
sqm.Add(u);
string found = sqm.GetUserByUserName(tempUserName);
Assert.AreEqual(tempUserName, found);
}
public Recipe MapDbResultToRecipe(SqlDataReader res)
{
res.Read();
User u = new User();
Recipe r = new Recipe();
r.Name = res["name"].ToString();
r.Username = res["username"].ToString();
r.Content = res["content"].ToString();
return r;
}
private User MapDbResultToUser(SqlDataReader res)
{
res.Read();
User u = new User();
if (res.HasRows)
{
u.Id = (int)res["id"];
u.Password = "";
u.Username = res["username"].ToString();
}
return u;
}
public User GetUserByUsername(string username)
{
User u = new User();
SqlConnection con = CreateConnection();
try
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "GetUserByUsername";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@username", username);
SqlDataReader res = cmd.ExecuteReader();
u = MapDbResultToUser(res);
}
catch (SqlException ex)
{
throw;
}
finally
{
if (con != null)
{
con.Close();
}
}
return u;
}
