public void InsertUsers(List <User> i_Users)
{
Connect();
List <SQL_User> SqlUsers = SQL_User.GetSqlObjects(i_Users);
m_MySqlConnection.Execute("call insertUsers (@id, @username,@name,@password)", SqlUsers);
CloseConnection();
}
public User CreateNewUser(SQL_User i_SQL_User)
{
//inserting to the users table:
var list = new List <SQL_User>();
list.Add(i_SQL_User);
InsertUsers(list);
//inserting to bank table:
int InitialMoney = 40000;
InsertBank(i_SQL_User, InitialMoney);
Bank bank = new Bank();
bank.userId = i_SQL_User.id;
bank.money = InitialMoney;
return(new User(i_SQL_User.id, i_SQL_User.username, i_SQL_User.name, i_SQL_User.password, bank));
}
private void button1_Click(object sender, EventArgs e)
{
Random rnd = new Random();
int ID = rnd.Next(1, 1000000);
string Name = textBoxName.Text;
string Username = textBoxUsername.Text;
string Password = textBoxPassword.Text;
if (!string.IsNullOrEmpty(Name) && !string.IsNullOrEmpty(Username) && !string.IsNullOrEmpty(Password) && !Name.Equals("Name") && !Username.Equals("Username") && !Password.Equals("Password"))
{
user = new SQL_User()
{
id = ID, name = Name, username = Username, password = Password
};
m_UserMapperDelegate(user);
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("You have entered one or more things wrong, try fill again..");
}
}
public User CreateNewUser(SQL_User i_SQL_User)
{
return(DataBaseProxy.CreateNewUser(i_SQL_User));
}
public void InsertBank(SQL_User i_SQL_User, int InitialMoney)
{
Connect();
m_MySqlConnection.Execute($"insert into bank values('{i_SQL_User.id}','{InitialMoney}');");
CloseConnection();
}
public void UserMapper(SQL_User i_User)
{
sQL_User = i_User;
}
