public int Insert(QuickQuestionAddRequest model, string userId)
{
int id = 0;
DataProvider.ExecuteNonQuery(GetConnection, "dbo.QuickQuestions_Insert"
, inputParamMapper: delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Question", model.Question);
paramCollection.AddWithValue("@Status", model.Status);
paramCollection.AddWithValue("@UserId", userId);
SqlParameter p = new SqlParameter("@Id", System.Data.SqlDbType.Int);
p.Direction = System.Data.ParameterDirection.Output;
paramCollection.Add(p);
}, returnParameters: delegate(SqlParameterCollection param)
{
Int32.TryParse(param["@Id"].Value.ToString(), out id);
}
);
return id;
}
public static void SendQuickQuestionEmails(QuickQuestionAddRequest qqModel, string userEmail
, int questionId)
{
string adminEmail = "000000000000000";
string fromEmail = adminEmail;
string name = "Admin";
string subject = "You asked a Quick Question";
string host = _baseURL;
string userUrl = "/quick/" + questionId;
string href = host + userUrl;
string message = "Hi there. You asked a Quick Question: "
+ qqModel.Question + " Here is a link to view your question: "
+ href;
string toEmail = userEmail;
EmailData userModel = FillEmailModel(fromEmail, name, subject, message, toEmail);
Send(userModel);
subject = "A Quick Question was asked";
string adminUrl = "/quick/admin/" + questionId;
href = host + adminUrl;
message = "Hi admin. " + "The user at " + userEmail
+ " asked the following Quick Question: "
+ qqModel.Question
+ " Here is a link: "
+ href;
toEmail = adminEmail;
EmailData adminModel = FillEmailModel(fromEmail, name, subject, message, toEmail);
Send(adminModel);
}
