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;
}
