public void Update(long ID, long?ID_WS, string Name, string Description, string XMLSchema, string Purpose, DateTime?CreatedOn, Guid?CreatedBy, DateTime?ModifiedOn, Guid?ModifiedBy)
        {
            DataClasses1DataContext classes1DataContext = new DataClasses1DataContext();

            try
            {
                DOCUMENTSTRUCTURE documentstructure = Queryable.Single <DOCUMENTSTRUCTURE>((IQueryable <DOCUMENTSTRUCTURE>)classes1DataContext.DOCUMENTSTRUCTUREs, (Expression <Func <DOCUMENTSTRUCTURE, bool> >)(p => p.ID == ID));
                if (ID_WS.HasValue)
                {
                    documentstructure.ID_WS = Convert.ToInt64((object)ID_WS);
                }
                if (Name != null)
                {
                    documentstructure.Name = Name.ToString();
                }
                if (Description != null)
                {
                    documentstructure.Description = Description.ToString();
                }
                if (XMLSchema != null)
                {
                    documentstructure.XMLSchema = XMLSchema.ToString();
                }
                if (Purpose != null)
                {
                    documentstructure.Purpose = Purpose.ToString();
                }
                if (CreatedOn.HasValue)
                {
                    documentstructure.CreatedOn = Convert.ToDateTime((object)CreatedOn);
                }
                if (CreatedBy.HasValue)
                {
                    documentstructure.CreatedBy = CreatedBy.Value;
                }
                if (ModifiedOn.HasValue)
                {
                    documentstructure.ModifiedOn = new DateTime?(Convert.ToDateTime((object)ModifiedOn));
                }
                if (ModifiedBy.HasValue)
                {
                    documentstructure.ModifiedBy = new Guid?(ModifiedBy.Value);
                }
                classes1DataContext.SubmitChanges();
            }
            catch
            {
            }
        }
        public long Insert(long ID_WS, string Name, string Description, string XMLSchema, string Purpose, DateTime CreatedOn, Guid CreatedBy, DateTime?ModifiedOn, Guid?ModifiedBy)
        {
            DataClasses1DataContext classes1DataContext = new DataClasses1DataContext();

            try
            {
                DOCUMENTSTRUCTURE entity = new DOCUMENTSTRUCTURE();
                entity.ID_WS       = ID_WS;
                entity.Name        = Name;
                entity.Description = Description;
                entity.XMLSchema   = XMLSchema;
                entity.Purpose     = Purpose;
                entity.CreatedOn   = CreatedOn;
                entity.CreatedBy   = CreatedBy;
                classes1DataContext.DOCUMENTSTRUCTUREs.InsertOnSubmit(entity);
                classes1DataContext.SubmitChanges();
                return(entity.ID);
            }
            catch
            {
                return(0L);
            }
        }