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; }