Exemplo n.º 1
0
 public bool SaveCatsFormData(CatsContactForm formData)
 {
     this.Logger.Info("SaveCatsFormData()");
     SqlCommand command = null;
     SqlConnection connection = null;
     string connectionString = ConfigurationManager.ConnectionStrings["CatsDb"].ToString();
     if (this.Logger.IsDebugEnabled)
     {
         this.Logger.DebugFormat("Connection: {0}", new object[] { connectionString });
     }
     string str2 = this.SerializeFormForLogging(formData);
     try
     {
         connection = new SqlConnection(connectionString);
         connection.Open();
         command = new SqlCommand(WebConfiguration.Current.CatsInsertSQL) {
             Connection = connection
         };
         command.Parameters.AddWithValue("@datesent", formData.dateSubmitted);
         command.Parameters.AddWithValue("@title", formData.Title);
         command.Parameters.AddWithValue("@fname", formData.FirstName);
         command.Parameters.AddWithValue("@lname", formData.LastName);
         command.Parameters.AddWithValue("@address1", formData.Address1);
         command.Parameters.AddWithValue("@address2", formData.Address2);
         command.Parameters.AddWithValue("@city", formData.City);
         command.Parameters.AddWithValue("@state", formData.State);
         command.Parameters.AddWithValue("@zipcode", formData.ZipCode);
         command.Parameters.AddWithValue("@country", formData.Country);
         command.Parameters.AddWithValue("@phone", formData.TelephoneNumber);
         command.Parameters.AddWithValue("@email", formData.EmailAddress);
         command.Parameters.AddWithValue("@prodtype", formData.ProductType);
         command.Parameters.AddWithValue("@proddescription", formData.ProductDescription);
         command.Parameters.AddWithValue("@questiontype", formData.QuestionType);
         command.Parameters.AddWithValue("@comments", formData.Comments);
         int num = command.ExecuteNonQuery();
         if (num != 1)
         {
             throw new Exception("Incorrect number of rows affected (should be 1) RowsAffected: " + num);
         }
         if (this.Logger.IsDebugEnabled)
         {
             this.Logger.DebugFormat("rowsAffected: {0}", new object[] { num });
         }
     }
     catch (Exception exception)
     {
         this.Logger.Error(string.Concat(new object[] { "CatsRepository: Could not save contact data in database form, Error: ", exception, " FormData: ", str2 }));
         return false;
     }
     finally
     {
         if (connection != null)
         {
             connection.Close();
         }
     }
     return true;
 }
Exemplo n.º 2
0
 public ActionResult Index(CatsContactForm form)
 {
     if (base.ModelState.IsValid)
     {
         string catsThankYou = this._settings.CatsThankYou;
         form.dateSubmitted = DateTime.Now;
         this._catsrepository.SaveCatsFormData(form);
         return this.Redirect(catsThankYou.AddApplicationRoot());
     }
     base.TempData["contactform"] = form;
     return this.Redirect("/contactus");
 }
Exemplo n.º 3
0
 public ActionResult Index()
 {
     CatsContactForm model = new CatsContactForm();
     if (base.TempData["contactform"] != null)
     {
         base.ViewData = (ViewDataDictionary) base.TempData["ViewData"];
         model = (CatsContactForm) base.TempData["contactform"];
         model.cp = base.GetComponentPresentation();
     }
     else
     {
         model.cp = base.GetComponentPresentation();
     }
     return base.View(model);
 }
Exemplo n.º 4
0
 private string SerializeFormForLogging(CatsContactForm formData)
 {
     formData.cp = null;
     return new JavaScriptSerializer().Serialize(formData);
 }