protected void Page_Load(object sender, System.EventArgs e) { cid = Convert.ToInt32(Request.QueryString["ContentID"]); origin = Request.QueryString["Origin"]; if (cid == 0) { Page_Error("ContentID Missing"); } if (IsPostBack) { Page.Validate(); if (Page.IsValid) { try { Account account = new Account(appEnv.GetConnection()); ContentNotes notes = new ContentNotes(appEnv.GetConnection()); notes.Insert(cid, tbNote.Text, account.GetAccountID(User.Identity.Name)); } catch (Exception err) { Page_Error("The following error occured: " + err.Message); } Response.Redirect("NoteList.aspx?ContentID=" + cid + "&Origin=" + origin); } } else { lbWho.Text = origin; } }
private void Page_Load(object sender, System.EventArgs e) { nid = Convert.ToInt32(Request.QueryString["NoteID"]); origin = Request.QueryString["Origin"]; if (nid == 0) { Page_Error("NoteID Missing"); } if (!IsPostBack) { Account account = new Account(appEnv.GetConnection()); AccountProperty property = new AccountProperty(appEnv.GetConnection()); DataRow dr = new ContentNotes(appEnv.GetConnection()).GetNote(nid); lbWho.Text = origin; lbContentID.Text = dr["ContentID"].ToString(); lbNote.Text = dr["Note"].ToString(); lbAuthor.Text = property.GetValue(Convert.ToInt32(dr["Author"]), "UserName").Trim(); lbModifiedDate.Text = dr["ModifiedDate"].ToString(); lbCreationDate.Text = dr["CreationDate"].ToString(); if (account.GetAccountID(User.Identity.Name) != Convert.ToInt32(dr["Author"])) { bnUpdate.Visible = false; bnRemove.Visible = false; } } }
private void BuildOrigPage() { AccountProperty property = new AccountProperty(appEnv.GetConnection()); DataRow dr = new ContentNotes(appEnv.GetConnection()).GetNote(nid); lbContentID.Text = dr["ContentID"].ToString(); tbNote.Text = dr["Note"].ToString(); lbAuthor.Text = property.GetValue(Convert.ToInt32(dr["Author"]), "UserName").Trim(); lbModifiedDate.Text = dr["ModifiedDate"].ToString(); lbCreationDate.Text = dr["CreationDate"].ToString(); }
protected void bnUpdate_Click(object sender, System.EventArgs e) { if (Page.IsValid) { try { ContentNotes note = new ContentNotes(appEnv.GetConnection()); note.Update(nid, tbNote.Text); } catch (Exception err) { Page_Error("The following error occured: " + err.Message); } Response.Redirect("NoteList.aspx?ContentID=" + lbContentID.Text + "&origin=" + origin); } }
private void Page_Load(object sender, System.EventArgs e) { nid = Convert.ToInt32(Request.QueryString["NoteID"]); origin = Request.QueryString["Origin"]; if (nid == 0) { Page_Error("NoteID Missing"); } notes = new ContentNotes(appEnv.GetConnection()); DataRow dr = notes.GetNote(nid); lbWho.Text = origin; lbContentID.Text = dr["ContentID"].ToString(); lbWhichNote.Text = dr["Note"].ToString(); }
protected void Page_Load(object sender, System.EventArgs e) { account = new Account(appEnv.GetConnection()); content = new MyContent(appEnv.GetConnection()); notes = new ContentNotes(appEnv.GetConnection()); DataTable dt; int accountNo = account.GetAccountID(User.Identity.Name); if (accountNo == 1) // Admin sees all { dt = content.GetHeadlines(); } else { dt = content.GetHeadlinesForAuth(accountNo); } LiteralControl lit; TableCell cell; int prv = -1; int cur; foreach (DataRow dr in dt.Rows) { cur = Convert.ToInt32(dr["ContentID"]); if (cur != prv) { prv = cur; if (IsTypeRequested(dr["Status"].ToString())) { TableRow row = new TableRow(); tblView.Rows.Add(row); lit = new LiteralControl(dr["ContentID"].ToString()); cell = new TableCell(); cell.Controls.Add(lit); cell.HorizontalAlign = HorizontalAlign.Center; row.Cells.Add(cell); lit = new LiteralControl(dr["Version"].ToString()); cell = new TableCell(); cell.Controls.Add(lit); cell.HorizontalAlign = HorizontalAlign.Center; row.Cells.Add(cell); lit = new LiteralControl(dr["Headline"].ToString()); cell = new TableCell(); cell.Controls.Add(lit); row.Cells.Add(cell); lit = new LiteralControl(StatusCodes.ToString( Convert.ToInt32(dr["Status"]))); cell = new TableCell(); cell.Font.Size = new FontUnit(FontSize.XSmall); cell.HorizontalAlign = HorizontalAlign.Center; cell.Controls.Add(lit); row.Cells.Add(cell); BuildImageButton(row, "AutView.aspx?ContentID=" + dr["ContentID"].ToString(), -1); BuildImageButton(row, "../Note/NoteList.aspx?ContentID=" + dr["ContentID"].ToString() + "&Origin=Author", notes.CountNotesForID(Convert.ToInt32(dr["ContentID"]))); if (StatusCodes.isCreating(dr["Status"].ToString())) { BuildImageButton(row, "AutUpdate.aspx?ContentID=" + dr["ContentID"].ToString(), -1); BuildImageButton(row, "AutSubmit.aspx?ContentID=" + dr["ContentID"].ToString(), -1); BuildImageButton(row, "AutRemove.aspx?ContentID=" + dr["ContentID"].ToString(), -1); } else { BuildImageButton(row, null, -1); BuildImageButton(row, null, -1); BuildImageButton(row, null, -1); } } } } }
private void Page_Load(object sender, System.EventArgs e) { cid = Convert.ToInt32(Request.QueryString["ContentID"]); origin = Request.QueryString["Origin"]; if (cid == 0) { Page_Error("ContentID Missing"); } AccountProperty property = new AccountProperty(appEnv.GetConnection()); account = new Account(appEnv.GetConnection()); note = new ContentNotes(appEnv.GetConnection()); DataTable dt = note.GetNotesForID(cid); LiteralControl lit; TableCell cell; lbWho.Text = origin; foreach (DataRow dr in dt.Rows) { TableRow row = new TableRow(); tblView.Rows.Add(row); lit = new LiteralControl(dr["ModifiedDate"].ToString()); cell = new TableCell(); cell.Font.Size = new FontUnit(FontSize.XSmall); cell.Controls.Add(lit); row.Cells.Add(cell); lit = new LiteralControl(property.GetValue(Convert.ToInt32(dr["Author"]), "UserName").Trim()); cell = new TableCell(); cell.Controls.Add(lit); cell.HorizontalAlign = HorizontalAlign.Center; row.Cells.Add(cell); string tmp = dr["Note"].ToString(); if (tmp.Length > 80) { tmp = tmp.Substring(0, 80); tmp += "..."; } lit = new LiteralControl(tmp); cell = new TableCell(); cell.Controls.Add(lit); row.Cells.Add(cell); BuildImageButton(row, "NoteView.aspx?NoteID=" + dr["NoteID"].ToString() + "&Origin=" + origin); if (account.GetAccountID(User.Identity.Name) == Convert.ToInt32(dr["Author"])) { BuildImageButton(row, "NoteUpdate.aspx?NoteID=" + dr["NoteID"].ToString() + "&Origin=" + origin); BuildImageButton(row, "NoteRemove.aspx?NoteID=" + dr["NoteID"].ToString() + "&Origin=" + origin); } else { BuildImageButton(row, null); BuildImageButton(row, null); } } }