protected void ButtonContact_Click(object sender, EventArgs e)
{
ContactUti con = new ContactUti();
con.Name = TextBoxName.Text;
con.Content = TextBoxContact.Text;
con.insertLog();
LabelMessage.Text = "Message sent!";
ButtonContact.Visible = false;
LabelMessage.Visible = true;
}
protected void Page_Load(object sender, EventArgs e)
{
List <ContactUti> list_contact = new ContactUti().getContactInfo();
foreach (ContactUti con in list_contact)
{
ContactList.InnerHtml += "<div class=\"col-xs-2 table-bordered\"><p>" + con.id + "</p></div>";
ContactList.InnerHtml += "<div class=\"col-xs-2 table-bordered\"><p>" + con.Name + "</p></div>";
ContactList.InnerHtml += "<div class=\"col-xs-6 table-bordered\"><p>" + con.Content + "</p></div>";
ContactList.InnerHtml += "<div class=\"col-xs-2 table-bordered\"><p>" + con.Time + "</p></div>";
}
}
public List <ContactUti> getContactInfo()
{
List <ContactUti> list_contact = new List <ContactUti>();
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["PizzaDBRemote"].ConnectionString);
conn.Open();
string qry = "select * from ContactLog order by Time";
SqlCommand comd = new SqlCommand(qry, conn);
SqlDataReader dr = comd.ExecuteReader();
while (dr.Read())
{
ContactUti contact = new ContactUti();
contact.id = dr[0].ToString();
contact.Name = dr[1].ToString();
contact.Content = dr[2].ToString();
contact.Time = dr[3].ToString();
list_contact.Add(contact);
}
return(list_contact);
}
