public void UpdateUser(GlobalClass.userCreateMapper AlteringUser) { //Open connection if (this.openConnection() == true) { MySqlCommand cmd = new MySqlCommand(); cmd.Connection = dbConnect; string query = @"UPDATE user_info SET Name='" + AlteringUser.Name + @"', Surname='" + AlteringUser.Surname + @"', Patronym='" + AlteringUser.Patronim + @"' WHERE ID=" + AlteringUser.id_info; cmd.CommandText = query; cmd.ExecuteNonQuery(); query = @"UPDATE aquser SET ID_group=" + AlteringUser.id_group + @", passwd='" + AlteringUser.MD5HashPass + @"' WHERE ID=" + AlteringUser.ID; cmd.CommandText = query; cmd.ExecuteNonQuery(); //close connection this.CloseConnection(); } }
private void AlterUser() { AlteringUser = elementBase.SelectUserWhere(this.userId); this.SurnameT.Text = AlteringUser.Surname; this.NameT.Text = AlteringUser.Name; this.PatronymT.Text = AlteringUser.Patronim; this.groupSelector.SelectedValue = AlteringUser.id_group; }
public GlobalClass.userCreateMapper SelectUserWhere(int id) { string query = @"SELECT a.ID, b.Name, b.Surname, b.Patronym,a.ID_info, a.ID_group, a.passwd FROM aquser as a JOIN user_info as b ON b.ID = a.ID_info where a.ID = " + id.ToString() + " limit 1"; GlobalClass.userCreateMapper tempUser = new GlobalClass.userCreateMapper(); if (this.openConnection() == true) { MySqlCommand cmd = new MySqlCommand(query, dbConnect); MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list while (dataReader.Read()) { int II = (int)((long)dataReader["ID_info"]); int IG = (int)((long)dataReader["ID_group"]); int I = (int)((long)dataReader["ID"]); string N = (string)dataReader["Name"]; string S = (string)dataReader["Surname"]; string P = (string)dataReader["Patronym"]; string Pw = (string)dataReader["passwd"]; tempUser = new GlobalClass.userCreateMapper(I, N, S, P, II, IG, Pw); } //close Data Reader dataReader.Close(); //close Connection this.CloseConnection(); //return list to be displayed return(tempUser); } else { return(tempUser); } }
public void InsertUserInfo(GlobalClass.userCreateMapper InsertingUser) { if (this.openConnection() == true) { MySqlCommand cmd = new MySqlCommand(); cmd.Connection = dbConnect; string query = @"INSERT INTO user_info (`Name`,`Surname`,`Patronym`) VALUES ('" + InsertingUser.Name + "','" + InsertingUser.Surname + "','" + InsertingUser.Patronim + "')"; cmd.CommandText = query; cmd.ExecuteNonQuery(); long inserted_id = -1; inserted_id = cmd.LastInsertedId; if (inserted_id > -1) { query = @"INSERT INTO aquser (`ID_group`,`ID_info`,`passwd`) VALUES ('" + InsertingUser.id_group + "','" + inserted_id + "','" + InsertingUser.MD5HashPass + "')"; cmd.CommandText = query; cmd.ExecuteNonQuery(); } //close connection this.CloseConnection(); } }
public AddUser() { InitializeComponent(); newUser = true; AlteringUser = new GlobalClass.userCreateMapper(); }