protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
BundleMobileConfig.RegisterBundles(BundleTable.Bundles);
Database.SetInitializer <LocalDbContext>(new LocalDbInitializer());
LocalDbContext context = new LocalDbContext();
context.Database.Initialize(true);
DisplayModeProvider.Instance.Modes.Insert(0, new DefaultDisplayMode("iPhone")
{
ContextCondition = (ctx => ctx.GetOverriddenUserAgent().IndexOf("iPhone", StringComparison.OrdinalIgnoreCase) >= 0)
});
DisplayModeProvider.Instance.Modes.Insert(1, new DefaultDisplayMode("iPad")
{
ContextCondition = (ctx => ctx.GetOverriddenUserAgent().IndexOf("iPad", StringComparison.OrdinalIgnoreCase) >= 0)
});
ModelBinders.Binders.Add(typeof(CustomModelBinderModel), new CustomModelBinderModelCustomBinder());
}
private static async Task <List <RssItem> > SyncCoreAsync(LocalDbContext ctx, ISyncSource syncSource, SyncSourceInfo syncInfo,
CancellationToken cancellationToken)
{
if (syncInfo is null)
{
syncInfo = new SyncSourceInfo {
SyncSourceId = syncSource.SyncSourceId
};
ctx.Add(syncInfo);
}
var page = await syncSource.TryGetItemsAsync(syncInfo.LastSyncId, cancellationToken)
.ConfigureAwait(false);
if (page.LastId is int lastId)
{
syncInfo.LastSyncId = lastId;
}
var newItems = page.GetItems().Select(z =>
{
var r = new RssItem();
r.UpdateFrom(z);
return(r);
}).ToList();
return(ctx.AddOrIgnoreRange(newItems));
}
public IRun GetRun(Guid runId)
{
using (var db = new LocalDbContext())
{
return(db.Runs.FirstOrDefault(x => x.Id == runId));
}
}
public void AddTwoEntities_GetAll()
{
sqlConnection = new SqlConnection("Server=(localdb)\\mssqllocaldb;Database=ProductsTest");
context = new LocalDbContext(sqlConnection);
anotherContext = new LocalDbContext(sqlConnection);
if (!context.Database.Exists())
{
context.Database.Create();
}
var products = context.Set <Product>();
products.Add(new Product {
Name = "Product #1", Price = 1.23m, Count = 8
});
products.Add(new Product {
Name = "Product #2", Price = 4.56m, Count = 3
});
context.SaveChanges();
var allProducts = anotherContext.Set <Product>().ToArray();
Assert.IsNotNull(allProducts);
Assert.AreEqual(2, allProducts.Length);
Assert.AreEqual("Product #1", allProducts[0].Name);
Assert.AreEqual(1.23m, allProducts[0].Price);
Assert.AreEqual(8, allProducts[0].Count);
Assert.AreEqual("Product #2", allProducts[1].Name);
Assert.AreEqual(4.56m, allProducts[1].Price);
Assert.AreEqual(3, allProducts[1].Count);
}
//readonly ObservableCollection<Order> orders;
public JournalViewModel(LocalDbContext context)
{
Title = "ORDERS JOURNAL";
_context = context;
Orders = new ObservableCollection <Order>(context.Orders);
}
///<inheritdoc/>
public IExperiment GetExperiment(string experimentName)
{
using (var db = new LocalDbContext())
{
return(db.Experiments.Single(x => x.ExperimentName == experimentName));
}
}
private static Task <string> GetToken()
{
using (var db = new LocalDbContext())
{
return(Task.FromResult(db.Usuario.SingleOrDefault()?.Token));
}
}
public ProductsStatViewModel(LocalDbContext context)
{
Title = "PRODUCTS";
//get data for all queries
context.Categories.Load();
categories = context.Categories.ToList <Category>();
context.Products.Load();
products = context.Products.ToList <Product>();
//query for ProductByCategoryGroups
var ProductsAndCountries =
products.Join(categories,
pro => pro.CategoryID,
cat => cat.CategoryID,
(pro, cat) => new { pro.ProductID, cat.CategoryName });
//projection on ProductByCategoryObject
this.ProductByCategoryGroups =
new List <ProductByCategoryObject>(ProductsAndCountries.GroupBy(c => c.CategoryName).
Select(g => new ProductByCategoryObject {
CategoryName = g.Key, ProductCount = g.Count()
}));
}
public TableLessonViewPageModel(
TableLessonViewToken token, LocalDbContext db, IExportLocatorScope scope, TabPageHost host
)
{
_db = db;
_scope = scope;
_host = host;
this.Items = new CollectionViewSource {
Source = _items
};
this.Columns.Add(BuildMissedLessonsColumn());
this.WhenActivated(c => {
this.WhenAnyValue(model => model.FilterText)
.Throttle(TimeSpan.FromMilliseconds(300))
.ObserveOnDispatcher(DispatcherPriority.Background)
.Subscribe(_ => {
if (string.IsNullOrWhiteSpace(this.FilterText))
{
this.Items.View.Filter = null;
return;
}
this.Items.View.Filter =
o => o is StudentLessonViewModel item &&
item.FullName.ToUpper().Contains(this.FilterText.ToUpper());
}).DisposeWith(c);
});
Init(token.Lesson);
}
// Clean up the db here
private void CleanUp()
{
try
{
using (var context = new LocalDbContext())
{
var tempUser = context.Users.Where(x => x.UserName == "tempUsername").FirstOrDefault();
var dummyUser = context.Users.Where(x => x.UserName == "dummy").FirstOrDefault();
if (tempUser != null)
{
context.Users.Remove(tempUser);
}
if (dummyUser == null)
{
var dummy = new User
{
FullName = "Dummy User",
UserName = "******",
Password = AppSecurity.HashPassword("test1234!").HashedPassword,
Role = "Tester"
};
context.Users.Add(dummy);
}
context.SaveChanges();
}
}
catch (Exception ex) { }
}
///<inheritdoc/>
public List <IRun> GetRuns(Guid experimentId)
{
using (var db = new LocalDbContext())
{
return(db.Runs.Where(x => x.ExperimentId == experimentId).ToList <IRun>());
}
}
///<inheritdoc/>
public List <IMetric> GetMetrics(Guid runId)
{
using (var db = new LocalDbContext())
{
return(db.Metrics.Where(x => x.RunId == runId).ToList <IMetric>());
}
}
public EmployeeStatsViewModel(LocalDbContext context)
{
Title = "Employees";
_context = context;
//get data for all queries
_context.Orders.Load();
orders = _context.Orders.Local.ToList <Order>();
_context.Order_Details.Load();
orderDetails = _context.Order_Details.ToList <Order_Details>();
_context.Employees.Load();
employees = _context.Employees.Local.ToList <Employee>();
//query for SalesByEmployeeGroups
var EmployeesAndOrders =
employees.Join(orders,
emp => emp.EmployeeID,
ord => ord.EmployeeID,
(emp, ord) => new { LastName = emp.LastName, OrderId = ord.OrderID }).
Join(orderDetails,
emp => emp.OrderId,
det => det.OrderID,
(emp, det) => new { name = emp.LastName, sale = det.UnitPrice * det.Quantity });
//projection on SalesByEmployeeObject
this.SalesByEmployeeGroups =
new List <SalesByEmployeeObject>(EmployeesAndOrders.GroupBy(c => c.name).
Select(g => new SalesByEmployeeObject {
LastName = g.Key, SumOfSale = g.Sum(c => c.sale)
}).OrderBy(g => g.SumOfSale));
}
private async Task TrySetAudioDiscriminator(LocalDbContext context)
{
var alarms = await context.Alarms.ToListAsync();
foreach (var alarmEntity in alarms)
{
var sound = alarmEntity.Sound;
if (sound == null || sound.Length == 0 || !string.IsNullOrWhiteSpace(alarmEntity.Discriminator))
{
continue;
}
var metadataStart = new byte[20];
Array.Copy(sound, metadataStart, 20);
var metadataAsString = Encoding.ASCII.GetString(metadataStart);
if (metadataAsString.StartsWith(MpegStartMetadata))
{
alarmEntity.Discriminator = ".mp3";
}
if (metadataAsString.StartsWith(WavStartMetadata))
{
alarmEntity.Discriminator = ".wav";
}
}
await context.SaveChangesAsync();
}
///<inheritdoc/>
public IEnumerable <IExperiment> GetExperiments()
{
using (var db = new LocalDbContext())
{
return(db.Experiments);
}
}
//private void WithDisabledConstraints(Action action)
//{
// _db.Database.Connection.Open();
// _db.Database.ExecuteSqlCommand("PRAGMA foreign_keys=OFF;");
// _db.Database.ExecuteSqlCommand("PRAGMA ignore_check_constraints=true;");
// action();
// _db.Database.ExecuteSqlCommand("PRAGMA foreign_keys=ON;");
// _db.Database.ExecuteSqlCommand("PRAGMA ignore_check_constraints=false;");
// _db.Database.Connection.Close();
//}
//private void SaveChangesWithDisabledConstraints()
//{
// WithDisabledConstraints(() => _db.SaveChanges());
//}
public List <DbLocalizedString> GetLocalizedStrings(Lang language)
{
var strLang = $"{language.EnumToString().Take(3).ToUpper()}_";
var db = new LocalDbContext();
return(db.LocalizedStrings.Where(ls => ls.Key.StartsWith(strLang)).ToList());
}
public JournalViewModel(LocalDbContext context, IEventAggregator eventAggregator)
{
Title = "ORDERS JOURNAL";
_context = context;
_eventAggregator = eventAggregator;
cachedOrders = context.Orders;
Orders = new ReadOnlyCollection <Order>(cachedOrders.ToList());
var propertyChangedObservable = Observable.FromEventPattern <PropertyChangedEventHandler, PropertyChangedEventArgs>
(handler => this.PropertyChanged += handler, handler => this.PropertyChanged -= handler);
var searchTermObservable = propertyChangedObservable
.Where(p => p.EventArgs.PropertyName == nameof(SearchTerm))
.Select(_ => _searchTerm).Throttle(TimeSpan.FromMilliseconds(250)).Subscribe
(s =>
{
if (string.IsNullOrEmpty(s))
{
this.Orders = new ReadOnlyCollection <Order>(cachedOrders.ToList());
}
else
{
this.Orders =
new ReadOnlyCollection <Order>(cachedOrders
.Where(o => o.CustomerID.SafeSubstring(0, s.Length).ToLower() == s.ToLower()).OrderBy(o => o.CustomerID)
.ToList());
}
});
ClearSearchCommand = new DelegateCommand(() => SearchTerm = "");
}
public BaseApplication(
IEmailSender _emailSender,
LocalDbContext _ldbc,
EntityDbContext _edbc,
ExamsDbContext _xdbc,
IModuleRepo _moduleRepo,
IAppDetails _app,
IModuleMarkRepo _moduleMarkRepo,
IModuleMarkChangeLogRepo _moduleMarkChangeLogRepo,
ICMPMarksImportRepo _cmpMarksImportRepo,
TestDbContext _tdbc,
IStudentRepo _studentRepo
)
{
emailSender = _emailSender;
ldbc = _ldbc;
edbc = _edbc;
tdbc = _tdbc;
xdbc = _xdbc;
moduleRepo = _moduleRepo;
moduleMarkRepo = _moduleMarkRepo;
moduleMarkChangeLogRepo = _moduleMarkChangeLogRepo;
app = _app;
cmpMarksImportRepo = _cmpMarksImportRepo;
//Test cases
studentRepo = _studentRepo;
}
public void SaveOrder(Order order, bool isFraud)
{
using var db = new LocalDbContext();
var dbOrder = new DbOrder(order, isFraud);
db.Orders.Add(dbOrder);
db.SaveChanges();
}
private static void AtualizaInscricao(Inscricao inscricao)
{
using (var db = new LocalDbContext())
{
db.UpdateInscricao(inscricao);
db.SaveChanges();
}
}
public SettingsPageModel(AudioService service, LocalDbContext context)
{
this.RefreshSubject.AsObservable().Subscribe(_ => {
this.Alarms.Clear();
this.Alarms.AddRange(context.Alarms
.Select(alarm => new AlarmSettingsViewModel(alarm, service, context)).ToList());
});
}
public async Task <Settings> Get()
{
using (var db = new LocalDbContext())
{
Settings.SetCurrent(await db.Settings.FirstOrDefaultAsync());
return(Settings.Current);
}
}
public HomeController(IRepository <User> userRepository, IRepository <FileReference> fileRepository, ILogger <HomeController> logger,
IWebHostEnvironment webHostingEnvironment, LocalDbContext context)
{
_userRepository = userRepository;
_fileRepository = fileRepository;
_logger = logger;
this.webHostingEnvironment = webHostingEnvironment;
}
public void Get_Id1OnEmptyDb_ReturnsNull()
{
var mock = GetMockDependency <Product>();
var obj = new LocalDbContext <Product>(mock);
var actual = obj.Get(1);
Assert.Null(actual);
}
public void Delete_Id1EmptyDb_ReturnsFalse()
{
var mock = GetMockDependency <Product>();
var obj = new LocalDbContext <Product>(mock);
var actual = obj.Delete(1);
Assert.False(actual);
}
public void GetAll_EmptyDb_ReturnsEmptyCollection()
{
var mock = GetMockDependency <Product>();
var obj = new LocalDbContext <Product>(mock);
var actual = obj.GetAll();
Assert.Empty(actual);
}
public static string GetClaimUsernameById(int userId)
{
using (var context = new LocalDbContext())
{
var user = context.Users.Where(x => x.Id == userId).SingleOrDefault();
return((user == null || String.IsNullOrEmpty(user.UserName)) ? "" : user.UserName);
}
}
public BaseRepository(LocalDbContext dbContext)
{
if (dbContext == null)
{
throw new Exception("Data context can not be null!");
}
_dbContext = dbContext;
}
public CreateViewModel(LocalDbContext context, IEventAggregator eventAggregator)
{
_context = context;
_eventAggregator = eventAggregator;
SelectCommand = new DelegateCommand(Select, CanSelect);
UnselectCommand = new DelegateCommand(Unselect, CanUnselect);
CreateOrderCommand = new DelegateCommand(CreateOrder, CanCreateOrder);
}
private static void AtualizaConfirmacao(Confirmacao confirmacao)
{
using (var db = new LocalDbContext())
{
confirmacao.IdRemoto = confirmacao.Id;
db.UpdateConfirmacao(confirmacao);
db.SaveChanges();
}
}
