public static void SaveClientContactDetail(ClientContactInfo ci)
{
ci.CreatedBy = Environment.UserName;
ci.CreatedAt = DateTime.UtcNow;
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
conn.Open();
try
{
IEnumerable<ClientContactInfo> resultList = conn.Query<ClientContactInfo>(@"
INSERT INTO [Phenix].[dbo].[ContactDetail]
([CompanyName]
,[FirstName]
,[LastName]
,[Email]
,[MobileNumber]
,[OfficeNumber]
,[Message]
,[CreatedAt]
,[CreatedBy])
VALUES
(@CompanyName
,@FirstName
,@LastName
,@Email
,@MobileNumber
,@OfficeNumber
,@Message
,@CreatedAt
,@CreatedBy)
", new {
ci.CompanyName
,ci.FirstName
,ci.LastName
,ci.Email
,ci.MobileNumber
,ci.OfficeNumber
,ci.Message
,ci.CreatedAt
,ci.CreatedBy
}
);
}
catch (Exception ex)
{
PhenixMail.SendMail("daContactDetail.SaveClientContactDetail()-ERROR", string.Format("{0}", ex.Message), ConfigurationManager.AppSettings["MAIL_SALES_TEAM"]);
}
}
}
public ActionResult Contact()
{
ViewBag.Message = "Leave us a message.";
ClientContactInfo p = new ClientContactInfo();
p.CompanyName = string.Empty;
p.FirstName = string.Empty;
p.LastName = string.Empty;
p.Email = string.Empty;
p.MobileNumber = string.Empty;
p.OfficeNumber = string.Empty;
p.Message = string.Empty;
SimplexLogger.Info("Returning view from HomeController Contact()");
return View(p);
}