public IList <ExpenseReport> QueryExpenseReports() { using (ExpenseContext db = new ExpenseContext()) { db.Database.Connection.ConnectionString = "Data Source=mainstorage.database.windows.net;Initial Catalog=ExpenseReportingDatabase;Integrated Security=False;User ID=HECFLORES1993;Password=Armandorocha1-;Connect Timeout=15;Encrypt=True;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"; return(db.ExpenseReports.ToList()); } }
/// <summary> /// Constructor pulls in all the required services /// </summary> /// <param name="expenseDb"></param> /// <param name="addUpdateExpenseLine"></param> /// <param name="deleteExpenseLine"></param> public AddUpdateExpense(ExpenseContext expenseDb, ICommandHandler <AddUpdateExpenseLineInfo> addUpdateExpenseLine, ICommandHandler <DeleteExpenseLineInfo> deleteExpenseLine) { this.expenseDb = expenseDb; this.addUpdateExpenseLine = addUpdateExpenseLine; this.deleteExpenseLine = deleteExpenseLine; }
public ActionResult Index() //DO NOT change the action name { //fill code here var context = new ExpenseContext(); List <Expense> expense = context.Expenses.ToList(); return(View(expense)); }
public ExpenseController(ExpenseContext context) { _context = context; if (_context.ExpenseItems.Count() == 0) { _context.SaveChanges(); } }
private ExpenseContext GetContext() { var options = new DbContextOptionsBuilder <ExpenseContext>() .UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString()) .Options; var context = new ExpenseContext(options); context.Database.EnsureCreated(); return(context); }
public UpdateExpenseValidatorTests() { expenseDb = DatabaseSetup.CreateExpenseContext(); updateExpenseValidator = new UpdateExpenseValidator(expenseDb); expenseDb.Expenses.Add(new Expense() { expenseId = 1 }); expenseDb.SaveChanges(); }
public AddUpdateExpenseValidatorTests() { expenseDb = DatabaseSetup.CreateExpenseContext(); addUpdateExpenseValidator = new AddUpdateExpenseValidator(expenseDb); // Add an existing expense/expense line expenseDb.Expenses.Add(new Expense() { expenseId = 1 }); expenseDb.SaveChanges(); }
public void DeleteExpenseReport(ExpenseReport report) { using (ExpenseContext db = new ExpenseContext()) { db.Database.Connection.ConnectionString = "Data Source=mainstorage.database.windows.net;Initial Catalog=ExpenseReportingDatabase;Integrated Security=False;User ID=HECFLORES1993;Password=Armandorocha1-;Connect Timeout=15;Encrypt=True;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"; ExpenseReport foundItem = db.ExpenseReports.Find(report.ExpenseReportId); if (foundItem != null) { db.ExpenseReports.Remove(foundItem); } db.SaveChanges(); } }
public XmlExtractorController(ExpenseContext expenseContext, ReservationContext reservationContext) { ReservationContext = reservationContext; if (reservationContext.ReservationItems.Count() == 0) { reservationContext.SaveChanges(); } ExpenseContext = expenseContext; if (expenseContext.ExpenseItems.Count() == 0) { expenseContext.SaveChanges(); } }
public AddUpdateExpenseLineValidatorTests() { expenseDb = DatabaseSetup.CreateExpenseContext(); addUpdateExpenseLineValidator = new AddUpdateExpenseLineValidator(expenseDb); expenseDb.Expenses.Add(new Expense() { expenseId = 1 }); expenseDb.ExpenseLines.Add(new ExpenseLine() { expenseLineId = 1, expenseId = 1 }); expenseDb.SaveChanges(); }
public ActionResult AddExpense(Expense Expense) //DO NOT change the action name { var viewModel = new ExpenseViewModel(); ViewBag.ExpenseTypes = viewModel.ExpenseTypeList; //fill code here if (ModelState.IsValid) { var context = new ExpenseContext(); context.Expenses.Add(Expense); context.SaveChanges(); // return RedirectToAction("Index"); return(View(viewModel)); } ViewBag.Flag = 1; return(View(viewModel)); }
public async void GetExpenses_ReturnsZeroItems_WhenDBIsEmpty() { //Arrange //DBContext var optionsBuilder = new DbContextOptionsBuilder <ExpenseContext>(); optionsBuilder.UseInMemoryDatabase("UnitTestInMemBD"); var dbContext = new ExpenseContext(optionsBuilder.Options); var expenseRepo = new ExpenseRepository(dbContext); //Controller var controller = new ExpensesController(expenseRepo, null); //Act var result = await controller.GetExpenses(); //Assert Assert.Empty(result.Value); }
public ExpenseController(IConfiguration configuration, ExpenseContext context) { _configuration = configuration; _context = context; if (_context.Expenses.Count() == 0) { // Create some new Expenses if collection is empty, _context.Expenses.Add(new Expense { ExpenseDate = DateTime.UtcNow, Amount = 43.5M, Reason = "Rail ticket to T.A." }); _context.Expenses.Add(new Expense { ExpenseDate = DateTime.UtcNow, Amount = 51.5M, Reason = "Rail ticket to BeerSheva" }); _context.SaveChanges(); } }
public async Task <IContext> ExtractEmailContent(Email email) { var context = new ExpenseContext(); var xml = $"<Foo>{email.Content}</Foo>"; var xmlHelper = new XmlHelper(); var xmlDoc = await xmlHelper.LoadXmlDocument(xml); if (xmlDoc == null) { context.Validations.Add(ErrorMessages.EmailErrorMsgs["ERR0001"]); return(context); } var nodes = xmlDoc.SelectNodes("/Foo/expense"); if (nodes.Count == 0) { context.Validations.Add(ErrorMessages.EmailErrorMsgs["ERR0002"]); return(context); } var expenses = new List <Expense>(); foreach (XmlNode node in nodes) { var costCentre = node["cost_centre"]?.InnerText; decimal total; var paymentMethod = node["payment_method"]?.InnerText; if (decimal.TryParse(node["total"]?.InnerText, out total)) { expenses.Add(new Expense(costCentre, total, paymentMethod)); } else { context.Validations.Add(ErrorMessages.ExpenseErrorMsgs["ERR0001"]); } } context.Expenses = expenses; return(context); }
public async void GetExpenses_ReturnsTwoItems_WhenDBIsNotEmpty() { //Arrange //DBContext var optionsBuilder = new DbContextOptionsBuilder <ExpenseContext>(); optionsBuilder.UseInMemoryDatabase("UnitTestInMemBD2"); var dbContext = new ExpenseContext(optionsBuilder.Options); dbContext.Add(new Expense() { Amount = 88.49f, Currency = Currency.EUR, Description = "Skateboard trucks" }); dbContext.Add(new Expense() { Amount = 49.99f, Currency = Currency.EUR, Description = "Skateboard deck" }); dbContext.SaveChanges(); var expenseRepo = new ExpenseRepository(dbContext); //Controller var controller = new ExpensesController(expenseRepo); //Act var result = await controller.GetExpenses(); //Assert Assert.Equal(2, result.Value.Count); }
/// <summary> /// Constructor pulls in all the required services /// </summary> /// <param name="expensesDb"></param> public AddUpdateExpenseValidator(ExpenseContext expensesDb) { this.expensesDb = expensesDb; }
public BudgetsController(ExpenseContext context) { _context = context; }
/// <summary> /// Constructor pulls in all the required services /// </summary> /// <param name="expenseDb"></param> public GetExpensesOverview(ExpenseContext expenseDb) { this.expenseDb = expenseDb; }
//private readonly Serilog.ILogger _logger; //UnComment this for non Serilog Sink to Database public WalletController(ExpenseContext context, ILogger <WalletController> logger) { _context = context; _logger = logger; }
public ColumnChartController(ExpenseContext context) { _context = context; }
public ExpensesController(ExpenseContext context, ILogger <ExpensesController> logger) { this.context = context; this.logger = logger; }
public ExpensesController(ExpenseContext context) { _service = new ExpenseService(context); }
public UserService(IOptions <AppSettings> appSettings, ExpenseContext context) { _appSettings = appSettings.Value; _context = context; }
public UserRepository(ExpenseContext context) => _context = context;
public ExpenseRepository(ExpenseContext dbContext) { _dbContext = dbContext; }
public AddExpenseValidatorTests() { expenseDb = DatabaseSetup.CreateExpenseContext(); addExpenseValidator = new AddExpenseValidator(expenseDb); }
public ExpensesController(ExpenseContext context) { _context = context; }
public ExpenseService(ExpenseContext expenseContext, IOptions <VATSetting> options) { _context = expenseContext; vatSetting = options.Value; }
public ExpenseController(ExpenseContext expenseDatabase) { _expenseDatabase = expenseDatabase; }
/// <summary> /// Constructor pulls in all the required services /// </summary> /// <param name="expenseDb"></param> public GetExpenseDetail(ExpenseContext expenseDb) { this.expenseDb = expenseDb; }