/// <summary>
/// Takes the specified account balance.
/// </summary>
/// <param name="accountBalance">The account balance.</param>
/// <returns></returns>
private static object[] Take(AccountBalanceEntity accountBalance)
{
return(new object[]
{
@"AccountBalanceID", accountBalance.AccountBalanceId,
@"AccountNumber", accountBalance.AccountNumber,
@"CurrencyCode", accountBalance.CurrencyCode,
@"ExchangeRate", accountBalance.ExchangeRate,
@"BalanceDate", accountBalance.BalanceDate,
@"MovementDebitAmountOC", accountBalance.MovementDebitAmountOC,
@"MovementDebitAmount", accountBalance.MovementDebitAmount,
@"MovementCreditAmountOC", accountBalance.MovementCreditAmountOC,
@"MovementCreditAmount", accountBalance.MovementCreditAmount,
@"BudgetSourceID", accountBalance.BudgetSourceId,
@"BudgetChapterCode", accountBalance.BudgetChapterCode,
@"BudgetKindItemCode", accountBalance.BudgetKindItemCode,
@"BudgetSubKindItemCode", accountBalance.BudgetSubKindItemCode,
@"BudgetItemCode", accountBalance.BudgetItemCode,
@"BudgetSubItemCode", accountBalance.BudgetSubItemCode,
@"BudgetDetailItemCode", accountBalance.BudgetDetailItemCode,
@"MethodDistributeID", accountBalance.MethodDistributeId,
@"AccountingObjectID", accountBalance.AccountingObjectId,
@"ActivityID", accountBalance.ActivityId,
@"ProjectID", accountBalance.ProjectId,
@"ProjectActivityID", accountBalance.ProjectActivityId,
@"ProjectExpenseID", accountBalance.ProjectExpenseId,
@"FundID", accountBalance.FundId,
@"TaskID", accountBalance.TaskId,
@"BankAccount", accountBalance.BankAccount,
@"FundStructureID", accountBalance.FundStructureId
});
}
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;
AccountBalanceEntity expected = new AccountBalanceEntity();
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);
AccountBalanceEntity actual = accountBalanceService.ViewBalance(2016, 1);
AssertObjects.PropertyValuesAreEquals(actual, expected);
}
public ActionResult Index()
{
var isAdmin = false;
var balanceEntity = new AccountBalanceEntity();
balanceEntity.NewAccountConsumeBalance = "0.00";
balanceEntity.NewAccountTotalBalance = "0.00";
if (base.UserInfo != null)
{
ViewBag.CompanyName = base.UserInfo.CompanyName;
ViewBag.BussinID = base.UserInfo.BusinessID;
//判断是不是管理员账号
if (base.UserInfo.UserName == AdminAccount.Split('|')[0])
{
isAdmin = true;
return(Redirect("/UserManage/Index"));
}
//balanceEntity = balanceLogic.QueryBalanceByUserId(new Model.AccountBalanceEntity { BusinessId = base.UserInfo.BusinessID, UserName = base.UserInfo.UserName });
}
if (balanceEntity == null)
{
balanceEntity = new AccountBalanceEntity();
balanceEntity.NewAccountConsumeBalance = "0.00";
balanceEntity.NewAccountTotalBalance = "0.00";
}
ViewBag.IsAdmin = isAdmin;
return(View(balanceEntity));
}
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;
AccountBalanceEntity accountBalanceBAL = new AccountBalanceEntity();
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);
}
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;
AccountBalanceEntity accountBalanceBAL = new AccountBalanceEntity();
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);
}
/// <summary>
/// Gets the exits account balance.
/// </summary>
/// <param name="accountBalance">The account balance.</param>
/// <returns></returns>
public AccountBalanceEntity GetExitsAccountBalance(AccountBalanceEntity accountBalance)
{
const string sql = @"uspCheckExist_AccountBalance";
object[] parms = { "@AccountNumber", accountBalance.AccountNumber,
"@BalanceDate", accountBalance.BalanceDate,
"@CurrencyCode", accountBalance.CurrencyCode,
"@BudgetSourceID", accountBalance.BudgetSourceId,
"@BudgetChapterCode", accountBalance.BudgetChapterCode,
"@BudgetKindItemCode", accountBalance.BudgetKindItemCode,
"@BudgetSubKindItemCode", accountBalance.BudgetSubKindItemCode,
"@BudgetItemCode", accountBalance.BudgetItemCode,
"@BudgetSubItemCode", accountBalance.BudgetSubItemCode,
"@MethodDistributeID", accountBalance.MethodDistributeId,
"@AccountingObjectID", accountBalance.AccountingObjectId,
"@ActivityID", accountBalance.ActivityId,
"@ProjectID", accountBalance.ProjectId,
"@ProjectActivityID", accountBalance.ProjectActivityId,
"@ProjectExpenseID", accountBalance.ProjectExpenseId,
"@FundID", accountBalance.FundId,
"@TaskID", accountBalance.TaskId,
"@BankID", accountBalance.BankAccount };
return(Db.Read(sql, true, Make, parms));
}
/// <summary>
/// Deletes the account balance.
/// </summary>
/// <param name="accountBalance">The journal entry account.</param>
/// <returns></returns>
public string DeleteAccountBalance(AccountBalanceEntity accountBalance)
{
const string sql = @"uspDelete_AccountBalance";
object[] parms = { "@AccountBalanceID", accountBalance.AccountBalanceId };
return(Db.Delete(sql, true, parms));
}
/// <summary>
/// Takes the specified account balance.
/// </summary>
/// <param name="accountBalance">The account balance.</param>
/// <returns></returns>
private static object[] Take(AccountBalanceEntity accountBalance)
{
return(new object[]
{
@"AccountBalanceID", accountBalance.AccountBalanceId,
@"BalanceDate", accountBalance.BalanceDate,
@"CurrencyCode", accountBalance.CurrencyCode,
@"ExchangeRate", accountBalance.ExchangeRate,
@"AccountNumber", accountBalance.AccountNumber,
@"MovementCreditAmountExchange", accountBalance.MovementCreditAmountExchange,
@"MovementCreditAmountOC", accountBalance.MovementCreditAmountOC,
@"MovementDebitAmountExchange", accountBalance.MovementDebitAmountExchange,
@"MovementDebitAmountOC", accountBalance.MovementDebitAmountOC,
@"BudgetChapterCode", accountBalance.BudgetChapterCode,
@"BudgetCategoryCode", accountBalance.BudgetCategoryCode,
@"BudgetSourceCode", accountBalance.BudgetSourceCode,
@"BudgetItemCode", accountBalance.BudgetItemCode,
@"CustomerID", accountBalance.CustomerId,
@"VendorID", accountBalance.VendorId,
@"EmployeeID", accountBalance.EmployeeId,
@"AccountingObjectID", accountBalance.AccountingObjectId,
@"MergerFundID", accountBalance.MergerFundId,
@"BankID", accountBalance.BankId,
@"ProjectID", accountBalance.ProjectId,
@"InventoryItemID", accountBalance.InventoryItemId
});
}
// upload balance
public string UploadBalance(AccountBalanceEntity 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
AccountBalanceEntity existingRecord = ViewBalance(accountBalance.year, accountBalance.month);
// if balances exsists
if (existingRecord.year != 0)
{
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);
}
// view balances of a time period
public List <AccountBalanceEntity> ViewBalanceChart(int startYear, int startMonth, int endYear, int endMonth)
{
// call repository method
List <AccountBalance> resultList = _AccountBalanceRepo.ViewBalanceChart(startYear, startMonth, endYear, endMonth); // reuslt from the DB
// create list for BLL
List <AccountBalanceEntity> result = new List <AccountBalanceEntity>();
// convert DAL objects into BLL objects
if (resultList != null)
{
foreach (AccountBalance accountBalance in resultList)
{
AccountBalanceEntity accountBalaceBAL = new AccountBalanceEntity();
accountBalaceBAL.year = accountBalance.year;
accountBalaceBAL.month = accountBalance.month;
accountBalaceBAL.rnd = (double)accountBalance.rnd;
accountBalaceBAL.canteen = (double)accountBalance.canteen;
accountBalaceBAL.ceocar = (double)accountBalance.ceocar;
accountBalaceBAL.marketing = (double)accountBalance.marketing;
accountBalaceBAL.parking = (double)accountBalance.parking;
if (accountBalance.uid != null)
{
accountBalaceBAL.uid = (int)accountBalance.uid;
}
result.Add(accountBalaceBAL);
}
}
// return list of BLL objects
return(result);
}
public AccountBalanceEntity QueryBalanceByUserId(AccountBalanceEntity request)
{
string sql = " select [Id],[UserId],[UserName],[BusinessId],[AccountTotalBalance],[AccountConsumeBalance],[NewAccountTotalBalance],[NewAccountConsumeBalance],[CreateTime],FinanceTotalBanalceAmount,NewFinanceTotalBanalceAmount from [dbo].[tblAccountBalance] where BusinessId = @BusinessId and UserName = @UserName ";
using (IDbConnection conn = new SqlConnection(DBConnectionStringConfig.Default.JMGGConnectionString))
{
return(conn.Query <AccountBalanceEntity>(sql, request).FirstOrDefault());
}
}
/// <summary>
/// Takes the specified account balance.
/// </summary>
/// <param name="accountBalance">The account balance.</param>
/// <returns></returns>
private static object[] TakeUpdate(AccountBalanceEntity accountBalance)
{
return(new object[]
{
@"AccountBalanceID", accountBalance.AccountBalanceId,
@"AccountNumber", accountBalance.AccountNumber,
@"CurrencyCode", accountBalance.CurrencyCode,
@"ExchangeRate", accountBalance.ExchangeRate,
@"MovementDebitAmountOC", accountBalance.MovementDebitAmountOC,
@"MovementDebitAmount", accountBalance.MovementDebitAmount,
@"MovementCreditAmountOC", accountBalance.MovementCreditAmountOC,
@"MovementCreditAmount", accountBalance.MovementCreditAmount
});
}
protected override void Seed(DatabaseContext context)
{
base.Seed(context);
AccountBalanceEntity accountBalance = new AccountBalanceEntity
{
rAndD = 5.63,
canteen = 50000,
ceoCar = 10000,
marketing = -600,
parkingFines = 2000
};
context.accountBalances.Add(accountBalance);
context.SaveChanges();
}
/// <summary>
/// Updates the account balance.
/// </summary>
/// <param name="accountBalanceEntity">The account balance entity.</param>
/// <param name="movementAmount">The movement amount.</param>
/// <param name="movementAmountExchange">The movement amount exchange.</param>
/// <param name="isMovementAmount">if set to <c>true</c> [is movement amount].</param>
/// <param name="balanceSide">The balance side.</param>
/// <returns></returns>
public string UpdateAccountBalance(AccountBalanceEntity accountBalanceEntity, decimal movementAmount, decimal movementAmountExchange,
bool isMovementAmount, int balanceSide)
{
string message;
// cập nhật bên TK nợ
if (balanceSide == 1)
{
accountBalanceEntity.ExchangeRate = accountBalanceEntity.ExchangeRate;
if (isMovementAmount)
{
accountBalanceEntity.MovementDebitAmountExchange = accountBalanceEntity.MovementDebitAmountExchange + movementAmountExchange;
accountBalanceEntity.MovementDebitAmountOC = accountBalanceEntity.MovementDebitAmountOC + movementAmount;
}
else
{
accountBalanceEntity.MovementDebitAmountExchange = accountBalanceEntity.MovementDebitAmountExchange - movementAmountExchange;
accountBalanceEntity.MovementDebitAmountOC = accountBalanceEntity.MovementDebitAmountOC - movementAmount;
}
message = AccountBalanceDao.UpdateAccountBalance(accountBalanceEntity);
if (message != null)
{
return(message);
}
}
else
{
accountBalanceEntity.ExchangeRate = accountBalanceEntity.ExchangeRate;
if (isMovementAmount)
{
accountBalanceEntity.MovementCreditAmountExchange = accountBalanceEntity.MovementCreditAmountExchange + movementAmountExchange;
accountBalanceEntity.MovementCreditAmountOC = accountBalanceEntity.MovementCreditAmountOC + movementAmount;
}
else
{
accountBalanceEntity.MovementCreditAmountExchange = accountBalanceEntity.MovementCreditAmountExchange - movementAmountExchange;
accountBalanceEntity.MovementCreditAmountOC = accountBalanceEntity.MovementCreditAmountOC - movementAmount;
}
message = AccountBalanceDao.UpdateAccountBalance(accountBalanceEntity);
if (message != null)
{
return(message);
}
}
return(null);
}
// View balance of a month
public AccountBalanceEntity ViewBalance(int year, int month)
{
// call viewBalance method
AccountBalance accountBalance = _AccountBalanceRepo.ViewBalance(year, month);
// create object for BLL
AccountBalanceEntity accountBalanceResult = new AccountBalanceEntity();
// 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);
}
/// <summary>
/// Gets the exits account balance.
/// </summary>
/// <param name="accountBalance">The account balance.</param>
/// <returns></returns>
public AccountBalanceEntity GetExitsAccountBalance(AccountBalanceEntity accountBalance)
{
const string sql = @"uspGet_Exist_AccountBalance";
object[] parms = { "@BalanceDate", accountBalance.BalanceDate,
"@CurrencyCode", accountBalance.CurrencyCode,
"@AccountNumber", accountBalance.AccountNumber,
"@BudgetChapterCode", accountBalance.BudgetChapterCode,
"@BudgetCategoryCode", accountBalance.BudgetCategoryCode,
"@BudgetSourceCode", accountBalance.BudgetSourceCode,
"@BudgetItemCode", accountBalance.BudgetItemCode,
"@MergerFundID", accountBalance.MergerFundId,
"@BankID", accountBalance.BankId,
"@ProjectID", accountBalance.ProjectId,
"@VendorId", accountBalance.VendorId,
"@AccountingObjectID", accountBalance.AccountingObjectId,
"@CustomerID", accountBalance.CustomerId,
"@InventoryItemID", accountBalance.InventoryItemId };
return(Db.Read(sql, true, Make, parms));
}
public void ViewBalance_Balance_Not_Exists_In_Db()
{
AccountBalanceEntity expected = new AccountBalanceEntity();
expected.year = 0;
expected.month = 0;
expected.rnd = 0;
expected.canteen = 0;
expected.ceocar = 0;
expected.marketing = 0;
expected.parking = 0;
var mockAccountBalanceRepo = new Mock <IAccountBalanceRepo>();
mockAccountBalanceRepo.Setup(x => x.ViewBalance(It.IsAny <int>(), It.IsAny <int>())).Returns((AccountBalance)null);
AccountBalanceService accountBalanceService = new AccountBalanceService(mockAccountBalanceRepo.Object);
AccountBalanceEntity actual = accountBalanceService.ViewBalance(2016, 1);
AssertObjects.PropertyValuesAreEquals(actual, expected);
}
/// <summary>
/// Updates the account balance.
/// </summary>
/// <param name="accountBalance">The journal entry account.</param>
/// <returns></returns>
public string UpdateAccountBalance(AccountBalanceEntity accountBalance)
{
const string sql = @"uspUpdate_AccountBalance";
return(Db.Update(sql, true, Take(accountBalance)));
}
/// <summary>
/// Inserts the account balance.
/// </summary>
/// <param name="accountBalance">The account balance.</param>
/// <returns></returns>
public int InsertAccountBalance(AccountBalanceEntity accountBalance)
{
const string sql = @"uspInsert_AccountBalance";
return(Db.Insert(sql, true, Take(accountBalance)));
}
public string UploadBalance(UserRequest userRequest)
{
// array of moths to get index of the month
string[] months = { "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December" };
string result = "";
// content of the file
string fileContent = userRequest.fileContent;
// year of the uploaded fbalance file
int year = userRequest.year;
char delimiterNewLine = '\n';
char delimiterTab = '\t';
List <string[]> tabSeperated = new List <string[]>();
double[] balances = new double[5];
// seperate the file content line by line
string[] lineSeperated = fileContent.Split(delimiterNewLine);
for (int i = 0; i < 6; i++)
{
// seperate the line seperated content by tab
string[] splitted = lineSeperated[i].Split(delimiterTab);
tabSeperated.Add(splitted);
}
// get the month from the file content
string[] tabSeperatedArrayForMonth = tabSeperated[0];
string month = tabSeperatedArrayForMonth[tabSeperatedArrayForMonth.Length - 1].Replace("\r", "");
int monthIndex = 0;
// get the month index from the months array
for (int i = 0; i < 12; i++)
{
if (months[i].Equals(month))
{
monthIndex = i + 1;
}
}
// if valid month index is not found
if (monthIndex == 0)
{
result = "The month in the file is incorrect.Please check again";
}
else
{
//if month is valid
for (int i = 1; i < 6; i++)
{
string[] tabSeperatedArray = tabSeperated[i];
//get the balance from tab seperated content and replace commas in the balances
string balance = tabSeperatedArray[tabSeperatedArray.Length - 1].Replace(",", "");
double balanceDouble;
try
{
// convert to double values and put to balances array
balanceDouble = Convert.ToDouble(balance);
balances[i - 1] = balanceDouble;
}
catch (FormatException)
{
// if balance amounts ara incorrect
result = "Balance amounts are incorrect.Please check again.";
}
catch (OverflowException)
{
result = "Balance amounts are incorrect.Please check again.";
}
}
//Created object for BLL
AccountBalanceEntity accountBalance = new AccountBalanceEntity();
accountBalance.year = year;
accountBalance.month = monthIndex;
accountBalance.rnd = balances[0];
accountBalance.canteen = balances[1];
accountBalance.ceocar = balances[2];
accountBalance.marketing = balances[3];
accountBalance.parking = balances[4];
accountBalance.uid = 1;
//call method in BLL
result = _AccountBalanceService.UploadBalance(accountBalance);
}
return(result);
}
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 <AccountBalanceEntity> expected = new List <AccountBalanceEntity>();
AccountBalanceEntity expectedValue1 = new AccountBalanceEntity();
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);
AccountBalanceEntity expectedValue2 = new AccountBalanceEntity();
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 <AccountBalanceEntity> actual = accountBalanceService.ViewBalanceChart(startYear, startMonth, endYear, endMonth);
for (int i = 0; i < actual.Count; i++)
{
AssertObjects.PropertyValuesAreEquals(expected[i], actual[i]);
}
}
public AccountBalanceEntity QueryBalanceByUserId(AccountBalanceEntity request)
{
return(query.QueryBalanceByUserId(request));
}
/// <summary>
/// Updates the account balance for existed.
/// </summary>
/// <param name="accountBalance">The account balance.</param>
/// <returns></returns>
public string UpdateAccountBalanceForExisted(AccountBalanceEntity accountBalance)
{
const string sql = @"uspUpdate_AccountBalance_ForExisted";
return(Db.Update(sql, true, TakeUpdate(accountBalance)));
}
