public IActionResult CreateNewExpense(ExpensesDTO newExpense)
{
newExpense.purchaseDate = DateTime.Today;
var addNewExpense = _repo.AddExpense(newExpense);
return(Ok(addNewExpense));
}
public bool AddExpenses(ExpensesDTO expensesDTO)
{
var flag = true;
try
{
using (var entities = new ManiMotorsEntities1())
{
var expense = new Expens()
{
Description = expensesDTO.Description,
CreatedDate = expensesDTO.CreatedDate,
Createdby = expensesDTO.CreatedBy,
Modifiedby = expensesDTO.ModifiedBy,
ModifiedDate = expensesDTO.ModifiedDate
};
entities.Expenses.Add(expense);
entities.SaveChanges();
flag = true;
}
}
catch (Exception ex)
{
flag = false;
throw ex;
}
return(flag);
}
public bool UpdateExpenses(ExpensesDTO expensesDTO)
{
var flag = true;
try
{
using (var entities = new ManiMotorsEntities1())
{
var Gamesys = entities.Expenses.Where(g => g.ExpenseID == expensesDTO.ExpenseID).FirstOrDefault();
Gamesys.Description = expensesDTO.Description;
//Gamesys.CreatedDate = expensesDTO.CreatedDate;
//Gamesys.Createdby = expensesDTO.CreatedBy;
Gamesys.Modifiedby = expensesDTO.ModifiedBy;
Gamesys.ModifiedDate = expensesDTO.ModifiedDate;
entities.SaveChanges();
}
}
catch (Exception ex)
{
flag = false;
throw ex;
}
return(flag);
}
public void DeleteExpenseById()
{
int userId = 1;
int expenseId = 2;
var expense = new ExpensesViewModel {
Title = "mock Expenses", Price = 20
};
var expenseDTO = new ExpensesDTO {
Title = "mock Expenses", Price = 20
};
var mockRepo = new Mock <IExpensesService>();
mockRepo.Setup(repo => repo.DeleteExpenseByIdAsync(expenseId, userId))
.ReturnsAsync(true);
var mockMapper = new Mock <IMapper>();
var mockExceptionREpo = new Mock <IExceptionHandler>();
var controller = new ExpensesController(mockRepo.Object, mockExceptionREpo.Object, mockMapper.Object);
// Act
var okResult = controller.DeleteExpenseById(expenseId, userId).Result;
// Assert
Assert.IsType <OkObjectResult>(okResult);
}
public void GetExpenses()
{
var client = new HttpClient();
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Token", "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1bmlxdWVfbmFtZSI6IjQ4MDZhYWVmLTJmNjctNGY3Yy0yYjdiLTA4ZDdiNTE3MGEzMyIsIm5iZiI6MTU4MjEwMTQ4NywiZXhwIjoxNTgyMTA0MTg3LCJpYXQiOjE1ODIxMDE0ODd9.m-zrNriR1RqSF6pchSBbQ_noiIaNeVSfmixUgyrFqik");
var expense = new ExpensesViewModel {
Title = "mock Expenses", Price = 20
};
var expenseDTO = new ExpensesDTO {
Title = "mock Expenses", Price = 20
};
int userId = 1;
var mockMapper = new Mock <IMapper>();
mockMapper.Setup(repo => repo.Map(expense, expenseDTO))
.Returns(expenseDTO);
mockMapper.Setup(repo => repo.Map(expenseDTO, expense))
.Returns(expense);
List <ExpensesDTO> expensesList = new List <ExpensesDTO>();
var mockRepo = new Mock <IExpensesService>();
mockRepo.Setup(repo => repo.GetExpensesAsync(userId))
.ReturnsAsync(expensesList);
var mockExceptionREpo = new Mock <IExceptionHandler>();
var controller = new ExpensesController(mockRepo.Object, mockExceptionREpo.Object, mockMapper.Object);
// Act
var okResult = controller.GetExpenses(userId).Result;
// Assert
Assert.IsType <OkObjectResult>(okResult);
}
//edit a expense
public async Task <ExpensesDTO> EditExpenseByIdAsync(ExpensesDTO item)
{
try
{
Expense expense = _mapper.Map <Expense>(item);
Expense newExpenseEntity = await expensesDataLayerLogic.EditExpenseByIdAsync(expense);
return(_mapper.Map <ExpensesDTO>(newExpenseEntity));
}
catch (Exception ex)
{
throw ex;
}
}
//create expense of a user
public async Task <ExpensesDTO> CreateExpenseAsync(ExpensesDTO newExpense)
{
try
{
Expense expense = _mapper.Map <Expense>(newExpense);
Expense newExpenseEntity = await expensesDataLayerLogic.CreateExpenseAsync(expense);
return(_mapper.Map <ExpensesDTO>(newExpenseEntity));
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IActionResult> AddExpense(ExpensesDTO model)
{
var expense = new ExpensesDTO()
{
Amount = model.Amount,
Id = model.Id,
OutcomeDate = model.OutcomeDate,
Title = model.Title,
Type = model.Type,
UserId = model.UserId
};
await _expensesDAL.Add(expense);
return(Ok(expense));
}
public async Task <IActionResult> GetExpenseById([FromQuery] int expenseId, [FromQuery] int userId)
{
try
{
ExpensesDTO expenseItem = await expensesBusinessLogic.GetExpenseByIdAsync(expenseId, userId);
ExpensesViewModel expesesViewModel = _mapper.Map <ExpensesViewModel>(expenseItem);
return(Ok(expesesViewModel));
}
catch (Exception ex)
{
_logger.LogInformation(ex.Message);
return(_exceptionHandler.HandleError(ex.Message));
}
}
public async Task <IActionResult> CreateExpense([FromQuery] int userId, [FromBody] ExpensesViewModel newExpense)
{
try
{
newExpense.UserId = userId;
ExpensesDTO expensesDTO = _mapper.Map <ExpensesDTO>(newExpense);
ExpensesDTO createdExpense = await expensesBusinessLogic.CreateExpenseAsync(expensesDTO);
ExpensesViewModel expesesViewModel = _mapper.Map <ExpensesViewModel>(createdExpense);
return(CreatedAtAction("GetExpenseById", new { expenseId = expesesViewModel.ExpensesId }, expesesViewModel));
}
catch (Exception ex)
{
_logger.LogInformation(ex.Message);
return(_exceptionHandler.HandleError(ex.Message));
}
}
public List <ExpensesDTO> GetExpenses()
{
var lstExpenses = new List <ExpensesDTO>();
using (var entities = new ManiMotorsEntities1())
{
foreach (var ent in entities.Expenses)
{
var expenseDTO = new ExpensesDTO();
expenseDTO.ExpenseID = ent.ExpenseID;
expenseDTO.Description = ent.Description;
lstExpenses.Add(expenseDTO);
}
}
return(lstExpenses);
}
public async Task <ExpensesDTO> Edit(int expenseId, ExpensesDTO model)
{
var result = _ctx.Expense.FirstOrDefaultAsync(x => x.Id == expenseId).Result;
if (result != null)
{
result.Amount = model.Amount;
result.Id = model.Id;
result.OutcomeDate = model.OutcomeDate;
result.Title = model.Title;
result.Type = model.Type;
result.UserId = model.UserId;
_ctx.SaveChanges();
}
return(model);
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (validate())
{
if (btntext == "ADD")
{
ExpensesDTO expenseDTO = new ExpensesDTO();
expenseDTO.Description = txtDescription.Text;
expenseDTO.CreatedBy = GlobalSetup.Userid;
expenseDTO.CreatedDate = DateTime.Now;
expenseDTO.ModifiedDate = DateTime.Now;
ExpensesBL expen = new ExpensesBL();
var result = expen.AddExpenses(expenseDTO);
LoadExpenses();
if (result)
{
MyMessageBox.ShowBox("Expense is Saved", "Expense");
}
else
{
MyMessageBox.ShowBox("Expense Save is failed !!!");
}
}
else
{
ExpensesDTO expenseDTO = new ExpensesDTO();
expenseDTO.Description = txtDescription.Text;
expenseDTO.ExpenseID = Convert.ToInt32(dgExpenses.CurrentRow.Cells["ExpenseID"].Value);
expenseDTO.ModifiedDate = DateTime.Now;
expenseDTO.ModifiedBy = GlobalSetup.Userid;
ExpensesBL exp = new ExpensesBL();
var result = exp.UpdateExpenses(expenseDTO);
btntext = "ADD";
}
clear();
LoadExpenses();
}
else
{
MyMessageBox.ShowBox("Description cannot be Empty !!!");
}
}
public async Task <ExpensesDTO> Add(ExpensesDTO model)
{
using (_ctx)
{
var expense = new ExpensesDTO()
{
Amount = model.Amount,
Id = model.Id,
OutcomeDate = model.OutcomeDate,
Title = model.Title,
Type = model.Type,
UserId = model.UserId
};
_ctx.Expense.Add(expense);
_ctx.SaveChanges();
return(expense);
}
}
public IEnumerable <Expense> AddExpense(ExpensesDTO newExpense)
{
using (var db = new SqlConnection(_connectionString))
{
var sql = @"INSERT INTO [Expenses]
([expenseName]
,[cost]
,[purchaseDate]
,[category]
,[rentalId]
)
output inserted.*
VALUES
(@expenseName
,@cost
,@purchaseDate
,@category
,@rentalId)";
return(db.Query <Expense>(sql, newExpense));
}
}
public ExpensesController(IExpensesDAL expensesDAL, ExpensesDTO expensesDTO)
{
_expensesDAL = expensesDAL;
_expensesDTO = expensesDTO;
}
