public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <Treballador> builder)
{
builder.ToTable("Treballadors");
builder.HasKey("Id");
builder.Property(c => c.Codi).HasColumnName("Codi").HasMaxLength(50).IsRequired().IsUnicode(false);
builder.Property(c => c.Nom).HasColumnName("Nom").HasMaxLength(50).IsRequired().IsUnicode(false);
builder.Property(c => c.PrimerCognom).HasColumnName("PrimerCognom").HasMaxLength(50).IsRequired().IsUnicode(false);
builder.Property(c => c.SegonCognom).HasColumnName("SegonCognom").HasMaxLength(50).IsRequired().IsUnicode(false);
builder.Property(c => c.NIF).HasColumnName("NIF").HasMaxLength(10).IsRequired().IsUnicode(false);
builder.Property(c => c.NSS).HasColumnName("NSS").HasMaxLength(25).IsUnicode(false);
builder.Property(c => c.Adreça).HasColumnName("Adreça").HasMaxLength(100).IsUnicode(false);
builder.Property(c => c.CP).HasColumnName("CP").HasMaxLength(10).IsRequired().IsUnicode(false);
builder.Property(c => c.Poblacio).HasColumnName("Poblacio").HasMaxLength(50).IsUnicode(false);
builder.Property(c => c.Provincia).HasColumnName("Provincia").HasMaxLength(50).IsUnicode(false);
builder.Property(c => c.Telefon1).HasColumnName("Telefon1").HasMaxLength(15).IsUnicode(false);
builder.Property(c => c.Telefon2).HasColumnName("Telefon2").HasMaxLength(15).IsUnicode(false);
builder.Property(c => c.Telefon3).HasColumnName("Telefon3").HasMaxLength(15).IsUnicode(false);
builder.Property(c => c.Mobil1).HasColumnName("Mobil1").HasMaxLength(15).IsUnicode(false);
builder.Property(c => c.Mobil2).HasColumnName("Mobil2").HasMaxLength(15).IsUnicode(false);
builder.Property(c => c.Mobil3).HasColumnName("Mobil3").HasMaxLength(15).IsUnicode(false);
builder.Property(c => c.Email1).HasColumnName("Email1").HasMaxLength(100).IsUnicode(false);
builder.Property(c => c.Email2).HasColumnName("Email2").HasMaxLength(100).IsUnicode(false);
builder.Property(c => c.Email3).HasColumnName("Email3").HasMaxLength(100).IsUnicode(false);
builder.Property(c => c.DataAlta).HasColumnName("DataAlta").HasColumnType("Date").IsRequired();
builder.Property(c => c.DataBaixa).HasColumnName("DataBaixa").HasColumnType("Date");
builder.Property(c => c.Observacions).HasColumnName("Observacions").HasMaxLength(500).IsUnicode(false);
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <Funcionalidad> builder)
{
builder.HasKey(k => k.FuncionalidadGuid);
builder.Property(p => p.FuncionalidadGuid).ValueGeneratedOnAdd();
builder.Property(p => p.Nombre).IsRequired().HasMaxLength(100);
builder.Property(p => p.Descripcion).IsRequired().HasColumnType("nvarchar(max)");
builder.Property(p => p.PreRequisitos).IsRequired().HasColumnType("nvarchar(max)");
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <ConveniTreballador> builder)
{
builder.ToTable("ConvenisTreballador");
builder.HasKey(c => new { c.ConveniId, c.TreballadorId });
builder.Property(c => c.DataInici).HasColumnName("DataInici").HasColumnType("Date").IsRequired();
builder.Property(c => c.DataFinal).HasColumnName("DataFinal").HasColumnType("Date");
builder.Property(c => c.Observacions).HasColumnName("Observacions").HasMaxLength(500).IsUnicode(false);
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <Modulo> builder)
{
builder.ToTable("Modulo", "flamas").HasKey(c => c.id);
builder.Property(c => c.nombre).HasMaxLength(50);
builder.Property(c => c.categoria).HasMaxLength(50);
builder.Property(c => c.semestre).HasMaxLength(50);
builder.Property(c => c.logo).HasMaxLength(500);
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <PlantillaCalendari> builder)
{
builder.ToTable("PlantillesCalendari");
builder.HasKey("Id");
builder.Property(c => c.DataInici).HasColumnName("DataInici").HasColumnType("Date").IsRequired();
builder.Property(c => c.DataFinal).HasColumnName("DataFinal").HasColumnType("Date");
builder.Property(c => c.Observacions).HasColumnName("Observacions").HasMaxLength(500).IsUnicode(false);
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <Conveni> builder)
{
builder.ToTable("Convenis");
builder.HasKey("Id");
builder.Property(c => c.Codi).HasColumnName("Codi").HasMaxLength(50).IsRequired().IsUnicode(false);
builder.Property(c => c.Nom).HasColumnName("Nom").HasMaxLength(100).IsRequired().IsUnicode(false);
builder.Property(c => c.HoresAnuals).HasColumnName("HoresAnuals").IsRequired();
builder.Property(c => c.DataInici).HasColumnName("DataInici").HasColumnType("Date").IsRequired();
builder.Property(c => c.DataFinal).HasColumnName("DataFinal").HasColumnType("Date");
builder.Property(c => c.Observacions).HasColumnName("Observacions").HasMaxLength(500).IsUnicode(false);
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <TipoConta> builder)
{
#region Configurancao do TipoConta
builder.Property(x => x.Descricao)
.HasColumnType("varchar(500)");
#endregion
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <DetallPlantillaCalendari> builder)
{
builder.ToTable("DetallsPlantillaCalendari");
builder.HasKey("Id");
builder.Property(d => d.DataInicial).HasColumnName("DataInicial").HasColumnType("Date").IsRequired();
builder.Property(d => d.DataFinal).HasColumnName("DataFinal").HasColumnType("Date").IsRequired();
builder.Property(d => d.HoraInici1).HasColumnName("HoraInici1");
builder.Property(d => d.HoraFinal1).HasColumnName("HoraFinal1");
builder.Property(d => d.HoraInici2).HasColumnName("HoraInici2");
builder.Property(d => d.HoraFinal2).HasColumnName("HoraFinal2");
builder.Property(d => d.HoraInici3).HasColumnName("HoraInici3");
builder.Property(d => d.HoraFinal3).HasColumnName("HoraFinal3");
builder.Property(d => d.Vacances).HasColumnName("Vacances").IsRequired();
builder.Property(d => d.Observacions).HasColumnName("Observacions").HasMaxLength(500).IsUnicode(false);
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <ChatEntity> builder)
{
builder.ToTable("Chat");
builder.HasKey(p => p.Id);
builder.Property(p => p.Id)
.ValueGeneratedOnAdd();
builder.Property(p => p.Name)
.IsRequired()
.HasMaxLength(50);
builder.Property(p => p.CreateAt)
.IsRequired();
builder.Property(p => p.Description)
.IsRequired();
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <Rol> builder)
{
builder.ToTable("rol")
.HasKey(r => r.idrol);
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <Salon> builder)
{
builder.ToTable("Salon");
builder.HasData
(
new Salon {
Name = "Salon BEA",
FullName = "Salon Fryzjerski BEA Beata Bunar",
AddressCity = "Gliwice",
AddressStreet = "Zygmunta Starego ",
AddressBuildingNumber = 1,
AddressApartmentNumber = 2,
PhoneNumber = "32 238 21 93",
WorkingHours = new List <WorkingHour> {
new WorkingHour {
DayOfWeek = DayOfWeek.Monday, OpenHour = "8:00", CloseHour = "18:00"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Tuesday, OpenHour = "8:00", CloseHour = "18:00"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Wednesday, OpenHour = "8:00", CloseHour = "18:00"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Thursday, OpenHour = "8:00", CloseHour = "18:00"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Friday, OpenHour = "8:00", CloseHour = "18:00"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Saturday, OpenHour = "8:00", CloseHour = "13:00"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Sunday, OpenHour = "0", CloseHour = "0"
}
}
},
new Salon {
Name = "Art Fryzjer",
FullName = "ART FRYZJER SP Z O O",
AddressCity = "Warszawa",
AddressStreet = "Warszawa",
AddressBuildingNumber = 15,
AddressApartmentNumber = 23,
PhoneNumber = "500500500",
WorkingHours = new List <WorkingHour> {
new WorkingHour {
DayOfWeek = DayOfWeek.Monday, OpenHour = "10:00", CloseHour = "18:00"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Tuesday, OpenHour = "10:00", CloseHour = "18:00"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Wednesday, OpenHour = "10:00", CloseHour = "18:00"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Thursday, OpenHour = "10:00", CloseHour = "18:00"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Friday, OpenHour = "10:00", CloseHour = "18:00"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Saturday, OpenHour = "12:00", CloseHour = "18:00"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Sunday, OpenHour = "12:00", CloseHour = "18:00"
}
}
},
new Salon {
Name = "Salon Fryzjerski",
FullName = "Salon Fryzjerski Dla Pań i Panów Bożena Drewek",
AddressCity = "Kartuzy",
AddressStreet = "3 maja",
AddressBuildingNumber = 3,
PhoneNumber = "589101189",
WorkingHours = new List <WorkingHour> {
new WorkingHour {
DayOfWeek = DayOfWeek.Monday, OpenHour = "8:00", CloseHour = "18:00"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Tuesday, OpenHour = "8:00", CloseHour = "18:00"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Wednesday, OpenHour = "8:00", CloseHour = "18:00"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Thursday, OpenHour = "8:00", CloseHour = "18:00"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Friday, OpenHour = "8:00", CloseHour = "18:00"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Saturday, OpenHour = "0", CloseHour = "0"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Sunday, OpenHour = "0", CloseHour = "0"
}
}
},
new Salon {
Name = "Twój fryzjer",
FullName = "TWÓJ FRYZJER SP Z O O",
AddressCity = "Katowice",
AddressStreet = "Gliwicka",
AddressBuildingNumber = 155,
PhoneNumber = "364918344",
WorkingHours = new List <WorkingHour> {
new WorkingHour {
DayOfWeek = DayOfWeek.Monday, OpenHour = "8:00", CloseHour = "18:00"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Tuesday, OpenHour = "8:00", CloseHour = "18:00"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Wednesday, OpenHour = "8:00", CloseHour = "18:00"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Thursday, OpenHour = "8:00", CloseHour = "18:00"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Friday, OpenHour = "8:00", CloseHour = "18:00"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Saturday, OpenHour = "8:00", CloseHour = "13:00"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Sunday, OpenHour = "0", CloseHour = "0"
}
}
},
new Salon {
Name = "Super fryzjer",
AddressCity = "Opole",
AddressStreet = "Komandosow",
AddressBuildingNumber = 12,
AddressApartmentNumber = 22,
PhoneNumber = "500000000",
WorkingHours = new List <WorkingHour> {
new WorkingHour {
DayOfWeek = DayOfWeek.Monday, OpenHour = "0", CloseHour = "0"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Tuesday, OpenHour = "0", CloseHour = "0"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Wednesday, OpenHour = "0", CloseHour = "0"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Thursday, OpenHour = "0", CloseHour = "0"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Friday, OpenHour = "0", CloseHour = "0"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Saturday, OpenHour = "0", CloseHour = "0"
},
new WorkingHour {
DayOfWeek = DayOfWeek.Sunday, OpenHour = "0", CloseHour = "0"
}
}
}
);
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <ChargeLog> builder)
{
}
public void Configure(Microsoft.EntityFrameworkCore.Metadata.Builders.EntityTypeBuilder <AppUser> builder)
{
SetupAdmin(builder);
SetupPowerUser(builder);
}
