public void DeleteInvoiceHeaderFromDatabase()
{
IInvoice invoiceHeader = new Invoice
{
CustomerId = 1,
SupplierId = 2,
InvoiceNumber = 10
};
IInvoiceDao invoiceDao = new InvoiceDao(_sqlConnection);
invoiceDao.Write(invoiceHeader);
invoiceDao = new InvoiceDao(_sqlConnection);
var rowsAffected = invoiceDao.Delete(invoiceHeader);
Assert.IsTrue(rowsAffected == 1);
}
public void GetInvoiceHeaderEntityByInvoiceNumberFromDatabase()
{
IInvoice invoiceHeader = new Invoice
{
CustomerId = 1,
SupplierId = 2,
InvoiceNumber = 56
};
IInvoiceDao invoiceDao = new InvoiceDao(_sqlConnection);
invoiceDao.Write(invoiceHeader);
invoiceDao = new InvoiceDao(_sqlConnection);
invoiceHeader = invoiceDao.GetByInvoiceNumber(invoiceHeader.InvoiceNumber);
Assert.IsTrue(invoiceHeader != null);
}
public void GetInvoiceHeaderEntityBySqlFromDatabase()
{
IInvoice invoiceHeader = new Invoice
{
CustomerId = 1,
SupplierId = 2,
InvoiceNumber = 56
};
IInvoiceDao invoiceDao = new InvoiceDao(_sqlConnection);
invoiceDao.Write(invoiceHeader);
invoiceDao = new InvoiceDao(_sqlConnection);
string sqlQuery = $"SELECT * FROM InvoiceHeader WHERE [Id] = {invoiceHeader.Id}";
invoiceHeader = invoiceDao.GetBySql(sqlQuery);
Assert.IsTrue(invoiceHeader != null);
}
public void WriteInvoiceHeaderEntityToDatabase()
{
IInvoice invoiceHeader = new Invoice
{
CustomerId = 1,
SupplierId = 2,
InvoiceNumber = 10
};
IInvoiceDao invoiceDao = new InvoiceDao(_sqlConnection);
invoiceDao.Write(invoiceHeader);
Assert.IsTrue(invoiceHeader.Id > 0);
}
