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