public static void deleteUser(UserData u) { // CALL `p_delete_user`(@_user_id); try { using (MySqlConnection conn = new MySqlConnection(App.setting.connectString)) { conn.Open(); string query = "CALL `p_delete_user` (@_user_id);"; using (MySqlCommand cmd = new MySqlCommand(query, conn)) { cmd.Parameters.AddWithValue("@_user_id", u.ID); cmd.ExecuteNonQuery(); }; conn.Close(); }; } catch (MySqlException) { } catch (Exception) { } }
public static List<UserData> toUsers(this MySqlDataReader reader) { if (reader.HasRows) { List<UserData> results = new List<UserData>(); while (reader.Read()) { if (!reader.IsDBNull(0)) { UserData u = new UserData(); u.ID = reader.GetInt32(Define.user_id); u.Full_Name = reader.GetString(Define.user_full_name); u.Permision = Permision.Read(reader.GetString(Define.user_permision)); u.Status = reader.GetBoolean(Define.user_status); u.Type = reader.GetInt32(Define.user_type); u.Time = reader.GetDateTime(Define.user_time); u.setDirectpass(reader.GetString(Define.user_pass)); try { u.Comment = reader.GetString(Define.user_content); } catch (Exception) { } try { u.Phone = reader.GetString(Define.user_phone); } catch (Exception) { } try { u.Email = reader.GetString(Define.user_email); } catch (Exception) { } u.User_Name = reader.GetString(Define.user_name); results.Add(u); } } return results; } return null; }
public static int insertUser(UserData u) { int result = 0; try { using (MySqlConnection conn = new MySqlConnection(App.setting.connectString)) { conn.Open(); string query = "`p_insert_user`"; using (MySqlCommand cmd = new MySqlCommand(query, conn)) { cmd.Parameters.Add(new MySqlParameter("@_fullname", MySqlDbType.Text) { Direction = System.Data.ParameterDirection.Input, Value = u.Full_Name }); cmd.Parameters.Add(new MySqlParameter("@_user_name", MySqlDbType.VarChar, 100) { Direction = System.Data.ParameterDirection.Input, Value = u.User_Name }); cmd.Parameters.Add(new MySqlParameter("@_user_pass", MySqlDbType.VarChar, 100) { Direction = System.Data.ParameterDirection.Input, Value = u.Pass }); cmd.Parameters.Add(new MySqlParameter("@_user_type", MySqlDbType.Int32) { Direction = System.Data.ParameterDirection.Input, Value = u.Type }); cmd.Parameters.Add(new MySqlParameter("@_user_phone", MySqlDbType.VarChar, 100) { Direction = System.Data.ParameterDirection.Input, Value = u.Phone }); cmd.Parameters.Add(new MySqlParameter("@_user_email", MySqlDbType.VarChar, 100) { Direction = System.Data.ParameterDirection.Input, Value = u.Email }); cmd.Parameters.Add(new MySqlParameter("@_user_finger_print", MySqlDbType.LongBlob) { Direction = System.Data.ParameterDirection.Input, Value = u.Finger_Print }); cmd.Parameters.Add(new MySqlParameter("@_result", MySqlDbType.Int32) { Direction = System.Data.ParameterDirection.Output, Value = 0 }); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.ExecuteScalar(); result = Convert.ToInt32(cmd.Parameters["@_result"].Value); }; conn.Close(); }; } catch (Exception) { } return result; }
public static UserData toUser(this MySqlDataReader reader) { UserData u = null; while (reader.Read()) { if (!reader.IsDBNull(0)) { u = new UserData(); u.ID = reader.GetInt32(Define.user_id); u.Full_Name = reader.GetString(Define.user_full_name); u.Permision = Permision.Read(reader.GetString(Define.user_permision)); u.Status = reader.GetBoolean(Define.user_status); u.Type = reader.GetInt32(Define.user_type); u.Time = reader.GetDateTime(Define.user_time); u.User_Name = reader.GetString(Define.user_name); u.setDirectpass(reader.GetString(Define.user_pass)); try { u.Comment = reader.GetString(Define.user_content); } catch (Exception) { } try { u.Phone = reader.GetString(Define.user_phone); } catch (Exception) { } try { u.Email = reader.GetString(Define.user_email); } catch (Exception) { } try { u.Finger_Print = new byte[10 * 1024 * 1024]; long bytesRead = reader.GetBytes(reader.GetOrdinal(Define.user_finger_print), 0, u.Finger_Print, 0, u.Finger_Print.Length); Console.WriteLine(bytesRead + " bytes downloaded from table to file."); } catch (Exception) { } } } return u; }