protected void btnAdd_Click(object sender, EventArgs e)
    {
        if (Page.IsValid)
        {
            ServiceReference1.Coach coach = new ServiceReference1.Coach();
            coach.Train_ID = int.Parse(ddlTrainName.SelectedValue);
            coach.Coach_Type = ddlCoachesType.SelectedItem.Text;
            coach.Number_Of_Seats = int.Parse(txtSeats.Text);
            coach.Price = double.Parse(txtPrices.Text);
            if (RadioButton1.Checked)
            {
                coach.Status = RadioButton1.Text;
            }
            else
            {
                coach.Status = RadioButton2.Text;
            }

            ServiceReference1.Service1Client sv = new ServiceReference1.Service1Client();
            if (sv.Add_Coaches(coach) == 1)
            {
                ScriptManager.RegisterStartupScript(this, GetType(), "Thông báo", "alert('Add coach successed !!!');", true);
                BindingData_Table();
                BindingData_TrainName();
                Reset();
            }
            else
            {
                ScriptManager.RegisterStartupScript(this, GetType(), "Thông báo", "alert('Add coach failed !!!');", true);
            }
        }
    }
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        if (Page.IsValid)
        {
            ServiceReference1.Coach coach = new ServiceReference1.Coach();
            coach.Coach_ID = id;
            coach.Train_ID = int.Parse(ddlTrainName.SelectedValue);
            coach.Coach_Type = ddlCoachesType.SelectedItem.Text;
            coach.Number_Of_Seats = int.Parse(txtSeats.Text);
            coach.Price = double.Parse(txtPrices.Text);
            if (RadioButton1.Checked)
            {
                coach.Status = RadioButton1.Text;
            }
            else
            {
                coach.Status = RadioButton2.Text;
            }
            if (coach.Status == "Block")
            {
                var a = new ServiceReference1.Service1Client().GetAll_Tickets_v2();
                int dem = 0;
                foreach (var item in a)
                {
                    if (item.Train_ID == _train_id && item.Departure_Date > DateTime.Now.Date)
                    {
                        dem++;
                    }
                }
                if (dem > 0)
                {
                    ScriptManager.RegisterStartupScript(this, GetType(), "Thông báo", "alert('Tickets of this coach still exist. Can not Block. Please, try again !!!');", true);
                }
                else
                {
                    ServiceReference1.Service1Client sv = new ServiceReference1.Service1Client();
                    if (sv.Update_Coaches(coach) == 1)
                    {
                        ScriptManager.RegisterStartupScript(this, GetType(), "Thông báo", "alert('Update coach successed !!!');", true);
                        BindingData_Table();
                        BindingData_TrainName();
                        Reset();
                    }
                    else
                    {
                        ScriptManager.RegisterStartupScript(this, GetType(), "Thông báo", "alert('Update coach failed !!!');", true);
                    }
                }
            }

        }
    }