internal CONTACTFORM GetById(int id)
{
CONTACTFORM contactForm = new CONTACTFORM();
using (con = new SqlConnection(connectionString))
{
string sqlQuery = "SELECT * FROM TCONTACTFORM WHERE ID = @ID";
using (SqlCommand cmd = new SqlCommand(sqlQuery, con))
{
con.Open();
cmd.Parameters.AddWithValue("@ID", id);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
contactForm = new CONTACTFORM()
{
ID = (int)reader["ID"],
NAME = (string)reader["NAME"],
EMAIL = (string)reader["EMAIL"],
MESSAGE = (string)reader["MESSAGE"],
SEND_DATE = (DateTime)reader["SEND_DATE"]
};
}
con.Close();
}
}
return(contactForm);
}
public ActionResult ContactFormDelete(int id)
{
if (Session["ID"] == null)
{
return(RedirectToAction("Index"));
}
CONTACTFORM contactForm = contactFormDA.GetById(id);
return(View(contactForm));
}
public ActionResult ContactForm(CONTACTFORM contactForm)
{
if (ModelState.IsValid)
{
try
{
contactFormDA.Insert(contactForm);
return(Json(new { SuccessMsg = "Mesajınız iletildi." }));
}
catch (Exception ex)
{
return(Json(new { ErrorMsg = "Try Again." }));
}
}
else
{
return(Json(new { ErrorMsg = "Check All Fields." }));
}
}
internal void Insert(CONTACTFORM contactForm)
{
using (con = new SqlConnection(connectionString))
{
string sqlQuery = $@"INSERT INTO TCONTACTFORM (NAME, EMAIL, MESSAGE, SEND_DATE) VALUES (@NAME, @EMAIL, @MESSAGE, @SEND_DATE)";
using (SqlCommand cmd = new SqlCommand(sqlQuery, con))
{
con.Open();
cmd.Parameters.AddWithValue("@NAME", contactForm.NAME);
cmd.Parameters.AddWithValue("@EMAIL", contactForm.EMAIL);
cmd.Parameters.AddWithValue("@MESSAGE", contactForm.MESSAGE);
cmd.Parameters.AddWithValue("@SEND_DATE", DateTime.Now);
cmd.ExecuteNonQuery();
con.Close();
}
}
}
public ActionResult DeleteContactForm(int id)
{
CONTACTFORM contactForm = contactFormDA.GetById(id);
try
{
if (ModelState.IsValid)
{
contactFormDA.Delete(id);
return(RedirectToAction("ContactForms", "Admin"));
}
else
{
ViewBag.Error = "Try Again.";
return(View("ContactFormDelete", contactForm));
}
}
catch (Exception ex)
{
ViewBag.Error = "Try Again.";
return(View("ContactFormDelete", contactForm));
}
}
