public void Add(OCTHDB item)
{
conn.connect();
var comm = new SqlCommand("CTHDB_Add", conn.db);
comm.CommandType = CommandType.StoredProcedure;
if (comm == null)
{
return;
}
comm.Parameters.Add("@MaHDB", SqlDbType.Int).Value = item.MaHDB;
comm.Parameters.Add("@MaSanPham", SqlDbType.Int).Value = item.MaSanPham;
comm.Parameters.Add("@SoLuong", SqlDbType.Int).Value = item.SoLuong;
comm.Parameters.Add("@ThanhTien", SqlDbType.Decimal).Value = item.ThanhTien;
comm.ExecuteNonQuery();
}
public bool Delete(OCTHDB item)
{
conn.connect();
var comm = new SqlCommand("CTHDB_Delete", conn.db);
comm.CommandType = CommandType.StoredProcedure;
if (comm == null)
{
return(false);
}
comm.Parameters.Add("@MaHDB", SqlDbType.Int).Value = item.MaHDB;
comm.Parameters.Add("@MaSanPham", SqlDbType.Int).Value = item.MaSanPham;
if (comm.ExecuteNonQuery() != 0)
{
return(true);
}
return(false);
}
