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; } }