public ArrayList getUser() { string query = "SELECT * from tbl_user"; list = new ArrayList(); openConnection(); MySqlCommand cmd = new MySqlCommand(query, connection); try { MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { User u = new User(); u.id = dataReader.GetString(0); u.name = dataReader.GetString(1); u.department = dataReader.GetString(2); u.contactWith = dataReader.GetString(3); u.idCard = dataReader.GetString(4); u.placeOfIdCard = dataReader.GetString(5); u.dateOfIdCard = dataReader.GetString(6); u.image = dataReader.GetString(7); list.Add(u); } } catch (Exception e) { MessageBox.Show("Unable To Connect To Database!", "Database Warning!"); } closeConnection(); return list; }
public void addUser(User u) { if (db.addUser(u)) { message = "Add Compeleted!"; } else message = "Add Error!"; }
private void addUser() { User u = new User(); u.id = tbId.Text; u.name = tbName.Text; u.department = tbDepartment.Text; u.contactWith = tbContactWith.Text; u.idCard = tbIdCard.Text; u.placeOfIdCard = tbPlaceOfIdCard.Text; u.dateOfIdCard = tbDateOfIdCard.Text; u.image = Path.GetFileName(filePath); um.addUser(u); copyImage(filePath); MessageBox.Show(um.getMessage(), "System"); }
public bool addUser(User u) { if (openConnection()) { MySqlCommand cmd = connection.CreateCommand(); cmd.CommandText = "INSERT INTO tbl_User values (@id, @name, @department, @contactWith, @idCard, @placeOfIdCard, @dateOfIdCard, @image)"; cmd.Parameters.AddWithValue("@id", u.id); cmd.Parameters.AddWithValue("@name", u.name); cmd.Parameters.AddWithValue("@department", u.department); cmd.Parameters.AddWithValue("@contactWith", u.contactWith); cmd.Parameters.AddWithValue("@idCard", u.idCard); cmd.Parameters.AddWithValue("@placeOfIdCard", u.placeOfIdCard); cmd.Parameters.AddWithValue("@dateOfIdCard", u.dateOfIdCard); cmd.Parameters.AddWithValue("@image", u.image); cmd.ExecuteNonQuery(); closeConnection(); return true; } return false; }