public void UpdateReview(BALReview obj)
{
query = "update Review set ReviewContent='" + obj.ReviewContent + "',UserId=" + obj.UserId + ",BusinessId=" + obj.BusinessId + ",ReviewDate='" + obj.ReviewDate + "',ReviewStatus='" + obj.ReviewStatus + "',Rating=" + obj.Rating + "where ReviewId=" + obj.ReviewId;
SqlCommand cmd = new SqlCommand(query,con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void InsertReview(BALReview obj)
{
query = "insert into Review(ReviewContent,UserId,BusinessId,ReviewDate,ReviewStatus,Rating) values ('" + obj.ReviewContent + "'," + obj.UserId + "," + obj.BusinessId + ",'" + obj.ReviewDate + "','" + obj.ReviewStatus + "'," + obj.Rating + ")";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public DataSet SelectReviewByBusinessID(BALReview obj)
{
query = "select * from Review r inner join [User] u on r.UserId=u.UserId inner join Business b on r.BusinessId=b.BusinessId inner join Login l on u.LoginId=l.LoginId where r.BusinessId="+obj.BusinessId;
DataSet ds = new DataSet();
SqlDataAdapter adp = new SqlDataAdapter(query, con);
adp.Fill(ds);
return ds;
}
public void DeleteReview(BALReview obj)
{
query = "delete from Review where ReviewId=" + obj.ReviewId;
SqlCommand cmd = new SqlCommand(query,con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
