public void GetExpenses_Success_Test()
{
// Arrange
R_Expense expense = SampleExpense(1);
IList <R_Expense> list = new List <R_Expense>();
list.Add(expense);
// create mock for repository
var mock = new Mock <IExpenseRepository>();
mock.Setup(s => s.GetExpenses()).Returns(list);
// service
ExpenseService expenseService = new ExpenseService();
ExpenseService.Repository = mock.Object;
// Act
var resultList = expenseService.GetExpenses();
ExpenseDTO result = resultList.FirstOrDefault();
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(1, result.ExpenseId);
}
public void UpdateExpense(R_Expense t)
{
//Requires.NotNull(t);
//Requires.PropertyNotNegative(t, "ExpenseId");
t.Update();
}
public ExpenseDTO GetExpense(int expenseId)
{
try
{
//Requires.NotNegative("expenseId", expenseId);
log.Debug("expenseId: " + expenseId + " ");
// get
R_Expense t = Repository.GetExpense(expenseId);
ExpenseDTO dto = new ExpenseDTO(t);
log.Debug(ExpenseDTO.FormatExpenseDTO(dto));
return(dto);
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public int AddExpense(ExpenseDTO dto)
{
int id = 0;
try
{
log.Debug(ExpenseDTO.FormatExpenseDTO(dto));
R_Expense t = ExpenseDTO.ConvertDTOtoEntity(dto);
// add
id = Repository.AddExpense(t);
dto.ExpenseId = id;
log.Debug("result: 'success', id: " + id);
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
return(id);
}
public R_Expense GetExpense(int expenseId)
{
//Requires.NotNegative("expenseId", expenseId);
R_Expense t = R_Expense.SingleOrDefault(expenseId);
return(t);
}
public IEnumerable <R_Expense> GetExpenses()
{
IEnumerable <R_Expense> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_Expense")
.Where("IsDeleted = 0")
;
results = R_Expense.Query(sql);
return(results);
}
public IList <R_Expense> GetExpenses(string searchTerm, int pageIndex, int pageSize)
{
IList <R_Expense> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_Expense")
.Where("IsDeleted = 0")
.Where(
"Name like '%" + searchTerm + "%'"
+ " or " + "Description like '%" + searchTerm + "%'"
)
;
results = R_Expense.Fetch(pageIndex, pageSize, sql);
return(results);
}
public ExpenseDTO(R_Expense expense)
{
ExpenseId = expense.ExpenseId;
NucleoId = expense.NucleoId;
Name = expense.Name;
Description = expense.Description;
ResponsiblePersonId = expense.ResponsiblePersonId;
ExecuterPersonId = expense.ExecuterPersonId;
DocumentId = expense.DocumentId;
PartnerId = expense.PartnerId;
InvoiceDate = expense.InvoiceDate;
Amount = expense.Amount;
IsDeleted = expense.IsDeleted;
CreateBy = expense.CreateBy;
CreateOn = expense.CreateOn;
UpdateBy = expense.UpdateBy;
UpdateOn = expense.UpdateOn;
}
public void DeleteExpense(ExpenseDTO dto)
{
try
{
log.Debug(ExpenseDTO.FormatExpenseDTO(dto));
R_Expense t = ExpenseDTO.ConvertDTOtoEntity(dto);
// delete
Repository.DeleteExpense(t);
dto.IsDeleted = t.IsDeleted;
log.Debug("result: 'success'");
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public static R_Expense ConvertDTOtoEntity(ExpenseDTO dto)
{
R_Expense expense = new R_Expense();
expense.ExpenseId = dto.ExpenseId;
expense.NucleoId = dto.NucleoId;
expense.Name = dto.Name;
expense.Description = dto.Description;
expense.ResponsiblePersonId = dto.ResponsiblePersonId;
expense.ExecuterPersonId = dto.ExecuterPersonId;
expense.DocumentId = dto.DocumentId;
expense.PartnerId = dto.PartnerId;
expense.InvoiceDate = dto.InvoiceDate;
expense.Amount = dto.Amount;
expense.IsDeleted = dto.IsDeleted;
expense.CreateBy = dto.CreateBy;
expense.CreateOn = dto.CreateOn;
expense.UpdateBy = dto.UpdateBy;
expense.UpdateOn = dto.UpdateOn;
return(expense);
}
public void GetExpense_Success_Test()
{
// Arrange
int id = 1;
R_Expense expense = SampleExpense(id);
// create mock for repository
var mock = new Mock <IExpenseRepository>();
mock.Setup(s => s.GetExpense(Moq.It.IsAny <int>())).Returns(expense);
// service
ExpenseService expenseService = new ExpenseService();
ExpenseService.Repository = mock.Object;
// Act
ExpenseDTO result = expenseService.GetExpense(id);
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(1, result.ExpenseId);
}
// example data
public static R_Expense SampleExpense(int id = 1)
{
R_Expense expense = new R_Expense();
// int
expense.ExpenseId = id;
// int?
expense.NucleoId = 1;
// string
expense.Name = "NameTestValue";
// string
expense.Description = "DescriptionTestValue";
// int?
expense.ResponsiblePersonId = 1;
// int?
expense.ExecuterPersonId = 1;
// int?
expense.DocumentId = 1;
// int?
expense.PartnerId = 1;
// System.DateTime?
expense.InvoiceDate = new System.DateTime();
// double
expense.Amount = 1;
// bool
expense.IsDeleted = false;
// int?
expense.CreateBy = 1;
// System.DateTime?
expense.CreateOn = new System.DateTime();
// int?
expense.UpdateBy = 1;
// System.DateTime?
expense.UpdateOn = new System.DateTime();
return(expense);
}
public void UpdateExpense(ExpenseDTO dto)
{
try
{
//Requires.NotNull(t);
//Requires.PropertyNotNegative(t, "ExpenseId");
log.Debug(ExpenseDTO.FormatExpenseDTO(dto));
R_Expense t = ExpenseDTO.ConvertDTOtoEntity(dto);
// update
Repository.UpdateExpense(t);
log.Debug("result: 'success'");
}
catch (System.Exception e)
{
// error
log.Error(e.ToString());
throw;
}
}
public IEnumerable <R_Expense> GetExpenseListAdvancedSearch(
int?nucleoId
, string name
, string description
, int?responsiblePersonId
, int?executerPersonId
, int?documentId
, int?partnerId
, System.DateTime?invoiceDateFrom
, System.DateTime?invoiceDateTo
, double?amount
)
{
IEnumerable <R_Expense> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_Expense")
.Where("IsDeleted = 0"
+ (nucleoId != null ? " and NucleoId like '%" + nucleoId + "%'" : "")
+ (name != null ? " and Name like '%" + name + "%'" : "")
+ (description != null ? " and Description like '%" + description + "%'" : "")
+ (responsiblePersonId != null ? " and ResponsiblePersonId like '%" + responsiblePersonId + "%'" : "")
+ (executerPersonId != null ? " and ExecuterPersonId like '%" + executerPersonId + "%'" : "")
+ (documentId != null ? " and DocumentId like '%" + documentId + "%'" : "")
+ (partnerId != null ? " and PartnerId like '%" + partnerId + "%'" : "")
+ (invoiceDateFrom != null ? " and InvoiceDate >= '" + invoiceDateFrom.Value.ToShortDateString() + "'" : "")
+ (invoiceDateTo != null ? " and InvoiceDate <= '" + invoiceDateTo.Value.ToShortDateString() + "'" : "")
+ (amount != null ? " and Amount like '%" + amount + "%'" : "")
)
;
results = R_Expense.Query(sql);
return(results);
}
public void DeleteExpense(R_Expense t)
{
t.IsDeleted = true;
t.Update();
}
public int AddExpense(R_Expense t)
{
int id = (int)t.Insert();
return(id);
}
