protected void Page_Load(object sender, EventArgs e)
{
if (Session["Login"] == null || Session["Package"] == null)
{
Response.Redirect("/Authorization/Login");
}
if (!IsPostBack)
{
if (Request.Params["code"] != null)
{
string[] code = Request.Params["code"].Split('U');
string Nationality_id = code[1];
if (Request.Params["mode"] == "e")
{
bs_ntn = bs_ntn_mng.getNationalityById(Convert.ToInt32(Nationality_id));
_loadNationality(bs_ntn);
}
else if (Request.Params["mode"] == "r")
{
_removeNationality(Nationality_id);
Response.Redirect("/Form_Base/Base_Nationalitys_Management");
}
}
}
}
// สัญชาติ
private void _loadNationality()
{
List <Base_Nationalitys> list_data = new Base_Nationalitys_Manager().getNationalitys();
Cust_Nationality_DDL.Items.Add(new ListItem("กรุณาเลือก", "0"));
Marry_Nationality_DDL.Items.Add(new ListItem("กรุณาเลือก", "0"));
for (int i = 0; i < list_data.Count; i++)
{
Base_Nationalitys data = list_data[i];
Cust_Nationality_DDL.Items.Add(new ListItem(data.Nationality_name_TH + " ( " + data.Nationality_name_ENG + " ) ", data.Nationality_id.ToString()));
Marry_Nationality_DDL.Items.Add(new ListItem(data.Nationality_name_TH + " ( " + data.Nationality_name_ENG + " ) ", data.Nationality_id.ToString()));
}
}
public List <Base_Nationalitys> getNationalitys()
{
MySqlConnection con = MySQLConnection.connectionMySQL();
try
{
con.Open();
string sql = "SELECT * FROM base_nationalitys";
MySqlCommand cmd = new MySqlCommand(sql, con);
MySqlDataReader reader = cmd.ExecuteReader();
int defaultNum = 0;
string defaultString = "";
List <Base_Nationalitys> list_bs_ntn = new List <Base_Nationalitys>();
while (reader.Read())
{
Base_Nationalitys bs_ntn = new Base_Nationalitys();
bs_ntn.Nationality_id = reader.IsDBNull(0) ? defaultNum : reader.GetInt32(0);
bs_ntn.Nationality_name_ENG = reader.IsDBNull(1) ? defaultString : reader.GetString(1);
bs_ntn.Nationality_name_TH = reader.IsDBNull(2) ? defaultString : reader.GetString(2);
list_bs_ntn.Add(bs_ntn);
}
return(list_bs_ntn);
}
catch (MySqlException ex)
{
error = "MysqlException ==> Managers_Base --> Base_Nationalitys_Manager --> getNationalitys() ";
Log_Error._writeErrorFile(error, ex);
return(null);
}
catch (Exception ex)
{
error = "Exception ==> Managers_Base --> Base_Nationalitys_Manager --> getNationalitys() ";
Log_Error._writeErrorFile(error, ex);
return(null);
}
finally
{
con.Close();
con.Dispose();
}
}
private void _loadNationality(Base_Nationalitys bs_ntn)
{
Nationality_name_ENG_TBx.Text = bs_ntn.Nationality_name_ENG;
Nationality_name_TH_TBx.Text = bs_ntn.Nationality_name_TH;
}
