public static List <Message> GetMessages()
{
using (var dbContext = new BasicContext(ConnectionString))
{
return(dbContext.Messages.OrderByDescending(x => x.Timestamp).Take(Limit).OrderBy(x => x.Timestamp).ToList());
}
}
/// <summary>
/// Read - Vehicles List
/// </summary>
/// <returns></returns>
public List <Vehicle> GetVehicles()
{
using (var ctx = new BasicContext())
{
return(ctx.Vehicles.ToList());
}
}
CanGetSalt()
{
using (var context = new BasicContext()) {
var service = context.Resolve <IHashService>();
Assert.AreEqual("SALT", service.NewSalt());
}
}
public IEnumerable <ProductMISInfo> GetProductMIS()
{
using (BasicContext entityContext = new BasicContext())
{
var query = from a in entityContext.ProductMISSet
join b in entityContext.ProductSet on a.ProductCode equals b.Code
join c in entityContext.TeamSet on a.TeamCode equals c.Code
join d in entityContext.TeamSet on a.AccountOfficerCode equals d.Code into parents
from pt in parents.DefaultIfEmpty()
join h in entityContext.BSCaptionSet on a.CaptionCode equals h.CaptionCode
join i in entityContext.TeamDefinitionSet on a.TeamDefinitionCode equals i.Code
join j in entityContext.TeamDefinitionSet on a.AccountOfficerDefinitionCode equals j.Code into jparents
from jt in jparents.DefaultIfEmpty()
select new ProductMISInfo()
{
ProductMIS = a,
Product = b,
TeamDefinition = i,
Team = c,
AccountOfficerDefinition = jt,
AccountOfficer = pt,
Caption = h
};
return(query.ToFullyLoaded());
}
}
public IEnumerable <AccountMISInfo> GetAccountMISs()
{
using (BasicContext entityContext = new BasicContext())
{
var query = from a in entityContext.AccountMISSet
join c in entityContext.TeamSet on a.TeamCode equals c.Code
join e in entityContext.TeamSet on a.AccountOfficerCode equals e.Code into parents
from pt in parents.DefaultIfEmpty()
join b in entityContext.TeamDefinitionSet on a.TeamDefinitionCode equals b.Code
join d in entityContext.TeamDefinitionSet on a.AccountOfficerDefinitionCode equals d.Code into jparents
from jt in jparents.DefaultIfEmpty()
join f in entityContext.CustAccountSet on a.AccountNo equals f.AccountNo into fparents
from ft in fparents.DefaultIfEmpty()
select new AccountMISInfo()
{
AccountMIS = a,
TeamDefinition = b,
Team = c,
AccountOfficerDefinition = jt,
AccountOfficer = pt,
CustAccount = ft
};
return(query.ToFullyLoaded());
}
}
/**
* Creates a new empty context (with no variables) that contains all the
* behaviour trees specified in <code>library</code>.
*
* @param library
* the set of behaviour trees that the returned IContext will
* contain.
* @return a new empty context that contains all the behaviour trees
* specified in <code>library</code>.
*/
public static IContext CreateContext(IBTLibrary library)
{
var result = new BasicContext();
result.AddBTLibrary(library);
return(result);
}
/// <summary>
/// Find vehicle by Id
/// </summary>
/// <param name="vehicleId"></param>
/// <returns></returns>
private Vehicle FindById(int vehicleId)
{
using (var ctx = new BasicContext())
{
return(ctx.Vehicles.Find(vehicleId));
}
}
public IEnumerable <string> GetDistinctLoanPeriodicScheduleRefNos()
{
BasicContext entityContext = new BasicContext();
var query = (entityContext.LoanPeriodicScheduleSet.Select <LoanPeriodicSchedule, string>(r => r.RefNo)).Distinct();
return(query.ToFullyLoaded());
}
public IEnumerable <TBillsComputationResult> GetTBillsComputationResultRefNos(string tBillsComputationResultClassification)
{
BasicContext entityContext = new BasicContext();
var query = entityContext.TBillsComputationResultSet.AsQueryable().Where(r => r.Classification == tBillsComputationResultClassification);
return(query.ToFullyLoaded());
}
public IEnumerable <LoanPeriodicSchedule> GetLoanPeriodicScheduleRefNos(string loanPeriodicScheduleRefNo)
{
BasicContext entityContext = new BasicContext();
var query = entityContext.LoanPeriodicScheduleSet.AsQueryable().Where(r => r.RefNo == loanPeriodicScheduleRefNo);
return(query.ToFullyLoaded());
}
public IEnumerable <string> GetDistinctBondComputationResultZeroRefNos()
{
BasicContext entityContext = new BasicContext();
var query = (entityContext.BondComputationResultZeroSet.Select <BondComputationResultZero, string>(r => r.RefNo)).Distinct();
return(query.ToFullyLoaded());
}
public IEnumerable <BondComputationResultZero> GetBondComputationResultZeroRefNos(string bondComputationResultZeroRefNo)
{
BasicContext entityContext = new BasicContext();
var query = entityContext.BondComputationResultZeroSet.AsQueryable().Where(r => r.RefNo == bondComputationResultZeroRefNo);
return(query.ToFullyLoaded());
}
public IEnumerable <IndividualImpairment> GetIndividualImpairments()
{
using (BasicContext entityContext = new BasicContext())
{
var query = entityContext.IndividualImpairmentSet.AsQueryable().Where(r => r.Processed == false);
return(query.ToFullyLoaded());
}
}
/// <summary>
/// Delete = Delete vehicle
/// </summary>
/// <param name="vehicleId"></param>
public void DeleteVehicle(int vehicleId)
{
using (var ctx = new BasicContext())
{
var vehicle = FindById(vehicleId);
ctx.Remove(vehicle);
SaveChanges(ctx);
}
}
public void Indexer_doesnt_throw_when_passed_unknown_variable_name()
{
var context = new BasicContext();
Assert.DoesNotThrow(() =>
{
var str = (string)context["unknown"];
});
}
public void Setup()
{
_connectionString = "server=localhost; Database=BChat; Integrated Security=True";
using (var dbContext = new BasicContext(_connectionString))
{
dbContext.Database.EnsureCreated();
}
Repository.ConnectionString = _connectionString;
}
public IEnumerable <string> GetDistinctRefNos()
{
using (BasicContext entityContext = new BasicContext())
{
var query = (entityContext.LoanDetailsSet.Select <LoanDetails, string>(r => r.RefNo)).Distinct();
return(query.ToFullyLoaded());
}
}
public IEnumerable <LoanDetails> GetIndividualImpairments(string refNo)
{
using (BasicContext entityContext = new BasicContext())
{
var query = entityContext.LoanDetailsSet.AsQueryable().Where(r => r.RefNo == refNo);
return(query.ToFullyLoaded());
}
}
/// <summary>
/// Create = Create vehicle
/// </summary>
/// <param name="vehicle"></param>
/// <returns></returns>
public Vehicle CreateVehicle(Vehicle vehicle)
{
using (var ctx = new BasicContext())
{
ctx.Add(vehicle);
SaveChanges(ctx);
return(vehicle);
}
}
protected override IEnumerable <PLIncomeReportAdjustment> GetEntities(BasicContext entityContext)
{
//return from e in entityContext.Set<PLIncomeReportAdjustment>()
// select e;
var query = (from e in entityContext.Set <PLIncomeReportAdjustment>()
select e).Take(5000);
var results = query;
return(results);
}
protected override PLIncomeReportAdjustment GetEntity(BasicContext entityContext, int id)
{
var query = (from e in entityContext.Set <PLIncomeReportAdjustment>()
where e.Id == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override TBillsComputationResult GetEntity(BasicContext entityContext, int id)
{
var query = (from e in entityContext.Set <TBillsComputationResult>()
where e.Id == id
select e);
var results = query.FirstOrDefault();
return(results);
}
public void RedisContext_CanConnectWithConnectionString()
{
// Arrange
// Act
var context = new BasicContext();
// Assert
Assert.True(context.ConnectionMultiplexer.IsConnected);
}
protected override ActivityBase GetEntity(BasicContext entityContext, int id)
{
var query = (from e in entityContext.Set <ActivityBase>()
where e.ActivityBaseId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override MPRPLDerivedCaption GetEntity(BasicContext entityContext, int id)
{
var query = (from e in entityContext.Set <MPRPLDerivedCaption>()
where e.PLDerivedCaptionId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override CollateralInformation GetEntity(BasicContext entityContext, int id)
{
var query = (from e in entityContext.Set <CollateralInformation>()
where e.CollateralInformationId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override LoanPeriodicSchedule GetEntity(BasicContext entityContext, int id)
{
var query = (from e in entityContext.Set <LoanPeriodicSchedule>()
where e.Id == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override CustAccount GetEntity(BasicContext entityContext, int id)
{
var query = (from e in entityContext.Set <CustAccount>()
where e.CustAccountId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override TeamDefinition GetEntity(BasicContext entityContext, int id)
{
var query = (from e in entityContext.Set <TeamDefinition>()
where e.TeamDefinitionId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override BranchDefaultMIS GetEntity(BasicContext entityContext, int id)
{
var query = (from e in entityContext.Set <BranchDefaultMIS>()
where e.BranchDefaultMISId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override IEnumerable <Revenue> GetEntities(BasicContext entityContext)
{
// return from e in entityContext.Set<Revenue>()
// select e;
var query = (from e in entityContext.Set <Revenue>()
select e).Take(5000);
var results = query;
return(results);
}
public RedisSetMockTests()
{
_context = RedisContextMock<BasicContext>.Create();
}
