public ActionResult AddNewContact(ContactEntity contact)
{
if (!ModelState.IsValid)
{
return(View("ContactInsertForm", contact));
}
contact dbContact = new Models.contact();
dbContact.City = contact.City;
dbContact.Comment = contact.Comment;
dbContact.CompanyID = contact.CompanyID;
dbContact.Country = contact.Country;
dbContact.DateOfBirth = contact.DateOfBirth;
dbContact.emails = contact.emails;
dbContact.FirstName = contact.FirstName;
dbContact.LastName = contact.LastName;
dbContact.MiddleName = contact.MiddleName;
dbContact.Phone = contact.Phone;
dbContact.Photo = contact.Photo;
dbContact.Region = contact.Region;
dbContact.Sites = contact.Sites;
dbContact.State = contact.State;
dbContact.Street = contact.Street;
dbContact.Zip = contact.Zip;
pr.CreateNewContact(dbContact);
return(RedirectToAction("Index", "Contact"));
}
public IActionResult showContact()
{
List <Models.contact> list = new List <Models.contact>();
try
{
string dbcon = configuration.GetConnectionString("DefaultConnectionString");
SqlConnection connection = new SqlConnection(dbcon);
connection.Open();
DataTable dt = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = new SqlCommand("Select * from contactDetails", connection);
sda.Fill(dt);
foreach (DataRow row in dt.Rows)
{
var c = new Models.contact();
c.name = row["name"].ToString();
c.email = row["email"].ToString();
c.subject = row["subject"].ToString();
c.message = row["message"].ToString();
list.Add(c);
}
connection.Close();
return(View(list));
}
catch (Exception e)
{
return(View());
}
}
