public ActionResult Create([Bind(Include = "CONTENT")] REVIEW review)
{
if (ModelState.IsValid)
{
review.REVIEWDATE = DateTime.Now.ToString("yyyy-MM-dd");
/*
* review.BOOKID
* review.CHAPTERID
*/
var que = from p in db.REVIEW
group p by p.COMMENTID into g
select new { g.Key, COUNT = g.Count() };
var ans = que.Count();
var currentid = ans.ToString();
for (int i = 0; i < 8 - currentid.Length; ++i)
{
currentid = "0" + currentid;
}
review.COMMENTID = currentid;
review.FLOORNUMBER = 0;
string userid = Request.Cookies["_userid"].Value;
review.ID = userid;
db.REVIEW.Add(review);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(review));
}
public ActionResult Edit([Bind(Include = "REVIEW_ID,PID,WRITER,SCORE,UPDATE_DATE,REVIEW_COMMENT,REVIEW_IMAGE")] REVIEW review)
{
if (ModelState.IsValid)
{
if (Request.Files.Count > 0)
{
var file = Request.Files[0];
if (file != null &&
file.ContentLength > 0)
{
var fileName = "review_img_" + review.REVIEW_ID + "_" + Path.GetFileName(file.FileName);
var path = Path.Combine(Server.MapPath("~/images/"), fileName);
file.SaveAs(path);
review.REVIEW_IMAGE = fileName;
}
}
else
{
var old_review = db.REVIEW.Find(review.REVIEW_ID);
review.REVIEW_IMAGE = old_review.REVIEW_IMAGE;
}
db.Entry(review).State = EntityState.Modified;
db.SaveChanges();
return(Redirect("~/Place/Details/" + review.PID));
}
ViewBag.PID = new SelectList(db.PLACE, "ID", "STORE_NAME", review.PID);
return(View(review));
}
public async Task OnGetAsync(int?id)
{
if (HttpContext.Session.Get("Id") != null)
{
byte[] str = HttpContext.Session.Get("Id");
string ID = Encoding.UTF8.GetString(str, 0, str.Length);
ViewData["Userid"] = ID;
//Console.Out.Write(ViewData["Userid"]);
}
if (HttpContext.Session.Get("Role") != null)
{
byte[] str = HttpContext.Session.Get("Role");
string Role = Encoding.UTF8.GetString(str, 0, str.Length);
ViewData["UserRole"] = Role;
}
USERS = _context.getUserList();
REVIEW = _context.getReviewList();
PRODUCTS = _context.getProductList();
count = REVIEW.Count();
for (int i = 0; i < USERS.Count(); i++)
{
//Msg1 = "In";
//ID;s validation
if (USERS[i].U_ID == id)
{
currentUserID = USERS[i].U_ID - 1;//-1 because ID start from 1, but list is start from 0
}
}
}
public bool AddReview(String review, int bookid, int userid)
{
try
{
if (String.IsNullOrWhiteSpace(review))
{
return(false);
}
REVIEW reviewData = new REVIEW()
{
REVIEW1 = review,
BOOKID = bookid,
USERID = userid
};
dataAccess.REVIEWs.InsertOnSubmit(reviewData);
dataAccess.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public HttpResponseMessage put(int id, REVIEW review)
{
try
{
using (ReviewEntities entities = new ReviewEntities())
{
var entity = entities.REVIEW.FirstOrDefault(e => e.ReviewId == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Review doesnt exist"));
}
else
{
entity.Rating = review.Rating;
entity.Comment = review.Comment;
entity.GenerateReviewId = review.GenerateReviewId;
entity.EmployeeId = review.EmployeeId;
entity.PerameterId = review.PerameterId;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public async Task <IActionResult> InsertReview(ReviewViewModel view)
{
var exista_cititor = repository.VerifyReaderByNameAsync(view.CITITOR.Nume.Trim() + " " + view.CITITOR.Prenume.Trim()).Result.ToList();
var queryCititorId = repository.GetReaderAsync(exista_cititor[0].CititorId);
var queryCarteImprumut = repository.GetLoanByBookTitleReaderIdAsync(view.CARTE.Titlu.Trim(), queryCititorId.Result.CititorId).Result.ToList();
if (queryCarteImprumut.LongCount() == 0)
{
return(RedirectToAction("NotPossible", "Home", view));
}
var queryCarteId = repository.GetBookAsync(queryCarteImprumut[0].CarteId);
if (queryCarteId.Result.CarteId > 0)
{
int idCarte = queryCarteId.Result.CarteId;
var queryDateCarteImprumutata = repository.GetLoanAsync(queryCarteImprumut[0].ImprumutId);
IMPRUMUT loan = new IMPRUMUT
{
DataRestituire = DateTime.Now,
ImprumutId = queryDateCarteImprumutata.Result.ImprumutId,
DataImprumut = queryDateCarteImprumutata.Result.DataImprumut,
DataScadenta = queryDateCarteImprumutata.Result.DataScadenta,
CititorId = queryDateCarteImprumutata.Result.CititorId,
CarteId = queryDateCarteImprumutata.Result.CarteId,
};
view.IMPRUMUT = loan;
await repository.UpdateLoanAsync(view.IMPRUMUT);
// issues, I think
var queryDateImprumut = repository.GetLoanAsync(idCarte).Result;
var queryCititorImprumut = repository.GetLoanAsync(idCarte).Result;
if (queryDateImprumut.DataRestituire > queryDateImprumut.DataScadenta)
{
var queryStareCititor = repository.GetReaderAsync(queryCititorImprumut.CititorId);
view.CITITOR.CititorId = queryStareCititor.Result.CititorId;
view.CITITOR.Nume = queryStareCititor.Result.Nume;
view.CITITOR.Prenume = queryStareCititor.Result.Prenume;
view.CITITOR.Email = queryStareCititor.Result.Email;
view.CITITOR.Adresa = queryStareCititor.Result.Adresa;
view.CITITOR.Stare = 1;
await repository.UpdateReaderAsync(view.CITITOR);
}
REVIEW review = new REVIEW
{
Text = view.REVIEW.Text,
ImprumutId = queryDateImprumut.ImprumutId
};
view.REVIEW = review;
await repository.InsertReviewAsync(view.REVIEW);
}
return(RedirectToAction("AfisareReview", "Review", view));
}
public ActionResult Reply([Bind(Include = "CONTENT")] REVIEW review)
{
if (ModelState.IsValid)
{
var que = from p in db.REVIEW
group p by p.COMMENTID into g
select new { g.Key, COUNT = g.Count() };
//commentid从客户端获取
var floorid = from q in que
where q.Key == ""
//where q.Key == commentid
select q.COUNT;
//floorid = floorid + 1;
//review.FLOORNUMBER = floorid;
db.REVIEW.Add(review);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(review));
}
public string DeleteReview(REVIEW review)
{
var message = "";
try
{
var toDelete = new REVIEW();
toDelete = review.ReviewId == 0 ? context.REVIEWs.FirstOrDefault(t => t.ReviewId == review.ReviewId) : context.REVIEWs.FirstOrDefault(t => t.ReviewId == review.ReviewId);
if (toDelete != null)
{
context.REVIEWs.Remove(toDelete);
context.SaveChanges();
}
else
{
message = "This review does not exist or has already been deleted!";
}
}
catch (Exception e)
{
message = e.Message;
}
return(message);
}
public ActionResult DeleteConfirmed(int id)
{
REVIEW rEVIEW = db.REVIEW.Find(id);
db.REVIEW.Remove(rEVIEW);
db.SaveChanges();
return(RedirectToAction("Index"));
}
internal ReviewDTO getReviewDTO(REVIEW review)
{
return(new ReviewDTO()
{
ReviewId = review.ReviewId,
Text = review.Text
});
}
public REVIEW UpdateReview(REVIEW review)
{
using (var context = new ModelDatabaseFirst())
{
context.REVIEWs.AddOrUpdate(review);
context.SaveChanges();
return(review);
}
}
public REVIEWDTO S_review_dto(REVIEW r)
{
return(new REVIEWDTO()
{
ReviewId = r.ReviewId,
ImprumutId = r.ImprumutId,
Text = r.Text
});
}
public ActionResult Edit([Bind(Include = "ID,CONTENT,AUTHOR,RATE,MOVIEID")] REVIEW rEVIEW)
{
if (ModelState.IsValid)
{
db.Entry(rEVIEW).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MOVIEID = new SelectList(db.MOVIE, "ID", "TITLE", rEVIEW.MOVIEID);
return(View(rEVIEW));
}
// TODO : TO REVISIT User should be able to add 1 review (rating and comment) for a product/ service
/// <summary>
/// Add a new review for a product/ service by a user
/// </summary>
/// <param name="userReview"></param>
/// <returns></returns>
public Guid AddNewReview(REVIEW userReview)
{
try
{
if (userReview == null)
{
throw new ArgumentNullException("UserReview", "UserReview can not be null");
}
if ((!userReview.PRODUCTID.HasValue || userReview.PRODUCTID.Value == Guid.Empty) && (!userReview.SERVICEID.HasValue || userReview.SERVICEID.Value == Guid.Empty))
{
throw new ArgumentException("Both PRODUCTID SERVICEID can not be null together", "UserReview");
}
if ((userReview.PRODUCTID.HasValue && userReview.PRODUCTID.Value != Guid.Empty) && (userReview.SERVICEID.HasValue && userReview.SERVICEID.Value != Guid.Empty))
{
throw new ArgumentException("Both PRODUCTID SERVICEID can not have values together", "UserReview");
}
if (!userReview.REVIEWERID.HasValue || userReview.REVIEWERID.Value == Guid.Empty)
{
throw new ArgumentException("REVIEWERID can not be null", "UserReview");
}
if (userReview.RATING == null && string.IsNullOrEmpty(userReview.COMMENTS))
{
return(Guid.Empty);
}
if (!userReview.ID.HasValue || userReview.ID.Value == Guid.Empty)
{
userReview.ID = Guid.NewGuid();
}
userReview.REVIEWDATE = DateTime.Now;
using (APIShopKaro.Models.apsteamCFHEntities db = new APIShopKaro.Models.apsteamCFHEntities())
{
try
{
db.REVIEWS.Add(userReview);
db.SaveChanges();
}
catch (System.Data.DataException e)
{
throw new Exception(e.InnerException.InnerException.Message);
}
}
return(userReview.ID.Value);
}
catch (Exception e)
{
throw;
}
}
public ActionResult Edit([Bind(Include = "Id,RestaurantId,Review1,Rating,CustomerId")] REVIEW rEVIEW)
{
if (ModelState.IsValid)
{
db.Entry(rEVIEW).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CustomerId = new SelectList(db.AspNetUsers, "Id", "Email", rEVIEW.CustomerId);
ViewBag.RestaurantId = new SelectList(db.Restaurants, "Id", "Name", rEVIEW.RestaurantId);
return(View(rEVIEW));
}
public string InsertReview(REVIEW review)
{
try
{
context.REVIEWs.Add(review);
context.SaveChanges();
}
catch (Exception e)
{
return(e.Message);
}
return("");
}
// GET: REVIEWs/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
REVIEW rEVIEW = db.REVIEW.Find(id);
if (rEVIEW == null)
{
return(HttpNotFound());
}
return(View(rEVIEW));
}
public ActionResult addReview(String book_id, String information_id, String review, String star)
{
try
{
var user = db.INFORMATION.Find(information_id);
if (user is null)
{
var result = new
{
status = false,
message = "user không tồn tại"
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
else
{
var reviews = new REVIEW()
{
book_id = book_id,
information_id = information_id,
review1 = review,
star = Int32.Parse(star),
DateOfReview = DateTime.Now
};
db.REVIEWS.Add(reviews);
db.SaveChanges();
var result = new
{
status = true,
message = "Thêm nhận xét thành công",
link = new
{
actionName = "SingleBook?_id=" + book_id,
controllerName = "Category"
}
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
catch
{
var result = new
{
status = false,
message = "Thêm nhận xét không thành công"
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
public ReviewContract GetReviewContract(REVIEW Review)
{
var reviewcontrat = new ReviewContract
{
ProductReviewID = Review.PRODUCTREVIEWID,
ProductID = Review.PRODUCTID,
Comments = Review.COMMENTS,
ReviewDate = Review.REVIEWDATE,
ReviewerName = Review.REVIEWERNAME,
Ratings = Review.RATINGS,
CreatedDate = Review.CREATEDDATE,
};
return(reviewcontrat);
}
// GET: REVIEWs/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
REVIEW rEVIEW = db.REVIEW.Find(id);
if (rEVIEW == null)
{
return(HttpNotFound());
}
ViewBag.MOVIEID = new SelectList(db.MOVIE, "ID", "TITLE", rEVIEW.MOVIEID);
return(View(rEVIEW));
}
public HttpResponseMessage AddNewReview(REVIEW review)
{
try
{
var commonService = new CommonService();
var id = commonService.AddNewReview(review);
var response = Request.CreateResponse(HttpStatusCode.OK, id);
return(response);
}
catch (Exception e)
{
var error = Request.CreateResponse(HttpStatusCode.InternalServerError, e.Message);
return(error);
}
}
public string UpdateReview(REVIEW review)
{
var message = "";
try
{
context.REVIEWs.AddOrUpdate(review);
context.SaveChanges();
}
catch (Exception e)
{
message = e.Message;
}
return(message);
}
// GET: Review/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
REVIEW review = db.REVIEW.Find(id);
if (review == null)
{
return(HttpNotFound());
}
ViewBag.placeInfo = db.PLACE.Find(review.PID);
return(View(review));
}
// GET: REVIEWs/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
REVIEW rEVIEW = db.REVIEW.Find(id);
if (rEVIEW == null)
{
return(HttpNotFound());
}
ViewBag.CustomerId = new SelectList(db.AspNetUsers, "Id", "Email", rEVIEW.CustomerId);
ViewBag.RestaurantId = new SelectList(db.Restaurants, "Id", "Name", rEVIEW.RestaurantId);
return(View(rEVIEW));
}
public void DeleteReview(REVIEW review)
{
try
{
using (var context = new ModelDatabaseFirst())
{
context.REVIEWs.Remove(review);
context.SaveChanges();
return;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private void InsertReview_Click(object sender, EventArgs e)
{
var exista_cititor = service.VerifyReaderByName(boxNumeCititorInsertReview.Text.Trim());
var queryCititorId = service.GetReader(exista_cititor[0].CititorId);
var queryCarteImprumut = service.GetLoanByBookTitleReaderId(boxTitluCarteInsertReview.Text.Trim(), queryCititorId.CititorId);
var queryCarteId = service.GetBook(queryCarteImprumut[0].CarteId);
if (queryCarteId.CarteId > 0)
{
int idCarte = queryCarteId.CarteId;
var queryDateCarteImprumutata = service.GetLoan(queryCarteImprumut[0].ImprumutId);
queryDateCarteImprumutata.DataRestituire = DateTime.Now;
service.UpdateLoan(queryDateCarteImprumutata);
// issues, I think
var queryDateImprumut = service.GetLoan(idCarte);
var queryCititorImprumut = service.GetLoan(idCarte);
if (queryDateImprumut.DataRestituire > queryDateImprumut.DataScadenta)
{
var queryStareCititor = service.GetReader(queryCititorImprumut.CititorId);
queryStareCititor.Stare = 1;
service.UpdateReader(queryStareCititor);
}
REVIEW rev = new REVIEW()
{
Text = boxTextReviewInsertReview.Text.Trim(),
ImprumutId = queryDateImprumut.ImprumutId,
};
service.InsertReview(rev);
MessageBox((IntPtr)0, "\nInsert Operation Completed", "Message Box", 0);
}
else
{
MessageBox((IntPtr)0, "\nCartea nu exista/este imprumutata", "Message Box", 0);
}
boxTitluCarteInsertReview.Text = "";
boxNumeCititorInsertReview.Text = "";
boxTextReviewInsertReview.Text = "";
}
public Response DeleteReview(REVIEW review)
{
var response = new Response();
var mapped = Mapper.Map <REVIEW, Data.Entities.REVIEW>(review);
var reply = _bookRepository.DeleteReview(mapped);
if (reply == "")
{
response.Messages.Add("The review has been successfully deleted!");
}
else
{
response.Error = true;
response.Messages.Add(reply);
}
return(response);
}
public HttpResponseMessage post([FromBody] REVIEW review)
{
try
{
using (ReviewEntities entities = new ReviewEntities())
{
entities.REVIEW.Add(review);
entities.SaveChanges();
HttpResponseMessage message = Request.CreateResponse(HttpStatusCode.Created, review);
message.Headers.Location = new Uri(Request.RequestUri + review.ReviewId.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
private void InsertReview_Click(object sender, EventArgs e)
{
var book = new BookRepository();
var reader = new ReaderRepository();
var review = new ReviewRepository();
var loan = new LoanRepository();
var queryCarteId = book.GetBookIdByTitle(boxTitluCarteInsertReview.Text.Trim());
if (queryCarteId.LongCount() > 0)
{
int idCarte = queryCarteId[0].CarteId;
var queryDateCarteImprumutata = loan.GetLoanIdByBookId(idCarte);
queryDateCarteImprumutata[0].DataRestituire = DateTime.Now;
loan.UpdateLoan(queryDateCarteImprumutata[0]);
var queryDateImprumut = loan.GetLoanIdByBookId(idCarte);
var queryCititorImprumut = loan.GetLoanIdByBookId(idCarte);
if (queryDateImprumut[0].DataRestituire > queryDateImprumut[0].DataScadenta)
{
var queryStareCititor = reader.GetReaderById(queryCititorImprumut[0].CititorId);
queryStareCititor[0].Stare = 1;
reader.UpdateReader(queryStareCititor[0]);
}
REVIEW rev = new REVIEW()
{
Text = boxTextReviewInsertReview.Text.Trim(),
ImprumutId = queryDateImprumut[0].ImprumutId,
};
review.InsertReview(rev);
MessageBox((IntPtr)0, "\nInsert Operation Completed", "Message Box", 0);
}
else
{
MessageBox((IntPtr)0, "\nCartea nu exista/este imprumutata", "Message Box", 0);
}
boxTitluCarteInsertReview.Text = "";
boxTextReviewInsertReview.Text = "";
}
public bool DeleteReview(int reviewid)
{
try
{
REVIEW review = dataAccess.REVIEWs.Single(rview => rview.REVIEWID == reviewid);
if (review == null)
{
throw new KeyNotFoundException();
}
dataAccess.REVIEWs.DeleteOnSubmit(review);
dataAccess.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
