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