protected void ShowForumThreadGrid(DataGrid dataGrid,
int index, string sort, string order, Guid groupGuid)
{
dataGrid.PageSize = Helpers.GetPageSize("PageSize.ForumThreadList");
// Get query result from database
ForumThread filter = new ForumThread(Guid.NewGuid());
filter.FilterOnIsactive = 1;
filter.ForumGroupRef = groupGuid;
IForumThreadService srv = ServiceFactory.GetForumThreadService();
ForumThreadContainer selected = srv.ForumThreadSelectFiltered(filter);
if (selected.AllCount > 0)
{
dataGrid.Visible = true;
lblNotFound.Visible = false;
}
else
{
dataGrid.Visible = false;
lblNotFound.Visible = true;
return;
}
ArrayList sortableList = null;
// Sort if necessary
if (sort == null)
{
sortableList = selected.All.Items;
}
else
{
if (String.Compare(order, "Ascending", true) == 0)
{
sortableList = selected.All.SortBy(sort, true);
}
else if (String.Compare(order, "Descending", true) == 0)
{
sortableList = selected.All.SortBy(sort, false);
}
else
{
sortableList = selected.All.SortBy(sort);
}
}
// Bind list to datagrid control
dataGrid.CurrentPageIndex = index;
dataGrid.CurrentSortExpression = sort;
dataGrid.CurrentSortOrder = order;
dataGrid.DataSource = sortableList;
dataGrid.DataBind();
}
protected void btnCreate_Click(object sender, EventArgs e)
{
try
{
string groupId = Request["groupId"];
Guid groupGuid = new Guid(groupId);
ForumThread forumThread = new ForumThread(Guid.NewGuid());
forumThread.Name = txtName.Text;
// Modification HP060111 Begin
// Replacing line ends
string desc = txtDescription.Text;
string newLine = "\r\n";
desc = desc.Replace(newLine, "<br/>");
forumThread.Description = desc;
// Modification HP060111 End
forumThread.ForumGroupRef = groupGuid;
if (!Context.User.Identity.IsAuthenticated)
{
forumThread.CreatedBy = txtCreatedBy.Text;
}
forumThread.IsActive = true;
IForumThreadService srv = ServiceFactory.GetForumThreadService();
srv.ForumThreadInsert(forumThread);
Response.Redirect("ForumThreadList.aspx?groupId=" + groupId);
}
catch (Exception ex)
{
errorPanel.Exception = ex;
}
}
public virtual void ForumThreadUpdate(ForumThread entity)
{
TraceCallEnterEvent.Raise();
try
{
m_DataContext.BeginNestedTran();
try
{
int count;
m_DataContext.ndihdForumThreadUpdate(entity.ID,
entity.Name,
entity.Description,
entity.CreatedBy,
entity.CreatedDate,
entity.IsActive,
entity.ForumGroupRef, out count);
if (count == 0) throw new ServiceUpdateException();
m_DataContext.CommitNested();
}
catch
{
m_DataContext.RollbackNested();
throw;
}
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public virtual ForumThread ForumThreadSelect(DBGuid IDVal)
{
TraceCallEnterEvent.Raise();
try
{
ForumThread result = null;
DataSet entitySet = m_DataContext.ndihdForumThreadSelect(IDVal);
if (entitySet.Tables[0].Rows.Count != 0)
{
result = new ForumThread(entitySet);
}
TraceCallReturnEvent.Raise();
return result;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public virtual void ForumThreadInsert(ForumThread entity)
{
TraceCallEnterEvent.Raise();
try
{
m_DataContext.BeginNestedTran();
try
{
m_DataContext.ndihdForumThreadInsert(entity.ID,
entity.Name,
entity.Description,
entity.CreatedBy,
entity.CreatedDate,
entity.IsActive,
entity.ForumGroupRef);
m_DataContext.CommitNested();
}
catch
{
m_DataContext.RollbackNested();
throw;
}
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public virtual void ForumThreadDelete(ForumThread entity)
{
TraceCallEnterEvent.Raise();
try
{
m_DataContext.BeginNestedTran();
try
{
m_DataContext.ndihdForumThreadDelete(entity.ID);
m_DataContext.CommitNested();
}
catch
{
m_DataContext.RollbackNested();
throw;
}
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
// -------------------------------------------------------------------------------------
/// <summary>
/// Copy constructor.
/// </summary>
/// <param name="IDVal">Value of 'uID' field</param>
/// <param name="origInstance">Original document data to copy.</param>
// -------------------------------------------------------------------------------------
public ForumThread(DBGuid IDVal,
ForumThread origInstance)
: base(IDVal, origInstance)
{
}
// -------------------------------------------------------------------------------------
/// <summary>
/// Copy constructor.
/// </summary>
/// <param name="origInstance">Original document data to copy.</param>
// -------------------------------------------------------------------------------------
public ForumThread(ForumThread origInstance)
: base(origInstance)
{
}
public new void ForumThreadInsert(ForumThread entity)
{
TraceCallEnterEvent.Raise();
try
{
// check required fields:
if (entity.ID.IsNull)
throw new ArgumentNullException("ForumThread.ID", "A fórum szál azonosítója nincs megadva.");
if (entity.Name.Length == 0)
throw new ArgumentNullException("ForumThread.Name", "A fórum szál neve nincs megadva.");
if (entity.Description.Length == 0)
throw new ArgumentNullException("ForumThread.Description", "A fórum szál leírása nincs megadva.");
if (entity.ForumGroupRef.IsNull)
throw new ArgumentNullException("ForumThread.ForumGroupRef", "A fórum téma azonosítója nincs megadva.");
// logical checks:
ForumGroupService groupSrv = new ForumGroupService();
ForumGroup group = groupSrv.ForumGroupSelect(entity.ForumGroupRef);
if (group == null)
throw new ApplicationException("A megadott azonosítóval nem létezik fórum téma.");
if (!group.IsActive)
throw new ApplicationException("A fórum téma nem aktív.");
// check permission:
if (!group.VisibleForVisitor)
{
PrincipalPermission permReg = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Registered");
PrincipalPermission permAdmin =
new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Administrator");
permReg.Union(permAdmin).Demand();
}
// save data:
entity.CreatedDate = DBDateTime.Now;
if (Thread.CurrentPrincipal.Identity.IsAuthenticated)
{
entity.CreatedBy = Thread.CurrentPrincipal.Identity.Name;
}
else
{
if (entity.CreatedBy.Length == 0)
{
entity.CreatedBy = "Anonymous";
}
}
base.ForumThreadInsert(entity);
BusinessAuditEvent.Success(
new EventParameter("ForumThreadID", entity.ID.ToString()),
new EventParameter("ForumThreadName", entity.Name)
);
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
BusinessAuditEvent.Fail(
new EventParameter("Exception", ex.ToString()),
new EventParameter("ForumThreadID", entity.ID.ToString()),
new EventParameter("ForumThreadName", entity.Name)
);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public new void ForumThreadUpdate(ForumThread entity)
{
// Check permission: Admin
PrincipalPermission permAdmin = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Administrator");
permAdmin.Demand();
TraceCallEnterEvent.Raise();
try
{
// Check required fields
if (entity.Name.Length == 0)
throw new ArgumentNullException("ForumThread.Name", "A fórum szál neve nincs megadva.");
if (entity.Description.Length == 0)
throw new ArgumentNullException("ForumThread.Description", "A fórum szál leírása nincs megadva.");
// Logical checks
ForumThread selected = base.ForumThreadSelect(entity.ID);
if (selected == null)
throw new ApplicationException("A megadott azonosítóval nem létezik fórum szál.");
// Save data
selected.IsActive = entity.IsActive;
selected.Name = entity.Name;
selected.Description = entity.Description;
base.ForumThreadUpdate(selected);
BusinessAuditEvent.Success(
new EventParameter("ForumThreadID", entity.ID.ToString()),
new EventParameter("ForumThreadName", entity.Name)
);
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
BusinessAuditEvent.Fail(
new EventParameter("Exception", ex.ToString()),
new EventParameter("ForumThreadID", entity.ID.ToString()),
new EventParameter("ForumThreadName", entity.Name)
);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public ForumThreadContainer ForumThreadSelectFiltered(ForumThread filter)
{
TraceCallEnterEvent.Raise();
try
{
ForumThreadContainer result;
DataSet entitySet = m_DataContext.ndihdForumThreadSelectFiltered(
filter.Name,
filter.ForumGroupRef,
filter.FilterOnLastItemFrom,
filter.FilterOnLastItemTo,
filter.FilterOnIsactive);
result = new ForumThreadContainer(entitySet.Tables[0]);
TraceCallReturnEvent.Raise();
return result;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
/// <summary>
/// Fill datagrid with data
/// </summary>
private void FillDatagrid(DBGuid ID)
{
try
{
string sSortColumn = "Name";
int nSelectedRow = -1;
// Storing the previous sort order
if (dtgMain.DataSource != null)
{
sSortColumn = ((DataTable) dtgMain.DataSource).DefaultView.Sort;
}
// Set filter
ForumThread filter = new ForumThread(Guid.Empty);
filter.FilterOnIsactive = DBInt.Null;
if (cmbStatus.SelectedIndex > 0)
{
bool bIsActive = (cmbStatus.SelectedValue.ToString() == "1" ? true : false);
filter.FilterOnIsactive = (DBInt) Convert.ToInt32(bIsActive);
filter.IsActive = bIsActive;
}
if (cmbForumGroup.SelectedIndex > 0)
{
filter.ForumGroupRef = new DBGuid(new Guid(cmbForumGroup.SelectedValue.ToString()));
}
if (dtpLastItemFrom.Checked)
{
filter.FilterOnLastItemFrom = new DBDateTime(dtpLastItemFrom.Value);
}
if (dtpLastItemTo.Checked)
{
DBDateTime dateTo = new DBDateTime(dtpLastItemTo.Value);
filter.FilterOnLastItemTo = dateTo.AddDays(1).AddMilliseconds(-1);
}
// Retrieving data from BusinessServices
IForumThreadService srv = ServiceFactory.GetForumThreadService();
ForumThreadContainer allData = srv.ForumThreadSelectFiltered(filter);
DataTable dt = allData.AllAsDatatable;
dt.DefaultView.Sort = sSortColumn;
dtgMain.DataSource = dt;
// Locates the row specified by ID param
if (!ID.IsNull)
{
BindingManagerBase bm = dtgMain.BindingContext[dtgMain.DataSource, dtgMain.DataMember];
DataRow dr;
for (int i = 0; i < bm.Count; i++)
{
dr = ((DataRowView) bm.Current).Row;
if (ID.Value.Equals(dr["ID"]))
{
nSelectedRow = i;
break;
}
bm.Position += 1;
}
}
// Makes the row selected
if (nSelectedRow <= ((DataTable) dtgMain.DataSource).DefaultView.Count && nSelectedRow > -1)
{
dtgMain.Select(nSelectedRow);
dtgMain.CurrentRowIndex = nSelectedRow;
}
else if (((DataTable) dtgMain.DataSource).DefaultView.Count != 0)
{
dtgMain.Select(0);
}
// Enabling or disabling the buttons according to record count.
// And is because of previous disable state.
bool bIsEmptyGrid = (((DataTable) dtgMain.DataSource).DefaultView.Count == 0);
tbbInactivate.Enabled = ! bIsEmptyGrid;
tbbModify.Enabled = ! bIsEmptyGrid;
}
catch (Exception ex)
{
// --- Log exception
ExceptionManager.Publish(ex);
// --- Display Exception
ErrorHandler.DisplayError("Nem várt hiba lépett fel a lista frissítése során.", ex);
}
}
// -------------------------------------------------------------------------------------
/// <summary>
/// Prepage Save action
/// </summary>
// -------------------------------------------------------------------------------------
private void SaveData()
{
if (m_bNewItem)
{
CurrentID = new DBGuid(Guid.NewGuid());
}
IForumThreadService srv = ServiceFactory.GetForumThreadService();
ForumThread fth = new ForumThread(CurrentID);
// Get control values
fth.Name = txtName.Text;
fth.Description = txtDescription.Text;
fth.IsActive = cbxActivate.Checked;
fth.ForumGroupRef = new Guid(cmbForumGroup.SelectedValue.ToString());
// Save values
if (m_bNewItem)
srv.ForumThreadInsert(fth);
else
srv.ForumThreadUpdate(fth);
}
