//
// GET: /Families/
public ActionResult Index()
{
int count = DbUtils.GetRandomizedSubjectsCount();
var contact = new FamilyContactsModel();
var vm = new FamiliesViewModel();
vm.RandomizedCount = count;
vm.FamilyContact = contact;
return(View(vm));
}
public static bool ProcessEmails(FamilyContactsModel fcm, string url, HttpServerUtilityBase server)
{
//to halfpint
var toEmail = new[] { "*****@*****.**" };
//var toEmail = new[] {"*****@*****.**" };
var ccEmail = new[] { "*****@*****.**" };
var sbBody = new StringBuilder("");
sbBody.Append("Comments received from:");
sbBody.Append("<br/>");
sbBody.Append("Email: " + fcm.Email);
sbBody.Append("<br/>");
sbBody.Append("Name: " + fcm.FirstName + " " + fcm.LastName);
sbBody.Append("<br/>");
sbBody.Append("<br/>");
sbBody.Append("Comments:");
sbBody.Append("<br/>");
sbBody.Append(fcm.Comment);
string subject = "Families contact";
Utility.SendFamilyContactMail(toEmail, ccEmail, null, server, sbBody.ToString(), subject);
//confirm to the user
toEmail = new[] { fcm.Email };
ccEmail = new[] { "*****@*****.**" };
sbBody = new StringBuilder("");
sbBody.Append("Dear " + fcm.FirstName + ",");
sbBody.Append("<br/><br/>");
sbBody.Append("Thank you for sending us your comments! We greatly appreciate your interest in improving the HALF-PINT trial. We will respond to all of your questions as soon as possible.");
sbBody.Append("<br/><br/>");
sbBody.Append("Sincerely,");
sbBody.Append("<br/>");
sbBody.Append("<br/>");
sbBody.Append("The HALF-PINT Team");
sbBody.Append("<br/><br/>");
sbBody.Append("Your comments:");
sbBody.Append("<br/>");
sbBody.Append(fcm.Comment);
subject = "HALF-PINT email confirmation";
Utility.SendFamilyContactMail(toEmail, ccEmail, url, server, sbBody.ToString(), subject);
return(true);
}
public static bool AddFamiliesContact(FamilyContactsModel fcm)
{
String strConn = ConfigurationManager.ConnectionStrings["Halfpint"].ToString();
using (var conn = new SqlConnection(strConn))
{
try
{
var cmd = new SqlCommand("", conn)
{
CommandType = CommandType.StoredProcedure,
CommandText = "AddFamiliesContact"
};
var param = new SqlParameter("@firstName", fcm.FirstName);
cmd.Parameters.Add(param);
param = new SqlParameter("@lastName", fcm.LastName);
cmd.Parameters.Add(param);
param = new SqlParameter("@email", fcm.Email);
cmd.Parameters.Add(param);
param = new SqlParameter("@comment", fcm.Comment);
cmd.Parameters.Add(param);
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Nlogger.LogError(ex);
return(false);
}
}
return(true);
}
