public async Task AddReview()
{
CityReview rev = new CityReview();
rev.ReviewCategory = "Events";
rev.reviewItemID = CityEventID;
await Navigation.PushAsync(new AddReviewView(rev, Navigation));
}
public AddReviewView(CityReview review, INavigation navigation)
{
InitializeComponent();
ReviewViewModel vm = new ReviewViewModel(review, navigation);
this.BindingContext = vm;
// this.
}
public List <CityReview> returnReviews(string category)
{
try
{
SqlConnectionStringBuilder build = new SqlConnectionStringBuilder(ConnString);
build.UserID = "IhaveHiddenthisinthispublicrepository";
build.Password = @"IhaveHiddenthisinthispublicrepository";
string connstring = build.ConnectionString;
List <CityReview> myReviews = new List <CityReview>();
using (SqlConnection conn = new SqlConnection(connstring))
{
// conn.ConnectionString = ConnString;
conn.Open();
SqlCommand cmd = new SqlCommand(@"SELECT * FROM CityReviews", conn);
SqlDataReader reader = cmd.ExecuteReader();
string a = "";
while (reader.Read())
{
CityReview myReview = new CityReview();
myReview.ReviewID = (int)reader[0];
myReview.ReviewCategory = reader[1].ToString();
myReview.ReviewItemID = (int)reader[2];
myReview.ReviewRating = reader[3].ToString();
myReview.ReviewText = reader[4].ToString();
myReviews.Add(myReview);
}
conn.Close();
}
return(myReviews);
}
catch (Exception e)
{
_logger.LogError(e.InnerException.ToString());
return(null);
}
}
public async void PostReview(CityReview review)
{
using (HttpClient client = new HttpClient())
{
client.BaseAddress = new Uri(@"http://35.195.148.99/api/reviews");
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(
new MediaTypeWithQualityHeaderValue("application/json"));
string abc = JsonConvert.SerializeObject(review);
StringContent c = new StringContent(JsonConvert.SerializeObject(review), Encoding.UTF8, "application/json");
var response = await client.PostAsync(client.BaseAddress, c);
}
}
public void Post([FromBody] JToken value)
{
var a = value.ToString();
CityReview review = new CityReview();
review.ReviewCategory = (string)value["ReviewCategory"];
review.ReviewItemID = (int)value["reviewItemID"];
review.ReviewRating = (string)value["reviewRating"];
review.ReviewText = (string)value["reviewText"];
ReviewsRepository repo = new ReviewsRepository(_logger);
repo.addReview(review);
_logger.LogInformation("Value added");
}
public void addReview(CityReview c)
{
SqlConnectionStringBuilder build = new SqlConnectionStringBuilder(ConnString);
build.UserID = "IhaveHiddenthisinthispublicrepository";
build.Password = @"IhaveHiddenthisinthispublicrepository";
string connstring = build.ConnectionString;
using (SqlConnection conn = new SqlConnection(connstring))
{
conn.Open();
string sql = @"INSERT INTO CityReviews(ReviewCategory,ReviewItemID,ReviewRating,ReviewText)";
sql += @"VALUES('" + c.ReviewCategory + "'," + c.ReviewItemID + ",'" + c.ReviewRating + "','" + c.ReviewText + "');";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
}
public ReviewViewModel(CityReview review, INavigation navigation)
{
item = review;
Navigation = navigation;
}
