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