public void SaveAccountDetails(AccountModel accountModelDetails) { AccountRepository accountRepository = new AccountRepository(); AccountDTO accountEntity = new AccountDTO(); AutoMapper.Mapper.Map(accountModelDetails, accountEntity); accountRepository.SaveAccountDetails(accountEntity); }
private AccountDTO PopulateAccountDetails(IDataRecord dataRecord) { AccountDTO accountDetails = new AccountDTO(); accountDetails.Id = Convert.ToInt32(dataRecord["Id"]); accountDetails.CustomerId = Convert.ToInt32(dataRecord["CustomerId"]); accountDetails.CustomerName = Convert.ToString(dataRecord["CustomerName"]); accountDetails.BrokAmount = Convert.ToInt32(dataRecord["BrokAmount"]); accountDetails.TransAmount = Convert.ToInt32(dataRecord["TransAmount"]); accountDetails.Interest = Convert.ToInt32(dataRecord["Interest"]); accountDetails.GainLost = Convert.ToInt32(dataRecord["GainLost"]); accountDetails.Balance = Convert.ToInt32(dataRecord["Balance"]); return accountDetails; }
public void SaveAccountDetails(AccountDTO accountEntity) { SqlParameter[] _sqlParams = new SqlParameter[] { new SqlParameter("@AccountId", accountEntity.Id), new SqlParameter("@CustomerId", accountEntity.CustomerId), new SqlParameter("@BrokAmount", accountEntity.BrokAmount), new SqlParameter("@TransAmount", accountEntity.TransAmount), new SqlParameter("@Interest", accountEntity.Interest), new SqlParameter("@GainLost", accountEntity.GainLost), new SqlParameter("@Balance", accountEntity.Balance) }; SqlHelper.ExecuteNonQuery(ConnectionClass.OpenConnection(), CommandType.StoredProcedure, AppConstants.SAVEORUPDATEACCOUNTS, _sqlParams); }