public bool UpdateRateItem(Rating rating)
{
if (rating == null)
{
return(false);
}
query = $@"UPDATE Ratings
SET ratingStars = {rating.RatingStars}, ratingTitle = '{rating.RatingTitle}', ratingContent = '{rating.RatingContent}', ratingDate = NOW()
WHERE itemID = {rating.ItemId} and userID = {rating.UserId};";
try
{
int numberEffect = DbHelper.ExecNonQuery(query, DbHelper.OpenConnection());
if (numberEffect == 0)
{
return(false);
}
}
catch (System.Exception)
{
return(false);
}
finally
{
DbHelper.CloseConnection();
}
return(true);
}
public bool DeleteItemInShoppingCartByIdItem(int?itemId)
{
if (itemId == null)
{
return(false);
}
query = $@"DELETE FROM orderDetails where itemId = {itemId};";
MySqlConnection connection = DbHelper.OpenConnection();
if (DbHelper.ExecNonQuery(query, connection) == 0)
{
DbHelper.CloseConnection();
return(false);
}
DbHelper.CloseConnection();
return(true);
}
public bool UpdateStatusShoppingCartById(bool isHave, int?userId)
{
if (userId == null)
{
return(false);
}
switch (isHave)
{
case true:
query = $@"update Users set userShoppingCart = false where userId = {userId}";
break;
case false:
query = $@"update Users set userShoppingCart = true where userId = {userId}";
break;
}
DbHelper.ExecNonQuery(query, DbHelper.OpenConnection());
DbHelper.CloseConnection();
return(true);
}
public bool RateItem(Rating rating)
{
if (rating == null)
{
return(false);
}
query = $@"insert into Ratings values
({rating.ItemId},{rating.UserId},'{rating.RatingStars}','{rating.RatingTitle}','{rating.RatingContent}',NOW());";
try
{
DbHelper.ExecNonQuery(query, DbHelper.OpenConnection());
}
catch (System.Exception)
{
return(false);
}
finally
{
DbHelper.CloseConnection();
}
return(true);
}