//UPDATE RECOMMENDATION public static int UpdateRecommendation(Recommendation recommendation) { try { command.CommandText = $"UPDATE RECOMMENDATIONS " + $" SET USER_ID = {recommendation.UserId} , " + $" DESTINATION_CODE = {recommendation.DestinationCode} ," + $" DESCRIPTION = N'{recommendation.Description}' , " + $" POST_IMAGE = N'{recommendation.PostImage}' ," + $" UPLOAD_DATE = '{recommendation.UploadDate}' " + $" WHERE RECO_ID = {recommendation.RecoId}"; con.Open(); int rowsAffected = command.ExecuteNonQuery(); return(rowsAffected); } finally { if (con.State == ConnectionState.Open) { con.Close(); } } }
//READ ONE RECOMMENDATION BY ID public static Recommendation GetRecommendationById(int RECO_ID) { Recommendation countryToReturn = ExecReader($"SELECT * FROM RECOMMENDATIONS WHERE RECO_ID = {RECO_ID} ").FirstOrDefault(); return(countryToReturn); }