// สถานะภาพของผู้อาศัย
private void _loadHomeStatus()
{
List <Base_Home_Status> list_data = new Base_Home_Status_Manager().getHomeStatus();
Current_Cust_Home_status_id_DDL.Items.Add(new ListItem("--------กรุณาเลือก--------", "0"));
Home_Cust_Home_status_id_DDL.Items.Add(new ListItem("--------กรุณาเลือก--------", "0"));
Idcard_Cust_Home_status_DDL.Items.Add(new ListItem("--------กรุณาเลือก--------", "0"));
for (int i = 0; i < list_data.Count; i++)
{
Base_Home_Status data = list_data[i];
Current_Cust_Home_status_id_DDL.Items.Add(new ListItem(data.Home_status_name, data.Home_status_id.ToString()));
Home_Cust_Home_status_id_DDL.Items.Add(new ListItem(data.Home_status_name, data.Home_status_id.ToString()));
Idcard_Cust_Home_status_DDL.Items.Add(new ListItem(data.Home_status_name, data.Home_status_id.ToString()));
}
}
public List <Base_Home_Status> getHomeStatus()
{
MySqlConnection con = MySQLConnection.connectionMySQL();
try
{
con.Open();
string sql = "SELECT * FROM base_home_status";
MySqlCommand cmd = new MySqlCommand(sql, con);
MySqlDataReader reader = cmd.ExecuteReader();
int defaultNum = 0;
string defaultString = "";
List <Base_Home_Status> list_bs_home_stt = new List <Base_Home_Status>();
while (reader.Read())
{
Base_Home_Status bs_home_stt = new Base_Home_Status();
bs_home_stt.Home_status_id = reader.IsDBNull(0) ? defaultNum : reader.GetInt32(0);
bs_home_stt.Home_status_name = reader.IsDBNull(1) ? defaultString : reader.GetString(1);
list_bs_home_stt.Add(bs_home_stt);
}
return(list_bs_home_stt);
}
catch (MySqlException ex)
{
error = "MysqlException ==> Managers_Base --> Base_Home_Status_Manager --> getHomeStatus() ";
Log_Error._writeErrorFile(error, ex);
return(null);
}
catch (Exception ex)
{
error = "Exception ==> Managers_Base --> Base_Home_Status_Manager --> getHomeStatus() ";
Log_Error._writeErrorFile(error, ex);
return(null);
}
finally
{
con.Close();
con.Dispose();
}
}
