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