/// <summary>
/// Deletes the account category.
/// </summary>
/// <param name="accountCategory">The account category.</param>
/// <returns>System.String.</returns>
public string DeleteAccountCategory(AccountCategoryEntity accountCategory)
{
const string sql = @"uspDelete_AccountCategory";
object[] parms = { "@AccountCategoryID", accountCategory.AccountCategoryId };
return(Db.Delete(sql, true, parms));
}
/// <summary>
/// Inserts the account category.
/// </summary>
/// <param name="accountCategoryEntity">The account category entity.</param>
/// <returns>AccountCategoryResponse.</returns>
public AccountCategoryResponse InsertAccountCategory(AccountCategoryEntity accountCategoryEntity)
{
var response = new AccountCategoryResponse {
Acknowledge = AcknowledgeType.Success
};
try
{
if (!accountCategoryEntity.Validate())
{
foreach (string error in accountCategoryEntity.ValidationErrors)
{
response.Message += error + Environment.NewLine;
}
response.Acknowledge = AcknowledgeType.Failure;
return(response);
}
accountCategoryEntity.AccountCategoryId = AccountCategoryDao.InsertAccountCategory(accountCategoryEntity);
if (!string.IsNullOrEmpty(response.Message))
{
response.Acknowledge = AcknowledgeType.Failure;
return(response);
}
response.AccountCategoryId = accountCategoryEntity.AccountCategoryId;
return(response);
}
catch (Exception ex)
{
response.Acknowledge = AcknowledgeType.Failure;
response.Message = ex.Message;
return(response);
}
}
/// <summary>
/// Takes the specified account categories.
/// </summary>
/// <param name="accountCategories">The account categories.</param>
/// <returns>System.Object[][].</returns>
private object[] Take(AccountCategoryEntity accountCategories)
{
return(new object[]
{
"@AccountCategoryId", accountCategories.AccountCategoryId,
"@AccountCategoryName", accountCategories.AccountCategoryName,
"@AccountCategoryKind", accountCategories.AccountCategoryKind,
"@DetailByBudgetSource", accountCategories.DetailByBudgetSource,
"@DetailByBudgetChapter", accountCategories.DetailByBudgetChapter,
"@DetailByBudgetKindItem", accountCategories.DetailByBudgetKindItem,
"@DetailByBudgetItem", accountCategories.DetailByBudgetItem,
"@DetailByBudgetSubItem", accountCategories.DetailByBudgetSubItem,
"@DetailByMethodDistribute", accountCategories.DetailByMethodDistribute,
"@DetailByAccountingObject", accountCategories.DetailByAccountingObject,
"@DetailByActivity", accountCategories.DetailByActivity,
"@DetailByProject", accountCategories.DetailByProject,
"@DetailByTask", accountCategories.DetailByTask,
"@DetailBySupply", accountCategories.DetailBySupply,
"@DetailByInventoryItem", accountCategories.DetailByInventoryItem,
"@DetailByFixedAsset", accountCategories.DetailByFixedAsset,
"@DetailByBankAccount", accountCategories.DetailByBankAccount,
"@DetailByFund", accountCategories.DetailByFund,
"@IsActive", accountCategories.IsActive
});
}
/// <summary>
/// Takes the specified account categories.
/// </summary>
/// <param name="accountCategories">The account categories.</param>
/// <returns>System.Object[][].</returns>
private object[] Take(AccountCategoryEntity accountCategories)
{
return(new object[]
{
"@AccountCategoryID", accountCategories.AccountCategoryId,
"@AccountCategoryCode", accountCategories.AccountCategoryCode,
"@AccountCategoryName", accountCategories.AccountCategoryName,
"@ForeignName", accountCategories.ForeignName,
"@ParentID", accountCategories.ParentId,
"@Grade", accountCategories.Grade,
"@IsDetail", accountCategories.IsDetail,
"@IsActive", accountCategories.IsActive
});
}
public List <AccountCategoryEntity> GetAccountsCategory(string connectionString)
{
List <AccountCategoryEntity> listAccount = new List <AccountCategoryEntity>();
using (var context = new MISAEntity(connectionString))
{
var categories = context.AccountCategories.ToList();
foreach (var result in categories)
{
var accountCategory = new AccountCategoryEntity();
accountCategory.AccountCategoryId = result.AccountCategoryID;
accountCategory.AccountCategoryKind = result.AccountCategoryKind ?? 0;
accountCategory.DetailByBudgetSource = result.DetailByBudgetSource;
accountCategory.DetailByBudgetChapter = result.DetailByBudgetChapter;
accountCategory.DetailByBudgetKindItem = result.DetailByBudgetKindItem;
accountCategory.DetailByBudgetItem = result.DetailByBudgetItem;
accountCategory.DetailByBudgetSubItem = result.DetailByBudgetSubItem;
accountCategory.DetailByMethodDistribute = result.DetailByMethodDistribute;
accountCategory.DetailByAccountingObject = result.DetailByAccountingObject;
accountCategory.DetailByActivity = result.DetailByActivity;
accountCategory.DetailByProject = result.DetailByProject;
accountCategory.DetailByTask = result.DetailByTask;
accountCategory.DetailBySupply = result.DetailBySupply;
accountCategory.DetailByInventoryItem = result.DetailByInventoryItem;
accountCategory.DetailByFixedAsset = result.DetailByFixedAsset;
accountCategory.DetailByFund = result.DetailByFund;
accountCategory.DetailByBankAccount = result.DetailByBankAccount;
accountCategory.IsActive = result.Inactive == true ? false:true;
accountCategory.AccountCategoryName = result.AccountCategoryName;
listAccount.Add(accountCategory);
}
}
return(listAccount);
}
/// <summary>
/// Updates the account category.
/// </summary>
/// <param name="accountCategory">The account category.</param>
/// <returns>System.String.</returns>
public string UpdateAccountCategory(AccountCategoryEntity accountCategory)
{
const string sql = "uspUpdate_AccountCategory";
return(Db.Update(sql, true, Take(accountCategory)));
}
/// <summary>
/// Inserts the account category.
/// </summary>
/// <param name="accountCategory">The account category.</param>
/// <returns>System.Int32.</returns>
public int InsertAccountCategory(AccountCategoryEntity accountCategory)
{
const string sql = "uspInsert_AccountCategory";
return(Db.Insert(sql, true, Take(accountCategory)));
}
