public void ViewBalance_Balance_Exists_In_Db()
{
accountbalance accountBalanceDAL = new accountbalance();
accountBalanceDAL.year = 2016;
accountBalanceDAL.month = 1;
accountBalanceDAL.rnd = 10000.00;
accountBalanceDAL.canteen = 150000.25;
accountBalanceDAL.ceocar = 2500.36;
accountBalanceDAL.marketing = 69354.25;
accountBalanceDAL.parking = 25369.25;
AccountBalance expected = new AccountBalance();
expected.year = 2016;
expected.month = 1;
expected.rnd = 10000.00;
expected.canteen = 150000.25;
expected.ceocar = 2500.36;
expected.marketing = 69354.25;
expected.parking = 25369.25;
var mockAccountBalanceRepo = new Mock <IAccountBalanceRepo>();
mockAccountBalanceRepo.Setup(x => x.ViewBalance(It.IsAny <int>(), It.IsAny <int>())).Returns(accountBalanceDAL);
AccountBalanceService accountBalanceService = new AccountBalanceService(mockAccountBalanceRepo.Object);
AccountBalance actual = accountBalanceService.ViewBalance(2016, 1);
AssertObjects.PropertyValuesAreEquals(actual, expected);
}
public accountbalance ViewCurrentBalance()
{
// get the last row of the accountbalance table
accountbalance maximum = DbContext.accountbalances.OrderByDescending(o => o.year).ThenByDescending(o => o.month).FirstOrDefault();
return(maximum);
}
public void ViewCurrentBalance_Balance_Exists_In_Db()
{
string accountType = "canteen";
accountbalance accountBalanceDAL = new accountbalance();
accountBalanceDAL.year = 2016;
accountBalanceDAL.month = 1;
accountBalanceDAL.rnd = 10000.00;
accountBalanceDAL.canteen = 150000.25;
accountBalanceDAL.ceocar = 2500.36;
accountBalanceDAL.marketing = 69354.25;
accountBalanceDAL.parking = 25369.25;
double[] expected = new double[] { 0, 150000.25 };
var mockAccountBalanceRepo = new Mock <IAccountBalanceRepo>();
mockAccountBalanceRepo.Setup(x => x.ViewCurrentBalance()).Returns(accountBalanceDAL);
AccountBalanceService accountBalanceService = new AccountBalanceService(mockAccountBalanceRepo.Object);
double[] actual = accountBalanceService.ViewCurrentBalance(accountType);
Assert.AreEqual(expected, actual);
}
public void UploadBalance_Balance_Not_In_Db()
{
accountbalance accountBalanceDAL = new accountbalance();
accountBalanceDAL.year = 2016;
accountBalanceDAL.month = 1;
accountBalanceDAL.rnd = 10000.00;
accountBalanceDAL.canteen = 150000.25;
accountBalanceDAL.ceocar = 2500.36;
accountBalanceDAL.marketing = 69354.25;
accountBalanceDAL.parking = 25369.25;
AccountBalance accountBalanceBAL = new AccountBalance();
accountBalanceBAL.year = 2016;
accountBalanceBAL.month = 1;
accountBalanceBAL.rnd = 10000.00;
accountBalanceBAL.canteen = 150000.25;
accountBalanceBAL.ceocar = 2500.36;
accountBalanceBAL.marketing = 69354.25;
accountBalanceBAL.parking = 25369.25;
string expected = "uploaded succesfully";
Mock <IAccountBalanceRepo> mockAccountBalanceRepo = new Mock <IAccountBalanceRepo>();
mockAccountBalanceRepo.Setup(x => x.ViewBalance(It.IsAny <int>(), It.IsAny <int>())).Returns((accountbalance)null);
mockAccountBalanceRepo.Setup(x => x.UploadBalance(It.IsAny <accountbalance>())).Returns("uploaded succesfully");
AccountBalanceService accountBalanceService = new AccountBalanceService(mockAccountBalanceRepo.Object);
string status = accountBalanceService.UploadBalance(accountBalanceBAL);
Assert.AreEqual(status, expected);
}
public void UploadBalance_Balance_Already_In_Db()
{
accountbalance accountBalanceDAL = new accountbalance();
accountBalanceDAL.year = 2016;
accountBalanceDAL.month = 1;
accountBalanceDAL.rnd = 10000.00;
accountBalanceDAL.canteen = 150000.25;
accountBalanceDAL.ceocar = 2500.36;
accountBalanceDAL.marketing = 69354.25;
accountBalanceDAL.parking = 25369.25;
AccountBalance accountBalanceBAL = new AccountBalance();
accountBalanceBAL.year = 2016;
accountBalanceBAL.month = 1;
accountBalanceBAL.rnd = 10000.00;
accountBalanceBAL.canteen = 150000.25;
accountBalanceBAL.ceocar = 2500.36;
accountBalanceBAL.marketing = 69354.25;
accountBalanceBAL.parking = 25369.25;
string expected = "Balances of this month already exsists in the database";
Mock <IAccountBalanceRepo> mockAccountBalanceRepo = new Mock <IAccountBalanceRepo>();
mockAccountBalanceRepo.Setup(x => x.ViewBalance(It.IsAny <int>(), It.IsAny <int>())).Returns(accountBalanceDAL);
AccountBalanceService accountBalanceService = new AccountBalanceService(mockAccountBalanceRepo.Object);
string status = accountBalanceService.UploadBalance(accountBalanceBAL);
Assert.AreEqual(status, expected);
}
// upload balance
public string UploadBalance(AccountBalance accountBalance)
{
string uploadStatus = "";
// creating a object for DAL and set values
accountbalance accountBalanceDAL = new accountbalance();
accountBalanceDAL.year = accountBalance.year;
accountBalanceDAL.month = accountBalance.month;
accountBalanceDAL.rnd = accountBalance.rnd;
accountBalanceDAL.canteen = accountBalance.canteen;
accountBalanceDAL.ceocar = accountBalance.ceocar;
accountBalanceDAL.marketing = accountBalance.marketing;
accountBalanceDAL.parking = accountBalance.parking;
accountBalanceDAL.uid = accountBalance.uid;
// to check if balance is already in the database
AccountBalance existingRecord = ViewBalance(accountBalance.year, accountBalance.month);
// if balances exsists
if (existingRecord != null)
{
uploadStatus = "Balances of this month already exsists in the database";
}
else
{
// if balances doesn't exists call repository method to upload
uploadStatus = _AccountBalanceRepo.UploadBalance(accountBalanceDAL);
}
// return the result
return(uploadStatus);
}
// upload account balance
public string UploadBalance(accountbalance accountBalance)
{
DbContext.accountbalances.Add(accountBalance);
int result = DbContext.SaveChanges();
if (result != 0)
{
return("uploaded succesfully");
}
else
{
return("An error occured");
}
}
public string DeleteAccountBalance(int year, int month)
{
accountbalance accountToDelete = DbContext.accountbalances.Where(o => o.year == year && o.month == month).FirstOrDefault();
DbContext.Entry(accountToDelete).State = System.Data.Entity.EntityState.Deleted;
int result = DbContext.SaveChanges();
if (result != 0)
{
return("deleted successfully");
}
else
{
return("Error occured while deleting");
}
}
// View balance of a month
public AccountBalance ViewBalance(int year, int month)
{
// call viewBalance method
accountbalance accountBalance = _AccountBalanceRepo.ViewBalance(year, month);
// create object for BLL
AccountBalance accountBalanceResult = new AccountBalance();
// if balance record exists
if (accountBalance != null)
{
accountBalanceResult.year = accountBalance.year;
accountBalanceResult.month = accountBalance.month;
accountBalanceResult.rnd = (double)accountBalance.rnd;
accountBalanceResult.canteen = (double)accountBalance.canteen;
accountBalanceResult.ceocar = (double)accountBalance.ceocar;
accountBalanceResult.marketing = (double)accountBalance.marketing;
accountBalanceResult.parking = (double)accountBalance.parking;
if (accountBalance.uid != null)
{
accountBalanceResult.uid = (int)accountBalance.uid;
}
else
{
accountBalanceResult.uid = 0;
}
}
else
{
// if balances ara not in the db
accountBalanceResult.year = 0;
accountBalanceResult.month = 0;
accountBalanceResult.rnd = 0;
accountBalanceResult.canteen = 0;
accountBalanceResult.ceocar = 0;
accountBalanceResult.marketing = 0;
accountBalanceResult.parking = 0;
accountBalanceResult.uid = 0;
}
return(accountBalanceResult);
}
// method to view current balance account typewise
public double[] ViewCurrentBalance(string accountType)
{
double[] balance = new double[2];
// call repository method
accountbalance accountBalance = _AccountBalanceRepo.ViewCurrentBalance();
// if at least one record is in the db records in the database
if (accountBalance != null)
{
balance[0] = 0;
if (accountType == "rnd")
{
balance[1] = (double)accountBalance.rnd;
}
else if (accountType == "canteen")
{
balance[1] = (double)accountBalance.canteen;
}
else if (accountType == "ceocar")
{
balance[1] = (double)accountBalance.ceocar;
}
else if (accountType == "marketing")
{
balance[1] = (double)accountBalance.marketing;
}
else if (accountType == "parking")
{
balance[1] = (double)accountBalance.parking;
}
}
else
{
balance[0] = 1;
}
// return the result
return(balance);
}
// view balance of an account
public accountbalance ViewBalance(int year, int month)
{
accountbalance accountBalanceresult = DbContext.accountbalances.Where(o => o.year == year && o.month == month).FirstOrDefault();
return(accountBalanceresult);
}
public void ViewBalanceChart_Data_Available_In_DB()
{
int startYear = 2017;
int startMonth = 1;
int endYear = 2017;
int endMonth = 2;
List <accountbalance> resultDAL = new List <accountbalance>();
accountbalance resultDALValue1 = new accountbalance();
resultDALValue1.year = 2017;
resultDALValue1.month = 1;
resultDALValue1.rnd = 1200.36;
resultDALValue1.canteen = 4563.36;
resultDALValue1.ceocar = -635.89;
resultDALValue1.marketing = 1456.25;
resultDALValue1.parking = 788.26;
resultDAL.Add(resultDALValue1);
accountbalance resultDALValue2 = new accountbalance();
resultDALValue2.year = 2017;
resultDALValue2.month = 2;
resultDALValue2.rnd = 10000.00;
resultDALValue2.canteen = 150000.25;
resultDALValue2.ceocar = 2500.36;
resultDALValue2.marketing = 69354.25;
resultDALValue2.parking = 25369.25;
resultDAL.Add(resultDALValue2);
List <AccountBalance> expected = new List <AccountBalance>();
AccountBalance expectedValue1 = new AccountBalance();
expectedValue1.year = 2017;
expectedValue1.month = 1;
expectedValue1.rnd = 1200.36;
expectedValue1.canteen = 4563.36;
expectedValue1.ceocar = -635.89;
expectedValue1.marketing = 1456.25;
expectedValue1.parking = 788.26;
expected.Add(expectedValue1);
AccountBalance expectedValue2 = new AccountBalance();
expectedValue2.year = 2017;
expectedValue2.month = 2;
expectedValue2.rnd = 10000.00;
expectedValue2.canteen = 150000.25;
expectedValue2.ceocar = 2500.36;
expectedValue2.marketing = 69354.25;
expectedValue2.parking = 25369.25;
expected.Add(expectedValue2);
var mockAccountBalanceRepo = new Mock <IAccountBalanceRepo>();
mockAccountBalanceRepo.Setup(x => x.ViewBalanceChart(It.IsAny <int>(), It.IsAny <int>(), It.IsAny <int>(), It.IsAny <int>())).Returns(resultDAL);
AccountBalanceService accountBalanceService = new AccountBalanceService(mockAccountBalanceRepo.Object);
List <AccountBalance> actual = accountBalanceService.ViewBalanceChart(startYear, startMonth, endYear, endMonth);
for (int i = 0; i < actual.Count; i++)
{
AssertObjects.PropertyValuesAreEquals(expected[i], actual[i]);
}
}
