public IHttpActionResult GetReviewById(int id) { ReviewService service = CreateReviewService(); ReviewDetail review = service.GetReviewById(id); return(Ok(review)); }
public void SaveReviewDetail(Sender sender, ReviewDetail obj) { try { using (ObjectProxy op = new ObjectProxy(true)) { if (op.LoadReviewDetail(obj) == 0) { obj.Created = DateTime.Now; obj.CreatedBy = sender.UserCode + "." + sender.UserName; op.InsertReviewDetail(obj); } else { obj.Created = DateTime.Now; obj.CreatedBy = sender.UserCode + "." + sender.UserName; op.UpdateReviewDetailByTransID(obj); } op.CommitTransaction(); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public ActionResult DeleteConfirmed(int id) { ReviewDetail reviewDetail = db.ReviewDetails.Find(id); db.ReviewDetails.Remove(reviewDetail); db.SaveChanges(); return(RedirectToAction("Index")); }
public void Post([FromBody] ReviewDetail reviewDetail) { ReviewDetail obja = new ReviewDetail(); obja = reviewDetail; obja.createdDate = DateTime.Now; _context.ReviewDetail.Add(obja); _context.SaveChanges(); }
// GET BY ID - READ public ZooListItems GetZooById(int id) { AttractionService attractionService = new AttractionService(); ReviewService reviewService = new ReviewService(); using (var ctx = new ApplicationDbContext()) { var entity = ctx .Zoos .SingleOrDefault(e => e.ZooId == id); foreach (Attraction attraction in entity.Attractions) { AttractionDetail attractionDetail = attractionService.GetAttractionById(attraction.AttId); var detail = new ZooListItems { ZooId = entity.ZooId, ZooName = entity.ZooName, Location = entity.Location, ZooSize = entity.ZooSize, AZAAccredited = entity.AZAAccredited, Admission = entity.Admission, AverageRating = entity.AverageRating, AttractionDetails = attractionDetail, AllZooReviews = new List <ReviewDetail>() //entity.AllZooReviews.Select(e=>reviewService.GetReviewById(e.ReviewId)).ToList() }; foreach (Review review in entity.AllZooReviews) { ReviewDetail reviewDetail = reviewService.GetReviewById(review.ReviewId); detail.AllZooReviews.Add(reviewDetail); } return(detail); } var zooDetail = new ZooListItems { ZooId = entity.ZooId, ZooName = entity.ZooName, Location = entity.Location, ZooSize = entity.ZooSize, AZAAccredited = entity.AZAAccredited, Admission = entity.Admission, AverageRating = entity.AverageRating, AllZooReviews = new List <ReviewDetail>() }; foreach (Review review in entity.AllZooReviews) { ReviewDetail reviewDetail = reviewService.GetReviewById(review.ReviewId); zooDetail.AllZooReviews.Add(reviewDetail); } return(zooDetail); } }
public ActionResult Edit([Bind(Include = "ReviewDetailID,ReviewID,UserID,ReviewDate,Reply,ISvisible")] ReviewDetail reviewDetail) { if (ModelState.IsValid) { db.Entry(reviewDetail).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ReviewID = new SelectList(db.Reviews, "ReviewID", "UserID", reviewDetail.ReviewID); return(View(reviewDetail)); }
/// <summary> /// 撤回评审 /// </summary> /// <param name="detailid"></param> /// <returns></returns> public ActionResult ReviewManager_WithDraw(int detailid) { var reviewdetail = Config.Helper.SingleById <ReviewDetail>(detailid); if (reviewdetail.ReviewStatus == ReviewStatus.Reviewed) { return(Error("此次评审已经全部结束,无法撤回")); } //撤回 ReviewDetail.WithDraw(reviewdetail); return(SuccessRedirect("提交成功", "/Manager/ReviewManager_Summary?id=" + reviewdetail.ReviewID)); }
// GET: ReviewDetails/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ReviewDetail reviewDetail = db.ReviewDetails.Find(id); if (reviewDetail == null) { return(HttpNotFound()); } return(View(reviewDetail)); }
// GET: ReviewDetails/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ReviewDetail reviewDetail = db.ReviewDetails.Find(id); if (reviewDetail == null) { return(HttpNotFound()); } ViewBag.ReviewID = new SelectList(db.Reviews, "ReviewID", "UserID", reviewDetail.ReviewID); return(View(reviewDetail)); }
public ActionResult Review(int detailid, FormCollection collection) { var publish = collection["publish"] == "1" ? true : false; var projectdetails = Newtonsoft.Json.JsonConvert.DeserializeObject <List <ReviewVoteExpertProjectDetail> >(collection["data"]); ReviewDetail.Review(detailid, projectdetails, publish); if (publish) { return(SuccessRedirect("提交成功", "/Expert/")); } else { return(Success("暂存成功")); } }
public ReviewDetail GetReviewById(int Id) { Review reviewToGet = _context.Reviews.Single(r => r.ReviewId == Id); ReviewDetail review = new ReviewDetail { ReviewId = reviewToGet.ReviewId, UserId = reviewToGet.UserId, Score = reviewToGet.Score, ReviewText = reviewToGet.ReviewText, CreatedUtc = reviewToGet.CreatedUtc, ModifiedUtc = reviewToGet.ModifiedUtc }; return(review); }
public ActionResult Detail(int?reviewId, string returnUrl) { if (reviewId == null) { return(RedirectToAction("List")); } ReviewDetail model = new ReviewDetail() { Review = repository.Reviews.FirstOrDefault(x => x.ReviewID == reviewId) ?? new Review(), ReturnUrl = returnUrl }; return(View(model)); }
public IActionResult Review(ReviewDetail model) { string reviewContnt = HttpContext.Request.Form["reviewBox"]; string restaurantId = HttpContext.Request.Form["restaurantId"]; ReviewDetail objreview = new ReviewDetail(); objreview.createdDate = DateTime.Now; objreview.restaurantId = Convert.ToInt32(restaurantId); objreview.review = reviewContnt; _context.ReviewDetail.Add(objreview); _context.SaveChanges(); var reviews = _context.ReviewDetail.Where(a => a.restaurantId == Convert.ToInt32(restaurantId)).OrderByDescending(a => a.createdDate).ToList(); return(View(reviews)); }
public ActionResult ReviewManager_Add(FormCollection collection) { var review = new Review(); var reviewdetail = new ReviewDetail(); var reviewmethodsetting = new ReviewMethodSetting(); review.InjectFrom <RequestInjection>(Request); reviewdetail.InjectFrom <RequestInjection>(Request); reviewmethodsetting.InjectFrom <RequestInjection>(Request); reviewdetail.ReviewMethod = (ReviewMethod)Convert.ToInt32(Request.Form["reviewmethod"]); if (review.AwardID == 0) { return(Error("请选择奖项")); } if (review.ReviewName.IsNullOrEmpty()) { return(Error("请输入评审活动说明")); } if (Config.Helper.Count <Review>("where awardid=@0 and isdelete=0 and reviewname=@1", review.AwardID, review.ReviewName) > 0) { return(Error("相同评审活动名称已存在")); } if (reviewdetail.TargetNumber == 0) { return(Error("请输入目标数量")); } if (reviewdetail.ReviewMethod == ReviewMethod.Average && (reviewmethodsetting.MaxScore == 0 || reviewmethodsetting.MinScore == 0 || reviewmethodsetting.ScoreStep == 0)) { return(Error("请正确设置参数")); } if (reviewdetail.ReviewMethod == ReviewMethod.Weighting && (reviewmethodsetting.MaxScore == 0 || reviewmethodsetting.MinScore == 0 || reviewmethodsetting.ScoreStep == 0 || reviewmethodsetting.WeightLast == 0 || reviewmethodsetting.WeightNow == 0)) { return(Error("请正确设置参数")); } if (reviewdetail.ReviewMethod == ReviewMethod.Vote && (reviewmethodsetting.VoteNumber == 0)) { return(Error("请正确设置参数")); } if (review.Award.ProjectCount < reviewdetail.TargetNumber) { return(Error("目标数量不能大于参选项目总数")); } var ispublish = collection["publish"] == "1"; Review.AddReview(review, reviewdetail, reviewmethodsetting, ispublish); return(SuccessCallback("提交成功", "location.href='/Manager/ReviewManager_List'")); }
public List <ReviewDetail> GetReviewDetailByTransID(Sender sender, Guid TransID) { try { using (ObjectProxy op = new ObjectProxy()) { ReviewDetail obj = new ReviewDetail(); obj.TransID = TransID; return(op.LoadReviewDetailByTransID(obj)); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
private void BuildTableData(DataTable dt, Review review, ReviewDetail reviewdetail, Award award, List <ProjectReviewDetail> projectreviewdetails) { var experts = award.Experts; //显示的最大轮数 var maxshowturn = reviewdetail.Turn == 1 ? review.ReviewDetails.Where(o => o.ReviewStatus == TFA.Vote.Models.ReviewStatus.Reviewed && o.Round == reviewdetail.Round).Max(o => o.Turn) : reviewdetail.Turn; var allreviewdetails = review.ReviewDetails.Where(o => o.Round == reviewdetail.Round).ToList(); foreach (var p in projectreviewdetails) { var awardproject = Config.Helper.CreateWhere <AwardProject>() .Where(o => o.AwardID == award.ID && o.ProjectID == p.ID).SingleOrDefault(); var row = dt.NewRow(); row["排名"] = p.Rank; row["序号"] = p.Sort; row["项目名称"] = p.ProjectName; if (reviewdetail.ReviewMethod == ReviewMethod.Weighting) { row["加权得分"] = p.Score; } row["本轮得分"] = p.OriScore; if (reviewdetail.Round == 1 && reviewdetail.Turn == 1 && reviewdetail.ReviewMethod != ReviewMethod.Vote) { row["基础分"] = awardproject?.BaseScore; } //补投列 for (var i = 2; i <= maxshowturn; i++) { row["补投" + (i - 1)] = p.SubScores[i - 2]; } //专家打分列 for (var i = 1; i <= maxshowturn; i++) { var expertprojectreviewdetail = allreviewdetails[i - 1].VoteDetails; experts.ForEach(o => { var projectdetail = expertprojectreviewdetail.Single(e => e.ExpertID == o.ID).VoteProjectDetail.SingleOrDefault(e => e.ProjectID == p.ID); if (projectdetail != null) { row[o.RealName + i] = projectdetail.IsAvoid ? "" : (allreviewdetails[i - 1].ReviewMethod == ReviewMethod.Vote ? (projectdetail.VoteFlag?"Y":"") : projectdetail.Score.ToString()); } }); } dt.Rows.Add(row); } }
public ReviewDetail GetReviewById(int id) { using (var ctx = new ApplicationDbContext()) { var entity = ctx.Reviews.Single(r => r.ReviewId == id); var model = new ReviewDetail { ReviewId = entity.ReviewId, ProductId = entity.ProductId, ProductName = entity.Product.ProductName, Message = entity.Message, Rating = entity.Rating }; return(model); } }
public ActionResult Create([Bind(Include = "ReviewDetailID,ReviewID,UserID,ReviewDate,Reply,ISvisible")] ReviewDetail reviewDetail) { var UserID = User.Identity.GetUserId(); if (ModelState.IsValid) { reviewDetail.ReviewID = reviewDetail.ReviewID; reviewDetail.UserID = UserID; reviewDetail.ReviewDate = DateTime.Now; reviewDetail.ISvisible = true; db.ReviewDetails.Add(reviewDetail); db.SaveChanges(); return(RedirectToAction("Index", "Reviews")); } ViewBag.ReviewID = new SelectList(db.Reviews, "ReviewID", "UserID", reviewDetail.ReviewID); return(View(reviewDetail)); }
public ReviewDetail GetReviewById(int id) { var entity = _context.Reviews.Find(id); if (entity == null) { return(null); } var detail = new ReviewDetail { ReviewId = entity.ReviewId, Rating = entity.Rating, ReviewText = entity.ReviewText, VisitDate = entity.VisitDate, ZooId = entity.ZooId, }; return(detail); }
public ReviewDetail GetReviewDetail(Sender sender, Guid TransID) { try { using (ObjectProxy op = new ObjectProxy()) { ReviewDetail obj = new ReviewDetail(); obj.TransID = TransID; if (op.LoadReviewDetail(obj) == 0) { return(null); } return(obj); } } catch (Exception ex) { PLogger.LogError(ex); throw ex; } }
public ActionResult ReviewManager_Edit(FormCollection collection) { var detailid = Convert.ToInt64(collection["id"]); var reviewdetail = Config.Helper.SingleById <ReviewDetail>(detailid); var reviewmethodsetting = new ReviewMethodSetting(); reviewdetail.InjectFrom <RequestInjection>(Request); reviewmethodsetting.InjectFrom <RequestInjection>(Request); reviewdetail.ReviewMethod = (ReviewMethod)Convert.ToInt32(Request.Form["reviewmethod"]); if (reviewdetail.TargetNumber == 0) { return(Error("请输入目标数量")); } if (reviewdetail.ReviewMethod == ReviewMethod.Average && (reviewmethodsetting.MaxScore <= 0 || reviewmethodsetting.MinScore <= 0 || reviewmethodsetting.ScoreStep <= 0)) { return(Error("请正确设置参数")); } if (reviewdetail.ReviewMethod == ReviewMethod.Weighting && (reviewmethodsetting.MaxScore <= 0 || reviewmethodsetting.MinScore <= 0 || reviewmethodsetting.ScoreStep <= 0 || reviewmethodsetting.WeightLast <= 0 || reviewmethodsetting.WeightNow <= 0)) { return(Error("请正确设置参数")); } if (reviewdetail.ReviewMethod == ReviewMethod.Weighting && (reviewmethodsetting.WeightLast + reviewmethodsetting.WeightNow != 100)) { return(Error("本轮权重与上轮权重之和必须为100")); } if (reviewdetail.ReviewMethod == ReviewMethod.Vote && (reviewmethodsetting.VoteNumber <= 0)) { return(Error("请正确设置参数")); } if (reviewdetail.SourceProjectIDs.Split(',').Count() < reviewdetail.TargetNumber) { return(Error("目标数量不能小于参选项目总数")); } var ispublish = collection["publish"] == "1"; ReviewDetail.EditDetail(reviewdetail, reviewmethodsetting, ispublish); return(SuccessCallback("提交成功", "location.href='/Manager/ReviewManager_Summary?id=" + reviewdetail.ReviewID + "'")); }
/// <summary> /// 构建表格结构 /// </summary> /// <param name="review"></param> /// <param name="reviewdetail"></param> /// <param name="award"></param> /// <returns></returns> private DataTable BuildProjectTable(Review review, ReviewDetail reviewdetail, Award award) { var experts = award.Experts; var dt = new DataTable(); var c = 53;//起始颜色 dt.Columns.AddRange(new DataColumn[] { new DataColumn("排名"), new DataColumn("序号"), new DataColumn("项目名称") }); if (reviewdetail.ReviewMethod == ReviewMethod.Weighting) { //如果是与上轮加权的,需要增加一列 dt.Columns.Add("加权得分").Prefix = "c" + c--.ToString(); } dt.Columns.Add("本轮得分").Prefix = "c" + c--.ToString(); if (reviewdetail.Round == 1 && reviewdetail.Turn == 1 && reviewdetail.ReviewMethod != ReviewMethod.Vote) { dt.Columns.Add("基础分").Prefix = "c" + c.ToString(); } //补投列 //显示的最大轮数 var maxshowturn = reviewdetail.Turn == 1 ? review.ReviewDetails.Where(o => o.ReviewStatus == TFA.Vote.Models.ReviewStatus.Reviewed && o.Round == reviewdetail.Round).Max(o => o.Turn) : reviewdetail.Turn; for (var i = 2; i <= maxshowturn; i++) { dt.Columns.Add("补投" + (i - 1)).Prefix = "c" + c--.ToString(); } //专家打分列 for (var i = 1; i <= maxshowturn; i++) { experts.ForEach(o => { dt.Columns.Add(o.RealName + i).Prefix = "c" + (c + i - 1).ToString(); }); } return(dt); }
public void ViewReviewById() { Console.Write("Enter Zoo ID: "); int userInput = int.Parse(Console.ReadLine()); _client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", _token); var readTask = _client.GetAsync("https://localhost:44322/api/Review/"); var response = readTask.Result; if (response.IsSuccessStatusCode) { Console.Clear(); ReviewDetail review = _client.GetAsync($"https://localhost:44322/api/Review/{userInput}").Result.Content.ReadAsAsync <ReviewDetail>().Result; if (review != null) { Console.WriteLine($"Review ID: {review.ReviewId}\n" + $"Zoo ID {review.ZooId}" + $"Rating: {review.Rating}\n" + $"Review Text: {review.ReviewText}\n" + $"VisitDate: {review.VisitDate}\n"); } Console.ReadLine(); } }
public void OrderReview() { try { using (ProxyBE p = new ProxyBE()) { string OrderID = Request["OrderID"]; if (string.IsNullOrEmpty(OrderID)) { throw new Exception("OrderID:参数无效"); } string Remark = Request["Remark"]; if (string.IsNullOrEmpty(Remark)) { throw new Exception("Remark:参数无效"); } Order order = p.Client.GetOrder(SenderUser, Guid.Parse(OrderID)); if (order.Status.ToUpper() == OrderStatus.F.ToString()) { SaveOrderArgs args = new SaveOrderArgs(); OrderStep step = p.Client.GetOrderStepByStepCode(SenderUser, StepCode.ordersreview.ToString()); OrderStepLog ot = new OrderStepLog(); ot.StepID = Guid.NewGuid(); ot.OrderID = order.OrderID; ot.StepNo = step.StepNo; ot.StepName = step.StepName; ot.Remark = Remark; args.OrderStepLog = ot; order.Status = OrderStatus.G.ToString(); order.StepNo = step.StepNo; args.Order = order; p.Client.SaveOrder(SenderUser, args); p.Client.UpdatePartnerOrder(args.Order); } #region PartnerTransDetail string Payee = Request["Payee"].ToString(); //收款人 string Amount = Request["Amount"].ToString(); //收款金额 string TransDate = Request["TransDate"].ToString(); //收款日期 string VoucherNo = Request["VoucherNo"].ToString(); //凭证号 if (!string.IsNullOrEmpty(Payee) && !string.IsNullOrEmpty(Amount) && !string.IsNullOrEmpty(TransDate) && !string.IsNullOrEmpty(VoucherNo)) { ReviewDetail model = new ReviewDetail() { TransID = Guid.NewGuid(), OrderID = order.OrderID, Payee = Payee, Amount = decimal.Parse(Amount), TransDate = Convert.ToDateTime(TransDate), VoucherNo = VoucherNo, }; p.Client.SaveReviewDetail(SenderUser, model); } #endregion #region ProductBOM List <OrderProduct> list = p.Client.GetOrderProductByOrderID(SenderUser, order.OrderID); foreach (OrderProduct Item in list) { ProductBOM model = new ProductBOM() { ProductCode = Item.ProductCode, Status = false, }; p.Client.SaveProductBOM(SenderUser, model); } #endregion } WriteSuccess(); } catch (Exception ex) { WriteError(ex.Message, ex); } }
public void UpdateReview() { Console.Clear(); Console.Write("Enter the Review ID for the Review You'd like to update: "); int id = int.Parse(Console.ReadLine()); _client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", _token); var getTask = _client.GetAsync("https://localhost:44322/api/Review/"); var response = getTask.Result; ReviewDetail oldReview = new ReviewDetail(); if (response.IsSuccessStatusCode) { Console.Clear(); oldReview = _client.GetAsync("https://localhost:44322/api/Review/{id}").Result.Content.ReadAsAsync <ReviewDetail>().Result; if (oldReview != null) { Console.WriteLine($"Review ID: {oldReview.ReviewId}\n" + $"Zoo ID {oldReview.ZooId}" + $"Rating: {oldReview.Rating}\n" + $"Review Text: {oldReview.ReviewText}\n" + $"VisitDate: {oldReview.VisitDate}\n"); } else { Console.WriteLine("The animals must have been hungry and ate that ID, please enter a valid Review ID."); } } //Console.Write("Zoo ID: "); //string zooId = Console.ReadLine(); // Need to figure out how to make it automatically use the key method for ZooId //newZoo.Add("ZooId", zooId); Dictionary <string, string> newReview = new Dictionary <string, string>(); Console.Write("Zoo ID: "); int zooId = int.Parse(Console.ReadLine()); newReview.Add("ZooId", zooId.ToString()); Console.Write("Rating: "); int rating = int.Parse(Console.ReadLine()); newReview.Add("Rating", rating.ToString()); Console.Write("Review Text: "); string reviewText = Console.ReadLine(); newReview.Add("Review Text", reviewText); Console.Write("Date of Visit: "); DateTime visitDate = DateTime.Parse(Console.ReadLine()); newReview.Add("Date of Visit", visitDate.ToString()); HttpContent newReviewHTTP = new FormUrlEncodedContent(newReview); var putResponse = _client.PostAsync("https://localhost:44322/api/Review/", newReviewHTTP); if (putResponse.Result.IsSuccessStatusCode) { Console.WriteLine("Review Successfully Created."); } else { Console.WriteLine("Failed to create Review."); } Console.ReadKey(); }