//Adds in database
/// <summary>
/// Adds in database
/// </summary>
/// <param name="date"></param>
/// <param name="income"></param>
/// <param name="rawmaterials"></param>
/// <param name="expenses"></param>
/// <param name="balance"></param>
/// <param name="counted"></param>
/// <param name="checkout"></param>
/// <param name="accountId"></param>
/// <param name="Userid"></param>
public void Add(DateTime date, decimal income, decimal rawmaterials, decimal expenses, decimal balance, decimal counted, decimal checkout, int accountId, int Userid)
{
RevenueExpenditureBook BookCreation = new RevenueExpenditureBook()
{
Date = date, Income = income, RawMaterials = rawmaterials, Expense = expenses, Balance = balance, Counted = counted, CheckOutPlusAndMinus = checkout, AccountRavenueBookId = accountId, UserRegisteredId = Userid
};
contexts.RevenueExpenditureBooks.Add(BookCreation);
contexts.SaveChanges();
}
//Updates the database
/// <summary>
/// Updates Database
/// </summary>
/// <param name="date"></param>
/// <param name="income"></param>
/// <param name="rawmaterials"></param>
/// <param name="expenses"></param>
/// <param name="balance"></param>
/// <param name="counted"></param>
/// <param name="checkout"></param>
/// <param name="accountid"></param>
/// <param name="userid"></param>
public void Update(DateTime date, decimal income, decimal rawmaterials, decimal expenses, decimal balance, decimal counted, decimal checkout, int accountid, int userid)
{
RevenueExpenditureBook BookCreation = new RevenueExpenditureBook()
{
Date = date, Income = income, RawMaterials = rawmaterials, Expense = expenses, Balance = balance, Counted = counted, CheckOutPlusAndMinus = checkout, AccountRavenueBookId = accountid, UserRegisteredId = userid
};
var getuserid = contexts.RevenueExpenditureBooks.OrderByDescending(x => x.Date).FirstOrDefault(x => x.UserRegisteredId == userid);
var Id = this.Get(getuserid.Id);
update = BookCreation;
update.Id = Id.Id;
contexts.Entry(Id).CurrentValues.SetValues(update);
contexts.SaveChanges();
}
public void CreateRevenueExpeditureBook_Saves_in_database()
{
var data = new RevenueExpenditureBook()
{
Id = 1, Date = DateTime.Today, Income = 100, Expense = 100, RawMaterials = 100, Counted = 100, Balance = 100, CheckOutPlusAndMinus = 100, AccountRavenueBookId = 1, UserRegisteredId = 1
};
var MockSet = new Mock <DbSet <RevenueExpenditureBook> >();
var MockContext = new Mock <ApplicationContexts>();
MockContext.Setup(x => x.RevenueExpenditureBooks).Returns(MockSet.Object);
var service = new RevenueExpenditureBookController(MockContext.Object);
service.Add(data.Date, data.Income, data.RawMaterials, data.Expense, data.Balance, data.Counted, data.CheckOutPlusAndMinus, data.AccountRavenueBookId, data.UserRegisteredId);
MockSet.Verify(x => x.Add(It.IsAny <RevenueExpenditureBook>()), Times.Once());
MockContext.Verify(x => x.SaveChanges(), Times.Once());
}
