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); }