private void _showUpdate(int id)
{
_panelControl(pnl_update);
contactClass _contact = new contactClass();
dtl_update.DataSource = _contact.getContactByID(id);
dtl_update.DataBind();
}
// Subroutine to bind gridview
private void _subBind()
{
contactClass objContact = new contactClass();
grv_contact.DataSource = objContact.getContact();
grv_contact.DataBind();
}
protected void subCancel(object sender, EventArgs e)
{
contactClass objContactDC = new contactClass();
txtfname.Text = string.Empty;
txtlname.Text = string.Empty;
//ddl_dept.Items.ToString();
txtemail.Text = string.Empty;
txtmsg.Text = string.Empty;
}
private void _subRebind()
{
contactClass objContactDC = new contactClass();
txt_fname.Text = string.Empty;
txt_lname.Text = string.Empty;
txtemail.Text = string.Empty;
ddl_dept.SelectedItem.Text = string.Empty;
txtmsg.Text = string.Empty;
}
// Deletes selected contact row
protected void DeleteContact(object sender, EventArgs e)
{
LinkButton lnkDelete = (LinkButton)sender;
contactClass objContact = new contactClass();
objContact.ContactID = Int32.Parse(lnkDelete.CommandArgument);
lbl_msg.Text = objContact.deleteContact();
_subBind();
}
// Insert new contact
protected void InsertContact(object sender, EventArgs e)
{
contactClass objContact = new contactClass();
objContact.ContactFname = txt_contactFnameI.Text.ToString();
objContact.ContactLname = txt_contactLnameI.Text.ToString();
objContact.ContactEmail = txt_contactEmailI.Text.ToString();
objContact.ContactMessage = txt_contactMessageI.Text.ToString();
lbl_msg.Text = objContact.insertContact();
_subBind();
}
// Update contact: updates the selected contact row
protected void UpdateContact(object sender, GridViewUpdateEventArgs e)
{
contactClass objContact = new contactClass();
objContact.ContactID = Int32.Parse(((Label)grv_contact.Rows[e.RowIndex].FindControl("lbl_contactID")).Text);
objContact.ContactFname = ((TextBox)grv_contact.Rows[e.RowIndex].FindControl("txt_contactFnameU")).Text;
objContact.ContactLname = ((TextBox)grv_contact.Rows[e.RowIndex].FindControl("txt_contactLnameU")).Text;
objContact.ContactEmail = ((TextBox)grv_contact.Rows[e.RowIndex].FindControl("txt_contactEmailU")).Text;
objContact.ContactMessage = ((TextBox)grv_contact.Rows[e.RowIndex].FindControl("txt_contactMessageU")).Text;
lbl_msg.Text = objContact.updateContact();
grv_contact.EditIndex = -1;
_subBind();
}
//connected model
// Retrieves values from database table and passes values into properties. Stores values in a list and returns
public List <contactClass> getContact()
{
List <contactClass> allContact = new List <contactClass>();
SqlConnection conn = new SqlConnection(_connString);
SqlCommand cmd = new SqlCommand("SELECT * FROM contact", conn);
try
{
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
// dr.read reads each row until there are none left
while (dr.Read())
{
contactClass objContact = new contactClass();
objContact.ContactID = Convert.ToInt32(dr["id"].ToString());
objContact.ContactFname = (string)dr["fname"];
objContact.ContactLname = (string)dr["lname"];
objContact.ContactEmail = (string)dr["email"];
objContact.ContactMessage = (string)dr["message"];
allContact.Add(objContact);
}
return(allContact);
}
catch (Exception err)
{
allContact.Clear();
contactClass objContact = new contactClass();
objContact.ContactFname = "Server Error (DB): " + err.Message.ToString();
allContact.Add(objContact);
return(allContact);
}
finally
{
conn.Close();
}
}
private void _subRebind()
{
contactClass objContactDC = new contactClass();
dtl_updel_all.DataSource = objContactDC.getContacts();
dtl_updel_all.DataBind();
_panelControl(pnl_all);
}
