protected void Button1_Click(object sender, EventArgs e)
{
if (TextBox1.Text == "")
{
Response.Write("Vui long nhap ten !!!");
TextBox1.Focus();
}
else
{
bpp = new Bol_Packing_Place();
Packing_Place pp = new Packing_Place();
if (bpp.CheckParking_PlaceExistByName(TextBox1.Text) == 0)
{
pp.Name = TextBox1.Text;
pp.Ci_ID = Convert.ToInt32(DropDownList1.SelectedValue);
Label1.Text = Convert.ToString(pp.Ci_ID);
if (RadioButton3.Checked)
{
pp.Status = true;
GridView1.DataSource = bpp.InsertPacking_Place(pp);
GridView1.DataBind();
}
else
{
pp.Status = false;
GridView1.DataSource = bpp.InsertPacking_Place(pp);
GridView1.DataBind();
}
}
else
{
Response.Write("Ten ban nhap da ton tai vui long nhap ten khac !!!");
}
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
pl = new Packing_Place();
bpp = new Bol_Packing_Place();
if (txtSearch.Text == "")
{
Response.Write("Vui long nhap ten hay id can tim !!!");
txtSearch.Focus();
}
else
{
if (DropDownList2.SelectedValue.ToString() == "ByID")
{
if (bpp.CheckParking_PlaceExistByID(Convert.ToInt32(txtSearch.Text)) == 0)
{
pl.PP_ID = Convert.ToInt32(txtSearch.Text);
GridView1.DataSource = bpp.SelectPacking_PlaceByID(pl);
GridView1.DataBind();
}
else
{
Response.Write("ID ban nhap khong ton tai vui long nhap id khac !!!");
txtSearch.Focus();
}
}
else if (DropDownList2.SelectedValue.ToString() == "ByName")
{
if (bpp.CheckParking_PlaceExistByName(txtSearch.Text) == 0)
{
pl.Name = txtSearch.Text;
GridView1.DataSource = bpp.SelectPacking_PlaceByName(pl);
GridView1.DataBind();
}
else
{
Response.Write("Name ban nhap khong ton tai vui long nhap id khac !!!");
txtSearch.Focus();
}
}
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
bpp = new Bol_Packing_Place();
pl = new Packing_Place();
if (txtDelete.Text == "")
{
Response.Write("Vui long nhap ten can delete !!!");
txtDelete.Focus();
}
else
{
if (DropDownList3.SelectedValue.ToString() == "ByID")
{
if (bpp.CheckParking_PlaceExistByID(Convert.ToInt32(txtDelete.Text)) == 0)
{
pl.Ci_ID = Convert.ToInt32(txtDelete.Text);
GridView1.DataBind();
}
else
{
Response.Write("ID ban nhap khong ton tai !!!");
txtDelete.Focus();
}
}
else if (DropDownList3.SelectedValue.ToString() == "ByName")
{
if (bpp.CheckParking_PlaceExistByName(txtDelete.Text) == 0)
{
pl.Name = txtDelete.Text;
GridView1.DataSource = bpp.DeletePacking_PlaceByName(pl);
GridView1.DataBind();
}
else
{
Response.Write("Ten ban nhap khong ton tai !!!");
txtDelete.Focus();
}
}
}
}
public int DeletePacking_PlaceByName(Packing_Place pl)
{
return(btac.DeletePacking_PlaceByName(pl.Name));
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
bpp = new Bol_Packing_Place();
pl = new Packing_Place();
if (txtSearch.Text == "")
{
Response.Write("Vui long nhap ten hay id can tim !!!");
txtSearch.Focus();
}
else
{
if (DropDownList4.SelectedValue.ToString() == "ByID")
{
if (bpp.CheckParking_PlaceExistByID(Convert.ToInt32(txtID.Text)) == 0)
{
if (txtName.Text == "")
{
Response.Write("Vui long nhap thong tin cap nhat !!!");
}
else
{
pl.Ci_ID = Convert.ToInt32(txtID.Text);
pl.Name = txtName.Text;
if (RadioButton1.Checked)
{
pl.Status = true;
}
else
{
pl.Status = false;
}
try
{
GridView1.DataSource = bpp.UpdatePacking_PlaceByID(pl);
GridView1.DataBind();
}
catch (Exception ex)
{
Response.Write(ex.Message + "SAO LAI THE NHI !!!");
}
}
}
else
{
Response.Write("ID ban nhap khong ton tai !!!");
txtID.Focus();
}
}
else if (DropDownList4.SelectedValue.ToString() == "ByName")
{
if (bpp.CheckParking_PlaceExistByName(txtID.Text) == 0)
{
if (txtName.Text == "")
{
Response.Write("Vui long nhap thong tin cap nhat !!!");
}
else
{
pl.Name = txtName.Text;
try
{
GridView1.DataSource = bpp.UpdatePacking_PlaceByName(pl);
GridView1.DataBind();
}
catch (Exception ex)
{
Response.Write(ex.Message + "CHAN CHUA KIA !!!");
}
}
}
else
{
Response.Write("Ten ban nhap khong ton tai !!!");
txtID.Focus();
}
}
}
}
public int DeletePacking_PlaceByID(Packing_Place pl)
{
return(btac.DeletePacking_PlaceByID(pl.PP_ID));
}
public int UpdatePacking_PlaceByName(Packing_Place pl)
{
return(btac.UpdatePacking_PlaceByName(pl.Name, pl.Ci_ID, pl.Status));
}
public int InsertPacking_Place(Packing_Place pl)
{
return(btac.InsertPacking_Place(pl.PP_ID, pl.Name, pl.Ci_ID, pl.Status));
}
public DataTable SelectPacking_PlaceByName(Packing_Place pl)
{
return(btac.GetPacking_PlaceByName(pl.Name));
}
public DataTable SelectPacking_PlaceByID(Packing_Place pl)
{
return(btac.GetPacking_PlaceByID(pl.PP_ID));
}