/** * Create a new user **/ public bool CreateUser( User newuser ) { bool toReturn = false; using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connstring"].ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.CommandText = "INSERT INTO [dbo].[User] ( Name, ID, Email, Password ) VALUES (@Name,@User,@mail,@pass)"; cmd.Parameters.AddWithValue("@Name", newuser.GetName()); cmd.Parameters.AddWithValue("@User", newuser.GetUserName()); cmd.Parameters.AddWithValue("@mail", newuser.GetEmail()); cmd.Parameters.AddWithValue("@pass", newuser.GetPassword()); cmd.Connection = conn; conn.Open(); if (cmd.ExecuteNonQuery()!=0) { toReturn = true; } conn.Close(); } } return toReturn; }
public void UserTest() { User user = new User("NewName", "NewUserName", "NewEmail", "password"); Assert.AreEqual("NewName", user.GetName()); Assert.AreEqual("NewUserName", user.GetUserName()); Assert.AreEqual("NewEmail", user.GetEmail()); Assert.AreEqual("password", user.GetPassword()); }