private void btn_Update_Click(object sender, EventArgs e)
{
//string query_Update;
//if (radiobtn_ThanhToanDu.Checked)
//{
// //query_Update = "UPDATE dbo.ThongTinGiaoDich SET DongXe =" + "N'" + cbBox_DongXe.Text + "'" +
// // ",LoaiGiaoDich =" + "N'" + radiobtn_ThanhToanDu.Text + "'" +
// // ",ThoiGianGiaoDich =" + "'" + dateTimePicker_GiaoDich.Value.ToString("yyyy/MM/dd") + "'" +
// // " WHERE HoTen = N'" + txtBox_HoTen.Text + "';";
// query_Update = string.Format("UPDATE dbo.ThongTinGiaoDich SET DongXe = N'{0}',LoaiGiaoDich = N'{1}',ThoiGianGiaoDich = '{2}' WHERE HoTen = N'{3}'"
// , cbBox_DongXe.Text, radiobtn_ThanhToanDu.Text, dateTimePicker_GiaoDich.Value.ToString("yyyy/MM/dd"), txtBox_HoTen.Text);
//}
//else
//{
// query_Update = "UPDATE dbo.ThongTinGiaoDich SET DongXe =" + "N'" + cbBox_DongXe.Text + "'" +
// ",LoaiGiaoDich =" + "N'" + radiobtn_TraGop.Text + "'" +
// ",ThoiGianGiaoDich =" + "'" + dateTimePicker_GiaoDich.Value.ToString("yyyy/MM/dd") + "'" +
// " WHERE HoTen = N'" + txtBox_HoTen.Text + "';";
//}
//Dbhelper db = new Dbhelper(s);
//db.ExcuteDB(query_Update);
//dataGridView_Data.DataSource = db.getTable("select * from dbo.ThongTinGiaoDich");
BLL_KH bll = new BLL_KH(s);
bll.Update_BLL(dataGridView_Data);
btn_Show_Click(sender, e);
}
private void txtBox_Search_TextChanged(object sender, EventArgs e)
{
BLL_KH bll = new BLL_KH(s);
DAL_KH dal = new DAL_KH(s);
dataGridView_Data.DataSource = bll.SearchKH_BLL(dal.getListKH_DAL(), txtBox_Search.Text);
}
private void btn_Show_Click(object sender, EventArgs e)
{
//Dbhelper db = new Dbhelper(s);
//dataGridView_Data.DataSource = db.getTable("select * from ThongTinGiaoDich");
BLL_KH bll = new BLL_KH(s);
bll.Show_BLL(dataGridView_Data);
}
private void btn_Sort_Click(object sender, EventArgs e)
{
if (cbBox_Sort.Text.ToString() == "HoTen")
{
BLL_KH bll = new BLL_KH(s);
dataGridView_Data.DataSource = bll.sortKH_HoTen();
}
else if (cbBox_Sort.Text.ToString() == "LoaiGiaoDich")
{
BLL_KH bll = new BLL_KH(s);
dataGridView_Data.DataSource = bll.sortKH_LoaiGiaoDich();
}
else if (cbBox_Sort.Text.ToString() == "ThoiGianGiaoDich")
{
BLL_KH bll = new BLL_KH(s);
dataGridView_Data.DataSource = bll.sortKH_ThoiGianGiaoDich();
}
}
