/// <summary>
/// Deletes the account tranfer.
/// </summary>
/// <param name="accountTransfer">The account tranfer.</param>
/// <returns></returns>
public string DeleteAccountTransfer(AccountTransferEntity accountTransfer)
{
const string sql = @"uspDelete_AccountTransfer";
object[] parms = { "@AccountTransferID", accountTransfer.AccountTransferId };
return Db.Delete(sql, true, parms);
}
public List <AccountTransferEntity> GetAccountsTransfer(string connectionString)
{
List <AccountTransferEntity> listAccount = new List <AccountTransferEntity>();
using (var context = new MISAEntity(connectionString))
{
var categories = context.AccountTransfers.ToList();
foreach (var result in categories)
{
var accountTransfer = new AccountTransferEntity();
accountTransfer.AccountTransferId = result.AccountTransferID.ToString();
accountTransfer.BusinessType = (result.BusinessType == 4?2: result.BusinessType) ?? 0;
accountTransfer.AccountTransferCode = result.AccountTransferCode;
accountTransfer.ReferentAccount = result.ReferentAccount;
accountTransfer.TransferOrder = result.TransferOrder ?? 0;
accountTransfer.FromAccount = result.FromAccount;
accountTransfer.ToAccount = result.ToAccount;
accountTransfer.TransferSide = result.TransferSide ?? 0;
accountTransfer.BudgetSourceId = result.BudgetSourceID.ToString();
accountTransfer.Description = result.Description;
accountTransfer.IsSystem = result.IsSystem;
accountTransfer.IsActive = result.Inactive == true ? false:true;
listAccount.Add(accountTransfer);
}
}
return(listAccount);
}
/// <summary>
/// Inserts the account category.
/// </summary>
/// <param name="accountTransferEntity">The account transfer entity.</param>
/// <returns>
/// AccountCategoryResponse.
/// </returns>
public AccountTransferResponse InsertAccountTransfer(AccountTransferEntity accountTransferEntity)
{
var response = new AccountTransferResponse {
Acknowledge = AcknowledgeType.Success
};
try
{
if (!accountTransferEntity.Validate())
{
foreach (string error in accountTransferEntity.ValidationErrors)
{
response.Message += error + Environment.NewLine;
}
response.Acknowledge = AcknowledgeType.Failure;
return(response);
}
var accountTransfer = AccountTransferDao.GetAccountTransfersByAccountTransferCode(accountTransferEntity.AccountTransferCode.Trim());
if (accountTransfer != null)
{
if (accountTransfer.AccountTransferId != accountTransferEntity.AccountTransferId)
{
response.Acknowledge = AcknowledgeType.Failure;
response.Message = @"Mã tài khoản kết chuyển " + accountTransferEntity.AccountTransferCode.Trim() + @" đã tồn tại !";
return(response);
}
}
accountTransferEntity.AccountTransferId = Guid.NewGuid().ToString();
response.Message = AccountTransferDao.InsertAccountTransfer(accountTransferEntity);
if (!string.IsNullOrEmpty(response.Message))
{
response.Acknowledge = AcknowledgeType.Failure;
return(response);
}
response.AccountTransferId = accountTransferEntity.AccountTransferId;
return(response);
}
catch (Exception ex)
{
response.Message = ex.Message;
return(response);
}
}
/// <summary>
/// Takes the specified account tranfer.
/// </summary>
/// <param name="accountTransfer">The account tranfer.</param>
/// <param name="accountTransfer">The account tranfer.</param>
/// <returns></returns>
private static object[] Take(AccountTransferEntity accountTransfer)
{
return new object[]
{
"@AccountTransferID", accountTransfer.AccountTransferId,
"@AccountTransferCode", accountTransfer.AccountTransferCode,
"@BusinessType", accountTransfer.BusinessType,
"@ReferentAccount", accountTransfer.ReferentAccount,
"@TransferOrder", accountTransfer.TransferOrder,
"@FromAccount", accountTransfer.FromAccount,
"@ToAccount", accountTransfer.ToAccount,
"@TransferSide", accountTransfer.TransferSide,
"@BudgetSourceID", accountTransfer.BudgetSourceId,
"@Description", accountTransfer.Description,
"@IsSystem", accountTransfer.IsSystem,
"@IsActive", accountTransfer.IsActive
};
}
/// <summary>
/// Updates the account tranfer.
/// </summary>
/// <param name="accountTransfer">The account tranfer.</param>
/// <returns></returns>
public string UpdateAccountTransfer(AccountTransferEntity accountTransfer)
{
const string sql = "uspUpdate_AccountTransfer";
return Db.Update(sql, true, Take(accountTransfer));
}
/// <summary>
/// Inserts the account tranfer.
/// </summary>
/// <param name="accountTransfer">The account tranfer.</param>
/// <returns></returns>
public string InsertAccountTransfer(AccountTransferEntity accountTransfer)
{
const string sql = "uspInsert_AccountTransfer";
return Db.Insert(sql, true, Take(accountTransfer));
}
