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