public static int DeleteLastVoucherInformation(tLastVoucherInformation lastVoucher) { int rowsAdded; var query = "DELETE FROM tLastVoucherInformation"; using (IDbConnection connection = DbConnectionHelper.GetConnection()) { rowsAdded = connection.Execute(query, lastVoucher); } return(rowsAdded); }
public static int AddLastVoucherInformation(tLastVoucherInformation lastVoucher) { int rowsAdded; using (IDbConnection connection = DbConnectionHelper.GetConnection()) { var query = SqlQueryHelper.GetInsertQuery <tLastVoucherInformation>(); rowsAdded = connection.Execute(query, lastVoucher); } return(rowsAdded); }