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