protected void btnDelete_Click(object sender, EventArgs e)
 {
     bs = new Bol_Sales();
     sa = new Sales();
     if (txtDelete.Text == "")
     {
         Response.Write("Vui long nhap id hoac name can xoa !!!");
         txtDelete.Focus();
     }
     else
     {
         if (DropDownList3.SelectedValue.ToString() == "ByID")
         {
             if (bs.CheckSalesExistByID(Convert.ToInt32(txtDelete.Text)) == 0)
             {
                 sa.Sa_ID = Convert.ToInt32(txtDelete.Text);
                 GridView1.DataSource = bs.DeleteSalesByID(sa);
                 GridView1.DataBind();
             }
             else
             {
                 Response.Write("ID ban nhap khong ton tai vui long nhap lai !!!");
                 txtDelete.Focus();
             }
         }
         else if (DropDownList3.SelectedValue.ToString() == "ByName")
         {
             if (bs.CheckSalesExistByName(txtDelete.Text) == 0)
             {
                 sa.Name = txtDelete.Text;
                 GridView1.DataSource = bs.DeleteSalesByName(sa);
                 GridView1.DataBind();
             }
             else
             {
                 Response.Write("Name ban nhap khong ton tai vui long nhap lai !!!");
                 txtDelete.Focus();
             }
         }
     }
 }
 protected void btnUpdate_Click(object sender, EventArgs e)
 {
     bs = new Bol_Sales();
     sa = new Sales();
     if (txtID.Text == "")
     {
         Response.Write("Vui long nhap id hay ten trong phan cap nhat !!!");
     }
     else
     {
         if (DropDownList4.SelectedValue.ToString() == "ByID")
         {
             if (bs.CheckSalesExistByID(Convert.ToInt32(txtID.Text))== 0)
             {
                 if (TextBox1.Text == "")
                 {
                     Response.Write("Ban nhap thieu thong tin !!!");
                     txtName.Focus();
                 }
                 else if (TextBox2.Text =="")
                 {
                     Response.Write("Ban nhap thieu thong tin !!!");
                     txtName.Focus();
                 }
                 else if (TextBox3.Text == "")
                 {
                     Response.Write("Ban nhap thieu thong tin !!!");
                     txtName.Focus();
                 }
                 else if (TextBox4.Text == "")
                 {
                     Response.Write("Ban nhap thieu thong tin !!!");
                     txtName.Focus();
                 }
                 else
                 {
                     sa.Sa_ID = Convert.ToInt32(txtID.Text);
                     sa.Name = txtName.Text;
                     sa.Maxage = Convert.ToInt32(txtMaxage.Text);
                     sa.Minage = Convert.ToInt32(txtMinage.Text);
                     sa.Rate = Convert.ToInt32(txtrate.Text);
                     if (RadioButton3.Checked)
                     {
                         sa.Status = true;
                     }
                     else
                     {
                         sa.Status = false;
                     }
                     try
                     {
                         GridView1.DataSource = bs.UpdateSalesByID(sa);
                         GridView1.DataBind();
                     }
                     catch (Exception ex)
                     {
                         Response.Write(ex.Message + "SAO LAI THE NHI !!!");
                     }
                 }
             }
         }
         else if (DropDownList4.SelectedValue.ToString() == "ByName")
         {
             if (bs.CheckSalesExistByName(txtID.Text) == 0)
             {
                 if (TextBox1.Text == "")
                 {
                     Response.Write("Ban nhap thieu thong tin !!!");
                     txtName.Focus();
                 }
                 else if (TextBox2.Text == "")
                 {
                     Response.Write("Ban nhap thieu thong tin !!!");
                     txtName.Focus();
                 }
                 else if (TextBox3.Text == "")
                 {
                     Response.Write("Ban nhap thieu thong tin !!!");
                     txtName.Focus();
                 }
                 else if (TextBox4.Text == "")
                 {
                     Response.Write("Ban nhap thieu thong tin !!!");
                     txtName.Focus();
                 }
                 else
                 {
                     sa.Name = txtName.Text;
                     sa.Maxage = Convert.ToInt32(txtMaxage.Text);
                     sa.Minage = Convert.ToInt32(txtMinage.Text);
                     sa.Rate = Convert.ToInt32(txtrate.Text);
                     if (RadioButton3.Checked)
                     {
                         sa.Status = true;
                     }
                     else
                     {
                         sa.Status = false;
                     }
                     try
                     {
                         GridView1.DataSource = bs.UpdateSalesByID(sa);
                         GridView1.DataBind();
                     }
                     catch (Exception ex)
                     {
                         Response.Write(ex.Message + "SAO LAI THE NHI !!!");
                     }
                 }
             }
         }
     }
 }
 protected void Page_Load(object sender, EventArgs e)
 {
     bs = new Bol_Sales();
     sa = new Sales();
     GridView1.DataSource = bs.SelectAllSales();
     GridView1.DataBind();
 }
 protected void btnSearch_Click(object sender, EventArgs e)
 {
     bs = new Bol_Sales();
     sa = new Sales();
     if (txtSearch.Text == "")
     {
         Response.Write("Vui long nhap ten hoac id can cap nhat !!!");
         txtSearch.Focus();
     }
     else
     {
         if (DropDownList1.SelectedValue.ToString() == "ByID")
         {
             if (bs.CheckSalesExistByID(Convert.ToInt32(txtSearch.Text)) == 0)
             {
                 sa.Sa_ID = Convert.ToInt32(txtSearch.Text);
                 GridView1.DataSource = bs.SelectSalesByID(sa);
                 GridView1.DataBind();
             }
             else
             {
                 Response.Write("ID nay khong ton tai !!!");
             }
         }
         else if (DropDownList1.SelectedValue.ToString() == "ByName")
         {
             if (bs.CheckSalesExistByName(txtSearch.Text) == 0)
             {
                 sa.Name = txtSearch.Text;
                 GridView1.DataSource = bs.SelectSalesByName(sa);
                 GridView1.DataBind();
             }
             else
             {
                 Response.Write("Name nay khong ton tai !!!");
             }
         }
     }
 }