static AdReminderEmail()
{
#region Create Schema
Schema = new TypedSchema<AdReminderEmail>("ReminderEmailLog");
Schema.PrimaryKey = RowIdColumn = Schema.Columns.AddValueColumn("RowId", typeof(Guid), null);
RowIdColumn.Unique = true;
RowIdColumn.AllowNulls = false;
RecipientColumn = Schema.Columns.AddForeignKey("Recipient", MelaveMalkaInvitation.Schema, "ReminderEmailLogs");
RecipientColumn.AllowNulls = false;
DateColumn = Schema.Columns.AddValueColumn("Date", typeof(DateTime), null);
DateColumn.AllowNulls = false;
EmailSubjectColumn = Schema.Columns.AddValueColumn("EmailSubject", typeof(String), null);
EmailSubjectColumn.AllowNulls = false;
EmailSourceColumn = Schema.Columns.AddValueColumn("EmailSource", typeof(String), null);
EmailSourceColumn.AllowNulls = false;
#endregion
#region Create SchemaMapping
SchemaMapping = new SchemaMapping(Schema, false);
SchemaMapping.SqlName = "ReminderEmailLog";
SchemaMapping.SqlSchemaName = "MelaveMalka";
SchemaMapping.Columns.AddMapping(RowIdColumn, "RowId");
SchemaMapping.Columns.AddMapping(RecipientColumn, "InviteId");
SchemaMapping.Columns.AddMapping(DateColumn, "Date");
SchemaMapping.Columns.AddMapping(EmailSubjectColumn, "EmailSubject");
SchemaMapping.Columns.AddMapping(EmailSourceColumn, "EmailSource");
#endregion
SchemaMapping.SetPrimaryMapping(SchemaMapping);
}
static StagedPayment()
{
#region Create Schema
Schema = new TypedSchema<StagedPayment>("StagedPayments");
Schema.PrimaryKey = StagedPaymentIdColumn = Schema.Columns.AddValueColumn("StagedPaymentId", typeof(Guid), null);
StagedPaymentIdColumn.Unique = true;
StagedPaymentIdColumn.AllowNulls = false;
StagedPersonColumn = Schema.Columns.AddForeignKey("StagedPerson", StagedPerson.Schema, "StagedPayments");
StagedPersonColumn.AllowNulls = false;
DateColumn = Schema.Columns.AddValueColumn("Date", typeof(DateTime), null);
DateColumn.AllowNulls = false;
MethodColumn = Schema.Columns.AddValueColumn("Method", typeof(String), null);
MethodColumn.AllowNulls = false;
CheckNumberColumn = Schema.Columns.AddValueColumn("CheckNumber", typeof(String), null);
CheckNumberColumn.AllowNulls = true;
AccountColumn = Schema.Columns.AddValueColumn("Account", typeof(String), null);
AccountColumn.AllowNulls = false;
AmountColumn = Schema.Columns.AddValueColumn("Amount", typeof(Decimal), null);
AmountColumn.AllowNulls = false;
CommentsColumn = Schema.Columns.AddValueColumn("Comments", typeof(String), null);
CommentsColumn.AllowNulls = true;
ExternalIdColumn = Schema.Columns.AddValueColumn("ExternalId", typeof(String), null);
ExternalIdColumn.AllowNulls = false;
CompanyColumn = Schema.Columns.AddValueColumn("Company", typeof(String), null);
CompanyColumn.AllowNulls = true;
#endregion
#region Create SchemaMapping
SchemaMapping = new SchemaMapping(Schema, false);
SchemaMapping.SqlName = "StagedPayments";
SchemaMapping.SqlSchemaName = "BillingMigration";
SchemaMapping.Columns.AddMapping(StagedPaymentIdColumn, "StagedPaymentId");
SchemaMapping.Columns.AddMapping(StagedPersonColumn, "StagedPersonId");
SchemaMapping.Columns.AddMapping(DateColumn, "Date");
SchemaMapping.Columns.AddMapping(MethodColumn, "Method");
SchemaMapping.Columns.AddMapping(CheckNumberColumn, "CheckNumber");
SchemaMapping.Columns.AddMapping(AccountColumn, "Account");
SchemaMapping.Columns.AddMapping(AmountColumn, "Amount");
SchemaMapping.Columns.AddMapping(CommentsColumn, "Comments");
SchemaMapping.Columns.AddMapping(ExternalIdColumn, "ExternalId");
SchemaMapping.Columns.AddMapping(CompanyColumn, "Company");
#endregion
SchemaMapping.SetPrimaryMapping(SchemaMapping);
}
static ImportedPayment()
{
#region Create Schema
Schema = new TypedSchema<ImportedPayment>("ImportedPayments");
Schema.PrimaryKey = ImportedPaymentIdColumn = Schema.Columns.AddValueColumn("ImportedPaymentId", typeof(Guid), null);
ImportedPaymentIdColumn.Unique = true;
ImportedPaymentIdColumn.AllowNulls = false;
PaymentColumn = Schema.Columns.AddForeignKey("Payment", Payment.Schema, "ImportedPayments");
PaymentColumn.Unique = true;
PaymentColumn.AllowNulls = false;
SourceColumn = Schema.Columns.AddValueColumn("Source", typeof(String), null);
SourceColumn.AllowNulls = false;
ExternalIdColumn = Schema.Columns.AddValueColumn("ExternalId", typeof(String), null);
ExternalIdColumn.AllowNulls = false;
DateImportedColumn = Schema.Columns.AddValueColumn("DateImported", typeof(DateTime), null);
DateImportedColumn.AllowNulls = false;
ImportingUserColumn = Schema.Columns.AddValueColumn("ImportingUser", typeof(String), null);
ImportingUserColumn.AllowNulls = false;
#endregion
#region Create SchemaMapping
SchemaMapping = new SchemaMapping(Schema, false);
SchemaMapping.SqlName = "ImportedPayments";
SchemaMapping.SqlSchemaName = "Billing";
SchemaMapping.Columns.AddMapping(ImportedPaymentIdColumn, "ImportedPaymentId");
SchemaMapping.Columns.AddMapping(PaymentColumn, "PaymentId");
SchemaMapping.Columns.AddMapping(SourceColumn, "Source");
SchemaMapping.Columns.AddMapping(ExternalIdColumn, "ExternalId");
SchemaMapping.Columns.AddMapping(DateImportedColumn, "DateImported");
SchemaMapping.Columns.AddMapping(ImportingUserColumn, "ImportingUser");
#endregion
SchemaMapping.SetPrimaryMapping(SchemaMapping);
}
static SeatingReservation()
{
#region Create Schema
Schema = new TypedSchema<SeatingReservation>("SeatingReservations");
Schema.PrimaryKey = IdColumn = Schema.Columns.AddValueColumn("Id", typeof(Guid), null);
IdColumn.Unique = true;
IdColumn.AllowNulls = false;
PledgeColumn = Schema.Columns.AddForeignKey("Pledge", Pledge.Schema, "SeatingReservations");
PledgeColumn.Unique = true;
PledgeColumn.AllowNulls = false;
MensSeatsColumn = Schema.Columns.AddValueColumn("MensSeats", typeof(Int32), 0);
MensSeatsColumn.AllowNulls = false;
WomensSeatsColumn = Schema.Columns.AddValueColumn("WomensSeats", typeof(Int32), 0);
WomensSeatsColumn.AllowNulls = false;
BoysSeatsColumn = Schema.Columns.AddValueColumn("BoysSeats", typeof(Int32), 0);
BoysSeatsColumn.AllowNulls = false;
GirlsSeatsColumn = Schema.Columns.AddValueColumn("GirlsSeats", typeof(Int32), 0);
GirlsSeatsColumn.AllowNulls = false;
NotesColumn = Schema.Columns.AddValueColumn("Notes", typeof(String), "");
NotesColumn.AllowNulls = false;
#endregion
#region Create SchemaMapping
SchemaMapping = new SchemaMapping(Schema, false);
SchemaMapping.SqlName = "SeatingReservations";
SchemaMapping.SqlSchemaName = "Seating";
SchemaMapping.Columns.AddMapping(IdColumn, "Id");
SchemaMapping.Columns.AddMapping(PledgeColumn, "PledgeId");
SchemaMapping.Columns.AddMapping(MensSeatsColumn, "MensSeats");
SchemaMapping.Columns.AddMapping(WomensSeatsColumn, "WomensSeats");
SchemaMapping.Columns.AddMapping(BoysSeatsColumn, "BoysSeats");
SchemaMapping.Columns.AddMapping(GirlsSeatsColumn, "GirlsSeats");
SchemaMapping.Columns.AddMapping(NotesColumn, "Notes");
#endregion
SchemaMapping.SetPrimaryMapping(SchemaMapping);
}
static RelativeLink()
{
#region Create Schema
Schema = new TypedSchema<RelativeLink>("Relatives");
Schema.PrimaryKey = RowIdColumn = Schema.Columns.AddValueColumn("RowId", typeof(Guid), null);
RowIdColumn.Unique = true;
RowIdColumn.AllowNulls = false;
MemberColumn = Schema.Columns.AddForeignKey("Member", Person.Schema, "ForeignRelatives");
MemberColumn.AllowNulls = false;
RelativeColumn = Schema.Columns.AddForeignKey("Relative", Person.Schema, "Relatives");
RelativeColumn.AllowNulls = false;
RelationTypeColumn = Schema.Columns.AddValueColumn("Relation", typeof(String), null);
RelationTypeColumn.AllowNulls = false;
#endregion
#region Create SchemaMapping
SchemaMapping = new SchemaMapping(Schema, false);
SchemaMapping.SqlName = "Relatives";
SchemaMapping.SqlSchemaName = "Data";
SchemaMapping.Columns.AddMapping(RowIdColumn, "RowId");
SchemaMapping.Columns.AddMapping(MemberColumn, "MemberId");
SchemaMapping.Columns.AddMapping(RelativeColumn, "RelativeId");
SchemaMapping.Columns.AddMapping(RelationTypeColumn, "Relation");
#endregion
SchemaMapping.SetPrimaryMapping(SchemaMapping);
}
static RaffleTicket()
{
#region Create Schema
Schema = new TypedSchema<RaffleTicket>("RaffleTickets");
Schema.PrimaryKey = RowIdColumn = Schema.Columns.AddValueColumn("RowId", typeof(Guid), null);
RowIdColumn.Unique = true;
RowIdColumn.AllowNulls = false;
PersonColumn = Schema.Columns.AddForeignKey("Person", Person.Schema, "RaffleTickets");
PersonColumn.AllowNulls = false;
DateAddedColumn = Schema.Columns.AddValueColumn("DateAdded", typeof(DateTime), null);
DateAddedColumn.AllowNulls = false;
YearColumn = Schema.Columns.AddValueColumn("Year", typeof(Int32), null);
YearColumn.AllowNulls = false;
TicketIdColumn = Schema.Columns.AddValueColumn("TicketId", typeof(Int32), null);
TicketIdColumn.AllowNulls = false;
PaidColumn = Schema.Columns.AddValueColumn("Paid", typeof(Boolean), null);
PaidColumn.AllowNulls = false;
CommentsColumn = Schema.Columns.AddValueColumn("Comments", typeof(String), null);
CommentsColumn.AllowNulls = true;
#endregion
#region Create SchemaMapping
SchemaMapping = new SchemaMapping(Schema, false);
SchemaMapping.SqlName = "RaffleTickets";
SchemaMapping.SqlSchemaName = "MelaveMalka";
SchemaMapping.Columns.AddMapping(RowIdColumn, "RowId");
SchemaMapping.Columns.AddMapping(PersonColumn, "PersonId");
SchemaMapping.Columns.AddMapping(DateAddedColumn, "DateAdded");
SchemaMapping.Columns.AddMapping(YearColumn, "Year");
SchemaMapping.Columns.AddMapping(TicketIdColumn, "TicketId");
SchemaMapping.Columns.AddMapping(PaidColumn, "Paid");
SchemaMapping.Columns.AddMapping(CommentsColumn, "Comments");
#endregion
SchemaMapping.SetPrimaryMapping(SchemaMapping);
}
static PledgeLink()
{
#region Create Schema
Schema = new TypedSchema<PledgeLink>("PledgeLinks");
Schema.PrimaryKey = LinkIdColumn = Schema.Columns.AddValueColumn("LinkId", typeof(Guid), null);
LinkIdColumn.Unique = true;
LinkIdColumn.AllowNulls = false;
PledgeColumn = Schema.Columns.AddForeignKey("Pledge", Pledge.Schema, "LinkedPayments");
PledgeColumn.AllowNulls = false;
PaymentColumn = Schema.Columns.AddForeignKey("Payment", Payment.Schema, "LinkedPledges");
PaymentColumn.AllowNulls = false;
AmountColumn = Schema.Columns.AddValueColumn("Amount", typeof(Decimal), null);
AmountColumn.AllowNulls = false;
#endregion
#region Create SchemaMapping
SchemaMapping = new SchemaMapping(Schema, false);
SchemaMapping.SqlName = "PledgeLinks";
SchemaMapping.SqlSchemaName = "Billing";
SchemaMapping.Columns.AddMapping(LinkIdColumn, "LinkId");
SchemaMapping.Columns.AddMapping(PledgeColumn, "PledgeId");
SchemaMapping.Columns.AddMapping(PaymentColumn, "PaymentId");
SchemaMapping.Columns.AddMapping(AmountColumn, "Amount");
#endregion
SchemaMapping.SetPrimaryMapping(SchemaMapping);
}
static Pledge()
{
#region Create Schema
Schema = new TypedSchema<Pledge>("Pledges");
Schema.PrimaryKey = PledgeIdColumn = Schema.Columns.AddValueColumn("PledgeId", typeof(Guid), null);
PledgeIdColumn.Unique = true;
PledgeIdColumn.AllowNulls = false;
PersonColumn = Schema.Columns.AddForeignKey("Person", Person.Schema, "Pledges");
PersonColumn.AllowNulls = false;
DateColumn = Schema.Columns.AddValueColumn("Date", typeof(DateTime), null);
DateColumn.AllowNulls = false;
TypeColumn = Schema.Columns.AddValueColumn("Type", typeof(String), null);
TypeColumn.AllowNulls = false;
SubTypeColumn = Schema.Columns.AddValueColumn("SubType", typeof(String), "");
SubTypeColumn.AllowNulls = false;
AccountColumn = Schema.Columns.AddValueColumn("Account", typeof(String), null);
AccountColumn.AllowNulls = false;
AmountColumn = Schema.Columns.AddValueColumn("Amount", typeof(Decimal), null);
AmountColumn.AllowNulls = false;
NoteColumn = Schema.Columns.AddValueColumn("Note", typeof(String), null);
NoteColumn.AllowNulls = true;
CommentsColumn = Schema.Columns.AddValueColumn("Comments", typeof(String), null);
CommentsColumn.AllowNulls = true;
ModifiedColumn = Schema.Columns.AddValueColumn("Modified", typeof(DateTime), null);
ModifiedColumn.AllowNulls = false;
ModifierColumn = Schema.Columns.AddValueColumn("Modifier", typeof(String), null);
ModifierColumn.AllowNulls = false;
ExternalSourceColumn = Schema.Columns.AddValueColumn("ExternalSource", typeof(String), null);
ExternalSourceColumn.AllowNulls = true;
ExternalIdColumn = Schema.Columns.AddValueColumn("ExternalId", typeof(Int32), null);
ExternalIdColumn.AllowNulls = true;
#endregion
#region Create SchemaMapping
SchemaMapping = new SchemaMapping(Schema, false);
SchemaMapping.SqlName = "Pledges";
SchemaMapping.SqlSchemaName = "Billing";
SchemaMapping.Columns.AddMapping(PledgeIdColumn, "PledgeId");
SchemaMapping.Columns.AddMapping(PersonColumn, "PersonId");
SchemaMapping.Columns.AddMapping(DateColumn, "Date");
SchemaMapping.Columns.AddMapping(TypeColumn, "Type");
SchemaMapping.Columns.AddMapping(SubTypeColumn, "SubType");
SchemaMapping.Columns.AddMapping(AccountColumn, "Account");
SchemaMapping.Columns.AddMapping(AmountColumn, "Amount");
SchemaMapping.Columns.AddMapping(NoteColumn, "Note");
SchemaMapping.Columns.AddMapping(CommentsColumn, "Comments");
SchemaMapping.Columns.AddMapping(ModifiedColumn, "Modified");
SchemaMapping.Columns.AddMapping(ModifierColumn, "Modifier");
SchemaMapping.Columns.AddMapping(ExternalSourceColumn, "ExternalSource");
SchemaMapping.Columns.AddMapping(ExternalIdColumn, "ExternalID");
#endregion
SchemaMapping.SetPrimaryMapping(SchemaMapping);
}
static JournalAd()
{
#region Create Schema
Schema = new TypedSchema<JournalAd>("Ads");
Schema.PrimaryKey = AdIdColumn = Schema.Columns.AddValueColumn("AdId", typeof(Guid), null);
AdIdColumn.Unique = true;
AdIdColumn.AllowNulls = false;
YearColumn = Schema.Columns.AddValueColumn("Year", typeof(Int32), null);
YearColumn.AllowNulls = false;
DateAddedColumn = Schema.Columns.AddValueColumn("DateAdded", typeof(DateTime), null);
DateAddedColumn.AllowNulls = false;
AdTypeColumn = Schema.Columns.AddValueColumn("AdType", typeof(String), null);
AdTypeColumn.AllowNulls = false;
ExternalIdColumn = Schema.Columns.AddValueColumn("ExternalId", typeof(Int32), null);
ExternalIdColumn.AllowNulls = false;
CommentsColumn = Schema.Columns.AddValueColumn("Comments", typeof(String), null);
CommentsColumn.AllowNulls = true;
#endregion
#region Create SchemaMapping
SchemaMapping = new SchemaMapping(Schema, false);
SchemaMapping.SqlName = "Ads";
SchemaMapping.SqlSchemaName = "MelaveMalka";
SchemaMapping.Columns.AddMapping(AdIdColumn, "AdId");
SchemaMapping.Columns.AddMapping(YearColumn, "Year");
SchemaMapping.Columns.AddMapping(DateAddedColumn, "DateAdded");
SchemaMapping.Columns.AddMapping(AdTypeColumn, "AdType");
SchemaMapping.Columns.AddMapping(ExternalIdColumn, "ExternalId");
SchemaMapping.Columns.AddMapping(CommentsColumn, "Comments");
#endregion
SchemaMapping.SetPrimaryMapping(SchemaMapping);
}
static Caller()
{
#region Create Schema
Schema = new TypedSchema<Caller>("Callers");
Schema.PrimaryKey = RowIdColumn = Schema.Columns.AddValueColumn("RowId", typeof(Guid), null);
RowIdColumn.Unique = true;
RowIdColumn.AllowNulls = false;
PersonColumn = Schema.Columns.AddForeignKey("Person", Person.Schema, "Callers");
PersonColumn.AllowNulls = false;
DateAddedColumn = Schema.Columns.AddValueColumn("DateAdded", typeof(DateTime), null);
DateAddedColumn.AllowNulls = false;
YearColumn = Schema.Columns.AddValueColumn("Year", typeof(Int32), null);
YearColumn.AllowNulls = false;
EmailAddressesColumn = Schema.Columns.AddCalculatedColumn<Caller, String>("EmailAddresses", row => String.Join(", ", row.Person.EmailAddresses.Select(e => e.Email)));
CalleeCountColumn = Schema.Columns.AddCalculatedColumn<Caller, Int32>("CalleeCount", row => row.Callees.Count);
#endregion
#region Create SchemaMapping
SchemaMapping = new SchemaMapping(Schema, false);
SchemaMapping.SqlName = "Callers";
SchemaMapping.SqlSchemaName = "MelaveMalka";
SchemaMapping.Columns.AddMapping(RowIdColumn, "RowId");
SchemaMapping.Columns.AddMapping(PersonColumn, "PersonId");
SchemaMapping.Columns.AddMapping(DateAddedColumn, "DateAdded");
SchemaMapping.Columns.AddMapping(YearColumn, "Year");
#endregion
SchemaMapping.SetPrimaryMapping(SchemaMapping);
}
static MelaveMalkaSeat()
{
#region Create Schema
Schema = new TypedSchema<MelaveMalkaSeat>("SeatReservations");
Schema.PrimaryKey = RowIdColumn = Schema.Columns.AddValueColumn("RowId", typeof(Guid), null);
RowIdColumn.Unique = true;
RowIdColumn.AllowNulls = false;
PersonColumn = Schema.Columns.AddForeignKey("Person", Person.Schema, "SeatReservations");
PersonColumn.AllowNulls = false;
DateAddedColumn = Schema.Columns.AddValueColumn("DateAdded", typeof(DateTime), null);
DateAddedColumn.AllowNulls = false;
YearColumn = Schema.Columns.AddValueColumn("Year", typeof(Int32), null);
YearColumn.AllowNulls = false;
MensSeatsColumn = Schema.Columns.AddValueColumn("MensSeats", typeof(Int32), 0);
MensSeatsColumn.AllowNulls = true;
WomensSeatsColumn = Schema.Columns.AddValueColumn("WomensSeats", typeof(Int32), 0);
WomensSeatsColumn.AllowNulls = true;
#endregion
#region Create SchemaMapping
SchemaMapping = new SchemaMapping(Schema, false);
SchemaMapping.SqlName = "SeatReservations";
SchemaMapping.SqlSchemaName = "MelaveMalka";
SchemaMapping.Columns.AddMapping(RowIdColumn, "RowId");
SchemaMapping.Columns.AddMapping(PersonColumn, "PersonId");
SchemaMapping.Columns.AddMapping(DateAddedColumn, "DateAdded");
SchemaMapping.Columns.AddMapping(YearColumn, "Year");
SchemaMapping.Columns.AddMapping(MensSeatsColumn, "MensSeats");
SchemaMapping.Columns.AddMapping(WomensSeatsColumn, "WomensSeats");
#endregion
SchemaMapping.SetPrimaryMapping(SchemaMapping);
}
static MelaveMalkaInvitation()
{
#region Create Schema
Schema = new TypedSchema<MelaveMalkaInvitation>("Invitees");
Schema.PrimaryKey = RowIdColumn = Schema.Columns.AddValueColumn("RowId", typeof(Guid), null);
RowIdColumn.Unique = true;
RowIdColumn.AllowNulls = false;
PersonColumn = Schema.Columns.AddForeignKey("Person", Person.Schema, "Invitees");
PersonColumn.AllowNulls = false;
YearColumn = Schema.Columns.AddValueColumn("Year", typeof(Int32), null);
YearColumn.AllowNulls = false;
SourceColumn = Schema.Columns.AddValueColumn("Source", typeof(String), null);
SourceColumn.AllowNulls = false;
DateAddedColumn = Schema.Columns.AddValueColumn("DateAdded", typeof(DateTime), null);
DateAddedColumn.AllowNulls = false;
ShouldCallColumn = Schema.Columns.AddValueColumn("ShouldCall", typeof(Boolean), false);
ShouldCallColumn.AllowNulls = false;
CallerColumn = Schema.Columns.AddForeignKey("Caller", Caller.Schema, "Callees");
CallerColumn.AllowNulls = true;
CallerNoteColumn = Schema.Columns.AddValueColumn("CallerNote", typeof(String), null);
CallerNoteColumn.AllowNulls = true;
AdAmountColumn = Schema.Columns.AddCalculatedColumn<MelaveMalkaInvitation, Decimal>("AdAmount", row => row.Person.Pledges.Where(p => p.ExternalSource == "Journal " + row.Year).Sum(p => p.Amount));
ShouldEmailColumn = Schema.Columns.AddValueColumn("ShouldEmail", typeof(Boolean), false);
ShouldEmailColumn.AllowNulls = false;
EmailSubjectColumn = Schema.Columns.AddValueColumn("EmailSubject", typeof(String), null);
EmailSubjectColumn.AllowNulls = true;
EmailSourceColumn = Schema.Columns.AddValueColumn("EmailSource", typeof(String), null);
EmailSourceColumn.AllowNulls = true;
EmailAddressesColumn = Schema.Columns.AddCalculatedColumn<MelaveMalkaInvitation, String>("EmailAddresses", row => String.Join(", ", row.Person.EmailAddresses.Select(e => e.Email)));
#endregion
#region Create SchemaMapping
SchemaMapping = new SchemaMapping(Schema, false);
SchemaMapping.SqlName = "Invitees";
SchemaMapping.SqlSchemaName = "MelaveMalka";
SchemaMapping.Columns.AddMapping(RowIdColumn, "RowId");
SchemaMapping.Columns.AddMapping(PersonColumn, "PersonId");
SchemaMapping.Columns.AddMapping(YearColumn, "Year");
SchemaMapping.Columns.AddMapping(SourceColumn, "Source");
SchemaMapping.Columns.AddMapping(DateAddedColumn, "DateAdded");
SchemaMapping.Columns.AddMapping(ShouldCallColumn, "ShouldCall");
SchemaMapping.Columns.AddMapping(CallerColumn, "Caller");
SchemaMapping.Columns.AddMapping(CallerNoteColumn, "CallerNote");
SchemaMapping.Columns.AddMapping(ShouldEmailColumn, "ShouldEmail");
SchemaMapping.Columns.AddMapping(EmailSubjectColumn, "EmailSubject");
SchemaMapping.Columns.AddMapping(EmailSourceColumn, "EmailSource");
#endregion
SchemaMapping.SetPrimaryMapping(SchemaMapping);
}
static MelaveMalkaInfo()
{
#region Create Schema
Schema = new TypedSchema<MelaveMalkaInfo>("MelaveMalkaInfo");
Schema.PrimaryKey = RowIdColumn = Schema.Columns.AddValueColumn("RowId", typeof(Guid), null);
RowIdColumn.Unique = true;
RowIdColumn.AllowNulls = false;
YearColumn = Schema.Columns.AddValueColumn("Year", typeof(Int32), null);
YearColumn.Unique = true;
YearColumn.AllowNulls = false;
AdDeadlineColumn = Schema.Columns.AddValueColumn("AdDeadline", typeof(DateTime), null);
AdDeadlineColumn.AllowNulls = false;
MelaveMalkaDateColumn = Schema.Columns.AddValueColumn("MelaveMalkaDate", typeof(DateTime), null);
MelaveMalkaDateColumn.AllowNulls = false;
HonoreeColumn = Schema.Columns.AddForeignKey("Honoree", Person.Schema, "Honorees");
HonoreeColumn.AllowNulls = false;
SpeakerColumn = Schema.Columns.AddValueColumn("Speaker", typeof(String), null);
SpeakerColumn.AllowNulls = false;
HonoreeTitleColumn = Schema.Columns.AddValueColumn("HonoreeTitle", typeof(String), null);
HonoreeTitleColumn.AllowNulls = false;
Honoree2Column = Schema.Columns.AddForeignKey("Honoree2", Person.Schema, "MelaveMalkaInfoes");
Honoree2Column.AllowNulls = true;
Honoree2TitleColumn = Schema.Columns.AddValueColumn("Honoree2Title", typeof(String), null);
Honoree2TitleColumn.AllowNulls = true;
#endregion
#region Create SchemaMapping
SchemaMapping = new SchemaMapping(Schema, false);
SchemaMapping.SqlName = "MelaveMalkaInfo";
SchemaMapping.SqlSchemaName = "MelaveMalka";
SchemaMapping.Columns.AddMapping(RowIdColumn, "RowId");
SchemaMapping.Columns.AddMapping(YearColumn, "Year");
SchemaMapping.Columns.AddMapping(AdDeadlineColumn, "AdDeadline");
SchemaMapping.Columns.AddMapping(MelaveMalkaDateColumn, "MelaveMalkaDate");
SchemaMapping.Columns.AddMapping(HonoreeColumn, "Honoree");
SchemaMapping.Columns.AddMapping(SpeakerColumn, "Speaker");
SchemaMapping.Columns.AddMapping(HonoreeTitleColumn, "HonoreeTitle");
SchemaMapping.Columns.AddMapping(Honoree2Column, "Honoree2");
SchemaMapping.Columns.AddMapping(Honoree2TitleColumn, "Honoree2Title");
#endregion
SchemaMapping.SetPrimaryMapping(SchemaMapping);
}
static LoggedStatement()
{
#region Create Schema
Schema = new TypedSchema<LoggedStatement>("StatementLog");
Schema.PrimaryKey = IdColumn = Schema.Columns.AddValueColumn("Id", typeof(Guid), null);
IdColumn.Unique = true;
IdColumn.AllowNulls = false;
PersonColumn = Schema.Columns.AddForeignKey("Person", Person.Schema, "LoggedStatements");
PersonColumn.AllowNulls = false;
DateGeneratedColumn = Schema.Columns.AddValueColumn("DateGenerated", typeof(DateTime), null);
DateGeneratedColumn.AllowNulls = false;
MediaColumn = Schema.Columns.AddValueColumn("Media", typeof(String), null);
MediaColumn.AllowNulls = false;
StatementKindColumn = Schema.Columns.AddValueColumn("StatementKind", typeof(String), null);
StatementKindColumn.AllowNulls = false;
StartDateColumn = Schema.Columns.AddValueColumn("StartDate", typeof(DateTime), null);
StartDateColumn.AllowNulls = false;
EndDateColumn = Schema.Columns.AddValueColumn("EndDate", typeof(DateTime), null);
EndDateColumn.AllowNulls = false;
UserNameColumn = Schema.Columns.AddValueColumn("UserName", typeof(String), null);
UserNameColumn.AllowNulls = false;
#endregion
#region Create SchemaMapping
SchemaMapping = new SchemaMapping(Schema, false);
SchemaMapping.SqlName = "StatementLog";
SchemaMapping.SqlSchemaName = "Billing";
SchemaMapping.Columns.AddMapping(IdColumn, "Id");
SchemaMapping.Columns.AddMapping(PersonColumn, "PersonId");
SchemaMapping.Columns.AddMapping(DateGeneratedColumn, "DateGenerated");
SchemaMapping.Columns.AddMapping(MediaColumn, "Media");
SchemaMapping.Columns.AddMapping(StatementKindColumn, "StatementKind");
SchemaMapping.Columns.AddMapping(StartDateColumn, "StartDate");
SchemaMapping.Columns.AddMapping(EndDateColumn, "EndDate");
SchemaMapping.Columns.AddMapping(UserNameColumn, "UserName");
#endregion
SchemaMapping.SetPrimaryMapping(SchemaMapping);
}
static Deposit()
{
#region Create Schema
Schema = new TypedSchema<Deposit>("Deposits");
Schema.PrimaryKey = DepositIdColumn = Schema.Columns.AddValueColumn("DepositId", typeof(Guid), null);
DepositIdColumn.Unique = true;
DepositIdColumn.AllowNulls = false;
DateColumn = Schema.Columns.AddValueColumn("Date", typeof(DateTime), null);
DateColumn.AllowNulls = false;
NumberColumn = Schema.Columns.AddValueColumn("Number", typeof(Int32), null);
NumberColumn.AllowNulls = false;
AccountColumn = Schema.Columns.AddValueColumn("Account", typeof(String), null);
AccountColumn.AllowNulls = false;
AmountColumn = Schema.Columns.AddCalculatedColumn<Deposit, Decimal>("Amount", row => row.Payments.Sum(p => p.Amount));
CountColumn = Schema.Columns.AddCalculatedColumn<Deposit, Int32>("Count", row => row.Payments.Count);
#endregion
#region Create SchemaMapping
SchemaMapping = new SchemaMapping(Schema, false);
SchemaMapping.SqlName = "Deposits";
SchemaMapping.SqlSchemaName = "Billing";
SchemaMapping.Columns.AddMapping(DepositIdColumn, "DepositId");
SchemaMapping.Columns.AddMapping(DateColumn, "Date");
SchemaMapping.Columns.AddMapping(NumberColumn, "Number");
SchemaMapping.Columns.AddMapping(AccountColumn, "Account");
#endregion
SchemaMapping.SetPrimaryMapping(SchemaMapping);
}
static EmailAddress()
{
#region Create Schema
Schema = new TypedSchema<EmailAddress>("EmailAddresses");
NameColumn = Schema.Columns.AddValueColumn("Name", typeof(String), null);
NameColumn.AllowNulls = true;
EmailColumn = Schema.Columns.AddValueColumn("Email", typeof(String), null);
EmailColumn.Unique = true;
EmailColumn.AllowNulls = false;
RandomCodeColumn = Schema.Columns.AddValueColumn("RandomCode", typeof(String), null);
RandomCodeColumn.AllowNulls = true;
ActiveColumn = Schema.Columns.AddValueColumn("Active", typeof(Boolean), true);
ActiveColumn.AllowNulls = false;
DateAddedColumn = Schema.Columns.AddValueColumn("DateAdded", typeof(DateTime), null);
DateAddedColumn.AllowNulls = false;
UseHtmlColumn = Schema.Columns.AddValueColumn("UseHtml", typeof(Boolean), true);
UseHtmlColumn.AllowNulls = false;
PersonColumn = Schema.Columns.AddForeignKey("Person", Person.Schema, "EmailAddresses");
PersonColumn.AllowNulls = true;
Schema.PrimaryKey = RowIdColumn = Schema.Columns.AddValueColumn("RowId", typeof(Guid), null);
RowIdColumn.Unique = true;
RowIdColumn.AllowNulls = false;
#endregion
#region Create SchemaMapping
SchemaMapping = new SchemaMapping(Schema, false);
SchemaMapping.SqlName = "tblMLMembers";
SchemaMapping.SqlSchemaName = "dbo";
SchemaMapping.Columns.AddMapping(NameColumn, "Name");
SchemaMapping.Columns.AddMapping(EmailColumn, "Email");
SchemaMapping.Columns.AddMapping(RandomCodeColumn, "ID_Code");
SchemaMapping.Columns.AddMapping(ActiveColumn, "Active");
SchemaMapping.Columns.AddMapping(DateAddedColumn, "Join_Date");
SchemaMapping.Columns.AddMapping(UseHtmlColumn, "HTMLformat");
SchemaMapping.Columns.AddMapping(PersonColumn, "PersonId");
SchemaMapping.Columns.AddMapping(RowIdColumn, "RowId");
#endregion
SchemaMapping.SetPrimaryMapping(SchemaMapping);
}
static Payment()
{
#region Create Schema
Schema = new TypedSchema<Payment>("Payments");
Schema.PrimaryKey = PaymentIdColumn = Schema.Columns.AddValueColumn("PaymentId", typeof(Guid), null);
PaymentIdColumn.Unique = true;
PaymentIdColumn.AllowNulls = false;
PersonColumn = Schema.Columns.AddForeignKey("Person", Person.Schema, "Payments");
PersonColumn.AllowNulls = false;
DateColumn = Schema.Columns.AddValueColumn("Date", typeof(DateTime), null);
DateColumn.AllowNulls = false;
MethodColumn = Schema.Columns.AddValueColumn("Method", typeof(String), null);
MethodColumn.AllowNulls = false;
CheckNumberColumn = Schema.Columns.AddValueColumn("CheckNumber", typeof(String), null);
CheckNumberColumn.AllowNulls = true;
AccountColumn = Schema.Columns.AddValueColumn("Account", typeof(String), null);
AccountColumn.AllowNulls = false;
AmountColumn = Schema.Columns.AddValueColumn("Amount", typeof(Decimal), null);
AmountColumn.AllowNulls = false;
DepositColumn = Schema.Columns.AddForeignKey("Deposit", Deposit.Schema, "Payments");
DepositColumn.AllowNulls = true;
CommentsColumn = Schema.Columns.AddValueColumn("Comments", typeof(String), null);
CommentsColumn.AllowNulls = true;
ModifiedColumn = Schema.Columns.AddValueColumn("Modified", typeof(DateTime), null);
ModifiedColumn.AllowNulls = false;
ModifierColumn = Schema.Columns.AddValueColumn("Modifier", typeof(String), null);
ModifierColumn.AllowNulls = false;
ExternalSourceColumn = Schema.Columns.AddValueColumn("ExternalSource", typeof(String), null);
ExternalSourceColumn.AllowNulls = true;
ExternalIdColumn = Schema.Columns.AddValueColumn("ExternalId", typeof(Int32), null);
ExternalIdColumn.AllowNulls = true;
CompanyColumn = Schema.Columns.AddValueColumn("Company", typeof(String), null);
CompanyColumn.AllowNulls = true;
#endregion
#region Create SchemaMapping
SchemaMapping = new SchemaMapping(Schema, false);
SchemaMapping.SqlName = "Payments";
SchemaMapping.SqlSchemaName = "Billing";
SchemaMapping.Columns.AddMapping(PaymentIdColumn, "PaymentId");
SchemaMapping.Columns.AddMapping(PersonColumn, "PersonId");
SchemaMapping.Columns.AddMapping(DateColumn, "Date");
SchemaMapping.Columns.AddMapping(MethodColumn, "Method");
SchemaMapping.Columns.AddMapping(CheckNumberColumn, "CheckNumber");
SchemaMapping.Columns.AddMapping(AccountColumn, "Account");
SchemaMapping.Columns.AddMapping(AmountColumn, "Amount");
SchemaMapping.Columns.AddMapping(DepositColumn, "DepositId");
SchemaMapping.Columns.AddMapping(CommentsColumn, "Comments");
SchemaMapping.Columns.AddMapping(ModifiedColumn, "Modified");
SchemaMapping.Columns.AddMapping(ModifierColumn, "Modifier");
SchemaMapping.Columns.AddMapping(ExternalSourceColumn, "ExternalSource");
SchemaMapping.Columns.AddMapping(ExternalIdColumn, "ExternalID");
SchemaMapping.Columns.AddMapping(CompanyColumn, "Company");
#endregion
SchemaMapping.SetPrimaryMapping(SchemaMapping);
}
static StagedPerson()
{
#region Create Schema
Schema = new TypedSchema<StagedPerson>("StagedPeople");
Schema.PrimaryKey = StagedPersonIdColumn = Schema.Columns.AddValueColumn("StagedPersonId", typeof(Guid), null);
StagedPersonIdColumn.Unique = true;
StagedPersonIdColumn.AllowNulls = false;
PersonColumn = Schema.Columns.AddForeignKey("Person", Person.Schema, "StagedPeople");
PersonColumn.AllowNulls = true;
HisNameColumn = Schema.Columns.AddValueColumn("HisName", typeof(String), null);
HisNameColumn.AllowNulls = true;
HerNameColumn = Schema.Columns.AddValueColumn("HerName", typeof(String), null);
HerNameColumn.AllowNulls = true;
LastNameColumn = Schema.Columns.AddValueColumn("LastName", typeof(String), null);
LastNameColumn.AllowNulls = false;
FullNameColumn = Schema.Columns.AddValueColumn("FullName", typeof(String), null);
FullNameColumn.AllowNulls = false;
AddressColumn = Schema.Columns.AddValueColumn("Address", typeof(String), null);
AddressColumn.AllowNulls = false;
CityColumn = Schema.Columns.AddValueColumn("City", typeof(String), null);
CityColumn.AllowNulls = true;
StateColumn = Schema.Columns.AddValueColumn("State", typeof(String), null);
StateColumn.AllowNulls = true;
ZipColumn = Schema.Columns.AddValueColumn("Zip", typeof(String), null);
ZipColumn.AllowNulls = true;
PhoneColumn = Schema.Columns.AddValueColumn("Phone", typeof(String), "");
PhoneColumn.AllowNulls = false;
#endregion
#region Create SchemaMapping
SchemaMapping = new SchemaMapping(Schema, false);
SchemaMapping.SqlName = "StagedPeople";
SchemaMapping.SqlSchemaName = "BillingMigration";
SchemaMapping.Columns.AddMapping(StagedPersonIdColumn, "StagedPersonId");
SchemaMapping.Columns.AddMapping(PersonColumn, "PersonId");
SchemaMapping.Columns.AddMapping(HisNameColumn, "HisName");
SchemaMapping.Columns.AddMapping(HerNameColumn, "HerName");
SchemaMapping.Columns.AddMapping(LastNameColumn, "LastName");
SchemaMapping.Columns.AddMapping(FullNameColumn, "FullName");
SchemaMapping.Columns.AddMapping(AddressColumn, "Address");
SchemaMapping.Columns.AddMapping(CityColumn, "City");
SchemaMapping.Columns.AddMapping(StateColumn, "State");
SchemaMapping.Columns.AddMapping(ZipColumn, "Zip");
SchemaMapping.Columns.AddMapping(PhoneColumn, "Phone");
#endregion
SchemaMapping.SetPrimaryMapping(SchemaMapping);
}
static Person()
{
#region Create Schema
Schema = new TypedSchema<Person>("MasterDirectory");
Schema.PrimaryKey = IdColumn = Schema.Columns.AddValueColumn("Id", typeof(Guid), null);
IdColumn.Unique = true;
IdColumn.AllowNulls = false;
YKIDColumn = Schema.Columns.AddValueColumn("YKID", typeof(Int32), null);
YKIDColumn.AllowNulls = true;
LastNameColumn = Schema.Columns.AddValueColumn("LastName", typeof(String), null);
LastNameColumn.AllowNulls = false;
HisNameColumn = Schema.Columns.AddValueColumn("HisName", typeof(String), null);
HisNameColumn.AllowNulls = true;
HerNameColumn = Schema.Columns.AddValueColumn("HerName", typeof(String), null);
HerNameColumn.AllowNulls = true;
FullNameColumn = Schema.Columns.AddValueColumn("FullName", typeof(String), null);
FullNameColumn.AllowNulls = true;
AddressColumn = Schema.Columns.AddValueColumn("Address", typeof(String), null);
AddressColumn.AllowNulls = true;
CityColumn = Schema.Columns.AddValueColumn("City", typeof(String), null);
CityColumn.AllowNulls = true;
StateColumn = Schema.Columns.AddValueColumn("State", typeof(String), null);
StateColumn.AllowNulls = true;
ZipColumn = Schema.Columns.AddValueColumn("Zip", typeof(String), null);
ZipColumn.AllowNulls = true;
PhoneColumn = Schema.Columns.AddValueColumn("Phone", typeof(String), null);
PhoneColumn.AllowNulls = false;
SourceColumn = Schema.Columns.AddValueColumn("Source", typeof(String), null);
SourceColumn.AllowNulls = false;
SalutationColumn = Schema.Columns.AddValueColumn("Salutation", typeof(String), null);
SalutationColumn.AllowNulls = false;
#endregion
#region Create SchemaMapping
SchemaMapping = new SchemaMapping(Schema, false);
SchemaMapping.SqlName = "MasterDirectory";
SchemaMapping.SqlSchemaName = "Data";
SchemaMapping.Columns.AddMapping(IdColumn, "Id");
SchemaMapping.Columns.AddMapping(YKIDColumn, "YKID");
SchemaMapping.Columns.AddMapping(LastNameColumn, "LastName");
SchemaMapping.Columns.AddMapping(HisNameColumn, "HisName");
SchemaMapping.Columns.AddMapping(HerNameColumn, "HerName");
SchemaMapping.Columns.AddMapping(FullNameColumn, "FullName");
SchemaMapping.Columns.AddMapping(AddressColumn, "Address");
SchemaMapping.Columns.AddMapping(CityColumn, "City");
SchemaMapping.Columns.AddMapping(StateColumn, "State");
SchemaMapping.Columns.AddMapping(ZipColumn, "Zip");
SchemaMapping.Columns.AddMapping(PhoneColumn, "Phone");
SchemaMapping.Columns.AddMapping(SourceColumn, "Source");
SchemaMapping.Columns.AddMapping(SalutationColumn, "Salutation");
#endregion
SchemaMapping.SetPrimaryMapping(SchemaMapping);
}