private void AddContact(string name, string email, string phone, string msg)
{
if (connection == null || connection.State == ConnectionState.Closed)
{
connection = WebText.TextDatabase();
}
// Ensure the database connection exists before querying it
if (connection != null && connection.State == ConnectionState.Open)
{
SqlCommand cmd = connection.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "INSERT INTO Contact VALUES (@name, @email, @phone, @msg)";
cmd.Parameters.AddWithValue("name", name.Trim(charsToTrim));
cmd.Parameters.AddWithValue("email", email.Trim(charsToTrim));
cmd.Parameters.AddWithValue("phone", phone.Trim(charsToTrim));
cmd.Parameters.AddWithValue("msg", msg.Trim(charsToTrim));
try
{
int values = cmd.ExecuteNonQuery();
btnClearContact_Click(btnClearContact, new EventArgs());
}
catch (Exception ex)
{
txtEntryMsg.Text = "ERROR: " + ex.Message + "\n" + txtEntryMsg.Text;
}
connection.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
switch (slideShowImageIndex)
{
case 0: // Monkey
imgHomeImage.ImageUrl = "~/Images/elephants.jpg";
slide1.BackColor = System.Drawing.Color.OrangeRed;
break;
case 1:
imgHomeImage.ImageUrl = "~/Images/wierdDeers.jpg";
slide2.BackColor = System.Drawing.Color.OrangeRed;
break;
case 2:
imgHomeImage.ImageUrl = "~/Images/Monkey.jpg";
slide3.BackColor = System.Drawing.Color.OrangeRed;
break;
default:
break;
}
// Card labels
Label[] cardLabels = new Label[] { cardHeader0, cardHeader1, cardHeader2, cardTitle0, cardTitle1, cardTitle2, cardDesc0, cardDesc1, cardDesc2 };
for (int i = 0; i < 3; i++)
{
WebText cardText = WebText.RetrieveText(i + 1);
cardLabels[i].Text = cardText.Header;
cardLabels[i + 3].Text = cardText.Title;
cardLabels[i + 6].Text = cardText.Desc;
}
// Main Title
WebText homeText = WebText.RetrieveText(4);
labelHomeImage.Text = homeText.Header;
labelHomeImage2.Text = homeText.Title;
titleDesc.Text = homeText.Desc;
}
protected void Page_Load(object sender, EventArgs e)
{
txtEntryName.Attributes.Add("placeholder", "Name");
txtEntryEmail.Attributes.Add("placeholder", "Email");
txtEntryPhone.Attributes.Add("placeholder", "Phone");
connection = WebText.TextDatabase();
// Title line
titleDesc.Text = WebText.RetrieveText(4).Desc;
// Address, phone, fax
WebText contact = WebText.RetrieveText(5);
lblAddress.Text = contact.Header;
lblPhone.Text = contact.Title;
lblFax.Text = contact.Desc;
// Email
WebText email = WebText.RetrieveText(6);
lblEmail.Text = email.Header;
}
protected void Page_Unload(object sender, EventArgs e)
{
WebText.DisposeTextDatabase();
}
