/**********************************
* *
* Register DAO Method *
* *
* Use with form generated User *
* obj *
* *
* To Register new User call *
* Register Business Method *
* *
**********************************/
public bool Register(MinesweeperProjectCLC247.Models.UserModel user)
{
//create SqlCommand to insert new user into DB
SqlCommand cmd = new SqlCommand("INSERT INTO dbo.Users(FirstName, LastName, Gender, Age, State, Email, Username, Password) VALUES('" + user.FirstName + "', '" + user.LastName + "', '" + user.Gender + "', '" + user.Age + "', '" + user.State + "', '" + user.Email + "', '" + user.Username + "', '" + user.Password + "')", this.conn);
//open database connection
conn.Open();
//execute query
int rows = cmd.ExecuteNonQuery();
//check to see how many rows were affected
if (rows >= 1)
{
return(true);
}
else
{
return(false);
}
}
/**********************************
* *
* Register Method *
* *
* Use with form generated User *
* obj *
* *
* Call this method to Register *
* new User *
********************************** */
public bool Register(MinesweeperProjectCLC247.Models.UserModel newUser)
{
DAO dao = new DAO();
return(dao.Register(newUser));
}