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