public JsonResult Delete(int?id)
{
if (id != null)
{
reviews_user reviews_user = db.reviews_user.Find(id);
db.reviews_user.Remove(reviews_user);
db.SaveChanges();
}
return(Json(""));
}
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
reviews_user reviews_user = await db.reviews_user.FindAsync(id);
if (reviews_user == null)
{
return(HttpNotFound());
}
return(View(reviews_user));
}
public ActionResult OneReview(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
reviews_user reviews_user = db.reviews_user.Find(id);
if (reviews_user == null)
{
return(HttpNotFound());
}
return(View(reviews_user));
}
public ActionResult Publish(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
reviews_user reviews_user = db.reviews_user.Find(id);
if (reviews_user == null)
{
return(HttpNotFound());
}
reviews_user.state_id = 2;
db.reviews_user.AddOrUpdate(reviews_user);
db.SaveChanges();
return(Redirect(Url.Action("Index", "Reviews", new { type = 2 })));
}
public ActionResult Index(string name, string email, string enter_type_edu, int type, string message)
{
reviews_user review = new reviews_user();
review.id = (db.reviews_user.Count() > 0) ? (db.reviews_user.Max(p => p.id + 1) + 1) : 1;
review.state_id = 1;
review.audit_object_id = Convert.ToInt32(db.education__institution.First(p => p.full_name.Contains(enter_type_edu)).audit_object_id);
review.author_email = email;
review.author_name = name;
review.date_create = DateTime.Now;
review.text = message;
review.type_id = type;
review.title = " ";
db.reviews_user.Add(review);
db.SaveChanges();
ViewBag.area = new SelectList(db.area.OrderBy(p => p.name), "id", "name");
ViewBag.district = new SelectList(db.district.OrderBy(p => p.name), "id", "name");
ViewBag.type_edu = new SelectList(db.type_edu.OrderBy(p => p.name), "id", "name");
return(View());
}
public ActionResult SendAnswer(string message, int id)
{
int user_id = Convert.ToInt32(Session["user_id"]);
User user = db.User.Find(user_id);
reviews_user review = db.reviews_user.Find(id);
string smtpHost = "mail.unibel.by";
string pass = "******";
string from = "*****@*****.**";
string to = review.author_email;
string subject = "Ответ на отзыв сайте " + review.audit_object.adress_site;
string mess = "Здравствуйте! \n На Ваш отзыв о сайте " + review.audit_object.adress_site + " был добавлен ответ: \n\n \"" + message + "\" \n\n С уважением\n -- \n АИС \"Мониторинг\"";
MailMessage mail = new MailMessage();
mail.From = new MailAddress(from);
mail.To.Add(new MailAddress(to));
mail.Subject = subject;
mail.Body = mess;
SmtpClient client = new SmtpClient();
client.Host = smtpHost;
client.Port = 25;
client.Credentials = new NetworkCredential(from.Split('@')[0], pass);
client.DeliveryMethod = SmtpDeliveryMethod.Network;
try
{
client.Send(mail);
mail.Dispose();
review.curator_answer = message;
db.reviews_user.AddOrUpdate(review);
db.SaveChanges();
}
catch (Exception e)
{
throw new Exception("Mail.Send: " + e.Message);
}
return(Redirect("/Curator/OneReview/" + id));
}
