public IEnumerable <TEntity> FindAll()
{
var query = from entity in ObjectContextHolder.ObjectContext().CreateObjectSet <TEntity>()
select entity;
return(query.AsEnumerable());
}
public UserAccount FindByAccountId(string accountId)
{
var query = from entity in ObjectContextHolder.ObjectContext().UserAccount
where entity.AccountId == accountId
select entity;
return(query.SingleOrDefault());
}
/// <summary>
/// 账户情报取得
/// </summary>
/// <param name="account">账户名</param>
/// <returns></returns>
public UserAccount FindByAccount(string account)
{
var query = from entity in ObjectContextHolder.ObjectContext().UserAccount
where entity.Account.Equals(account)
select entity;
return(query.FirstOrDefault());
}
/// <summary>
/// CurrentInfoHolderやObjectContextHolderの初期化をする
/// </summary>
/// <param name="actionContext"></param>
public override void OnActionExecuting(ActionExecutingContext actionContext)
{
CurrentInfoHolder.Init();
CurrentInfoHolder.BindDateTimeToThread(DateTime.UtcNow.UtcToJapanStandardTime());
ObjectContextHolder.ObjectContext();
base.OnActionExecuting(actionContext);
}
/// <summary>
/// （複数）データをDBから削除する
/// </summary>
/// <param name="entities"></param>
public void Delete(IEnumerable <TEntity> entities)
{
bool isSave = false;
foreach (var entity in entities)
{
ObjectContextHolder.ObjectContext().DeleteObject(entity);
isSave = true;
}
if (isSave)
{
ObjectContextHolder.ObjectContext().SaveChanges();
}
}
/// <summary>
/// （複数）データをDBに更新する
/// </summary>
/// <param name="entities"></param>
public void Update(IEnumerable <TEntity> entities)
{
bool isSave = false;
foreach (var entity in entities)
{
ObjectContextHolder.ObjectContext().ApplyCurrentValues(typeof(TEntity).Name, entity);
isSave = true;
}
if (isSave)
{
ObjectContextHolder.ObjectContext().SaveChanges();
}
}
/// <summary>
/// データをDBに更新する
/// </summary>
/// <param name="update">更新用Expression</param>
/// <param name="where">更新Where条件Expression</param>
/// <returns>更新件数</returns>
public int Update(Action <TEntity> update, Expression <Func <TEntity, bool> > where)
{
var query = ObjectContextHolder.ObjectContext().CreateObjectSet <TEntity>().Where <TEntity>(where);
var count = 0;
var isSave = false;
foreach (var entity in query)
{
update(entity);
isSave = true;
count++;
}
if (isSave)
{
ObjectContextHolder.ObjectContext().SaveChanges();
}
return(count);
}
/// <summary>
/// データをDBから削除する
/// </summary>
/// <param name="entity"></param>
public void Delete(TEntity entity)
{
ObjectContextHolder.ObjectContext().DeleteObject(entity);
ObjectContextHolder.ObjectContext().SaveChanges();
}
/// <summary>
/// データをDBに更新する
/// </summary>
/// <param name="entity"></param>
public void Update(TEntity entity)
{
ObjectContextHolder.ObjectContext().ApplyCurrentValues(typeof(TEntity).Name, entity);
ObjectContextHolder.ObjectContext().SaveChanges();
}
/// <summary>
/// データをDBにインサートする
/// </summary>
/// <param name="entity">エンティティ</param>
public void Save(TEntity entity)
{
ObjectContextHolder.ObjectContext().AddObject(typeof(TEntity).Name, entity);
ObjectContextHolder.ObjectContext().SaveChanges();
}
/// <summary>
/// 検索
/// </summary>
/// <param name="predicate">Expression</param>
/// <returns>結果</returns>
public IEnumerable <TEntity> FindAny(Expression <Func <TEntity, bool> > predicate)
{
var query = ObjectContextHolder.ObjectContext().CreateObjectSet <TEntity>().Where(predicate);
return(query.AsEnumerable());
}
/// <summary>
/// CurrentInfoHolderやObjectContextHolderの解除をする
/// </summary>
/// <param name="actionExecutedContext"></param>
public override void OnActionExecuted(ActionExecutedContext actionExecutedContext)
{
CurrentInfoHolder.Clear();
ObjectContextHolder.Dispose();
base.OnActionExecuted(actionExecutedContext);
}
public IEnumerable <TEntity> FindAllWithDescAndAsc(Expression <Func <TEntity, object> > orderDescDelegate, Expression <Func <TEntity, object> > orderAscDelegate2)
{
var query = ObjectContextHolder.ObjectContext().CreateObjectSet <TEntity>().OrderByDescending(orderDescDelegate).ThenBy(orderAscDelegate2);
return(query.AsEnumerable());
}
public IEnumerable <TEntity> FindAllWithAsc(Expression <Func <TEntity, object> > orderDelegate)
{
var query = ObjectContextHolder.ObjectContext().CreateObjectSet <TEntity>().OrderBy(orderDelegate);
return(query.AsEnumerable());
}