public ActionResult InsertAns(string SolutionEditor) { VwSolutionsModel model = new VwSolutionsModel(); string strContent = SolutionEditor; string strTemp = ""; if (Session["User"] != null) { user = (Users)Session["User"]; string quesID = RouteData.Values["id"].ToString(); ConnManager connManager = new ConnManager(); connManager.OpenConnection(); double dblReplyID = 0; Replies replies = new Replies(); SqlConnection LclConn = new SqlConnection(); SqlTransaction SetTransaction = null; bool IsinTransaction = false; if (LclConn.State != ConnectionState.Open) { replies.SetConnection = replies.OpenConnection(LclConn); SetTransaction = LclConn.BeginTransaction(IsolationLevel.ReadCommitted); IsinTransaction = true; } else { replies.SetConnection = LclConn; } replies.OptionID = 1; replies.QuestionId = double.Parse(quesID.ToString()); //CleanBeforeInsert(ref SolutionEditor, ref strTemp); replies.Reply = SolutionEditor; replies.RepliedDate = DateTime.Now; if (user.UserId == 1) { int[] myy = new int[38] { 16, 17, 18, 19, 23, 24, 25, 26, 32, 34, 35, 37, 39, 40, 41, 42, 44, 45, 46, 47, 48, 51, 52, 54, 55, 56, 57, 58, 59, 63, 69, 70, 71, 72, 73, 82, 104, 106 }; Random ran = new Random(); int mynum = myy[ran.Next(0, myy.Length)]; replies.RepliedUser = mynum; int[] myvotes = new int[12] { 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16}; Random ran2 = new Random(); int mynum2 = myvotes[ran2.Next(0, myvotes.Length)]; replies.UpVotes = mynum2; } else { replies.RepliedUser = user.UserId; } bool result = replies.CreateReplies(ref dblReplyID, SetTransaction); if (IsinTransaction && result) { SetTransaction.Commit(); } else { SetTransaction.Rollback(); } replies.CloseConnection(LclConn); ViewBag.ReplyId = dblReplyID; model = SetDefaults(); try { if (!Session["AskedUserEMail"].ToString().Contains("codeanalyze.com")) { Mail mail = new Mail(); string EMailBody = System.IO.File.ReadAllText(Server.MapPath("../../../EMailBody.txt")); System.Text.RegularExpressions.Regex rgx = new System.Text.RegularExpressions.Regex("[^a-zA-Z0-9 -]"); if (model.QuestionTitle != null) { model.QuestionTitle = rgx.Replace(model.QuestionTitle, "").Replace(" ", "-"); } string strLink = "www.codeanalyze.com/Que/Ans/" + quesID.ToString() + "/" + model.QuestionTitle + ""; string strBody = "Your question on CodeAnalyse has been answered by one of the users. Check now <a href=" + strLink + "\\>here</a>"; mail.Body = string.Format(EMailBody, strBody); mail.FromAdd = "*****@*****.**"; mail.Subject = "Code Analyze - Received response for " + model.QuestionTitle; mail.ToAdd = Session["AskedUserEMail"].ToString(); mail.CCAdds = "*****@*****.**"; mail.IsBodyHtml = true; if (!mail.ToAdd.ToString().ToLower().Equals("*****@*****.**")) { mail.SendMail(); } } } catch(Exception ex) { } //GetQuestionData(quesID.ToString(), ref model); //BindSolution("Select * from VwSolutions where QuestionId = " + quesID.ToString(), null); //ViewBag.lblAck = string.Empty; } else { ViewBag.lblAck = "Please sign in to post your question."; } return View("../Que/Ans", model); }