public StatsEN ReadOIDDefault(int id
)
{
StatsEN statsEN = null;
try
{
SessionInitializeTransaction();
statsEN = (StatsEN)session.Get(typeof(StatsEN), id);
SessionCommit();
}
catch (Exception ex) {
SessionRollBack();
if (ex is PickadosGenNHibernate.Exceptions.ModelException)
{
throw ex;
}
throw new PickadosGenNHibernate.Exceptions.DataLayerException("Error in StatsCAD.", ex);
}
finally
{
SessionClose();
}
return(statsEN);
}
public void DeleteMonthlyStats(int id
)
{
try
{
SessionInitializeTransaction();
StatsEN statsEN = (StatsEN)session.Load(typeof(StatsEN), id);
session.Delete(statsEN);
SessionCommit();
}
catch (Exception ex) {
SessionRollBack();
if (ex is PickadosGenNHibernate.Exceptions.ModelException)
{
throw ex;
}
throw new PickadosGenNHibernate.Exceptions.DataLayerException("Error in StatsCAD.", ex);
}
finally
{
SessionClose();
}
}
public int NewMonthlyStats(StatsEN stats)
{
try
{
SessionInitializeTransaction();
if (stats.Tipster != null)
{
// Argumento OID y no colección.
stats.Tipster = (PickadosGenNHibernate.EN.Pickados.TipsterEN)session.Load(typeof(PickadosGenNHibernate.EN.Pickados.TipsterEN), stats.Tipster.Id);
stats.Tipster.MonthlyStats
.Add(stats);
}
session.Save(stats);
SessionCommit();
}
catch (Exception ex) {
SessionRollBack();
if (ex is PickadosGenNHibernate.Exceptions.ModelException)
{
throw ex;
}
throw new PickadosGenNHibernate.Exceptions.DataLayerException("Error in StatsCAD.", ex);
}
finally
{
SessionClose();
}
return(stats.Id);
}
public int NewMonthlyStats(double p_benefit, double p_stakeAverage, float p_yield, double p_oddAverage, int p_totalPicks, Nullable <DateTime> p_initialDate, int p_tipster)
{
StatsEN statsEN = null;
int oid;
//Initialized StatsEN
statsEN = new StatsEN();
statsEN.Benefit = p_benefit;
statsEN.StakeAverage = p_stakeAverage;
statsEN.Yield = p_yield;
statsEN.OddAverage = p_oddAverage;
statsEN.TotalPicks = p_totalPicks;
statsEN.InitialDate = p_initialDate;
if (p_tipster != -1)
{
// El argumento p_tipster -> Property tipster es oid = false
// Lista de oids id
statsEN.Tipster = new PickadosGenNHibernate.EN.Pickados.TipsterEN();
statsEN.Tipster.Id = p_tipster;
}
//Call to StatsCAD
oid = _IStatsCAD.NewMonthlyStats(statsEN);
return(oid);
}
public void ModifyMonthlyStats(int p_Stats_OID, double p_benefit, double p_stakeAverage, float p_yield, double p_oddAverage, int p_totalPicks, Nullable <DateTime> p_initialDate)
{
StatsEN statsEN = null;
//Initialized StatsEN
statsEN = new StatsEN();
statsEN.Id = p_Stats_OID;
statsEN.Benefit = p_benefit;
statsEN.StakeAverage = p_stakeAverage;
statsEN.Yield = p_yield;
statsEN.OddAverage = p_oddAverage;
statsEN.TotalPicks = p_totalPicks;
statsEN.InitialDate = p_initialDate;
//Call to StatsCAD
_IStatsCAD.ModifyMonthlyStats(statsEN);
}
// Modify default (Update all attributes of the class)
public void ModifyDefault(StatsEN stats)
{
try
{
SessionInitializeTransaction();
StatsEN statsEN = (StatsEN)session.Load(typeof(StatsEN), stats.Id);
statsEN.Benefit = stats.Benefit;
statsEN.StakeAverage = stats.StakeAverage;
statsEN.Yield = stats.Yield;
statsEN.OddAverage = stats.OddAverage;
statsEN.TotalPicks = stats.TotalPicks;
statsEN.InitialDate = stats.InitialDate;
session.Update(statsEN);
SessionCommit();
}
catch (Exception ex) {
SessionRollBack();
if (ex is PickadosGenNHibernate.Exceptions.ModelException)
{
throw ex;
}
throw new PickadosGenNHibernate.Exceptions.DataLayerException("Error in StatsCAD.", ex);
}
finally
{
SessionClose();
}
}
