protected VwLatestOffShoreFundPricesMetadata()
{
_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(VwLatestOffShoreFundPricesMetadata.ColumnNames.FundName, 0, typeof(System.String), esSystemType.String);
c.PropertyName = VwLatestOffShoreFundPricesMetadata.PropertyNames.FundName;
c.CharacterMaxLength = 100;
_columns.Add(c);
c = new esColumnMetadata(VwLatestOffShoreFundPricesMetadata.ColumnNames.Price, 1, typeof(System.Double), esSystemType.Double);
c.PropertyName = VwLatestOffShoreFundPricesMetadata.PropertyNames.Price;
c.NumericPrecision = 15;
c.IsNullable = true;
_columns.Add(c);
c = new esColumnMetadata(VwLatestOffShoreFundPricesMetadata.ColumnNames.Currency, 2, typeof(System.String), esSystemType.String);
c.PropertyName = VwLatestOffShoreFundPricesMetadata.PropertyNames.Currency;
c.CharacterMaxLength = 5;
_columns.Add(c);
c = new esColumnMetadata(VwLatestOffShoreFundPricesMetadata.ColumnNames.OMAMFundId, 3, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = VwLatestOffShoreFundPricesMetadata.PropertyNames.OMAMFundId;
c.NumericPrecision = 10;
c.IsNullable = true;
_columns.Add(c);
}
protected vStoreEmailTemplateMetadata()
{
m_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(vStoreEmailTemplateMetadata.ColumnNames.NameKey, 0, typeof(System.String), esSystemType.String);
c.PropertyName = vStoreEmailTemplateMetadata.PropertyNames.NameKey;
c.CharacterMaxLength = 75;
m_columns.Add(c);
c = new esColumnMetadata(vStoreEmailTemplateMetadata.ColumnNames.Description, 1, typeof(System.String), esSystemType.String);
c.PropertyName = vStoreEmailTemplateMetadata.PropertyNames.Description;
c.CharacterMaxLength = 1073741823;
m_columns.Add(c);
c = new esColumnMetadata(vStoreEmailTemplateMetadata.ColumnNames.StoreId, 2, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = vStoreEmailTemplateMetadata.PropertyNames.StoreId;
c.NumericPrecision = 10;
m_columns.Add(c);
c = new esColumnMetadata(vStoreEmailTemplateMetadata.ColumnNames.EmailTemplateId, 3, typeof(System.Int16), esSystemType.Int16);
c.PropertyName = vStoreEmailTemplateMetadata.PropertyNames.EmailTemplateId;
c.NumericPrecision = 5;
m_columns.Add(c);
c = new esColumnMetadata(vStoreEmailTemplateMetadata.ColumnNames.SubjectTemplate, 4, typeof(System.String), esSystemType.String);
c.PropertyName = vStoreEmailTemplateMetadata.PropertyNames.SubjectTemplate;
c.CharacterMaxLength = 300;
m_columns.Add(c);
c = new esColumnMetadata(vStoreEmailTemplateMetadata.ColumnNames.BodyTemplate, 5, typeof(System.String), esSystemType.String);
c.PropertyName = vStoreEmailTemplateMetadata.PropertyNames.BodyTemplate;
c.CharacterMaxLength = 1073741823;
m_columns.Add(c);
}
protected StudentClassMetadata()
{
m_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(StudentClassMetadata.ColumnNames.Sid1, 0, typeof(System.String), esSystemType.String);
c.PropertyName = StudentClassMetadata.PropertyNames.Sid1;
c.IsInPrimaryKey = true;
c.CharacterMaxLength = 5;
m_columns.Add(c);
c = new esColumnMetadata(StudentClassMetadata.ColumnNames.Sid2, 1, typeof(System.String), esSystemType.String);
c.PropertyName = StudentClassMetadata.PropertyNames.Sid2;
c.IsInPrimaryKey = true;
c.CharacterMaxLength = 3;
m_columns.Add(c);
c = new esColumnMetadata(StudentClassMetadata.ColumnNames.Cid1, 2, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = StudentClassMetadata.PropertyNames.Cid1;
c.IsInPrimaryKey = true;
c.NumericPrecision = 10;
m_columns.Add(c);
c = new esColumnMetadata(StudentClassMetadata.ColumnNames.Cid2, 3, typeof(System.String), esSystemType.String);
c.PropertyName = StudentClassMetadata.PropertyNames.Cid2;
c.IsInPrimaryKey = true;
c.CharacterMaxLength = 10;
m_columns.Add(c);
}
static public OracleCommand BuildStoredProcInsertCommand(esDataRequest request, esEntitySavePacket packet)
{
Dictionary <string, OracleParameter> types = Cache.GetParameters(request);
OracleCommand cmd = new OracleCommand();
if (request.CommandTimeout != null)
{
cmd.CommandTimeout = request.CommandTimeout.Value;
}
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = CreateFullSPName(request, request.ProviderMetadata.spInsert);
PopulateStoredProcParameters(cmd, request, packet);
esColumnMetadataCollection cols = request.Columns;
OracleParameter p = null;
foreach (esColumnMetadata col in request.Columns)
{
if (col.IsComputed || col.IsAutoIncrement || col.IsEntitySpacesConcurrency)
{
p = cmd.Parameters["p" + (col.Name).Replace(" ", String.Empty)];
p.Direction = ParameterDirection.Output;
}
}
if (cols.DateAdded != null && cols.DateAdded.IsServerSide)
{
p = cmd.Parameters[types[cols.DateAdded.ColumnName].ParameterName];
p = cmd.Parameters[p.ParameterName];
p.Direction = ParameterDirection.Output;
}
if (cols.DateModified != null && cols.DateModified.IsServerSide)
{
p = cmd.Parameters[types[cols.DateModified.ColumnName].ParameterName];
p = cmd.Parameters[p.ParameterName];
p.Direction = ParameterDirection.Output;
}
if (cols.AddedBy != null && cols.AddedBy.IsServerSide)
{
p = cmd.Parameters[types[cols.AddedBy.ColumnName].ParameterName];
p.Size = (int)cols.FindByColumnName(cols.AddedBy.ColumnName).CharacterMaxLength;
p = cmd.Parameters[p.ParameterName];
p.Direction = ParameterDirection.Output;
}
if (cols.ModifiedBy != null && cols.ModifiedBy.IsServerSide)
{
p = cmd.Parameters[types[cols.ModifiedBy.ColumnName].ParameterName];
p.Size = (int)cols.FindByColumnName(cols.ModifiedBy.ColumnName).CharacterMaxLength;
p = cmd.Parameters[p.ParameterName];
p.Direction = ParameterDirection.Output;
}
return(cmd);
}
protected NamingTest2Metadata()
{
m_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(NamingTest2Metadata.ColumnNames.IdentityKey, 0, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = NamingTest2Metadata.PropertyNames.IdentityKey;
c.IsInPrimaryKey = true;
c.IsAutoIncrement = true;
c.NumericPrecision = 10;
m_columns.Add(c);
c = new esColumnMetadata(NamingTest2Metadata.ColumnNames.ItemDescription, 1, typeof(System.String), esSystemType.String);
c.PropertyName = NamingTest2Metadata.PropertyNames.ItemDescription;
c.CharacterMaxLength = 50;
c.IsNullable = true;
m_columns.Add(c);
c = new esColumnMetadata(NamingTest2Metadata.ColumnNames.ConcurrencyCheck, 2, typeof(System.Byte[]), esSystemType.ByteArray);
c.PropertyName = NamingTest2Metadata.PropertyNames.ConcurrencyCheck;
c.CharacterMaxLength = 8;
c.IsComputed = true;
c.IsConcurrency = true;
m_columns.Add(c);
c = new esColumnMetadata(NamingTest2Metadata.ColumnNames.GuidNewid, 3, typeof(System.Guid), esSystemType.Guid);
c.PropertyName = NamingTest2Metadata.PropertyNames.GuidNewid;
c.HasDefault = true;
c.Default = @"(newid())";
m_columns.Add(c);
}
protected KasMetadata()
{
_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(KasMetadata.ColumnNames.Id, 0, typeof(System.Int64), esSystemType.Int64);
c.PropertyName = KasMetadata.PropertyNames.Id;
c.IsInPrimaryKey = true;
c.IsAutoIncrement = true;
c.NumericPrecision = 19;
_columns.Add(c);
c = new esColumnMetadata(KasMetadata.ColumnNames.KaCode, 1, typeof(System.String), esSystemType.String);
c.PropertyName = KasMetadata.PropertyNames.KaCode;
c.CharacterMaxLength = 15;
_columns.Add(c);
c = new esColumnMetadata(KasMetadata.ColumnNames.KaName, 2, typeof(System.String), esSystemType.String);
c.PropertyName = KasMetadata.PropertyNames.KaName;
c.CharacterMaxLength = 256;
_columns.Add(c);
c = new esColumnMetadata(KasMetadata.ColumnNames.SaldoAwal, 3, typeof(System.Decimal), esSystemType.Decimal);
c.PropertyName = KasMetadata.PropertyNames.SaldoAwal;
c.NumericPrecision = 15;
c.NumericScale = 2;
_columns.Add(c);
c = new esColumnMetadata(KasMetadata.ColumnNames.PeriodeId, 4, typeof(System.Int64), esSystemType.Int64);
c.PropertyName = KasMetadata.PropertyNames.PeriodeId;
c.NumericPrecision = 19;
_columns.Add(c);
}
protected DefaultTestMetadata()
{
m_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(DefaultTestMetadata.ColumnNames.TestId, 0, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = DefaultTestMetadata.PropertyNames.TestId;
c.IsInPrimaryKey = true;
c.IsAutoIncrement = true;
c.NumericPrecision = 10;
m_columns.Add(c);
c = new esColumnMetadata(DefaultTestMetadata.ColumnNames.DefaultNotNullInt, 1, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = DefaultTestMetadata.PropertyNames.DefaultNotNullInt;
c.NumericPrecision = 10;
c.HasDefault = true;
c.Default = @"((0))";
m_columns.Add(c);
c = new esColumnMetadata(DefaultTestMetadata.ColumnNames.DefaultNotNullBool, 2, typeof(System.Boolean), esSystemType.Boolean);
c.PropertyName = DefaultTestMetadata.PropertyNames.DefaultNotNullBool;
c.HasDefault = true;
c.Default = @"((0))";
m_columns.Add(c);
}
protected ClientesMetadata()
{
m_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(ClientesMetadata.ColumnNames.Id, 0, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = ClientesMetadata.PropertyNames.Id;
c.IsInPrimaryKey = true;
c.IsAutoIncrement = true;
c.NumericPrecision = 10;
m_columns.Add(c);
c = new esColumnMetadata(ClientesMetadata.ColumnNames.Nombre, 1, typeof(System.String), esSystemType.String);
c.PropertyName = ClientesMetadata.PropertyNames.Nombre;
c.CharacterMaxLength = 150;
m_columns.Add(c);
c = new esColumnMetadata(ClientesMetadata.ColumnNames.Direccion, 2, typeof(System.String), esSystemType.String);
c.PropertyName = ClientesMetadata.PropertyNames.Direccion;
c.CharacterMaxLength = 150;
m_columns.Add(c);
c = new esColumnMetadata(ClientesMetadata.ColumnNames.Telefono, 3, typeof(System.String), esSystemType.String);
c.PropertyName = ClientesMetadata.PropertyNames.Telefono;
c.CharacterMaxLength = 23;
m_columns.Add(c);
c = new esColumnMetadata(ClientesMetadata.ColumnNames.Email, 4, typeof(System.String), esSystemType.String);
c.PropertyName = ClientesMetadata.PropertyNames.Email;
c.CharacterMaxLength = 75;
m_columns.Add(c);
}
protected AnnotationPlotAxisDataMetadata()
{
m_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(AnnotationPlotAxisDataMetadata.ColumnNames.Id, 0, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = AnnotationPlotAxisDataMetadata.PropertyNames.Id;
c.IsInPrimaryKey = true;
c.IsAutoIncrement = true;
c.NumericPrecision = 10;
m_columns.Add(c);
c = new esColumnMetadata(AnnotationPlotAxisDataMetadata.ColumnNames.AxisId, 1, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = AnnotationPlotAxisDataMetadata.PropertyNames.AxisId;
c.NumericPrecision = 10;
m_columns.Add(c);
c = new esColumnMetadata(AnnotationPlotAxisDataMetadata.ColumnNames.SeriesId, 2, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = AnnotationPlotAxisDataMetadata.PropertyNames.SeriesId;
c.NumericPrecision = 10;
m_columns.Add(c);
c = new esColumnMetadata(AnnotationPlotAxisDataMetadata.ColumnNames.DataBin, 3, typeof(System.Byte[]), esSystemType.ByteArray);
c.PropertyName = AnnotationPlotAxisDataMetadata.PropertyNames.DataBin;
c.CharacterMaxLength = 2147483647;
c.IsNullable = true;
m_columns.Add(c);
}
protected ADefHelpDeskLogMetadata()
{
m_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(ADefHelpDeskLogMetadata.ColumnNames.LogID, 0, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = ADefHelpDeskLogMetadata.PropertyNames.LogID;
c.IsInPrimaryKey = true;
c.IsAutoIncrement = true;
c.NumericPrecision = 10;
m_columns.Add(c);
c = new esColumnMetadata(ADefHelpDeskLogMetadata.ColumnNames.TaskID, 1, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = ADefHelpDeskLogMetadata.PropertyNames.TaskID;
c.NumericPrecision = 10;
m_columns.Add(c);
c = new esColumnMetadata(ADefHelpDeskLogMetadata.ColumnNames.LogDescription, 2, typeof(System.String), esSystemType.String);
c.PropertyName = ADefHelpDeskLogMetadata.PropertyNames.LogDescription;
c.CharacterMaxLength = 500;
m_columns.Add(c);
c = new esColumnMetadata(ADefHelpDeskLogMetadata.ColumnNames.DateCreated, 3, typeof(System.DateTime), esSystemType.DateTime);
c.PropertyName = ADefHelpDeskLogMetadata.PropertyNames.DateCreated;
m_columns.Add(c);
c = new esColumnMetadata(ADefHelpDeskLogMetadata.ColumnNames.UserID, 4, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = ADefHelpDeskLogMetadata.PropertyNames.UserID;
c.NumericPrecision = 10;
m_columns.Add(c);
}
protected ProductPhotoMetadata()
{
m_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(ProductPhotoMetadata.ColumnNames.Id, 0, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = ProductPhotoMetadata.PropertyNames.Id;
c.IsInPrimaryKey = true;
c.IsAutoIncrement = true;
c.NumericPrecision = 10;
m_columns.Add(c);
c = new esColumnMetadata(ProductPhotoMetadata.ColumnNames.ProductId, 1, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = ProductPhotoMetadata.PropertyNames.ProductId;
c.NumericPrecision = 10;
m_columns.Add(c);
c = new esColumnMetadata(ProductPhotoMetadata.ColumnNames.DisplayName, 2, typeof(System.String), esSystemType.String);
c.PropertyName = ProductPhotoMetadata.PropertyNames.DisplayName;
c.CharacterMaxLength = 250;
m_columns.Add(c);
c = new esColumnMetadata(ProductPhotoMetadata.ColumnNames.Filename, 3, typeof(System.String), esSystemType.String);
c.PropertyName = ProductPhotoMetadata.PropertyNames.Filename;
c.CharacterMaxLength = 500;
m_columns.Add(c);
c = new esColumnMetadata(ProductPhotoMetadata.ColumnNames.SortOrder, 4, typeof(System.Int16), esSystemType.Int16);
c.PropertyName = ProductPhotoMetadata.PropertyNames.SortOrder;
c.NumericPrecision = 5;
c.HasDefault = true;
c.Default = @"((1))";
m_columns.Add(c);
}
protected StorePaymentProviderSettingMetadata()
{
m_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(StorePaymentProviderSettingMetadata.ColumnNames.StoreId, 0, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = StorePaymentProviderSettingMetadata.PropertyNames.StoreId;
c.IsInPrimaryKey = true;
c.NumericPrecision = 10;
m_columns.Add(c);
c = new esColumnMetadata(StorePaymentProviderSettingMetadata.ColumnNames.PaymentProviderId, 1, typeof(System.Int16), esSystemType.Int16);
c.PropertyName = StorePaymentProviderSettingMetadata.PropertyNames.PaymentProviderId;
c.IsInPrimaryKey = true;
c.NumericPrecision = 5;
m_columns.Add(c);
c = new esColumnMetadata(StorePaymentProviderSettingMetadata.ColumnNames.Name, 2, typeof(System.String), esSystemType.String);
c.PropertyName = StorePaymentProviderSettingMetadata.PropertyNames.Name;
c.IsInPrimaryKey = true;
c.CharacterMaxLength = 500;
m_columns.Add(c);
c = new esColumnMetadata(StorePaymentProviderSettingMetadata.ColumnNames.Value, 3, typeof(System.String), esSystemType.String);
c.PropertyName = StorePaymentProviderSettingMetadata.PropertyNames.Value;
c.CharacterMaxLength = 1000;
m_columns.Add(c);
}
protected SqlCeDataTypesMetadata()
{
m_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(SqlCeDataTypesMetadata.ColumnNames.Id, 0, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = SqlCeDataTypesMetadata.PropertyNames.Id;
c.IsInPrimaryKey = true;
c.IsAutoIncrement = true;
c.NumericPrecision = 10;
m_columns.Add(c);
c = new esColumnMetadata(SqlCeDataTypesMetadata.ColumnNames.NumericType, 1, typeof(System.Decimal), esSystemType.Decimal);
c.PropertyName = SqlCeDataTypesMetadata.PropertyNames.NumericType;
c.NumericPrecision = 18;
c.IsNullable = true;
m_columns.Add(c);
c = new esColumnMetadata(SqlCeDataTypesMetadata.ColumnNames.RealType, 2, typeof(System.Single), esSystemType.Single);
c.PropertyName = SqlCeDataTypesMetadata.PropertyNames.RealType;
c.NumericPrecision = 24;
c.IsNullable = true;
m_columns.Add(c);
c = new esColumnMetadata(SqlCeDataTypesMetadata.ColumnNames.FloatType, 3, typeof(System.Double), esSystemType.Double);
c.PropertyName = SqlCeDataTypesMetadata.PropertyNames.FloatType;
c.NumericPrecision = 53;
c.IsNullable = true;
m_columns.Add(c);
}
protected TaxRegionMetadata()
{
m_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(TaxRegionMetadata.ColumnNames.StoreId, 0, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = TaxRegionMetadata.PropertyNames.StoreId;
c.IsInPrimaryKey = true;
c.NumericPrecision = 10;
m_columns.Add(c);
c = new esColumnMetadata(TaxRegionMetadata.ColumnNames.CountryCode, 1, typeof(System.String), esSystemType.String);
c.PropertyName = TaxRegionMetadata.PropertyNames.CountryCode;
c.IsInPrimaryKey = true;
c.CharacterMaxLength = 2;
m_columns.Add(c);
c = new esColumnMetadata(TaxRegionMetadata.ColumnNames.Region, 2, typeof(System.String), esSystemType.String);
c.PropertyName = TaxRegionMetadata.PropertyNames.Region;
c.IsInPrimaryKey = true;
c.CharacterMaxLength = 150;
m_columns.Add(c);
c = new esColumnMetadata(TaxRegionMetadata.ColumnNames.TaxRate, 3, typeof(System.Decimal), esSystemType.Decimal);
c.PropertyName = TaxRegionMetadata.PropertyNames.TaxRate;
c.NumericPrecision = 10;
c.NumericScale = 6;
c.IsNullable = true;
m_columns.Add(c);
}
protected PeriodeAnggaranMetadata()
{
_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(PeriodeAnggaranMetadata.ColumnNames.Id, 0, typeof(System.Int64), esSystemType.Int64);
c.PropertyName = PeriodeAnggaranMetadata.PropertyNames.Id;
c.IsInPrimaryKey = true;
c.IsAutoIncrement = true;
c.NumericPrecision = 19;
_columns.Add(c);
c = new esColumnMetadata(PeriodeAnggaranMetadata.ColumnNames.StartPeriod, 1, typeof(System.DateTime), esSystemType.DateTime);
c.PropertyName = PeriodeAnggaranMetadata.PropertyNames.StartPeriod;
_columns.Add(c);
c = new esColumnMetadata(PeriodeAnggaranMetadata.ColumnNames.EndPeriod, 2, typeof(System.DateTime), esSystemType.DateTime);
c.PropertyName = PeriodeAnggaranMetadata.PropertyNames.EndPeriod;
c.IsNullable = true;
_columns.Add(c);
c = new esColumnMetadata(PeriodeAnggaranMetadata.ColumnNames.IsClosed, 3, typeof(System.Boolean), esSystemType.Boolean);
c.PropertyName = PeriodeAnggaranMetadata.PropertyNames.IsClosed;
_columns.Add(c);
}
protected EmailTemplateMetadata()
{
m_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(EmailTemplateMetadata.ColumnNames.Id, 0, typeof(System.Int16), esSystemType.Int16);
c.PropertyName = EmailTemplateMetadata.PropertyNames.Id;
c.IsInPrimaryKey = true;
c.NumericPrecision = 5;
m_columns.Add(c);
c = new esColumnMetadata(EmailTemplateMetadata.ColumnNames.NameKey, 1, typeof(System.String), esSystemType.String);
c.PropertyName = EmailTemplateMetadata.PropertyNames.NameKey;
c.CharacterMaxLength = 75;
m_columns.Add(c);
c = new esColumnMetadata(EmailTemplateMetadata.ColumnNames.Description, 2, typeof(System.String), esSystemType.String);
c.PropertyName = EmailTemplateMetadata.PropertyNames.Description;
c.CharacterMaxLength = 1073741823;
m_columns.Add(c);
c = new esColumnMetadata(EmailTemplateMetadata.ColumnNames.DefaultSubject, 3, typeof(System.String), esSystemType.String);
c.PropertyName = EmailTemplateMetadata.PropertyNames.DefaultSubject;
c.CharacterMaxLength = 300;
c.HasDefault = true;
c.Default = @"('')";
m_columns.Add(c);
c = new esColumnMetadata(EmailTemplateMetadata.ColumnNames.DefaultBody, 4, typeof(System.String), esSystemType.String);
c.PropertyName = EmailTemplateMetadata.PropertyNames.DefaultBody;
c.CharacterMaxLength = 1073741823;
c.HasDefault = true;
c.Default = @"('')";
m_columns.Add(c);
}
static private DataTable CreateDataTable(esDataRequest request)
{
DataTable dataTable = new DataTable();
DataColumnCollection dataColumns = dataTable.Columns;
esColumnMetadataCollection cols = request.Columns;
if (request.SelectedColumns == null)
{
esColumnMetadata col;
for (int i = 0; i < cols.Count; i++)
{
col = cols[i];
dataColumns.Add(new DataColumn(col.Name, col.Type));
}
}
else
{
foreach (string col in request.SelectedColumns.Keys)
{
dataColumns.Add(new DataColumn(col, cols[col].Type));
}
}
return(dataTable);
}
protected AccountInfoMetadata()
{
m_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(AccountInfoMetadata.ColumnNames.Name, 0, typeof(System.String), esSystemType.String);
c.PropertyName = AccountInfoMetadata.PropertyNames.Name;
c.CharacterMaxLength = 50;
m_columns.Add(c);
c = new esColumnMetadata(AccountInfoMetadata.ColumnNames.Id, 1, typeof(System.Guid), esSystemType.Guid);
c.PropertyName = AccountInfoMetadata.PropertyNames.Id;
c.IsInPrimaryKey = true;
m_columns.Add(c);
c = new esColumnMetadata(AccountInfoMetadata.ColumnNames.Age, 2, typeof(System.Int16), esSystemType.Int16);
c.PropertyName = AccountInfoMetadata.PropertyNames.Age;
c.NumericPrecision = 5;
m_columns.Add(c);
c = new esColumnMetadata(AccountInfoMetadata.ColumnNames.Address, 3, typeof(System.String), esSystemType.String);
c.PropertyName = AccountInfoMetadata.PropertyNames.Address;
c.CharacterMaxLength = 256;
c.IsNullable = true;
m_columns.Add(c);
}
protected ReverseCompositeChildMetadata()
{
m_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(ReverseCompositeChildMetadata.ColumnNames.ChildId, 0, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = ReverseCompositeChildMetadata.PropertyNames.ChildId;
c.IsInPrimaryKey = true;
c.NumericPrecision = 10;
m_columns.Add(c);
c = new esColumnMetadata(ReverseCompositeChildMetadata.ColumnNames.ParentKeyId, 1, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = ReverseCompositeChildMetadata.PropertyNames.ParentKeyId;
c.IsInPrimaryKey = true;
c.NumericPrecision = 10;
m_columns.Add(c);
c = new esColumnMetadata(ReverseCompositeChildMetadata.ColumnNames.ParentKeySub, 2, typeof(System.String), esSystemType.String);
c.PropertyName = ReverseCompositeChildMetadata.PropertyNames.ParentKeySub;
c.IsInPrimaryKey = true;
c.CharacterMaxLength = 3;
m_columns.Add(c);
c = new esColumnMetadata(ReverseCompositeChildMetadata.ColumnNames.Description, 3, typeof(System.String), esSystemType.String);
c.PropertyName = ReverseCompositeChildMetadata.PropertyNames.Description;
c.CharacterMaxLength = 50;
c.IsNullable = true;
m_columns.Add(c);
}
protected NewTableMetadata()
{
m_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(NewTableMetadata.ColumnNames.Id, 0, typeof(System.Int64), esSystemType.Int64);
c.PropertyName = NewTableMetadata.PropertyNames.Id;
c.IsInPrimaryKey = true;
c.IsAutoIncrement = true;
c.NumericPrecision = 19;
m_columns.Add(c);
c = new esColumnMetadata(NewTableMetadata.ColumnNames.CustomerName, 1, typeof(System.String), esSystemType.String);
c.PropertyName = NewTableMetadata.PropertyNames.CustomerName;
c.CharacterMaxLength = 25;
m_columns.Add(c);
c = new esColumnMetadata(NewTableMetadata.ColumnNames.LastName, 2, typeof(System.String), esSystemType.String);
c.PropertyName = NewTableMetadata.PropertyNames.LastName;
c.CharacterMaxLength = 25;
m_columns.Add(c);
c = new esColumnMetadata(NewTableMetadata.ColumnNames.FirstName, 3, typeof(System.String), esSystemType.String);
c.PropertyName = NewTableMetadata.PropertyNames.FirstName;
c.CharacterMaxLength = 25;
m_columns.Add(c);
}
protected ADefHelpDeskSettingsMetadata()
{
m_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(ADefHelpDeskSettingsMetadata.ColumnNames.SettingID, 0, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = ADefHelpDeskSettingsMetadata.PropertyNames.SettingID;
c.IsInPrimaryKey = true;
c.IsAutoIncrement = true;
c.NumericPrecision = 10;
m_columns.Add(c);
c = new esColumnMetadata(ADefHelpDeskSettingsMetadata.ColumnNames.PortalID, 1, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = ADefHelpDeskSettingsMetadata.PropertyNames.PortalID;
c.NumericPrecision = 10;
m_columns.Add(c);
c = new esColumnMetadata(ADefHelpDeskSettingsMetadata.ColumnNames.SettingName, 2, typeof(System.String), esSystemType.String);
c.PropertyName = ADefHelpDeskSettingsMetadata.PropertyNames.SettingName;
c.CharacterMaxLength = 150;
m_columns.Add(c);
c = new esColumnMetadata(ADefHelpDeskSettingsMetadata.ColumnNames.SettingValue, 3, typeof(System.String), esSystemType.String);
c.PropertyName = ADefHelpDeskSettingsMetadata.PropertyNames.SettingValue;
c.CharacterMaxLength = 250;
m_columns.Add(c);
}
protected StoreEmailTemplateMetadata()
{
m_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(StoreEmailTemplateMetadata.ColumnNames.StoreId, 0, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = StoreEmailTemplateMetadata.PropertyNames.StoreId;
c.IsInPrimaryKey = true;
c.NumericPrecision = 10;
m_columns.Add(c);
c = new esColumnMetadata(StoreEmailTemplateMetadata.ColumnNames.EmailTemplateId, 1, typeof(System.Int16), esSystemType.Int16);
c.PropertyName = StoreEmailTemplateMetadata.PropertyNames.EmailTemplateId;
c.IsInPrimaryKey = true;
c.NumericPrecision = 5;
m_columns.Add(c);
c = new esColumnMetadata(StoreEmailTemplateMetadata.ColumnNames.SubjectTemplate, 2, typeof(System.String), esSystemType.String);
c.PropertyName = StoreEmailTemplateMetadata.PropertyNames.SubjectTemplate;
c.CharacterMaxLength = 300;
m_columns.Add(c);
c = new esColumnMetadata(StoreEmailTemplateMetadata.ColumnNames.BodyTemplate, 3, typeof(System.String), esSystemType.String);
c.PropertyName = StoreEmailTemplateMetadata.PropertyNames.BodyTemplate;
c.CharacterMaxLength = 1073741823;
m_columns.Add(c);
}
protected ProductMetadata()
{
m_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(ProductMetadata.ColumnNames.ProductID, 0, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = ProductMetadata.PropertyNames.ProductID;
c.IsInPrimaryKey = true;
c.IsAutoIncrement = true;
c.NumericPrecision = 10;
m_columns.Add(c);
c = new esColumnMetadata(ProductMetadata.ColumnNames.ProductName, 1, typeof(System.String), esSystemType.String);
c.PropertyName = ProductMetadata.PropertyNames.ProductName;
c.CharacterMaxLength = 50;
m_columns.Add(c);
c = new esColumnMetadata(ProductMetadata.ColumnNames.UnitPrice, 2, typeof(System.Decimal), esSystemType.Decimal);
c.PropertyName = ProductMetadata.PropertyNames.UnitPrice;
c.NumericPrecision = 19;
m_columns.Add(c);
c = new esColumnMetadata(ProductMetadata.ColumnNames.Discontinued, 3, typeof(System.Boolean), esSystemType.Boolean);
c.PropertyName = ProductMetadata.PropertyNames.Discontinued;
m_columns.Add(c);
}
protected EmployeeMetadata()
{
m_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(EmployeeMetadata.ColumnNames.EmployeeID, 0, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = EmployeeMetadata.PropertyNames.EmployeeID;
c.IsInPrimaryKey = true;
c.IsAutoIncrement = true;
c.NumericPrecision = 10;
m_columns.Add(c);
c = new esColumnMetadata(EmployeeMetadata.ColumnNames.LastName, 1, typeof(System.String), esSystemType.String);
c.PropertyName = EmployeeMetadata.PropertyNames.LastName;
c.CharacterMaxLength = 25;
m_columns.Add(c);
c = new esColumnMetadata(EmployeeMetadata.ColumnNames.FirstName, 2, typeof(System.String), esSystemType.String);
c.PropertyName = EmployeeMetadata.PropertyNames.FirstName;
c.CharacterMaxLength = 25;
m_columns.Add(c);
c = new esColumnMetadata(EmployeeMetadata.ColumnNames.Supervisor, 3, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = EmployeeMetadata.PropertyNames.Supervisor;
c.NumericPrecision = 10;
c.IsNullable = true;
m_columns.Add(c);
c = new esColumnMetadata(EmployeeMetadata.ColumnNames.Age, 4, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = EmployeeMetadata.PropertyNames.Age;
c.NumericPrecision = 10;
c.IsNullable = true;
m_columns.Add(c);
}
protected FullNameViewMetadata()
{
m_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(FullNameViewMetadata.ColumnNames.FullName, 0, typeof(System.String), esSystemType.String);
c.PropertyName = FullNameViewMetadata.PropertyNames.FullName;
c.CharacterMaxLength = 42;
c.IsNullable = true;
m_columns.Add(c);
c = new esColumnMetadata(FullNameViewMetadata.ColumnNames.DepartmentID, 1, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = FullNameViewMetadata.PropertyNames.DepartmentID;
c.NumericPrecision = 10;
c.IsNullable = true;
m_columns.Add(c);
c = new esColumnMetadata(FullNameViewMetadata.ColumnNames.HireDate, 2, typeof(System.DateTime), esSystemType.DateTime);
c.PropertyName = FullNameViewMetadata.PropertyNames.HireDate;
c.IsNullable = true;
m_columns.Add(c);
c = new esColumnMetadata(FullNameViewMetadata.ColumnNames.Salary, 3, typeof(System.Decimal), esSystemType.Decimal);
c.PropertyName = FullNameViewMetadata.PropertyNames.Salary;
c.NumericPrecision = 8;
c.NumericScale = 4;
c.IsNullable = true;
m_columns.Add(c);
c = new esColumnMetadata(FullNameViewMetadata.ColumnNames.IsActive, 4, typeof(System.Boolean), esSystemType.Boolean);
c.PropertyName = FullNameViewMetadata.PropertyNames.IsActive;
c.IsNullable = true;
m_columns.Add(c);
}
protected OffShoreFundPricesMetadata()
{
_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(OffShoreFundPricesMetadata.ColumnNames.Id, 0, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = OffShoreFundPricesMetadata.PropertyNames.Id;
c.IsInPrimaryKey = true;
c.IsAutoIncrement = true;
c.NumericPrecision = 10;
_columns.Add(c);
c = new esColumnMetadata(OffShoreFundPricesMetadata.ColumnNames.OMAMFundId, 1, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = OffShoreFundPricesMetadata.PropertyNames.OMAMFundId;
c.NumericPrecision = 10;
_columns.Add(c);
c = new esColumnMetadata(OffShoreFundPricesMetadata.ColumnNames.Price, 2, typeof(System.Double), esSystemType.Double);
c.PropertyName = OffShoreFundPricesMetadata.PropertyNames.Price;
c.NumericPrecision = 15;
_columns.Add(c);
c = new esColumnMetadata(OffShoreFundPricesMetadata.ColumnNames.CreatedDate, 3, typeof(System.DateTime), esSystemType.DateTime);
c.PropertyName = OffShoreFundPricesMetadata.PropertyNames.CreatedDate;
_columns.Add(c);
c = new esColumnMetadata(OffShoreFundPricesMetadata.ColumnNames.CreatedBy, 4, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = OffShoreFundPricesMetadata.PropertyNames.CreatedBy;
c.NumericPrecision = 10;
_columns.Add(c);
}
protected OrderItemMetadata()
{
m_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(OrderItemMetadata.ColumnNames.OrderID, 0, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = OrderItemMetadata.PropertyNames.OrderID;
c.IsInPrimaryKey = true;
c.NumericPrecision = 10;
m_columns.Add(c);
c = new esColumnMetadata(OrderItemMetadata.ColumnNames.ProductID, 1, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = OrderItemMetadata.PropertyNames.ProductID;
c.IsInPrimaryKey = true;
c.NumericPrecision = 10;
m_columns.Add(c);
c = new esColumnMetadata(OrderItemMetadata.ColumnNames.UnitPrice, 2, typeof(System.Decimal), esSystemType.Decimal);
c.PropertyName = OrderItemMetadata.PropertyNames.UnitPrice;
c.NumericPrecision = 19;
m_columns.Add(c);
c = new esColumnMetadata(OrderItemMetadata.ColumnNames.Quantity, 3, typeof(System.Int16), esSystemType.Int16);
c.PropertyName = OrderItemMetadata.PropertyNames.Quantity;
c.NumericPrecision = 5;
m_columns.Add(c);
c = new esColumnMetadata(OrderItemMetadata.ColumnNames.Discount, 4, typeof(System.Single), esSystemType.Single);
c.PropertyName = OrderItemMetadata.PropertyNames.Discount;
c.NumericPrecision = 7;
c.IsNullable = true;
m_columns.Add(c);
}
protected ADefHelpDeskRIAUsersMetadata()
{
m_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(ADefHelpDeskRIAUsersMetadata.ColumnNames.UserID, 0, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = ADefHelpDeskRIAUsersMetadata.PropertyNames.UserID;
c.IsInPrimaryKey = true;
c.NumericPrecision = 10;
m_columns.Add(c);
c = new esColumnMetadata(ADefHelpDeskRIAUsersMetadata.ColumnNames.RIAPassword, 1, typeof(System.String), esSystemType.String);
c.PropertyName = ADefHelpDeskRIAUsersMetadata.PropertyNames.RIAPassword;
c.CharacterMaxLength = 50;
m_columns.Add(c);
c = new esColumnMetadata(ADefHelpDeskRIAUsersMetadata.ColumnNames.IPAddress, 2, typeof(System.String), esSystemType.String);
c.PropertyName = ADefHelpDeskRIAUsersMetadata.PropertyNames.IPAddress;
c.CharacterMaxLength = 50;
m_columns.Add(c);
c = new esColumnMetadata(ADefHelpDeskRIAUsersMetadata.ColumnNames.CreatedDate, 3, typeof(System.DateTime), esSystemType.DateTime);
c.PropertyName = ADefHelpDeskRIAUsersMetadata.PropertyNames.CreatedDate;
m_columns.Add(c);
}
protected CategoriesMetadata()
{
m_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(CategoriesMetadata.ColumnNames.CategoryID, 0, typeof(System.Int32), esSystemType.Int32);
c.PropertyName = CategoriesMetadata.PropertyNames.CategoryID;
c.IsInPrimaryKey = true;
c.IsAutoIncrement = true;
c.NumericPrecision = 10;
m_columns.Add(c);
c = new esColumnMetadata(CategoriesMetadata.ColumnNames.CategoryName, 1, typeof(System.String), esSystemType.String);
c.PropertyName = CategoriesMetadata.PropertyNames.CategoryName;
c.CharacterMaxLength = 15;
m_columns.Add(c);
c = new esColumnMetadata(CategoriesMetadata.ColumnNames.Description, 2, typeof(System.String), esSystemType.String);
c.PropertyName = CategoriesMetadata.PropertyNames.Description;
c.CharacterMaxLength = 1073741823;
c.IsNullable = true;
m_columns.Add(c);
c = new esColumnMetadata(CategoriesMetadata.ColumnNames.Picture, 3, typeof(System.Byte[]), esSystemType.ByteArray);
c.PropertyName = CategoriesMetadata.PropertyNames.Picture;
c.CharacterMaxLength = 2147483647;
c.IsNullable = true;
m_columns.Add(c);
}
protected RadMenuDataSourceMetadata()
{
_columns = new esColumnMetadataCollection();
esColumnMetadata c;
c = new esColumnMetadata(RadMenuDataSourceMetadata.ColumnNames.ProgramID, 0, typeof(System.String), esSystemType.String);
c.PropertyName = RadMenuDataSourceMetadata.PropertyNames.ProgramID;
c.CharacterMaxLength = 30;
_columns.Add(c);
c = new esColumnMetadata(RadMenuDataSourceMetadata.ColumnNames.ParentProgramID, 1, typeof(System.String), esSystemType.String);
c.PropertyName = RadMenuDataSourceMetadata.PropertyNames.ParentProgramID;
c.CharacterMaxLength = 50;
c.IsNullable = true;
_columns.Add(c);
c = new esColumnMetadata(RadMenuDataSourceMetadata.ColumnNames.ProgramName, 2, typeof(System.String), esSystemType.String);
c.PropertyName = RadMenuDataSourceMetadata.PropertyNames.ProgramName;
c.CharacterMaxLength = 100;
_columns.Add(c);
c = new esColumnMetadata(RadMenuDataSourceMetadata.ColumnNames.NavigateUrl, 3, typeof(System.String), esSystemType.String);
c.PropertyName = RadMenuDataSourceMetadata.PropertyNames.NavigateUrl;
c.CharacterMaxLength = 1000;
c.IsNullable = true;
_columns.Add(c);
c = new esColumnMetadata(RadMenuDataSourceMetadata.ColumnNames.UserID, 4, typeof(System.String), esSystemType.String);
c.PropertyName = RadMenuDataSourceMetadata.PropertyNames.UserID;
c.CharacterMaxLength = 50;
_columns.Add(c);
}
