public int updatePhongBan(PhongBan_DTO pb)
{
String sql = "update PhongBan set tenpb=@TenPB,ngaytl=@NgayTL where mapb=@MaPB";
try
{
SqlConnection conn = getConnection();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@MaPB", pb.MaPB);
cmd.Parameters.AddWithValue("@TenPB", pb.TenPB);
cmd.Parameters.AddWithValue("@NgayTL", pb.NgayTL);
cmd.ExecuteNonQuery();
return(1);
}
catch (SqlException e)
{
//MessageBox.Show(e.Message);\
//return 0;
}
return(0);
}
public int insertPhongBan(PhongBan_DTO pb)
{
String sql = "insert into PhongBan values(@MaPB,@TenPB,@NgayTL)";
try
{
SqlConnection conn = getConnection();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@MaPB", pb.MaPB);
cmd.Parameters.AddWithValue("@TenPB", pb.TenPB);
cmd.Parameters.AddWithValue("@NgayTL", pb.NgayTL);
cmd.ExecuteNonQuery();
return(1);
}
catch (SqlException e)
{
//MessageBox.Show(e.Message);
//return 0;
}
return(0);
}
private void btnTimKiem_Click(object sender, EventArgs e)
{
PhongBan_DTO pb = new PhongBan_DTO();
pb.MaPB = txtMaPB.Text;
pb.TenPB = txtTenPB.Text;
pb.NgayTL = dtpNgayTL.Text;
DataTable dt = phongBan_BUL.findPhongBan(pb);
dtgPhongBan.DataSource = dt;
}
public DataTable findPhongBan(PhongBan_DTO pb)
{
String sql = "select * from PHONGBAN where 1=1 and mapb like '%" + pb.MaPB + "%' and tenpb like '%" + pb.TenPB + "%'";
SqlConnection conn = getConnection();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(reader);
return(dt);
}
private void btnSua_Click(object sender, EventArgs e)
{
if (txtMaPB.Text.Equals("") || txtTenPB.Text.Equals(""))
{
MessageBox.Show("Phải điền đủ thông tin", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
PhongBan_DTO pb = new PhongBan_DTO();
pb.MaPB = txtMaPB.Text;
pb.TenPB = txtTenPB.Text;
pb.NgayTL = dtpNgayTL.Text;
int kq = phongBan_BUL.updatePhongBan(pb);
if (kq == 1)
{
MessageBox.Show("Sửa thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (kq == 0)
{
MessageBox.Show("Sửa thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
HienThi();
}
public DataTable findPhongBan(PhongBan_DTO pb)
{
return(phongBan_DAL.findPhongBan(pb));
}
public int updatePhongBan(PhongBan_DTO pb)
{
return(phongBan_DAL.updatePhongBan(pb));
}
public int insertPhongBan(PhongBan_DTO pb)
{
return(phongBan_DAL.insertPhongBan(pb));
}
