public ActionResult Reviews(int announ_id) { var reviews_arr = (from a in db.reviews where a.announ_id == announ_id select a); List <iproby.Models.review> review_list = new List <iproby.Models.review>(); foreach (var item in reviews_arr) { iproby.Models.review review = new iproby.Models.review(); review.header = item.header; review.description = item.description; review.date_from = item.date_from; review.reviewer_id = item.reviewer_id; var contact_id_arr = (from a in db.customers where a.customer_id == item.reviewer_id select a.contact_id); int contact_id = 0; foreach (int item_customer in contact_id_arr) { contact_id = item_customer; } var contact_arr = (from a in db.contacts where a.contact_id == contact_id select a); foreach (var item_inside in contact_arr) { review.first_name = item_inside.first_name; review.address = item_inside.address; review.avatar = item_inside.avatar; } review_list.Add(review); } return(View("~/Views/Announ/ReviewsList.cshtml", review_list)); }
public ActionResult AddReview(iproby.Models.review model) { if (Session["login"] != null) { string login = Session["login"].ToString(); var customer_id_arr = (from a in db.customers where a.login == login select a.customer_id); int customer_id = 0; foreach (int item in customer_id_arr) { customer_id = item; } iproby.Data_Model.review review = new iproby.Data_Model.review(); review.reviewer_id = customer_id; review.announ_id = model.announ_id; review.customer_id = model.customer_id; var to_contact_id_arr = (from a in db.customers where a.customer_id == model.customer_id select a.contact_id); int to_contact_id = 0; foreach (int item in to_contact_id_arr) { to_contact_id = item; } var contact_arr = (from a in db.contacts where a.contact_id == to_contact_id select a); string email = string.Empty; foreach (var item in contact_arr) { email = item.email; } review.header = model.header; review.description = model.description; DateTime Now = DateTime.Now; review.date_from = Now; db.reviews.Add(review); db.SaveChanges(); InformationController notification = new InformationController(); notification.SendMail(email, @"К вашему объявлению добавили комментарий на сайте IPRO. Пожалуйста, проверьте в личном кабинете и по возможости напишите ответ (ответить автору сообщения возможно в Личном кабинете). Письмо сгенерировано автоматически. По всем вопросам пишите на [email protected]"); isSaved = true; return(RedirectToAction("Index", new { announ_id = model.announ_id })); } else { notLogin = true; return(RedirectToAction("Index", new { announ_id = model.announ_id })); } }
public ActionResult Reviews(int announ_id) { var reviews_arr = (from a in db.reviews where a.announ_id == announ_id select a); List<iproby.Models.review> review_list = new List<iproby.Models.review>(); foreach (var item in reviews_arr) { iproby.Models.review review = new iproby.Models.review(); review.header = item.header; review.description = item.description; review.date_from = item.date_from; review.reviewer_id = item.reviewer_id; var contact_id_arr = (from a in db.customers where a.customer_id == item.reviewer_id select a.contact_id); int contact_id = 0; foreach (int item_customer in contact_id_arr) { contact_id = item_customer; } var contact_arr = (from a in db.contacts where a.contact_id == contact_id select a); foreach (var item_inside in contact_arr) { review.first_name = item_inside.first_name; review.address = item_inside.address; review.avatar = item_inside.avatar; } review_list.Add(review); } return View("~/Views/Announ/ReviewsList.cshtml",review_list); }