/// <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))); }