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