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