public void Dispose()
{
if (DataContextFactory.GetDataContext() != null)
{
DataContextFactory.GetDataContext().Dispose();
}
}
public RelationalRepository()
{
var context = DataContextFactory.GetDataContext();
this.dbContext = context ?? throw new ArgumentNullException(nameof(context));
this.dbSet = this.dbContext.Set <TEntity>();
}
public List <Book> findby(Func <IEnumerable <Book>, IEnumerable <Book> > query)
{
var dbcontext = DataContextFactory.GetDataContext();
List <Book> matchedBooks = query(dbcontext.Books).ToList();
return(matchedBooks);
}
public void PersistDeletionOf(IAggregateRoot entity)
{
var et = (T)entity;
et.IsRemoved = true;
DataContextFactory.GetDataContext().Entry <T>(et).State = EntityState.Modified;
}
public ObjectQuery<Timelog> Translate(Query query)
{
ObjectQuery<Timelog> timelogQuery;
if (query.IsNamedQuery())
{
timelogQuery = FindEFQueryFor(query);
}
else
{
StringBuilder queryBuilder = new StringBuilder();
IList<ObjectParameter> paraColl = new List<ObjectParameter>();
CreateQueryAndObjectParameters(query, queryBuilder, paraColl);
//[Edited By= Iman] :
if (query.OrderByProperty == null)
{
timelogQuery = DataContextFactory.GetDataContext().Timelogs
.Where(queryBuilder.ToString(), paraColl.ToArray());
}
else if (query.OrderByProperty.Desc == true)
{
timelogQuery = DataContextFactory.GetDataContext().Timelogs
.Where(queryBuilder.ToString(), paraColl.ToArray()).OrderBy(String.Format("it.{0} desc", query.OrderByProperty.PropertyName));
}
else
{
timelogQuery = DataContextFactory.GetDataContext().Timelogs
.Where(queryBuilder.ToString(), paraColl.ToArray()).OrderBy(String.Format("it.{0} asc", query.OrderByProperty.PropertyName));
}
//[Edited By= Iman] .
}
return timelogQuery;
}
public override View OnCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState)
{
Log.Debug(TAG, nameof(OnCreateView));
// Use this to return your custom view for this Fragment
// return inflater.Inflate(Resource.Layout.YourFragment, container, false);
//return base.OnCreateView(inflater, container, savedInstanceState);
View v = inflater.Inflate(Resource.Layout.Export, container, false);
dateFrom_button = v.FindViewById <Button>(Resource.Id.dateFrom_button);
dateFrom_button.Click += DateFrom_button_Click;
dateTo_button = v.FindViewById <Button>(Resource.Id.dateTo_button);
dateTo_button.Click += DateTo_button_Click;
export_button = v.FindViewById <Button>(Resource.Id.export_button);
export_button.Click += Export_button_Click;
earnings_checkBox = v.FindViewById <CheckBox>(Resource.Id.earnings_checkBox);
costs_checkBox = v.FindViewById <CheckBox>(Resource.Id.costs_checkBox);
string pathToDatabase = DeviceInfo.GetFileFinallPath(Resources.GetString(Resource.String.DBfilename));
db = DataContextFactory.GetDataContext(pathToDatabase);
InitLayout();
return(v);
}
public void ExecuteSqlCommand(string cmd)
{
this.dbContext.Database.ExecuteSqlCommand(cmd);
DataContextFactory.Clear();
var context = DataContextFactory.GetDataContext();
this.dbContext = context ?? throw new ArgumentNullException(nameof(context));
this.dbSet = this.dbContext.Set <TEntity>();
}
public async Task CanFindPersonByIdAPI()
{
var context = DataContextFactory.GetDataContext();
var movieRepo = new TheMovieDBRepository();
int id = 1245;
var m = await movieRepo.FindPersonById(id);
m.Should().NotBeNull();
}
public void Commit(bool resetAfterCommit)
{
DataContextFactory.GetDataContext().SaveChanges();
if (resetAfterCommit)
{
DataContextFactory.Clear();
}
}
public ReceiveAdapterDALEFTests()
{
_sampleData = new SampleData4ReceiveAdapter();
//Get&Set data context
var dataContext = DataContextFactory.GetDataContext();
//Set Data Access Layer
_receiveAdapterRepository = new ReceiveAdapterRepository(dataContext);
}
public override void OnCreate(Bundle savedInstanceState)
{
Log.Debug(TAG, nameof(OnCreate));
base.OnCreate(savedInstanceState);
string pathToDatabase = DeviceInfo.GetFileFinallPath(Resources.GetString(Resource.String.DBfilename));
db = DataContextFactory.GetDataContext(pathToDatabase);
}
public void CanAddUserUsingMegaMediaManagerContext()
{
using (new EFUnitOfWorkFactory().Create())
{
var context = DataContextFactory.GetDataContext();
var user = new User {
UserName = "******", Email = "*****@*****.**", PasswordHash = "123456"
};
context.Users.Add(user);
context.Users.Remove(user);
}
}
public IQueryable <T> FindAll(params Expression <Func <T, object> >[] includeProperties)
{
IQueryable <T> items = DataContextFactory.GetDataContext().Set <T>();
if (includeProperties != null)
{
items = includeProperties.Aggregate(items,
(current, includeProperty) => current.Include(includeProperty));
}
return(items);
}
public IQueryable <TEntity> GetAll(bool withTracking = true,
params Expression <Func <TEntity, object> >[] includeProperties)
{
var items = DataContextFactory.GetDataContext().Set <TEntity>().AsQueryable();
if (includeProperties != null && includeProperties.Length > 0)
{
items = includeProperties.Aggregate(items,
(current, includeProperty) => current.Include(includeProperty));
}
return(withTracking ? items : items.AsNoTracking());
}
protected Task ExecuteSqlCommand(string cmd)
{
return(Task.Run(
() =>
{
this.dbContext.Database.ExecuteSqlCommand(cmd);
DataContextFactory.Clear();
var context = DataContextFactory.GetDataContext();
this.dbContext = context ?? throw new ArgumentNullException(nameof(context));
this.dbSet = this.dbContext.Set <TEntity>();
}));
}
public Device Register(Device device)
{
var application = DataContextFactory.GetDataContext().Application.Where(app => app.AppId == device.AppId && app.IsRemoved == false).FirstOrDefault();
if (application == null)
{
//app不存在
}
DataContextFactory.GetDataContext().Device.Add(device);
_uow.Commit();
return(device);
}
/// <summary>
/// Returns an IQueryable of items of type T.
/// </summary>
/// <param name="predicate">A predicate to limit the items being returned.</param>
/// <param name="includeProperties">An expression of additional properties to eager load. For example: x => x.SomeCollection, x => x.SomeOtherCollection.</param>
/// <returns>An IEnumerable of the requested type T.</returns>
public IEnumerable <T> FindAll(Expression <Func <T, bool> > predicate, params Expression <Func <T, object> >[] includeProperties)
{
IQueryable <T> items = DataContextFactory.GetDataContext().Set <T>();
if (includeProperties != null)
{
foreach (var includeProperty in includeProperties)
{
items = items.Include(includeProperty);
}
}
return(items.Where(predicate).OrderBy(o => o.Id));
}
/// <summary>
/// Returns an IQueryable of all items of type T.
/// </summary>
/// <param name="includeProperties">An expression of additional properties to eager load. For example: x => x.SomeCollection, x => x.SomeOtherCollection.</param>
/// <returns>An IQueryable of the requested type T.</returns>
public virtual IQueryable <T> FindAll(params Expression <Func <T, object> >[] includeProperties)
{
IQueryable <T> items = DataContextFactory.GetDataContext().Set <T>();
if (includeProperties != null)
{
foreach (var includeProperty in includeProperties)
{
items = items.Include(includeProperty);
}
}
return(items.OrderBy(o => o.Id));
}
public void CanExecuteQueryAgainstDataContext()
{
string lastName = Guid.NewGuid().ToString().Substring(0, 25);
var context = DataContextFactory.GetDataContext();
var person = new Person {
FirstName = "Imar", LastName = lastName, DateOfBirth = new DateTime(1971, 8, 9), DateCreated = DateTime.Now, DateModified = DateTime.Now, Type = PersonType.Colleague, HomeAddress = AddressTests.CreateAddress(ContactType.Personal), WorkAddress = AddressTests.CreateAddress(ContactType.Business)
};
context.People.Add(person);
context.SaveChanges();
var personCheck = context.People.First(x => x.LastName == lastName);
personCheck.Should().NotBeNull();
}
public void CanExecuteQueryAgainstDataContext()
{
using (var uow = new EFUnitOfWorkFactory().Create())
{
var context = DataContextFactory.GetDataContext();
string username = Guid.NewGuid().ToString().Substring(0, 10);
var user = new User {
UserName = username, Email = "*****@*****.**", PasswordHash = "123456"
};
context.Users.Add(user);
uow.Commit(false);
var personCheck = context.Users.SingleOrDefault(x => x.UserName == username);
personCheck.Should().NotBeNull();
context.Users.Remove(user);
}
}
public async Task CanFindMovieByIdAPI()
{
var context = DataContextFactory.GetDataContext();
var movieRepo = new MovieRepository();
int id = 558;
var m = await movieRepo.FindById(id);
m.Should().NotBeNull();
if (m.MovieGenres.Count > 0)
{
m.MovieGenres[0].Genre.Should().NotBeNull();
}
if (m.MovieKeywords.Count > 0)
{
m.MovieKeywords[0].Keyword.Should().NotBeNull();
}
}
public ObjectQuery <Member> Translate(Query query)
{
ObjectQuery <Member> memberQuery;
if (query.IsNamedQuery())
{
memberQuery = FindEFQueryFor(query);
}
else
{
StringBuilder queryBuilder = new StringBuilder();
IList <ObjectParameter> paraColl = new List <ObjectParameter>();
CreateQueryAndObjectParameters(query, queryBuilder, paraColl);
memberQuery = DataContextFactory.GetDataContext().Members
.Where(queryBuilder.ToString(), paraColl.ToArray()).OrderBy(String.Format("it.{0} desc", query.OrderByProperty.PropertyName));
}
return(memberQuery);
}
public IQueryable <Product> GetProductByRetailerId(int id)
{
IQueryable <Product> products = (from p in DataContextFactory.GetDataContext().Products
join c in DataContextFactory.GetDataContext().Catalogues
on p.Id equals c.ProductId
where c.RetailerId == id
select new Product
{
Id = p.Id,
Name = p.Name,
ShortDescription = p.ShortDescription,
Description = p.Description,
MRP = p.MRP,
ListPrice = c.ListPrice,
SellingPrice = c.SellingPrice,
ItemsPerUnit = p.ItemsPerUnit,
Notation = p.Notation,
IsActive = p.IsActive,
CategoryId = p.CategoryId,
ManufacturerId = p.ManufacturerId,
TaxId = p.TaxId,
Tax = p.Tax,
Rank = p.Rank,
CreatedOrModifiedOn = p.CreatedOrModifiedOn,
CreatedOrModifiedBy = p.CreatedOrModifiedBy,
ApprovedOrCancelledOn = p.ApprovedOrCancelledOn,
ApprovedOrCancelledBy = p.ApprovedOrCancelledBy,
ApprovalStatus = p.ApprovalStatus,
ImageId = p.ImageId,
WeightId = p.WeightId,
Manufacturer = p.Manufacturer,
Category = p.Category,
Unit = p.Unit,
Weight = p.Weight,
Image = p.Image
}).ToList().AsQueryable();
return(products);
}
public List <PushMessage> GetPrePushMessages(PushMessageStatus status, int size)
{
string sql = @"select P.*, m.DeviceType ,b.Title, b.Content from [Message] as m
inner join MessageBody as b on m.BodyToken = b.Token
inner join PushMessage as p on p.MessageId = m.Token where p.[Status] = @status ";
using (var db = DataContextFactory.GetDataContext())
{
//var result = db.Database.SqlQuery<PushMessage>(sql, new { status = status }).Take(size);
var result = db.Database.SqlQuery <Device>("select * from Device");
var r = result.ToList();
return(null);
/*
* var pushResult = db.PushMessage.Join(db.MessageBody, pm => pm.MessageId, m => m.Token, (pm, m) => new { Message = m, PushMessage = pm })
* .Select((a, i) => new PushMessage()
* {
* Message = new Message() { AppId = a.PushMessage.AppId, Token = a.PushMessage.MessageId, }
* });
*/
}
}
public ObjectQuery <Book> Translate(Query query)
{
ObjectQuery <Book> bookQuery;
if (query.IsNamedQuery())
{
bookQuery = FindEFQueryFor(query);
}
else
{
StringBuilder queryBuilder = new StringBuilder();
IList <ObjectParameter> paraColl = new List <ObjectParameter>();
CreateQueryAndObjectParameters(query, queryBuilder, paraColl);
//cast to all EF objectContext from DbContext
var objectContext = ((IObjectContextAdapter)DataContextFactory.GetDataContext()).ObjectContext;
var bookSet = objectContext.CreateObjectSet <Book>();
bookQuery = bookSet.Include("Title").OrderBy(String.Format("it.{0} desc", query.OrderByProperty.PropertyName));
// bookQuery = DataContextFactory.GetDataContext().Books.Include("Title").
// .Where(queryBuilder.ToString(), paraColl.ToArray()).OrderBy(String.Format("it.{0} desc", query.OrderByProperty.PropertyName));
}
return(bookQuery);
}
public GetSourceOfCityResponse GetSourceOfCity(GetSourceOfCityRequest request, IEnumerable <KeyValuePair <string, string> > pairs)
{
GetSourceOfCityResponse response = new GetSourceOfCityResponse();
try
{
var privilegeResulst = _agentPrivilege.CanUse(request.Agent);
if (!privilegeResulst.CheckResult)
{
response.Status = HttpStatusCode.Unauthorized;
return(response);
}
if (!_validService.ValidateReqest(pairs, privilegeResulst.Model.SecretKey, request.SecCode))
{
response.Status = HttpStatusCode.Forbidden;
return(response);
}
//var items =
// _repository.SqlQuery(@"SELECT city_id AS CityCode ,CASE WHEN source=1 THEN 1 WHEN source=0 THEN 2 ELSE POW(2,source) END AS Source FROM bx_agent_ukey WHERE city_id=" + request.CityCode + " GROUP BY city_id,source;");
var items =
DataContextFactory.GetDataContext()
.Database.SqlQuery <CityChannelItem>(
@"SELECT city_id AS CityCode ,CASE WHEN source is null THEN -1 WHEN source=1 THEN 1 WHEN source=0 THEN 2 ELSE POW(2,source) END AS Source FROM bx_agent_ukey WHERE city_id=" + request.CityCode + " GROUP BY city_id,source;").ToList();
response.Result = items;
response.Status = HttpStatusCode.OK;
}
catch (Exception ex)
{
response.Status = HttpStatusCode.ExpectationFailed;
_logError.Info("获取重复投保请求发生异常:" + ex.Source + "\n" + ex.StackTrace + "\n" + ex.Message + "\n" + ex.InnerException + ",请求对象信息：" + request.ToJson() + ";返回对象信息" + response.ToJson());
}
return(response);
}
public override IQueryable <Member> GetObjectSet()
{
return(DataContextFactory.GetDataContext().CreateObjectSet <Member>());
}
private void AddBody(MessageBody body)
{
DataContextFactory.GetDataContext().MessageBody.Add(body);
}
/// <summary>
/// 获得实体对象
/// </summary>
/// <returns></returns>
public virtual DbSet <T> GetObjectSet()
{
return(DataContextFactory.GetDataContext().Set <T>());
}
public void PersistUpdateOf(IAggregateRoot entity)
{
var et = (T)entity;
DataContextFactory.GetDataContext().Entry <T>(et).State = EntityState.Modified;
}
