public AcadPlanMap()
{
Id(p => p.Id, "UNIQUE_ID");
Map(p => p.Emplid, "EMPLID");
Map(p => p.Term, "TERM");
Map(p => p.PriAcadPlanType, "PRI_ACAD_PLAN_TYPE");
Map(p => p.PriAcadPlan, "PRI_ACAD_PLAN");
Map(p => p.PriAcadPlanLdesc, "PRI_ACAD_PLAN_LDESC");
Map(p => p.PriAcadDegree, "PRI_ACAD_DEGREE");
Map(p => p.PriAcadCollege, "PRI_ACAD_COLLEGE");
Map(p => p.SecAcadPlanType, "SEC_ACAD_PLAN_TYPE");
Map(p => p.SecAcadPlan, "SEC_ACAD_PLAN");
Map(p => p.SecAcadPlanLdesc, "SEC_ACAD_PLAN_LDESC");
Map(p => p.SecAcadDegree, "SEC_ACAD_DEGREE");
Map(p => p.SecAcadCollege, "SEC_ACAD_COLLEGE");
Map(p => p.TerAcadPlanType, "TER_ACAD_PLAN_TYPE");
Map(p => p.TerAcadPlan, "TER_ACAD_PLAN");
Map(p => p.TerAcadPlanLdesc, "TER_ACAD_PLAN_LDESC");
Map(p => p.TerAcadDegree, "TER_ACAD_DEGREE");
Map(p => p.TerAcadCollege, "TER_ACAD_COLLEGE");
Map(p => p.QuaAcadPlanType, "QUA_ACAD_PLAN_TYPE");
Map(p => p.QuaAcadPlan, "QUA_ACAD_PLAN");
Map(p => p.QuaAcadPlanLdesc, "QUA_ACAD_PLAN_LDESC");
Map(p => p.QuaAcadDegree, "QUA_ACAD_DEGREE");
Map(p => p.QuaAcadCollege, "QUA_ACAD_COLLEGE");
Table("ACAD_PLAN_FULL_VIEW");
SchemaAction.None();
}
public RoleMap()
{
Id(x => x.Emplid);
Map(p => p.RoleName, "role_name");
Map(p => p.RoleId, "roleid");
Table("graduation_role_vw");
SchemaAction.None();
}
public EmployeeMap()
{
SchemaAction.None(); //evita dar erro do tipo "tabela já existe no DB"
Id(x => x.Id);
Map(x => x.FirstName);
Map(x => x.LastName);
References(x => x.Store);
}
public CommencementCeremonyMap()
{
Id(x => x.College, "COLLEGE");
Map(p => p.Ceremony, "CEREMOMY"); //Yes, with an M
Map(p => p.MaxTicketsAllowed, "MAX_TICKETS_ALLOWED");
Table("TEST_ALM_COMMENCEMENT_CEREMONY");
SchemaAction.None();
}
public NameMap()
{
Id(x => x.Id, "UNIQUE_ID");
Map(p => p.Emplid, "EMPLID");
Map(p => p.LastName, "LAST_NAME");
Map(p => p.FirstName, "FIRST_NAME");
Table("NAME_VIEW");
SchemaAction.None();
}
public PortalIdMap()
{
Id(x => x.Emplid, "EMPLID");
Map(p => p.UserId, "USER_ID");
Map(p => p.Initialized, "INITIALIZED");
Map(p => p.CepId, "CEPID");
Table("RDSPRD.PORTALID_XWALK@PUBLIC_FRONT1");
SchemaAction.None();
}
public CommencementTermMap()
{
Id(x => x.Term, "COMMENCEMENT_TERM");
Map(p => p.CommencementTermLdesc, "COMMENCEMENT_TERM_LDESC");
Map(p => p.BeginDt, "BEGIN_DT");
Map(p => p.EndDt, "END_DT");
Table("ALM_COMMENCEMENT_TERM");
SchemaAction.None();
}
public EmployeeMap()
{
SchemaAction.None();
Table("Employee");
Id(x => x.Id);
Map(x => x.FirstName);
Map(x => x.LastName);
Map(x => x.Designation);
}
public ProductMap()
{
SchemaAction.None(); //evita dar erro do tipo "tabela já existe no DB"
Id(x => x.Id);
Map(x => x.Name);
Map(x => x.Price);
HasManyToMany(x => x.StoresStockedIn)
.Cascade.All()
.Inverse()
.Table("StoreProduct");
}
public MajorMap()
{
Id(x => x.AcadPlan, "ACAD_PLAN");
Map(p => p.AcadPlanType, "ACAD_PLAN_TYPE");
Map(p => p.AcadPlanLdesc, "ACAD_PLAN_LDESC");
Map(p => p.AcadDegree, "DEGREE");
Map(p => p.AcadCollege, "COLLEGE");
Map(p => p.AcadCeremony, "CEREMONY");
Table("MAJOR_VIEW");
SchemaAction.None();
}
public AddressMap()
{
Id(x => x.Id, "UNIQUE_ID");
Map(p => p.Emplid, "EMPLID");
Map(p => p.Address1, "ADDRESS1");
Map(p => p.Address2, "ADDRESS2");
Map(p => p.City, "CITY");
Map(p => p.State, "STATE");
Map(p => p.PostalZip, "POSTAL_ZIP");
Map(p => p.Phone, "PHONE");
Map(p => p.EmailAddress, "EMAIL_ADDRESS");
Table("ADDRESS_VIEW");
SchemaAction.None();
}
public AcadProgMap()
{
Id(x => x.Id, "UNIQUE_ID");
Map(p => p.Emplid, "EMPLID");
Map(p => p.ExpGradTerm, "EXP_GRAD_TERM");
Map(p => p.Effdt, "EFFDT");
Map(p => p.Effseq, "EFFSEQ");
Map(p => p.StdntCarNbr, "STDNT_CAR_NBR");
Map(p => p.Prog, "ACAD_PROG");
Map(p => p.AcadCareer, "ACAD_CAREER");
Map(p => p.ProgAction, "PROG_ACTION");
Map(p => p.ProgReason, "PROG_REASON");
Table("ACAD_PROG_VIEW");
SchemaAction.None();
}
public AccountMap()
{
SchemaAction.None();
Table("dbo.Account");
Id(m => m.Id);
Map(m => m.Name);
Map(m => m.OpeningBalance);
Map(m => m.CreationDate);
References(m => m.Person);
References(m => m.AccountType);
HasMany(m => m.Incomes).Inverse().Not.LazyLoad();
HasMany(m => m.Invoices).Inverse().Not.LazyLoad();
HasMany(m => m.InTransfers).Inverse().Not.LazyLoad();
HasMany(m => m.OutTransfers).Inverse().Not.LazyLoad();
}
public StudentSaveMap()
{
CompositeId(x => x.Id)
.KeyProperty(x => x.Emplid, "EMPLID")
.KeyProperty(x => x.CommencementTerm, "COMMENCEMENT_TERM")
.KeyProperty(x => x.CeremonyAcadPlan, "CEREMONY_ACAD_PLAN");
Map(p => p.PriAcadPlan, "PRI_ACAD_PLAN");
Map(p => p.PriAcadDegree, "PRI_ACAD_DEGREE");
Map(p => p.SecAcadPlan, "SEC_ACAD_PLAN");
Map(p => p.SecAcadDegree, "SEC_ACAD_DEGREE");
Map(p => p.ParticipatePriAcadPlan, "PARTICIPATE_PRI_ACAD_PLAN"); // Always '9' in latest term
Map(p => p.ParticipateSecAcadPlan, "PARTICIPATE_SEC_ACAD_PLAN"); // Always '9' in latest term
Map(p => p.StatusAfterGrad, "STATUS_AFTER_GRAD"); // Always null in latest term
Map(p => p.Organization, "ORGANIZATION"); // Always null in latest term
Map(p => p.JobTitle, "JOBTITLE"); // Always null in latest term
Map(p => p.CellPhoneNbr, "CELL_PHONE_NBR");
Table("TEST_ALM_COMMENCEMENT"); //TODO: Change before deployment
SchemaAction.None();
}
