/// <summary>
/// Deletes the receipt voucher.
/// </summary>
/// <param name="receiptVoucher">The receipt voucher.</param>
/// <returns></returns>
public string DeleteReceiptVoucher(ReceiptVoucherEntity receiptVoucher)
{
const string sql = @"uspDelete_ReceiptVoucher";
object[] parms = { "@ReceiptVoucherID", receiptVoucher.ReceiptVoucherID };
return(Db.Delete(sql, true, parms));
}
/// <summary>
/// Takes the specified receipt voucher.
/// </summary>
/// <param name="receiptVoucher">The receipt voucher.</param>
/// <returns></returns>
private object[] Take(ReceiptVoucherEntity receiptVoucher)
{
return(new object[]
{
"@ReceiptVoucherID", receiptVoucher.ReceiptVoucherID,
"@Code", receiptVoucher.Code,
"@RefDate", receiptVoucher.RefDate,
"@CreateBy", receiptVoucher.CreateBy,
"@Description", receiptVoucher.Description,
"@TotalAmount", receiptVoucher.TotalAmount
});
}
/// <summary>
/// Updates the receipt voucher.
/// </summary>
/// <param name="receiptVoucher">The receipt voucher.</param>
/// <returns></returns>
public string UpdateReceiptVoucher(ReceiptVoucherEntity receiptVoucher)
{
const string sql = @"uspUpdate_ReceiptVoucher";
return(Db.Update(sql, true, Take(receiptVoucher)));
}
/// <summary>
/// Inserts the receipt voucher.
/// </summary>
/// <param name="receiptVoucher">The receipt voucher.</param>
/// <returns></returns>
public int InsertReceiptVoucher(ReceiptVoucherEntity receiptVoucher)
{
const string sql = @"uspInsert_ReceiptVoucher";
return(Db.Insert(sql, true, Take(receiptVoucher)));
}
