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); }