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