public void AddLetter(Letter letter) { db_mysql db_mysql = new db_mysql(); if (letter.Id == 0) { letter last_letter = db_mysql.letters.OrderByDescending(u => u.Id).FirstOrDefault(); letter.Id = last_letter.Id + 1; } letter new_letter = Mapper.Map<Letter, letter>(letter); db_mysql.letters.Add(new_letter); db_mysql.SaveChanges(); }
public void AddComment(Comment comment, Letter letter) { letter transposed = Mapper.Map<Letter, letter>(letter); db_mysql db_mysql = new db_mysql(); db_mysql.letters.Attach(transposed); var letter_obj = db_mysql.Entry(transposed); if (comment.level > -1) { letter_obj.Property(e => e.letterComments).IsModified = true; transposed.letterComments = transposed.letterComments + 1; } db_mysql.comments.Add(Mapper.Map<Comment, comment>(comment)); db_mysql.SaveChanges(); }
public ActionResult Contact(Core.Model.Contact msg) { String userip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; if (userip == null || userip == "127.0.0.1") userip = Request.ServerVariables["REMOTE_ADDR"]; msg.Message = "Feedback received ( " + msg.Email + " ): <br /><br />" + msg.Message + "<br><br>sent from ip: " + userip; _mailService.SendContact(msg.Message, msg.Email); Letter contact_letter = new Letter(); contact_letter.letterLanguage = "en-US"; contact_letter.letterLevel = -10; contact_letter.letterPostDate = DateTime.UtcNow; contact_letter.senderIP = userip; contact_letter.letterMessage = msg.Message; contact_letter.letterComments = 0; contact_letter.letterUp = 1; _letterService.AddLetter(contact_letter); return View("Thanks"); }
public JsonResult Vote(int id, string c = "") { string userip = null; userip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; if (userip == null) userip = Request.ServerVariables["REMOTE_ADDR"]; string signalr_hub = "http://*****:*****@gmail.com"; string hub_state = ""; if (hubConnection != null) { hub_state = hubConnection.State.ToString(); } else { hub_state = "null"; } msg.Message = "state: " + hub_state + "<br><br>" + ex.Message.ToString(); if (ex.InnerException != null) { msg.Message = msg.Message + "<br><br>" + ex.InnerException.Message.ToString(); } _mailService.SendContact(msg.Message, msg.Email); } return Json(letter, JsonRequestBehavior.AllowGet); }