//connected model // Retrieves values from database table and passes values into properties. Stores values in a list and returns public List <contentClass> getContent() { List <contentClass> allContent = new List <contentClass>(); SqlConnection conn = new SqlConnection(_connString); SqlCommand cmd = new SqlCommand("SELECT * FROM contenttext", conn); try { conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); // dr.read reads each row until there are none left while (dr.Read()) { contentClass objContent = new contentClass(); objContent.ContentID = Convert.ToInt32(dr["id"].ToString()); objContent.ContentPage = (string)dr["page"]; objContent.ContentText = (string)dr["text"]; allContent.Add(objContent); } return(allContent); } catch (Exception err) { allContent.Clear(); contentClass objContent = new contentClass(); objContent.ContentPage = "Server Error (DB): " + err.Message.ToString(); allContent.Add(objContent); return(allContent); } finally { conn.Close(); } }
private void _subBindDataList() { contentClass objContent = new contentClass(); dtl_content.DataSource = objContent.getContent(); dtl_content.DataBind(); }
// Insert new content for datalist protected void InsertContent(object sender, EventArgs e) { contentClass objContent = new contentClass(); objContent.ContentPage = txt_pageI.Text.ToString(); objContent.ContentText = txt_textI.Text.ToString(); lbl_msg2.Text = objContent.insertContent(); _subBind(); _subBindDataList(); }
// delete selected content row protected void dtl_contentDelete(object sender, DataListCommandEventArgs e) { Label lblID = (Label)e.Item.FindControl("lbl_id"); contentClass objContent = new contentClass(); objContent.ContentID = Int32.Parse(lblID.Text.ToString()); lbl_msg2.Text = objContent.deleteContent(); _subBind(); _subBindDataList(); }
// delete selected content protected void contentItemDeleting(object sender, FormViewDeleteEventArgs e) { Label lblID = (Label)fmv_content.FindControl("lbl_id") as Label; contentClass objContent = new contentClass(); objContent.ContentID = Int32.Parse(lblID.Text.ToString()); lbl_msg.Text = objContent.deleteContent(); fmv_content.ChangeMode(FormViewMode.ReadOnly); //sends users back to original table view _subBind(); _subBindDataList(); }
// inserts new content protected void contentItemInserting(object sender, FormViewInsertEventArgs e) { TextBox txtPage = (TextBox)fmv_content.FindControl("txt_pageI") as TextBox; TextBox txtText = (TextBox)fmv_content.FindControl("txt_textI") as TextBox; contentClass objContent = new contentClass(); objContent.ContentPage = txtPage.Text.ToString(); objContent.ContentText = txtText.Text.ToString(); lbl_msg.Text = objContent.insertContent(); fmv_content.ChangeMode(FormViewMode.ReadOnly); _subBind(); _subBindDataList(); // both binds are here to update both data bound controls }
// update selected content protected void contentItemUpdating(object sender, FormViewUpdateEventArgs e) { Label lblID = (Label)fmv_content.FindControl("lbl_idU") as Label; TextBox txtPage = (TextBox)fmv_content.FindControl("txt_pageU") as TextBox; TextBox txtText = (TextBox)fmv_content.FindControl("txt_textU") as TextBox; contentClass objContent = new contentClass(); objContent.ContentID = Int32.Parse(lblID.Text.ToString()); objContent.ContentPage = txtPage.Text.ToString(); objContent.ContentText = txtText.Text.ToString(); lbl_msg.Text = objContent.updateContent(); fmv_content.ChangeMode(FormViewMode.ReadOnly); //sends users back to original table view _subBind(); _subBindDataList(); }
// update selected content row protected void dtl_contentUpdate(object sender, DataListCommandEventArgs e) { Label lblID = (Label)e.Item.FindControl("lbl_idU") as Label; TextBox txtPage = (TextBox)e.Item.FindControl("txt_pageU") as TextBox; TextBox txtText = (TextBox)e.Item.FindControl("txt_textU") as TextBox; contentClass objContent = new contentClass(); objContent.ContentID = Int32.Parse(lblID.Text.ToString()); objContent.ContentPage = txtPage.Text.ToString(); objContent.ContentText = txtText.Text.ToString(); lbl_msg2.Text = objContent.updateContent(); dtl_content.EditItemIndex = -1; // sends user back to original table iew _subBind(); _subBindDataList(); }