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 id = code[1];
if (Request.Params["mode"] == "e")
{
bs_class = bs_mng.getTentsById(Convert.ToInt32(id));
_loadTentsCar(bs_class);
}
else if (Request.Params["mode"] == "r")
{
_removeTentsCar(id);
Response.Redirect("/Form_Base/Base_Tents_Car_Management");
}
}
}
}
// ชื่อเต้นท์รถ
private void _loadTentsCar()
{
List <Base_Tents_Car> list_data = new Base_Tents_Car_Manager().getTents();
Tent_car_DDL.Items.Add(new ListItem("--------กรุณาเลือก--------", "0"));
for (int i = 0; i < list_data.Count; i++)
{
Base_Tents_Car data = list_data[i];
Tent_car_DDL.Items.Add(new ListItem(data.Tent_name, data.Tent_car_id.ToString()));
}
}
public List <Base_Tents_Car> getTents()
{
MySqlConnection con = MySQLConnection.connectionMySQL();
try
{
con.Open();
string sql = "SELECT * FROM base_tents_car ORDER BY Tent_name";
MySqlCommand cmd = new MySqlCommand(sql, con);
MySqlDataReader reader = cmd.ExecuteReader();
int defaultNum = 0;
string defaultString = "";
List <Base_Tents_Car> list_bs_tnc = new List <Base_Tents_Car>();
while (reader.Read())
{
Base_Tents_Car bs_tnc = new Base_Tents_Car();
bs_tnc.Tent_car_id = reader.IsDBNull(0) ? defaultNum : reader.GetInt32(0);
bs_tnc.Tent_name = reader.IsDBNull(1) ? defaultString : reader.GetString(1);
bs_tnc.Tent_local = reader.IsDBNull(2) ? defaultString : reader.GetString(2);
list_bs_tnc.Add(bs_tnc);
}
return(list_bs_tnc);
}
catch (MySqlException ex)
{
error = "MysqlException ==> Managers_Base --> Base_Tents_Car_Manager --> getTents() ";
Log_Error._writeErrorFile(error, ex);
return(null);
}
catch (Exception ex)
{
error = "Exception ==> Managers_Base --> Base_Tents_Car_Manager --> getTents() ";
Log_Error._writeErrorFile(error, ex);
return(null);
}
finally
{
con.Close();
con.Dispose();
}
}
private void _loadTentsCar(Base_Tents_Car bs_class)
{
Tent_name_TBx.Text = bs_class.Tent_name;
Tent_local_TBx.Text = bs_class.Tent_local;
}