public static int Create(ReviewCreateRequest review)
{
int id;
string connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand("dbo.Review_Insert", connection))
{
command.CommandType = CommandType.StoredProcedure;
SqlParameterCollection parameterCollection = command.Parameters;
parameterCollection.AddWithValue("@SubmissionID", review.SubmissionId);
parameterCollection.AddWithValue("@Rating", review.Rating);
parameterCollection.AddWithValue("@Comment", review.Comment);
parameterCollection.AddWithValue("@DepartmentID", review.DepartmentId);
parameterCollection.AddWithValue("@EmployeeName", review.Employee);
SqlParameter reviewId = new SqlParameter("@ReviewID", SqlDbType.Int);
reviewId.Direction = ParameterDirection.Output;
parameterCollection.Add(reviewId);
connection.Open();
command.ExecuteNonQuery();
int.TryParse(reviewId.Value.ToString(), out id);
}
}
return(id);
}
public ReviewViewModel Post(ReviewCreateRequest request)
{
var commentCreateRequest = new CommentCreateRequest()
{
Captcha = request.Captcha,
CustomData = request.CustomData,
Email = request.Email,
Message = request.Message,
Name = request.Name,
Rating = request.Rating,
Thread = request.Thread,
ThreadKey = request.ThreadKey
};
var commentResponse = this.PostInternal(commentCreateRequest);
var result = new ReviewViewModel()
{
AuthorIpAddress = commentResponse.AuthorIpAddress,
CustomData = commentResponse.CustomData,
DateCreated = commentResponse.DateCreated,
Email = commentResponse.Email,
Key = commentResponse.Key,
Message = commentResponse.Message,
Name = commentResponse.Name,
ProfilePictureThumbnailUrl = commentResponse.ProfilePictureThumbnailUrl,
ProfilePictureUrl = commentResponse.ProfilePictureUrl,
Rating = commentResponse.Rating,
Status = commentResponse.Status,
ThreadKey = commentResponse.ThreadKey
};
return(result);
}
public HttpResponseMessage Create(ReviewCreateRequest review)
{
ItemResponse <int> response = new ItemResponse <int>();
response.Item = ReviewService.Create(review);
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
public async Task <IActionResult> CreateReview(ReviewCreateRequest request)
{
if (ModelState.IsValid)
{
var result = await _reviewService.Create(request);
if (result.IsSuccessed)
{
var message = new EmailMessage
{
To = request.Email,
Subject = "Thank for review",
Content = "Thank you for reaching out to me. I really enjoyed my stay in your apartment and will make sure to come back next year.",
};
await _emailService.SendEmail(message);
return(RedirectToAction("detail", new { productId = request.ProductId }));
}
else
{
ModelState.AddModelError(string.Empty, result.Message);
return(View(request));
}
}
return(View(request));
}
public async Task <IActionResult> Create(ReviewCreateRequest request)
{
if (ModelState.IsValid == false)
{
return(BadRequest(ModelState));
}
var result = await _reviewService.Create(request);
if (result.IsSuccessed == false)
{
return(BadRequest(result));
}
return(Ok(result));
}
public async Task <ApiResult <string> > Create(ReviewCreateRequest request)
{
var json = JsonConvert.SerializeObject(request);
var httpContent = new StringContent(json, Encoding.UTF8, "application/json");
var response = await _client.PostAsync($"/api/reviews", httpContent);
var result = await response.Content.ReadAsStringAsync();
if (response.IsSuccessStatusCode)
{
return(JsonConvert.DeserializeObject <ApiResultSuccess <string> >(result));
}
return(JsonConvert.DeserializeObject <ApiResultErrors <string> >(result));
}
public async Task <ApiResult <bool> > Create(ReviewCreateRequest request)
{
var review = new Review()
{
Created_At = DateTime.Now,
Content = request.Content,
Email = request.Email,
Rating = request.Rating,
ProductId = request.ProductId,
Name = request.Name
};
_context.ReViews.Add(review);
return(await SaveChangeService.SaveChangeAsyncNotImage(_context));
}
