public FakeNorthwindDbContext()
{
AlphabeticalListOfProducts = new FakeDbSet <AlphabeticalListOfProduct>("ProductId", "ProductName", "Discontinued", "CategoryName");
Categories = new FakeDbSet <Category>("CategoryId");
CategorySalesFor1997 = new FakeDbSet <CategorySalesFor1997>("CategoryName");
CurrentProductLists = new FakeDbSet <CurrentProductList>("ProductId", "ProductName");
Customers = new FakeDbSet <Customer>("CustomerId");
CustomerAndSuppliersByCities = new FakeDbSet <CustomerAndSuppliersByCity>("CompanyName", "Relationship");
CustomerDemographics = new FakeDbSet <CustomerDemographic>("CustomerTypeId");
Employees = new FakeDbSet <Employee>("EmployeeId");
Invoices = new FakeDbSet <Invoice>("CustomerName", "Salesperson", "OrderId", "ShipperName", "ProductId", "ProductName", "UnitPrice", "Quantity", "Discount");
Orders = new FakeDbSet <Order>("OrderId");
OrderDetails = new FakeDbSet <OrderDetail>("OrderId", "ProductId");
OrderDetailsExtendeds = new FakeDbSet <OrderDetailsExtended>("OrderId", "ProductId", "ProductName", "UnitPrice", "Quantity", "Discount");
OrdersQries = new FakeDbSet <OrdersQry>("OrderId", "CompanyName");
OrderSubtotals = new FakeDbSet <OrderSubtotal>("OrderId");
Products = new FakeDbSet <Product>("ProductId");
ProductsAboveAveragePrices = new FakeDbSet <ProductsAboveAveragePrice>("ProductName");
ProductSalesFor1997 = new FakeDbSet <ProductSalesFor1997>("CategoryName", "ProductName");
ProductsByCategories = new FakeDbSet <ProductsByCategory>("CategoryName", "ProductName", "Discontinued");
Regions = new FakeDbSet <Region>("RegionId");
SalesByCategories = new FakeDbSet <SalesByCategory>("CategoryId", "CategoryName", "ProductName");
SalesTotalsByAmounts = new FakeDbSet <SalesTotalsByAmount>("OrderId", "CompanyName");
Shippers = new FakeDbSet <Shipper>("ShipperId");
SummaryOfSalesByQuarters = new FakeDbSet <SummaryOfSalesByQuarter>("OrderId");
SummaryOfSalesByYears = new FakeDbSet <SummaryOfSalesByYear>("OrderId");
Suppliers = new FakeDbSet <Supplier>("SupplierId");
Territories = new FakeDbSet <Territory>("TerritoryId");
InitializePartial();
}
public ActionResult Edit(Category category)
{
if (ModelState.IsValid)
{
Category entry = db.Entry(category).Entity;
System.Data.Entity.DbSet <Category> dbset = db.Categories;
//If we changed index, we need to shift other elements
int oldIndex = dbset.First(x => x.Id == entry.Id).Index;
shiftIndexes(entry, oldIndex, dbset);
//Ugly workaround
Category dbQ = dbset.First(x => x.Id == entry.Id);
dbQ.Index = entry.Index;
dbQ.Annotation = entry.Annotation;
dbQ.Weight = entry.Weight;
dbQ.Title = entry.Title;
dbQ.ImageDisplayFlag = entry.ImageDisplayFlag;
db.SaveChanges();
//db.Entry(category).State = EntityState.Modified;
//db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(category));
}
private IQueryable <T> GetEntitiesInternal <T>() where T : class
{
System.Data.Entity.DbSet <T> set = context.Set <T>();
IQueryable <T> queryableSet = !trackEntities?set.AsNoTracking() : set;
return(new DataLocalizationQueryable <T>(queryableSet));
}
private static List <PersonaViewModel> GetListPersonaViewModel(System.Data.Entity.DbSet <Persona> personas)
{
var personasList = new List <PersonaViewModel>();
foreach (var item in personas)
{
var personaVm = Map(item);
personasList.Add(personaVm);
}
return(personasList);
}
private static List <DireccionViewModel> GetListDireccionesViewModel(System.Data.Entity.DbSet <Direccion> direcciones)
{
List <DireccionViewModel> direccionesList = new List <DireccionViewModel>();
foreach (var item in direcciones)
{
var direccionVM = Map(item);
direccionesList.Add(direccionVM);
}
return(direccionesList);
}
public CorretorOnline obterCorretor(System.Data.Entity.DbSet <TEntity> value, DbSet <CorretorOnline> listCorretores)
{
if (value.Cast <PinheiroSereni.Dominio.Entidades.Chat>().Count() > 0)
{
CorretorOnline ultimoCorretor = listCorretores.Find(value.Cast <PinheiroSereni.Dominio.Entidades.Chat>().OrderByDescending(m => m.chatId).First().corretorId);
CorretorOnline proxCorretor = listCorretores.Where(m => m.indexEscala > ultimoCorretor.indexEscala && m.situacao == "A").OrderBy(j => j.indexEscala).FirstOrDefault() ?? listCorretores.Where(m => m.situacao == "A").OrderBy(m => m.indexEscala).FirstOrDefault();
return(proxCorretor);
}
else
{
return(listCorretores.Where(m => m.situacao == "A").OrderBy(m => m.indexEscala).FirstOrDefault());
}
}
public ActionResult DeleteConfirmed(int id)
{
Category category = db.Categories.Find(id);
System.Data.Entity.DbSet <Category> dbset = db.Categories;
int oldIndex = category.Index;
category.Index = dbset.Count() + 100;
shiftIndexes(category, oldIndex, dbset);
db.Categories.Remove(category);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void shiftIndexes(Category entry, int oldIndex, System.Data.Entity.DbSet <Category> dbset)
{
if (entry.Index - oldIndex == 1)
{
//Move forward by 1 step
try
{
dbset.First(x => x.Index == entry.Index).Index = oldIndex; //If was last row - it will throw an exception
}
catch (Exception e)
{ }
}
else if (entry.Index > oldIndex)
{
//We moved forward
foreach (var q in dbset.ToList())
{
if (oldIndex < q.Index && q.Index < entry.Index)
{
q.Index = q.Index - 1;
}
}
entry.Index = entry.Index - 1;
}
else if (entry.Index < oldIndex)
{
//We moved backwards
foreach (var q in dbset.ToList())
{
if (entry.Index <= q.Index && q.Index < oldIndex)
{
q.Index = q.Index + 1;
}
}
}
if (entry.Index > dbset.Count())
{
entry.Index = dbset.Count();
}
else if (entry.Index < 1)
{
entry.Index = 1;
}
}
public ActionResult Create(Category category)
{
if (ModelState.IsValid)
{
category.ImageDisplayFlag = true;
category.RiskRanges = new List <RiskRange>();
category.RiskRanges.Add(new RiskRange(1));
category.RiskRanges.Add(new RiskRange(2));
category.RiskRanges.Add(new RiskRange(3));
db.Categories.Add(category);
Category entry = db.Entry(category).Entity;
System.Data.Entity.DbSet <Category> dbset = db.Categories;
db.SaveChanges();
return(RedirectToAction("Edit/" + category.Id));
}
return(View(category));
}
private TDestination GetMapping <TSource, TDestination>(TSource source, System.Data.Entity.DbSet <TDestination> destDbSet) where TDestination : MappableEntity, new() where TSource : IMappableDTO
//private static TDestination GetMapping<TSource, TDestination>(TSource source, IEnumerable<TDestination> destDbSet) where TDestination : MappableEntity, new() where TSource : IMappableDTO
{
//return GetMapping<TSource, TDestination, TDestination>(source, destDbSet);
TDestination dest = null;
if (source?.MappingId != null)
{
//dest = destDbSet.SingleOrDefault(x => x.MappingId == source.MappingId);
dest = destDbSet.Find(source.MappingId);
}
if (dest == null)
{
dest = new TDestination();
//DbContext.SaveChanges();
//destDbSet.Add(dest);
}
return(dest);
}
public Repository()
{
db = new LibrarySystemContext();
dbSet = db.Set <T>();
}
public GenericRepository(ADAContext context)
{
Context = context;
Set = context.Set <T>();
}
protected GenericController()
{
Database = new Context.UniOpetDbContext();
_dbSet = Database.Set <TEntity>();
}
private TDestination GetMapping <TSource, TDestination>(TSource source, TDestination dest, System.Data.Entity.DbSet <TDestination> destDbSet) where TDestination : MappableEntity where TSource : IMappableDTO
//private static TDestination GetMapping<TSource, TDestination>(TSource source, TDestination dest, IEnumerable<TDestination> destDbSet) where TDestination : MappableEntity where TSource : IMappableDTO
{
if (dest == null || source.MappingId != dest.MappingId)
{
if (source?.MappingId != null)
{
//dest = destDbSet.SingleOrDefault(x => x.MappingId == source.MappingId);
dest = destDbSet.Find(source.MappingId);
return(dest);
}
else
{
return(null);
}
}
return(dest);
}
public DataRepository(TxnFlowDBEntities dbContext)
{
_dbContext = dbContext;
_dbSet = _dbContext.Set <TEntity>();
}
public Repository()
{
db = new EventManagerSystemContext();
dbSet = db.Set <T>();
}
public RepositoryBase()
{
_context = new EventsDataContext();
_dbSet = _context.Set <T>();
}
public Repository()
{
db = new SchoolDBContext();
dbSet = db.Set <T>();
}
public BaseDal()
{
_dbset = db.Context.Set <T>();
}
/// <summary>
/// Aggregration Connection với data set
/// </summary>
/// <param name="context"></param>
public GenericRepository(DbContext context)
{
_context = context;
_entitySet = context.Set <TEntity>();
}
public SQLRepository(DataContext context)
{
this.context = context;
this.dbSet = context.Set <T>();
}
public RepositoryBase(IBaseContext context, IBulkWorker <TEntity> bulkWorker)
{
_bulkWorker = bulkWorker;
this.Context = context;
this.DbSet = context.Set <TEntity>();
}
public void Dispose()
{
DbSet = null;
Context.Dispose();
GC.SuppressFinalize(this);
}
public GenericResposity(QJModelContext dbContext)
{
this.dbContext = dbContext;
this.entities = dbContext.Set <TEntity>();
}
