public virtual void CompetitionDelete(Competition entity)
{
TraceCallEnterEvent.Raise();
try
{
m_DataContext.BeginNestedTran();
try
{
m_DataContext.ndihdCompetitionDelete(entity.ID);
m_DataContext.CommitNested();
}
catch
{
m_DataContext.RollbackNested();
throw;
}
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public new void CompetitionInsert(Competition entity)
{
// Check permission: Admin
PrincipalPermission permAdmin = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Administrator");
permAdmin.Demand();
TraceCallEnterEvent.Raise();
try
{
if (entity.ID.IsNull)
throw new ArgumentNullException("Competition.ID", "A pályázat azonosítója nincs megadva.");
if (entity.Name.Length == 0)
throw new ArgumentNullException("Competition.Name", "A pályázat neve nincs megadva.");
if (entity.Url.Length == 0)
throw new ArgumentNullException("Competition.Url", "A pályázat linkje (Url) nincs megadva.");
// Save data
entity.CreatedDate = DBDateTime.Now;
base.CompetitionInsert(entity);
BusinessAuditEvent.Success(
new EventParameter("CompetitionID", entity.ID),
new EventParameter("CompetitionName", entity.Name)
);
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
BusinessAuditEvent.Fail(
new EventParameter("Exception", ex.ToString()),
new EventParameter("CompetitionID", entity.ID),
new EventParameter("CompetitionName", entity.Name)
);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public new void CompetitionUpdate(Competition 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("Competition.Name", "A pályázat neve nincs megadva.");
if (entity.Url.Length == 0)
throw new ArgumentNullException("Competition.Url", "A pályázat linkje (Url) nincs megadva.");
// Logical checks
Competition selected = base.CompetitionSelect(entity.ID);
if (selected == null)
throw new ApplicationException("A megadott azonosítóval nem létezik pályázat.");
// Save data
selected.Name = entity.Name;
selected.Url = entity.Url;
selected.Description = entity.Description;
selected.IsVisible = entity.IsVisible;
base.CompetitionUpdate(selected);
BusinessAuditEvent.Success(
new EventParameter("CompetitionID", entity.ID),
new EventParameter("CompetitionName", entity.Name)
);
TraceCallReturnEvent.Raise();
return;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
BusinessAuditEvent.Fail(
new EventParameter("Exception", ex.ToString()),
new EventParameter("CompetitionID", entity.ID),
new EventParameter("CompetitionName", entity.Name)
);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public CompetitionContainer CompetitionSelectFiltered(Competition filter)
{
// Check permission: Admin
PrincipalPermission permAdmin = new PrincipalPermission(Thread.CurrentPrincipal.Identity.Name, "Administrator");
permAdmin.Demand();
TraceCallEnterEvent.Raise();
try
{
CompetitionContainer result;
DataSet entitySet = m_DataContext.ndihdCompetitionSelectFiltered(
filter.FilterOnVisible);
result = new CompetitionContainer(entitySet.Tables[0]);
TraceCallReturnEvent.Raise();
return result;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public virtual Competition CompetitionSelect(DBGuid IDVal)
{
TraceCallEnterEvent.Raise();
try
{
Competition result = null;
DataSet entitySet = m_DataContext.ndihdCompetitionSelect(IDVal);
if (entitySet.Tables[0].Rows.Count != 0)
{
result = new Competition(entitySet);
}
TraceCallReturnEvent.Raise();
return result;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
TraceCallReturnEvent.Raise(false);
throw;
}
}
public virtual void CompetitionUpdate(Competition entity)
{
TraceCallEnterEvent.Raise();
try
{
m_DataContext.BeginNestedTran();
try
{
int count;
m_DataContext.ndihdCompetitionUpdate(entity.ID,
entity.Name,
entity.Url,
entity.Description,
entity.IsVisible,
entity.CreatedDate, 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 void CompetitionInsert(Competition entity)
{
TraceCallEnterEvent.Raise();
try
{
m_DataContext.BeginNestedTran();
try
{
m_DataContext.ndihdCompetitionInsert(entity.ID,
entity.Name,
entity.Url,
entity.Description,
entity.IsVisible,
entity.CreatedDate);
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 Competition(DBGuid IDVal,
Competition origInstance)
: base(IDVal, origInstance)
{
}
// -------------------------------------------------------------------------------------
/// <summary>
/// Copy constructor.
/// </summary>
/// <param name="origInstance">Original document data to copy.</param>
// -------------------------------------------------------------------------------------
public Competition(Competition origInstance)
: base(origInstance)
{
}
/// <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
Competition filter = new Competition(Guid.Empty);
filter.FilterOnVisible = DBInt.Null;
if (cmbVisible.SelectedIndex > 0)
{
bool bIsVisible = (cmbVisible.SelectedValue.ToString() == "1" ? true : false);
filter.FilterOnVisible = (DBInt) Convert.ToInt32(bIsVisible);
filter.IsVisible = bIsVisible;
}
// Retrieving data from BusinessServices
ICompetitionService srv = ServiceFactory.GetCompetitionService();
CompetitionContainer allData = srv.CompetitionSelectFiltered(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);
tbbModify.Enabled = ! bIsEmptyGrid;
tbbInactivate.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>
/// Create new or modify existing News item
/// </summary>
// -------------------------------------------------------------------------------------
private void SaveData()
{
ICompetitionService compSrv = ServiceFactory.GetCompetitionService();
Competition comp = null;
if (m_bNewEntity)
{
comp = new Competition(new DBGuid(Guid.NewGuid()));
}
else
{
comp = new Competition(CurrentID);
}
// Get control values
comp.Name = txtName.Text;
comp.Url = txtUrl.Text;
if (txtDescription.Text.Length > 0)
comp.Description = txtDescription.Text;
comp.IsVisible = cbxIsVisible.Checked;
// Save data
if (m_bNewEntity)
{
compSrv.CompetitionInsert(comp);
}
else
{
compSrv.CompetitionUpdate(comp);
}
}
