/// <summary>
/// Deletes the budgetCategory.
/// </summary>
/// <param name="budgetCategory">The budgetCategory.</param>
/// <returns>System.String.</returns>
public string DeleteBudgetCategory(BudgetCategoryEntity budgetCategory)
{
const string sql = @"uspDelete_BudgetCategory";
object[] parms = { "@BudgetCategoryID", budgetCategory.BudgetCategoryId };
return(Db.Delete(sql, true, parms));
}
/// <summary>
/// Takes the specified budget category.
/// </summary>
/// <param name="budgetCategory">The budget category.</param>
/// <returns>System.Object[][].</returns>
private object[] Take(BudgetCategoryEntity budgetCategory)
{
return(new object[]
{
"@BudgetCategoryID", budgetCategory.BudgetCategoryId,
"@BudgetCategoryCode", budgetCategory.BudgetCategoryCode,
"@BudgetCategoryName", budgetCategory.BudgetCategoryName,
"@ParentID", budgetCategory.ParentId,
"@IsParent", budgetCategory.IsParent,
"@Description", budgetCategory.Description,
"@IsSystem", budgetCategory.IsSystem,
"@IsActive", budgetCategory.IsActive,
"@Grade", budgetCategory.Grade,
"@ForeignName", budgetCategory.ForeignName
});
}
public void RemoveCategory(BudgetCategoryEntity category)
{
_context.BudgetCategories.Remove(category);
}
public void AddCategory(BudgetCategoryEntity category)
{
_context.BudgetCategories.Add(category);
}
/// <summary>
/// Updates the budgetCategory.
/// </summary>
/// <param name="budgetCategory">The budgetCategory.</param>
/// <returns>System.String.</returns>
public string UpdateBudgetCategory(BudgetCategoryEntity budgetCategory)
{
const string sql = "uspUpdate_BudgetCategory";
return(Db.Update(sql, true, Take(budgetCategory)));
}
/// <summary>
/// Inserts the budgetCategory.
/// </summary>
/// <param name="budgetCategory">The budgetCategory.</param>
/// <returns>System.Int32.</returns>
public int InsertBudgetCategory(BudgetCategoryEntity budgetCategory)
{
const string sql = "uspInsert_BudgetCategory";
return(Db.Insert(sql, true, Take(budgetCategory)));
}
