I need to decide on how to store online signed contracts for customers and
clients. I have considered a database in sql server 2005, but it seems to be
too complicated. Besides, if the contract contents or layout for new
contracts changes, I would have to change the whole database setup. Not to
mention that there would be a lot of repeated fields which could be a waste
of space. My next choice would be to keep the original unsigned blank (not
filled out) contract. in an xml file so it can be changed without bothering
all of the other contract copies. When some fills out and signs the
contract, it creates an xml file with the copy of the contract contents, the
filled out form and the fact that they had signed it. My only question is:
When I created the xsd file to define how the xml file output should look
like and ran it through xsd.exe, it created 18 nested objects. It also made
it to where there could be up to 60 objects created just for 1 filled
out/signed copy of this contract. Is there any possible way to do something
like this any better? If you need any examples of how this could be a
problem for me, I can give a few example situations below.
1. Definitions. Each word and it's definition for the contract dictionary
has to be an object. The contract has 12 dictionary entries, so that means
12 dictionary entries floating around loose. After this, they have to be
added to the dictionary. So, there are 24 dictionary entries created (2
copies of each entry).
2. Sections. Each divison of the contract is a "section". There are 21
different sections that need to be created as stand alone objects and then
added to the main Contract object (another 42 objects laying around).
3. Addresses. There are mulbiple addresses, but xsd.exe made it to where I
would need to create 6 address objects and then add them to the contract
object.
Anyways, is there any way to cut down on all of these loose objects sitting
around? Is there a different way besides xml/sql server that is secure that
I could look into for storing the contracts?
9  1356 
"Andy B" <a_*****@sbcglobal.netwrote in message
news:u0*************@TK2MSFTNGP05.phx.gbl...
Anyways, is there any way to cut down on all of these loose objects
sitting around? Is there a different way besides xml/sql server that is
secure that I could look into for storing the contracts?
You have a parent object and child objects that need to be saved. That's the
direction you should use is a database, like SQL Server. This could easily
be accomplished by making a database, creating the tables needed, and using
something like dotnet 3rd party integrated NHibernate tool to make the DAL
objects and plumbing for you based on the tables for you from the database.
What you need is tool that's going to make it easy for you.
So, that's good, but what happens if the contract changes? I wouldn't want
the new changes to affect an already signed/fulfilled contract. The changes
made to it would only be able to change contracts that havent been created
yet. Is there a way to do that?
"Mr. Arnold" <MR. Ar****@Arnold.comwrote in message
news:OK**************@TK2MSFTNGP04.phx.gbl...
>
"Andy B" <a_*****@sbcglobal.netwrote in message
news:u0*************@TK2MSFTNGP05.phx.gbl...
>Anyways, is there any way to cut down on all of these loose objects
sitting around? Is there a different way besides xml/sql server that is
secure that I could look into for storing the contracts?
You have a parent object and child objects that need to be saved. That's
the direction you should use is a database, like SQL Server. This could
easily be accomplished by making a database, creating the tables needed,
and using something like dotnet 3rd party integrated NHibernate tool to
make the DAL objects and plumbing for you based on the tables for you
from the database. What you need is tool that's going to make it easy for
you.
"Andy B" <a_*****@sbcglobal.netwrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...
So, that's good, but what happens if the contract changes? I wouldn't want
the new changes to affect an already signed/fulfilled contract. The
changes made to it would only be able to change contracts that havent been
created yet. Is there a way to do that?
Well if something changes something like a field taken away from a record or
added to a record, then you're going to have to regenerate the objects and
change code to accommodate the changes and recompile the solution. You may
also need to write a program to manipulate the data in the database to
reflect coding changes to the database. That's life in Information
Technology for a programmer, called maintinance.
>
"Mr. Arnold" <MR. Ar****@Arnold.comwrote in message
news:OK**************@TK2MSFTNGP04.phx.gbl...
>>
"Andy B" <a_*****@sbcglobal.netwrote in message
news:u0*************@TK2MSFTNGP05.phx.gbl...
>>Anyways, is there any way to cut down on all of these loose objects
sitting around? Is there a different way besides xml/sql server that is
secure that I could look into for storing the contracts?
You have a parent object and child objects that need to be saved. That's
the direction you should use is a database, like SQL Server. This could
easily be accomplished by making a database, creating the tables needed,
and using something like dotnet 3rd party integrated NHibernate tool to
make the DAL objects and plumbing for you based on the tables for you
from the database. What you need is tool that's going to make it easy for
you.
That's fine, but the contract changes have to be dynamically generated.
There will be a program module that will let an admin change the contract on
the fly and then have it take affect instantly the next time a blank
contract is generated. I have possibly a few ways to cut down on the clutter
of lots of objects setting around uselessly, but from what I can see, I will
never get away from the clutter of code to a point. I also thought about
creating sql databases and inserting the xml output of Xml.Serialize into an
xml dataType column. Will probably take a bit of research for me to do
though. Does this sound practicle?
"Mr. Arnold" <MR. Ar****@Arnold.comwrote in message
news:ex**************@TK2MSFTNGP03.phx.gbl...
>
"Andy B" <a_*****@sbcglobal.netwrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...
>So, that's good, but what happens if the contract changes? I wouldn't
want the new changes to affect an already signed/fulfilled contract. The
changes made to it would only be able to change contracts that havent
been created yet. Is there a way to do that?
Well if something changes something like a field taken away from a record
or added to a record, then you're going to have to regenerate the objects
and change code to accommodate the changes and recompile the solution. You
may also need to write a program to manipulate the data in the database to
reflect coding changes to the database. That's life in Information
Technology for a programmer, called maintinance.
>>
"Mr. Arnold" <MR. Ar****@Arnold.comwrote in message
news:OK**************@TK2MSFTNGP04.phx.gbl...
>>>
"Andy B" <a_*****@sbcglobal.netwrote in message
news:u0*************@TK2MSFTNGP05.phx.gbl...
Anyways, is there any way to cut down on all of these loose objects
sitting around? Is there a different way besides xml/sql server that is
secure that I could look into for storing the contracts?
You have a parent object and child objects that need to be saved. That's
the direction you should use is a database, like SQL Server. This could
easily be accomplished by making a database, creating the tables needed,
and using something like dotnet 3rd party integrated NHibernate tool to
make the DAL objects and plumbing for you based on the tables for you
from the database. What you need is tool that's going to make it easy
for you.
"Andy B" <a_*****@sbcglobal.netwrote in message
news:Of**************@TK2MSFTNGP05.phx.gbl...
That's fine, but the contract changes have to be dynamically generated.
There will be a program module that will let an admin change the contract
on the fly and then have it take affect instantly the next time a blank
contract is generated. I have possibly a few ways to cut down on the
clutter of lots of objects setting around uselessly, but from what I can
see, I will never get away from the clutter of code to a point. I also
thought about creating sql databases and inserting the xml output of
Xml.Serialize into an xml dataType column. Will probably take a bit of
research for me to do though. Does this sound practicle?
I can't tell you, because I have not worked with XML in this manner. I have
only worked with XML to a point of making objects and saving objects to a
database and retrieving them. I guess you're going to have to find the
proper solution.
I know I worked on some insurance policy applications that needed to be
compliant by state with the appropriate data dynamic data from the policy
holder on the form that wasn't XML long ago. But, it was text based data
shown on the form and received into the database, so it can be done.
"Mr. Arnold" <MR. Ar****@Arnold.comwrote in message
news:ex**************@TK2MSFTNGP03.phx.gbl...
>>
"Andy B" <a_*****@sbcglobal.netwrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...
>>So, that's good, but what happens if the contract changes? I wouldn't
want the new changes to affect an already signed/fulfilled contract. The
changes made to it would only be able to change contracts that havent
been created yet. Is there a way to do that?
Well if something changes something like a field taken away from a record
or added to a record, then you're going to have to regenerate the objects
and change code to accommodate the changes and recompile the solution.
You may also need to write a program to manipulate the data in the
database to reflect coding changes to the database. That's life in
Information Technology for a programmer, called maintinance.
>>>
"Mr. Arnold" <MR. Ar****@Arnold.comwrote in message
news:OK**************@TK2MSFTNGP04.phx.gbl...
"Andy B" <a_*****@sbcglobal.netwrote in message
news:u0*************@TK2MSFTNGP05.phx.gbl...
Anyways, is there any way to cut down on all of these loose objects
sitting around? Is there a different way besides xml/sql server that
is secure that I could look into for storing the contracts?
>
You have a parent object and child objects that need to be saved.
That's the direction you should use is a database, like SQL Server.
This could easily be accomplished by making a database, creating the
tables needed, and using something like dotnet 3rd party integrated
NHibernate tool to make the DAL objects and plumbing for you based on
the tables for you from the database. What you need is tool that's
going to make it easy for you.
I am certainly no lawyer but i would think you would need to keep all
versions of the contracts. Once a contract was signed i don't think
anyone can come along and edit it without getting it signed again. This
would mean to me that once a contract was signed it was frozen for that
customer and any changes made would only apply to new customers. This
would then imply you need some sort of version control on the contracts.
I know i certainly would not be happy if someone changed a contract I
had already reviewed with my lawyer and then signed.
Something to think about :)
Leon Lambert
Andy B wrote:
That's fine, but the contract changes have to be dynamically generated.
There will be a program module that will let an admin change the contract on
the fly and then have it take affect instantly the next time a blank
contract is generated. I have possibly a few ways to cut down on the clutter
of lots of objects setting around uselessly, but from what I can see, I will
never get away from the clutter of code to a point. I also thought about
creating sql databases and inserting the xml output of Xml.Serialize into an
xml dataType column. Will probably take a bit of research for me to do
though. Does this sound practicle?
"Mr. Arnold" <MR. Ar****@Arnold.comwrote in message
news:ex**************@TK2MSFTNGP03.phx.gbl...
>"Andy B" <a_*****@sbcglobal.netwrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...
>>So, that's good, but what happens if the contract changes? I wouldn't
want the new changes to affect an already signed/fulfilled contract. The
changes made to it would only be able to change contracts that havent
been created yet. Is there a way to do that?
Well if something changes something like a field taken away from a record
or added to a record, then you're going to have to regenerate the objects
and change code to accommodate the changes and recompile the solution. You
may also need to write a program to manipulate the data in the database to
reflect coding changes to the database. That's life in Information
Technology for a programmer, called maintinance.
>>>
"Mr. Arnold" <MR. Ar****@Arnold.comwrote in message
news:OK**************@TK2MSFTNGP04.phx.gbl...
"Andy B" <a_*****@sbcglobal.netwrote in message
news:u0*************@TK2MSFTNGP05.phx.gbl...
Anyways, is there any way to cut down on all of these loose objects
sitting around? Is there a different way besides xml/sql server that is
secure that I could look into for storing the contracts?
>
You have a parent object and child objects that need to be saved. That's
the direction you should use is a database, like SQL Server. This could
easily be accomplished by making a database, creating the tables needed,
and using something like dotnet 3rd party integrated NHibernate tool to
make the DAL objects and plumbing for you based on the tables for you
from the database. What you need is tool that's going to make it easy
for you.
I never planned on changing it after its been signed. The original question
was: What storage method would best be used if you wanted to change a blank
contract without affecting the ones already locked and frozen?
"Leon Lambert" <la******@inil.comwrote in message
news:ub**************@TK2MSFTNGP04.phx.gbl...
>I am certainly no lawyer but i would think you would need to keep all
versions of the contracts. Once a contract was signed i don't think anyone
can come along and edit it without getting it signed again. This would mean
to me that once a contract was signed it was frozen for that customer and
any changes made would only apply to new customers. This would then imply
you need some sort of version control on the contracts.
I know i certainly would not be happy if someone changed a contract I had
already reviewed with my lawyer and then signed.
Something to think about :)
Leon Lambert
Andy B wrote:
>That's fine, but the contract changes have to be dynamically generated.
There will be a program module that will let an admin change the contract
on the fly and then have it take affect instantly the next time a blank
contract is generated. I have possibly a few ways to cut down on the
clutter of lots of objects setting around uselessly, but from what I can
see, I will never get away from the clutter of code to a point. I also
thought about creating sql databases and inserting the xml output of
Xml.Serialize into an xml dataType column. Will probably take a bit of
research for me to do though. Does this sound practicle?
"Mr. Arnold" <MR. Ar****@Arnold.comwrote in message
news:ex**************@TK2MSFTNGP03.phx.gbl...
>>"Andy B" <a_*****@sbcglobal.netwrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl.. .
So, that's good, but what happens if the contract changes? I wouldn't
want the new changes to affect an already signed/fulfilled contract.
The changes made to it would only be able to change contracts that
havent been created yet. Is there a way to do that?
Well if something changes something like a field taken away from a
record or added to a record, then you're going to have to regenerate the
objects and change code to accommodate the changes and recompile the
solution. You may also need to write a program to manipulate the data in
the database to reflect coding changes to the database. That's life in
Information Technology for a programmer, called maintinance.
"Mr. Arnold" <MR. Ar****@Arnold.comwrote in message
news:OK**************@TK2MSFTNGP04.phx.gbl...
"Andy B" <a_*****@sbcglobal.netwrote in message
news:u0*************@TK2MSFTNGP05.phx.gbl...
>
>Anyways, is there any way to cut down on all of these loose objects
>sitting around? Is there a different way besides xml/sql server that
>is secure that I could look into for storing the contracts?
>>
You have a parent object and child objects that need to be saved.
That's the direction you should use is a database, like SQL Server.
This could easily be accomplished by making a database, creating the
tables needed, and using something like dotnet 3rd party integrated
NHibernate tool to make the DAL objects and plumbing for you based on
the tables for you from the database. What you need is tool that's
going to make it easy for you.
>
>
"Andy B" <a_*****@sbcglobal.netwrote in message
news:%2****************@TK2MSFTNGP05.phx.gbl...
>I never planned on changing it after its been signed. The original question
was: What storage method would best be used if you wanted to change a blank
contract without affecting the ones already locked and frozen?
The simple solution would be to scan in the signed contract and store the
scanned contract. Then you don't need to worry about changing the contract
by accident. You do still need a way to version contracts, but that would
be required even with paper storage (just slightly easier).
Mike.
Peter Morris wrote:
>1. Definitions. Each word and it's definition for the contract
dictionary has to be an object. The contract has 12 dictionary
entries, so that means 12 dictionary entries floating around loose.
After this, they have to be added to the dictionary. So, there are
24 dictionary entries created (2 copies of each entry).
Your business objects really have 1 object for each word? That's
overkill in my opinion, why would you do that? I can't see why you
would want to separatly declare the definitions either, those are
done inline within the section text.
For one thing, it would allow you to compare each definition against a table
of usual definitions and flag any that are unusual for detailed
consideration. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Steven Bethard |
last post by:
In the "empty classes as c structs?" thread, we've been talking in some
detail about my proposed "generic objects" PEP. Based on a number of
suggestions, I'm thinking more and more that instead of...
|
by: Bryan Parkoff |
last post by:
I have created three classes according to my own design. First class
is called CMain. It is the Top Class. Second class and third class are
called CMemory and CMPU. They are the sub-classes....
|
by: B0nj |
last post by:
I've got a class in which I want to implement a property
that operates like an indexer, for the various colors
associated with the class.
For instance, I want to be able to do 'set' operations...
|
by: scottrm |
last post by:
I am fairly new to oo design and I am looking at developing an object
oriented asp.net application which will be built on top of a relational
database. I have read quite a bit of the theory but...
|
by: D Witherspoon |
last post by:
I am developing a Windows Forms application in VB.NET that will use .NET
remoting to access the data tier classes.
A very simple way I have come up with is by creating typed (.xsd) datasets.
For...
|
by: news.microsoft.com |
last post by:
Hello,
I've got a design problem that I can't figure out. I need to override a
static method which happens to be referenced by methods inside nested
classes. In the sample below, in the call...
|
by: miked |
last post by:
I am architecting in a read only class for use in mapping data to a business
object. The object makes strong use of nested classes and their ability to
access protected fields. The downside is...
|
by: Jef Driesen |
last post by:
Suppose I have a datastructure (actually it's a graph) with one template
parameter (the property P for each edge and vertex):
struct graph<P>;
struct vertex<P>;
struct edge<P>;
I also have...
|
by: Doug |
last post by:
Hi,
I learned a little about the model view presenter pattern at a
conference this last week and am experimenting with it. It's working
pretty well but I have a question.
I am trying to use...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |
