public bool ThichVatPham(ThichVatPham temp) { OpenConnection(); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.Text; command.CommandText = "insert into YeuThich(SDT,MaVP) values (@sdt,@mavp)"; command.Parameters.Add("@sdt", SqlDbType.NChar).Value = temp.SDT; command.Parameters.Add("@mavp", SqlDbType.Int).Value = Int32.Parse(temp.MaVP); command.Connection = conn; int ret = command.ExecuteNonQuery(); SqlCommand comm = new SqlCommand(); comm.CommandType = CommandType.StoredProcedure; comm.CommandText = "ThongBaoTaiKhoan"; comm.Connection = conn; comm.Parameters.Add("@sdt", SqlDbType.NChar).Value = temp.SDT; comm.Parameters.Add("@mavp", SqlDbType.Int).Value = Int32.Parse(temp.MaVP); comm.Parameters.Add("@noidungtb", SqlDbType.NVarChar).Value = "Có người thích sản phẩm của bạn"; comm.Parameters.Add("@src", SqlDbType.NVarChar).Value = "/ChiTietVatPham/" + temp.MaVP; int ret2 = comm.ExecuteNonQuery(); if (ret > 0 && ret2 > 0) { return(true); } return(false); }
public bool BoThich(ThichVatPham temp) { OpenConnection(); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.Text; command.CommandText = "delete from YeuThich where MaVP = @mavp and SDT= @sdt"; command.Parameters.Add("@sdt", SqlDbType.NChar).Value = temp.SDT; command.Parameters.Add("@mavp", SqlDbType.Int).Value = Int32.Parse(temp.MaVP); command.Connection = conn; int ret = command.ExecuteNonQuery(); if (ret > 0) { return(true); } return(false); }