/// <summary> /// Deletes the budget source property. /// </summary> /// <param name="budgetSourceproperty">The budget sourceproperty.</param> public string DeleteBudgetSourceProperty(BudgetSourcePropertyEntity budgetSourceproperty) { const string sql = @"Delete_BudgetSourceProperty"; object[] parms = { "@BudgetSourcePropertyID", budgetSourceproperty.BudgetSourcePropertyID }; return(Db.Delete(sql, true, parms)); }
/// <summary> /// Takes the specified budget source property. /// </summary> /// <param name="budgetSourceProperty">The budget source property.</param> /// <returns></returns> private object[] Take(BudgetSourcePropertyEntity budgetSourceProperty) { return(new object[] { "@BudgetSourcePropertyID", budgetSourceProperty.BudgetSourcePropertyID, "@Code", budgetSourceProperty.BudgetSourcePropertyCode, "@Name", budgetSourceProperty.BudgetSourcePropertyName, "@Description", budgetSourceProperty.Description, "@IsSystem", budgetSourceProperty.IsSystem, "@IsActive", budgetSourceProperty.IsActive }); }
/// <summary> /// Updates the budget source property. /// </summary> /// <param name="budgetSourceproperty">The budget sourceproperty.</param> public string UpdateBudgetSourceProperty(BudgetSourcePropertyEntity budgetSourceproperty) { const string sql = "Update_BudgetSourceProperty"; return(Db.Update(sql, true, Take(budgetSourceproperty))); }
/// <summary> /// Inserts the budget source property. /// </summary> /// <param name="budgetSourceproperty">The budget sourceproperty.</param> public int InsertBudgetSourceProperty(BudgetSourcePropertyEntity budgetSourceproperty) { const string sql = "Insert_BudgetSourceProperty"; return(Db.Insert(sql, true, Take(budgetSourceproperty))); }