//ham lay du lieu tu cotroller
void ganDL(PhongBanDT dtPB)
{
dtPB.Maphongban = txtMaPhongBan.Text.Trim();
dtPB.Tenphongban = txtTenPhongBan.Text.Trim();
dtPB.Diachi = txtDiaChi.Text.Trim();
dtPB.Sodienthoai = txtSoDienThoai.Text.Trim();
}
//SỬA dl
public bool UpdateData(PhongBanDT dtPB)
{
cmd.CommandText = "UPDATE phongban SET tenphongban = N'" + dtPB.Tenphongban + "',diachi = N'" + dtPB.Diachi + "',sodienthoai = '" + dtPB.Sodienthoai + "' WHERE maphongban ='" + dtPB.Maphongban + "'";
cmd.CommandType = CommandType.Text;
cmd.Connection = conn.Connection;
try
{
conn.OpenConn();
cmd.ExecuteNonQuery();
conn.CloseConn();
return(true);
}
catch (Exception ex)
{
string mex = ex.Message;
cmd.Dispose();
conn.CloseConn();
}
return(false);
}
//thêm mới dl
public bool AddData(PhongBanDT dtPB)
{
cmd.CommandText = "INSERT INTO phongban values ('" + dtPB.Maphongban + "',N'" + dtPB.Tenphongban + "', N'" + dtPB.Diachi + "','" + dtPB.Sodienthoai + "')";
cmd.CommandType = CommandType.Text;
cmd.Connection = conn.Connection;
try
{
conn.OpenConn();
cmd.ExecuteNonQuery();
conn.CloseConn();
return(true);
}
catch (Exception ex)
{
string mex = ex.Message;
cmd.Dispose();
conn.CloseConn();
}
return(false);
}
public bool UpdateData(PhongBanDT dtPB)
{
return(pbMH.UpdateData(dtPB));
}
public bool AddData(PhongBanDT dtPB)
{
return(pbMH.AddData(dtPB));
}
