// สิทธิ์ในการใช้งาน
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();
}
}
