private IList loadVezbaneSpraveTak1(GimnasticarUcesnik g)
{
IDataContext dataContext = null;
try
{
DataAccessProviderFactory factory = new DataAccessProviderFactory();
dataContext = factory.GetDataContext();
dataContext.BeginTransaction();
return dataContext.ExecuteNamedQuery(
"FindVezbaneSpraveForGimnasticar",
new string[] { "gim", "deoTakKod" },
new object[] { g, DeoTakmicenjaKod.Takmicenje1 });
}
catch (Exception ex)
{
if (dataContext != null && dataContext.IsInTransaction)
dataContext.Rollback();
throw new InfrastructureException(
Strings.getFullDatabaseAccessExceptionMessage(ex), ex);
}
finally
{
if (dataContext != null)
dataContext.Dispose();
dataContext = null;
}
}
private IList<Ocena> loadOcene(int takmicenjeId, DeoTakmicenjaKod deoTakKod)
{
IDataContext dataContext = null;
try
{
DataAccessProviderFactory factory = new DataAccessProviderFactory();
dataContext = factory.GetDataContext();
dataContext.BeginTransaction();
return dataContext.ExecuteNamedQuery<Ocena>(
"FindOceneByDeoTakmicenja",
new string[] { "takId", "deoTakKod" },
new object[] { takmicenjeId, deoTakKod });
}
catch (Exception ex)
{
if (dataContext != null && dataContext.IsInTransaction)
dataContext.Rollback();
throw new InfrastructureException(
Strings.getFullDatabaseAccessExceptionMessage(ex), ex);
}
finally
{
if (dataContext != null)
dataContext.Dispose();
dataContext = null;
}
}
private bool hasOcene(GimnasticarUcesnik g)
{
IDataContext dataContext = null;
try
{
DataAccessProviderFactory factory = new DataAccessProviderFactory();
dataContext = factory.GetDataContext();
dataContext.BeginTransaction();
IList<Ocena> result = dataContext.ExecuteNamedQuery<Ocena>(
"FindAllOceneForGimnasticar",
new string[] { "gim" },
new object[] { g });
return result.Count > 0;
}
catch (Exception ex)
{
if (dataContext != null && dataContext.IsInTransaction)
dataContext.Rollback();
throw new InfrastructureException(
Strings.getFullDatabaseAccessExceptionMessage(ex), ex);
}
finally
{
if (dataContext != null)
dataContext.Dispose();
dataContext = null;
}
}
