/**
* 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());
}
