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