public async Task <bool> GetAllNBTScoresAsync(IntakeYear period)
{
log4net.Config.XmlConfigurator.Configure();
// BasicConfigurator.Configure();
bool isloaded = false;
AllScores = new ObservableCollection <CompositBDO>();
using (var context = new NBT_ProductionEntities())
{
var scores = await context.Composits.Where(x => x.DOT > period.yearStart && x.DOT < period.yearEnd).Select(m => m).ToListAsync();
if (scores != null)
{
isloaded = true;
foreach (var score in scores)
{
var NBTScore = new CompositBDO();
CompositDALToCompositBDO(NBTScore, score);
AllScores.Add(NBTScore);
}
}
}
log.Info("Composite is loaded");
return(isloaded);
}
public async Task <ObservableCollection <CompositBDO> > GetAllNBTScoresAsync(IntakeYearsBDO period)
{
var AllScores = new ObservableCollection <CompositBDO>();
using (var context = new NBT_ProductionEntities())
{
var scores = await context.Composits.Where(x => x.DOT >= period.yearStart && x.DOT <= period.yearEnd).Select(m => m).ToListAsync();
if (scores != null)
{
// isloaded = true;
foreach (var score in scores)
{
var NBTScore = new CompositBDO();
CompositDALToCompositBDO(NBTScore, score);
AllScores.Add(NBTScore);
}
}
else
{
string msg = "No such intake year " + period.Year;
log.Error(msg);
}
}
return(AllScores);
}
public IntakeYear GetIntakeRecord(int year)
{
var myYear = new IntakeYear();
using (var context = new NBT_ProductionEntities())
{
myYear = context.IntakeYears.Where(x => x.Year == year).Select(m => m).FirstOrDefault();
}
return(myYear);
}
public List <IntakeYearsBDO> GetAllIntakeYears()
{
var periods = new List <IntakeYearsBDO>();
using (var context = new NBT_ProductionEntities())
{
var period = context.IntakeYears.ToList();
foreach (var yr in period)
{
var yrBDO = new IntakeYearsBDO();
IntakeYearDalToIntakeYearBDO(yr, yrBDO);
periods.Add(yrBDO);
}
}
return(periods);
}
public ProvinceBDO getProvinceByID(int code)
{
ProvinceBDO provinceBDO = null;
int ProvID = code;
using (var context = new NBT_ProductionEntities())
{
var prov = context.Provinces.Where(x => x.Code == ProvID).FirstOrDefault();
if (prov != null)
{
provinceBDO = new ProvinceBDO();
ProvinceToProvinceBDO(provinceBDO, prov);
}
}
return(provinceBDO);
}
public List <VenueBDO> GetAllvenues()
{
List <VenueBDO> venuesBDO = new List <VenueBDO>();
using (var context = new NBT_ProductionEntities())
{
List <TestVenue> venues = (from a in context.TestVenues
select a).ToList();
foreach (var v in venues)
{
VenueBDO vbdo = new VenueBDO();
TestVenueToVenueBDO(vbdo, v);
// vbdo.IsDirty = false;
// vbdo.Province = getProvinceByID(vbdo.ProvinceID);
venuesBDO.Add(vbdo);
}
}
return(venuesBDO);
}
public List <UserBDO> GetAllUsers()
{
List <UserBDO> myUsers = new List <UserBDO>();
using (var context = new NBT_ProductionEntities())
try
{
List <User> DbUsers = context.Users.Select(x => x).ToList();
foreach (User person in DbUsers)
{
UserBDO M_User = new UserBDO();
UserDALToUserBDO(M_User, person);
myUsers.Add(M_User);
}
}
catch (Exception ex)
{
throw ex;
}
return(myUsers);
}
