/// <summary>
/// Deletes the payItem.
/// </summary>
/// <param name="payItem">The payItem.</param>
/// <returns></returns>
public string DeletePayItem(PayItemEntity payItem)
{
const string sql = @"uspDelete_PayItem";
object[] parms = { "@PayItemID", payItem.PayItemId };
return(Db.Delete(sql, true, parms));
}
/// <summary>
/// Takes the specified pay item.
/// </summary>
/// <param name="payItem">The pay item.</param>
/// <returns></returns>
private static object[] Take(PayItemEntity payItem)
{
return(new object[]
{
"@PayItemID", payItem.PayItemId,
"@PayItemCode", payItem.PayItemCode,
"@PayItemName", payItem.PayItemName,
"@Type", payItem.Type,
"@IsCalculateRatio", payItem.IsCalculateRatio,
"@IsSocialInsurance", payItem.IsSocialInsurance,
"@IsCareInsurance", payItem.IsCareInsurance,
"@IsTradeUnionFee", payItem.IsTradeUnionFee,
"@Description", payItem.Description,
"@DebitAccountCode", payItem.DebitAccountCode,
"@CreditAccountCode", payItem.CreditAccountCode,
"@BudgetChapterCode", payItem.BudgetChapterCode,
"@IsDefault", payItem.IsDefault,
"@IsActive", payItem.IsActive,
"@BudgetSourceCode", payItem.BudgetSourceCode,
"@BudgetCategoryCode", payItem.BudgetCategoryCode,
"@BudgetGroupCode", payItem.BudgetGroupCode,
"@BudgetItemCode", payItem.BudgetItemCode
});
}
/// <summary>
/// Updates the payItem.
/// </summary>
/// <param name="payItem">The payItem.</param>
/// <returns></returns>
public string UpdatePayItem(PayItemEntity payItem)
{
const string sql = @"uspUpdate_PayItem";
return(Db.Update(sql, true, Take(payItem)));
}
/// <summary>
/// Inserts the payItem.
/// </summary>
/// <param name="payItem">The payItem.</param>
/// <returns></returns>
public int InsertPayItem(PayItemEntity payItem)
{
const string sql = @"uspInsert_PayItem";
return(Db.Insert(sql, true, Take(payItem)));
}
