/// <summary> /// Deletes the account tranfer. /// </summary> /// <param name="accountTranfer">The account tranfer.</param> /// <returns></returns> public string DeleteAccountTranfer(AccountTranferEntity accountTranfer) { const string sql = @"uspDelete_AccountTranfer"; object[] parms = { "@AccountTranferID", accountTranfer.AccountTranferId }; return(Db.Delete(sql, true, parms)); }
/// <summary> /// Takes the specified account tranfer. /// </summary> /// <param name="accountTranfer">The account tranfer.</param> /// <returns></returns> private static object[] Take(AccountTranferEntity accountTranfer) { return(new object[] { "@AccountTranferID", accountTranfer.AccountTranferId, "@AccountTranferCode", accountTranfer.AccountTranferCode, "@SortOrder", accountTranfer.SortOrder, "@AccountSourceCode", accountTranfer.AccountSourceCode, "@AccountDestinationCode", accountTranfer.AccountDestinationCode, "@ReferentAccount", accountTranfer.ReferentAccount, "@BudgetSourceId", accountTranfer.BudgetSourceId, "@SideOfTranfer", accountTranfer.SideOfTranfer, "@Type", accountTranfer.Type, "@IsActive", accountTranfer.IsActive, "@Description", accountTranfer.Description }); }
internal static AccountTranferModel FromDataTransferObject(AccountTranferEntity entity) { return(entity == null ? null : AutoMapper.Mapper.Map <AccountTranferEntity, AccountTranferModel>(entity)); }
/// <summary> /// Updates the account tranfer. /// </summary> /// <param name="accountTranfer">The account tranfer.</param> /// <returns></returns> public string UpdateAccountTranfer(AccountTranferEntity accountTranfer) { const string sql = "uspUpdate_AccountTranfer"; return(Db.Update(sql, true, Take(accountTranfer))); }
/// <summary> /// Inserts the account tranfer. /// </summary> /// <param name="accountTranfer">The account tranfer.</param> /// <returns></returns> public int InsertAccountTranfer(AccountTranferEntity accountTranfer) { const string sql = "uspInsert_AccountTranfer"; return(Db.Insert(sql, true, Take(accountTranfer))); }