// สิทธิ์ในการใช้งาน private void _loadLevelAccess() { List <Account_Level> list_data = new Account_Manager().listAccountLevel(); for (int i = 0; i < list_data.Count; i++) { Account_Level data = list_data[i]; level_ChkBxL.Items.Add(new ListItem(data.level_name_TH + " ( " + data.level_name_ENG + " ) ", data.level_id.ToString())); } }
public List <Account_Level> listAccountLevel() { MySqlConnection con = MySQLConnection.connectionMySQL(); try { con.Open(); string sql = "SELECT * FROM account_login_levels"; MySqlCommand cmd = new MySqlCommand(sql, con); MySqlDataReader reader = cmd.ExecuteReader(); int defaultNum = 0; string defaultString = ""; List <Account_Level> list_acc_lv = new List <Account_Level>(); while (reader.Read()) { Account_Level acc_lv = new Account_Level(); acc_lv.level_id = reader.IsDBNull(0) ? defaultNum : reader.GetInt32(0); acc_lv.level_name_TH = reader.IsDBNull(1) ? defaultString : reader.GetString(1); acc_lv.level_name_ENG = reader.IsDBNull(2) ? defaultString : reader.GetString(2); acc_lv.level_details = reader.IsDBNull(3) ? defaultString : reader.GetString(3); acc_lv.level_access = reader.IsDBNull(4) ? defaultNum : reader.GetInt32(4); list_acc_lv.Add(acc_lv); } return(list_acc_lv); } catch (MySqlException ex) { error = "MysqlException ==> Managers_Base --> Account_Manager --> listAccountLevel() "; Log_Error._writeErrorFile(error, ex); return(null); } catch (Exception ex) { error = "Exception ==> Managers_Base --> Account_Manager --> listAccountLevel() "; Log_Error._writeErrorFile(error, ex); return(null); } finally { con.Close(); con.Dispose(); } }