public bool CapNhaphang(BEL_Hang hang, string mahang)
{
bool ketqua = false;
try
{
GetCon();
string sql = "Update tbHang set MaHang ='" + hang.MaHang + "' ,TenHang = N'" + hang.TenHang +
"' , SoLuong ='" + hang.SoLuong + "' , Loai ='" + hang.Loai + "', NhaCungCap = '" + hang.NCC + "' ,TThai ='" + hang.TThai + "', Hinh = N'" + hang.Hinh + "' Where MaHang ='" + mahang + "'";
SqlCommand commmand = new SqlCommand(sql, con);
if (commmand.ExecuteNonQuery() > 0)
{
ketqua = true;
}
}
catch (Exception err)
{
}
finally
{
con.Close();
}
return(ketqua);
}
public bool Themhang(BEL_Hang hang)
{
bool ketqua = false;
try
{
GetCon();
string sql = "INSERT INTO tbHang(MaHang,TenHang,SoLuong,Loai,Gia,NhaCungCap,Hinh,TThai) VALUES('" + hang.MaHang + "',N'" + hang.TenHang + "','" + hang.SoLuong +
"','" + hang.Loai + "','" + hang.Gia + "',N'" + hang.NCC + "','" + hang.Hinh + "','" + hang.TThai + "')";
SqlCommand commmand = new SqlCommand(sql, con);
if (commmand.ExecuteNonQuery() > 0)
{
ketqua = true;
}
}
catch (Exception err)
{
}
finally
{
con.Close();
}
return(ketqua);
}
public bool CapNhaphang(BEL_Hang hang, string mahang)
{
var xuly = new DAL_Hang();
return(xuly.CapNhaphang(hang, mahang));
}
public bool Themhang(BEL_Hang hang)
{
var xuly = new DAL_Hang();
return(xuly.Themhang(hang));
}
