public override void DeleteSingle(Expression <Func <ShopInfoExtensions, bool> > predicate)
{
using (IDbContextTransaction transaction = Database.BeginTransaction(IsolationLevel.ReadCommitted))
{
try
{
var shopInfoExtensions = CurrentDbSet.SingleOrDefault(predicate);
string shopId = shopInfoExtensions.ShopId;
var fileGroups = fileGroupDbSet.Where(fg => fg.ShopId == shopId).ToList();
if (fileGroups != null && fileGroups.Count > 0)
{
foreach (var groupItem in fileGroups)
{
fileGroupDbSet.Remove(groupItem);
}
}
var fileDatas = fileDataDbSet.Where(fg => fg.ShopId == shopId).ToList();
if (fileDatas != null && fileDatas.Count > 0)
{
foreach (var dataItem in fileDatas)
{
fileDataDbSet.Remove(dataItem);
}
}
CurrentDbSet.Remove(shopInfoExtensions);
this.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
Console.WriteLine(ex.Message);
}
}
}
/// <summary>
/// Gets the authentication.
/// </summary>
/// <param name="id">The identifier.</param>
/// <returns></returns>
public UserSession GetAuthentication(long id)
{
//--> need to define navigation property on type: return _dbset.Include(x=>x.User).Where(u=>u.UserId == id).SingleOrDefault();
return(CurrentDbSet.SingleOrDefault(p => p.Id == id));
}
/// <summary>
/// Gets the by identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <returns></returns>
public User GetById(long id)
{
//--> need to define navigation property on type: return _dbset.Include(x => x.UserSessions.Where(us => us.UserId == id)).Where(u => u.Id == id).FirstOrDefault();
return(CurrentDbSet.SingleOrDefault(p => p.Id == id));
}
/// <summary>
/// GetSession
/// </summary>
/// <param name="userId">The user identifier.</param>
/// <returns></returns>
public UserSession GetSession(long userId)
{
return(CurrentDbSet.SingleOrDefault(w => w.UserId == userId));
}