public async void GetRaspunsuri_GetSectiiCuObservatori_ReturneazaRaspunsPaginat(int page, int pageSize, bool urgent)
{
// ARRANGE
const int idONG = 1; // TODO set the idONG in token and use it as a param for the test
int countObservatori;
using (var context = new OngContext(_raspunsuriFixture.ContextOptions))
{
countObservatori = await context.Raspuns
.Where(x => x.IdObservatorNavigation.IdOng == idONG && x.IdRaspunsDisponibilNavigation.RaspunsCuFlag == urgent)
.Select(y =>
new { y.IdObservator, Observator = y.IdObservatorNavigation.NumeIntreg, IdSectie = y.IdSectieDeVotare, Sectie = y.IdSectieDeVotareNavigation.DenumireUat, y.DataUltimeiModificari }
)
.Distinct()
.CountAsync();
}
// ACT
var response = await _client.GetAsync($"api/v1/raspunsuri?page={page}&pagesize={pageSize}&urgent={urgent}");
// ASSERT
response.EnsureSuccessStatusCode();
var model = JsonConvert.DeserializeObject <ApiListResponse <RaspunsModel> >(await response.Content.ReadAsStringAsync());
Assert.NotNull(model);
Assert.NotNull(model.Data);
Assert.True(pageSize >= model.Data.Count);
Assert.Equal(page, model.Page);
Assert.Equal(pageSize, model.PageSize);
Assert.Equal(countObservatori, model.TotalPages);
}
public override void SeedData()
{
base.SeedData();
using (var context = new OngContext(ContextOptions))
{
using (var tran = context.Database.BeginTransaction())
{
SeedOngs(context);
SeedSectiiDeVotare(context, 1);
SeedSectiiDeVotare(context, 2);
SeedSectiiDeVotare(context, 3);
SeedSectiiDeVotare(context, 4);
SeedSectiiDeVotare(context, 5);
SeedObservatoriCuRaspunsuri(context, 1);
SeedObservatoriCuRaspunsuri(context, 2);
SeedObservatoriCuRaspunsuri(context, 3);
SeedObservatoriCuRaspunsuri(context, 4);
SeedObservatoriCuRaspunsuri(context, 5);
SeedObservatoriCuRaspunsuri(context, 6);
tran.Commit();
}
}
}
private void SeedSectiiDeVotare(OngContext context, int idJudet)
{
if (context.SectieDeVotare.Any(a => a.IdJudet == idJudet))
{
return;
}
context.SectieDeVotare.AddRange(
new SectieDeVotare {
IdSectieDeVotarre = idJudet * 10 + 1, IdJudet = idJudet, DenumireUat = $"Sectia {idJudet * 10 + 1}", NumarSectie = 1, LocalitateComponenta = $"Localitate {idJudet * 10 + 1}"
},
new SectieDeVotare {
IdSectieDeVotarre = idJudet * 10 + 2, IdJudet = idJudet, DenumireUat = $"Sectia {idJudet * 10 + 2}", NumarSectie = 2, LocalitateComponenta = $"Localitate {idJudet * 10 + 2}"
},
new SectieDeVotare {
IdSectieDeVotarre = idJudet * 10 + 3, IdJudet = idJudet, DenumireUat = $"Sectia {idJudet * 10 + 3}", NumarSectie = 3, LocalitateComponenta = $"Localitate {idJudet * 10 + 3}"
},
new SectieDeVotare {
IdSectieDeVotarre = idJudet * 10 + 4, IdJudet = idJudet, DenumireUat = $"Sectia {idJudet * 10 + 4}", NumarSectie = 4, LocalitateComponenta = $"Localitate {idJudet * 10 + 4}"
},
new SectieDeVotare {
IdSectieDeVotarre = idJudet * 10 + 5, IdJudet = idJudet, DenumireUat = $"Sectia {idJudet * 10 + 5}", NumarSectie = 5, LocalitateComponenta = $"Localitate {idJudet * 10 + 5}"
}
);
context.SaveChanges();
}
private void SeedOngs(OngContext context)
{
if (context.Ong.Any())
{
return;
}
context.Ong.AddRange(
new Domain.Ong.Models.Ong {
IdOng = 1, NumeOng = "Denumire ONG A", AbreviereNumeOng = "ONG A"
},
new Domain.Ong.Models.Ong {
IdOng = 2, NumeOng = "Denumire ONG B", AbreviereNumeOng = "ONG B"
},
new Domain.Ong.Models.Ong {
IdOng = 3, NumeOng = "Denumire ONG C", AbreviereNumeOng = "ONG C"
},
new Domain.Ong.Models.Ong {
IdOng = 4, NumeOng = "Denumire ONG D", AbreviereNumeOng = "ONG D"
},
new Domain.Ong.Models.Ong {
IdOng = 5, NumeOng = "Denumire ONG E", AbreviereNumeOng = "ONG E"
},
new Domain.Ong.Models.Ong {
IdOng = 6, NumeOng = "Denumire ONG F", AbreviereNumeOng = "ONG F"
}
);
context.SaveChanges();
}
public virtual void SeedData()
{
using (var c = new OngContext(ContextOptions))
{
c.Database.EnsureCreated();
c.EnsureSeedData();
}
}
private static void DataCleanUp(this OngContext context)
{
context.Database.ExecuteSqlCommand("delete from RaspunsDisponibil");
context.Database.ExecuteSqlCommand("delete from Intrebare");
context.Database.ExecuteSqlCommand("delete from Sectiune");
context.Database.ExecuteSqlCommand("delete from VersiuneFormular");
// context.Database.ExecuteSqlCommand("delete from Judet");
}
private static void SeedOptiuni(this OngContext context)
{
if (context.Optiune.Any())
{
return;
}
context.Optiune.AddRange(
new Optiune {
IdOptiune = 1, TextOptiune = "Da",
},
new Optiune {
IdOptiune = 2, TextOptiune = "Nu",
},
new Optiune {
IdOptiune = 3, TextOptiune = "Nu stiu",
},
new Optiune {
IdOptiune = 4, TextOptiune = "Dark Island",
},
new Optiune {
IdOptiune = 5, TextOptiune = "London Pride",
},
new Optiune {
IdOptiune = 6, TextOptiune = "Zaganu",
},
new Optiune {
IdOptiune = 7, TextOptiune = "Transmisia manualã",
},
new Optiune {
IdOptiune = 8, TextOptiune = "Transmisia automatã",
},
new Optiune {
IdOptiune = 9, TextOptiune = "Altele (specificaţi)", SeIntroduceText = true
},
new Optiune {
IdOptiune = 10, TextOptiune = "Metrou"
},
new Optiune {
IdOptiune = 11, TextOptiune = "Tramvai"
},
new Optiune {
IdOptiune = 12, TextOptiune = "Autobuz"
}
);
context.SaveChanges();
}
public async void GetRaspunsuri_GetSectiiCuObservatori_ReturneazaRaspunsuriOrdonateDupaDataModificareDesc(int page, int pageSize, bool urgent)
{
// ARRANGE
const int idONG = 1; // TODO set the idONG in token and use it as a param for the test
RaspunsModel first, last;
using (var context = new OngContext(_raspunsuriFixture.ContextOptions))
{
var sectiiCuObservatori = await context.Raspuns
.Where(x => x.IdObservatorNavigation.IdOng == idONG && x.IdRaspunsDisponibilNavigation.RaspunsCuFlag == urgent)
.Select(y =>
new { y.IdObservator, Observator = y.IdObservatorNavigation.NumeIntreg, IdSectie = y.IdSectieDeVotare, Sectie = y.IdSectieDeVotareNavigation.DenumireUat, y.DataUltimeiModificari }
)
.Distinct()
.OrderByDescending(x => x.DataUltimeiModificari)
.Skip((page - 1) * pageSize)
.Take(pageSize)
.ToListAsync();
var sectieFirst = sectiiCuObservatori.First();
var sectieLast = sectiiCuObservatori.Last();
first = new RaspunsModel {
IdObservator = sectieFirst.IdObservator, IdSectie = sectieFirst.IdSectie
};
last = new RaspunsModel {
IdObservator = sectieFirst.IdObservator, IdSectie = sectieLast.IdSectie
};
}
// ACT
var response = await _client.GetAsync($"api/v1/raspunsuri?page={page}&pagesize={pageSize}&urgent={urgent}");
// ASSERT
response.EnsureSuccessStatusCode();
var model = JsonConvert.DeserializeObject <ApiListResponse <RaspunsModel> >(await response.Content.ReadAsStringAsync());
Assert.NotNull(model);
Assert.NotNull(model.Data);
var firstModel = model.Data.First();
var lastModel = model.Data.Last();
Assert.Equal(first.IdObservator, firstModel.IdObservator);
Assert.Equal(first.IdSectie, firstModel.IdSectie);
Assert.Equal(last.IdObservator, firstModel.IdObservator);
Assert.Equal(last.IdObservator, firstModel.IdObservator);
}
private static void SeedSectiune(this OngContext context)
{
if (context.Sectiune.Any())
{
return;
}
context.Sectiune.AddRange(
new Sectiune {
IdSectiune = 1, CodSectiune = "B", Descriere = "Despre Bere"
},
new Sectiune {
IdSectiune = 2, CodSectiune = "C", Descriere = "Descriere masini"
}
);
context.SaveChanges();
}
private static void SeedVersions(this OngContext context)
{
if (context.VersiuneFormular.Any())
{
return;
}
context.VersiuneFormular.AddRange(
new VersiuneFormular {
CodFormular = "A", VersiuneaCurenta = 1
},
new VersiuneFormular {
CodFormular = "B", VersiuneaCurenta = 1
},
new VersiuneFormular {
CodFormular = "C", VersiuneaCurenta = 1
}
);
context.SaveChanges();
}
public static void EnsureSeedData(this OngContext context)
{
if (!context.AllMigrationsApplied())
{
return;
}
using (var tran = context.Database.BeginTransaction())
{
context.DataCleanUp();
context.SeedVersions();
context.SeedJudete();
context.SeedSectiune();
context.SeedOptiuni();
context.SeedQuestions('A');
context.SeedQuestions('B');
context.SeedQuestions('C');
tran.Commit();
}
}
public AdminQueryHandler(OngContext context, IHashService hash)
{
_context = context;
_hash = hash;
}
public BaseRepository()
{
db = new OngContext();
}
public RaspunsuriQueryHandler(OngContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public MiniStatisticsQueryHandler(OngContext context)
{
_context = context;
}
private static void SeedQuestions(this OngContext context, char idFormular)
{
if (context.Intrebare.Any(a => a.CodFormular == idFormular.ToString()))
{
return;
}
context.Intrebare.AddRange(
// primul formular
new Intrebare
{
IdIntrebare = idFormular * 20 + 1,
CodFormular = idFormular.ToString(),
IdSectiune = 1, //B
IdTipIntrebare = TipIntrebareEnum.OSinguraOptiune,
TextIntrebare = $"{idFormular}: Iti place berea? (se alege o singura optiune selectabila)",
RaspunsDisponibil = new List <RaspunsDisponibil>
{
new RaspunsDisponibil {
IdRaspunsDisponibil = idFormular * 20 + 1, IdOptiune = 1
},
new RaspunsDisponibil {
IdRaspunsDisponibil = idFormular * 20 + 2, IdOptiune = 2, RaspunsCuFlag = true
},
new RaspunsDisponibil {
IdRaspunsDisponibil = idFormular * 20 + 3, IdOptiune = 3
}
}
},
new Intrebare
{
IdIntrebare = idFormular * 20 + 2,
CodFormular = idFormular.ToString(),
IdSectiune = 1, //B
IdTipIntrebare = TipIntrebareEnum.OptiuniMultiple,
TextIntrebare = $"{idFormular}: Ce tipuri de bere iti plac? (se pot alege optiuni multiple)",
RaspunsDisponibil = new List <RaspunsDisponibil>
{
new RaspunsDisponibil {
IdRaspunsDisponibil = idFormular * 20 + 4, IdOptiune = 4, RaspunsCuFlag = true
},
new RaspunsDisponibil {
IdRaspunsDisponibil = idFormular * 20 + 5, IdOptiune = 5
},
new RaspunsDisponibil {
IdRaspunsDisponibil = idFormular * 20 + 6, IdOptiune = 6
}
}
},
new Intrebare
{
IdIntrebare = idFormular * 20 + 3,
CodFormular = idFormular.ToString(),
IdSectiune = 2, //C
IdTipIntrebare = TipIntrebareEnum.OSinguraOptiuneCuText,
TextIntrebare = $"{idFormular}: Ce tip de transmisie are masina ta? (se poate alege O singura optiune selectabila + text pe O singura optiune)",
RaspunsDisponibil = new List <RaspunsDisponibil>
{
new RaspunsDisponibil {
IdRaspunsDisponibil = idFormular * 20 + 7, IdOptiune = 7, RaspunsCuFlag = true
},
new RaspunsDisponibil {
IdRaspunsDisponibil = idFormular * 20 + 8, IdOptiune = 8
},
new RaspunsDisponibil {
IdRaspunsDisponibil = idFormular * 20 + 9, IdOptiune = 9
}
}
},
new Intrebare
{
IdIntrebare = idFormular * 20 + 4,
CodFormular = idFormular.ToString(),
IdSectiune = 2, //C
IdTipIntrebare = TipIntrebareEnum.OptiuniMultipleCuText,
TextIntrebare = $"{idFormular}: Ce mijloace de transport folosesti sa ajungi la birou? (se pot alege mai multe optiuni + text pe O singura optiune)",
RaspunsDisponibil = new List <RaspunsDisponibil>
{
new RaspunsDisponibil {
IdRaspunsDisponibil = idFormular * 20 + 10, IdOptiune = 10, RaspunsCuFlag = true
},
new RaspunsDisponibil {
IdRaspunsDisponibil = idFormular * 20 + 11, IdOptiune = 11
},
new RaspunsDisponibil {
IdRaspunsDisponibil = idFormular * 20 + 12, IdOptiune = 12
},
new RaspunsDisponibil {
IdRaspunsDisponibil = idFormular * 20 + 13, IdOptiune = 9
}
}
}
);
context.SaveChanges();
}
private void SeedObservatoriCuRaspunsuri(OngContext context, int idOng)
{
if (context.Observator.Any(a => a.IdOng == idOng))
{
return;
}
var listaObservatori = new List <Observator>
{
new Observator {
IdOng = idOng, NumeIntreg = "Popescu Florin", NumarTelefon = "0763000000", EsteDinEchipa = true
},
new Observator {
IdOng = idOng, NumeIntreg = "Cremarenco Alin", NumarTelefon = "0763000001", EsteDinEchipa = false
},
new Observator {
IdOng = idOng, NumeIntreg = "Chivu Marin", NumarTelefon = "0763000002", EsteDinEchipa = false
},
new Observator {
IdOng = idOng, NumeIntreg = "Neacsu Andreea", NumarTelefon = "0763000004", EsteDinEchipa = true
},
new Observator {
IdOng = idOng, NumeIntreg = "Stanciu Florina", NumarTelefon = "0763000003", EsteDinEchipa = false
},
new Observator {
IdOng = idOng, NumeIntreg = "Neacsu Andreea", NumarTelefon = "0763000004", EsteDinEchipa = true
},
new Observator {
IdOng = idOng, NumeIntreg = "Duta Andrei", NumarTelefon = "0763000005", EsteDinEchipa = true
},
new Observator {
IdOng = idOng, NumeIntreg = "Vlad George", NumarTelefon = "0763000007", EsteDinEchipa = true
},
new Observator {
IdOng = idOng, NumeIntreg = "Pascu Dan", NumarTelefon = "0763000008", EsteDinEchipa = true
},
new Observator {
IdOng = idOng, NumeIntreg = "Stan Stefan", NumarTelefon = "0763000010", EsteDinEchipa = true
},
new Observator {
IdOng = idOng, NumeIntreg = "Petrache Razvan", NumarTelefon = "0763000011", EsteDinEchipa = false
},
new Observator {
IdOng = idOng, NumeIntreg = "Dumbrava Valeria", NumarTelefon = "0763000009", EsteDinEchipa = true
}
};
context.Observator.AddRange(listaObservatori);
var listaRaspunsuri = new List <Raspuns>
{
new Raspuns {
IdObservator = listaObservatori[0].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 1, IdSectieDeVotare = 11, DataUltimeiModificari = DateTime.Now
},
new Raspuns {
IdObservator = listaObservatori[0].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 5, IdSectieDeVotare = 11, DataUltimeiModificari = DateTime.Now
},
new Raspuns {
IdObservator = listaObservatori[0].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 8, IdSectieDeVotare = 11, DataUltimeiModificari = DateTime.Now
},
new Raspuns {
IdObservator = listaObservatori[0].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 13, IdSectieDeVotare = 11, DataUltimeiModificari = DateTime.Now
},
new Raspuns {
IdObservator = listaObservatori[0].IdObservator, IdRaspunsDisponibil = 'B' * 20 + 2, IdSectieDeVotare = 11, DataUltimeiModificari = DateTime.Now.AddMinutes(10)
},
new Raspuns {
IdObservator = listaObservatori[0].IdObservator, IdRaspunsDisponibil = 'B' * 20 + 5, IdSectieDeVotare = 11, DataUltimeiModificari = DateTime.Now.AddMinutes(10)
},
new Raspuns {
IdObservator = listaObservatori[0].IdObservator, IdRaspunsDisponibil = 'B' * 20 + 9, IdSectieDeVotare = 11, DataUltimeiModificari = DateTime.Now.AddMinutes(10)
},
new Raspuns {
IdObservator = listaObservatori[0].IdObservator, IdRaspunsDisponibil = 'B' * 20 + 12, IdSectieDeVotare = 11, DataUltimeiModificari = DateTime.Now.AddMinutes(10)
},
new Raspuns {
IdObservator = listaObservatori[1].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 2, IdSectieDeVotare = 12, DataUltimeiModificari = DateTime.Now.AddMinutes(20)
},
new Raspuns {
IdObservator = listaObservatori[1].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 4, IdSectieDeVotare = 12, DataUltimeiModificari = DateTime.Now.AddMinutes(20)
},
new Raspuns {
IdObservator = listaObservatori[1].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 7, IdSectieDeVotare = 12, DataUltimeiModificari = DateTime.Now.AddMinutes(20)
},
new Raspuns {
IdObservator = listaObservatori[1].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 11, IdSectieDeVotare = 12, DataUltimeiModificari = DateTime.Now.AddMinutes(20)
},
new Raspuns {
IdObservator = listaObservatori[1].IdObservator, IdRaspunsDisponibil = 'C' * 20 + 2, IdSectieDeVotare = 12, DataUltimeiModificari = DateTime.Now.AddMinutes(-20)
},
new Raspuns {
IdObservator = listaObservatori[1].IdObservator, IdRaspunsDisponibil = 'C' * 20 + 5, IdSectieDeVotare = 12, DataUltimeiModificari = DateTime.Now.AddMinutes(-20)
},
new Raspuns {
IdObservator = listaObservatori[1].IdObservator, IdRaspunsDisponibil = 'C' * 20 + 9, IdSectieDeVotare = 12, DataUltimeiModificari = DateTime.Now.AddMinutes(-20)
},
new Raspuns {
IdObservator = listaObservatori[1].IdObservator, IdRaspunsDisponibil = 'C' * 20 + 12, IdSectieDeVotare = 12, DataUltimeiModificari = DateTime.Now.AddMinutes(-20)
},
new Raspuns {
IdObservator = listaObservatori[2].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 3, IdSectieDeVotare = 13, DataUltimeiModificari = DateTime.Now.AddMinutes(30)
},
new Raspuns {
IdObservator = listaObservatori[2].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 4, IdSectieDeVotare = 13, DataUltimeiModificari = DateTime.Now.AddMinutes(30)
},
new Raspuns {
IdObservator = listaObservatori[2].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 8, IdSectieDeVotare = 13, DataUltimeiModificari = DateTime.Now.AddMinutes(30)
},
new Raspuns {
IdObservator = listaObservatori[2].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 10, IdSectieDeVotare = 13, DataUltimeiModificari = DateTime.Now.AddMinutes(30)
},
new Raspuns {
IdObservator = listaObservatori[2].IdObservator, IdRaspunsDisponibil = 'C' * 20 + 2, IdSectieDeVotare = 12, DataUltimeiModificari = DateTime.Now.AddMinutes(-20)
},
new Raspuns {
IdObservator = listaObservatori[2].IdObservator, IdRaspunsDisponibil = 'C' * 20 + 4, IdSectieDeVotare = 12, DataUltimeiModificari = DateTime.Now.AddMinutes(-20)
},
new Raspuns {
IdObservator = listaObservatori[2].IdObservator, IdRaspunsDisponibil = 'C' * 20 + 8, IdSectieDeVotare = 12, DataUltimeiModificari = DateTime.Now.AddMinutes(-20)
},
new Raspuns {
IdObservator = listaObservatori[2].IdObservator, IdRaspunsDisponibil = 'C' * 20 + 12, IdSectieDeVotare = 12, DataUltimeiModificari = DateTime.Now.AddMinutes(-20)
},
new Raspuns {
IdObservator = listaObservatori[2].IdObservator, IdRaspunsDisponibil = 'B' * 20 + 1, IdSectieDeVotare = 13, DataUltimeiModificari = DateTime.Now.AddMinutes(20)
},
new Raspuns {
IdObservator = listaObservatori[2].IdObservator, IdRaspunsDisponibil = 'B' * 20 + 5, IdSectieDeVotare = 13, DataUltimeiModificari = DateTime.Now.AddMinutes(20)
},
new Raspuns {
IdObservator = listaObservatori[2].IdObservator, IdRaspunsDisponibil = 'B' * 20 + 9, IdSectieDeVotare = 13, DataUltimeiModificari = DateTime.Now.AddMinutes(20)
},
new Raspuns {
IdObservator = listaObservatori[2].IdObservator, IdRaspunsDisponibil = 'B' * 20 + 10, IdSectieDeVotare = 13, DataUltimeiModificari = DateTime.Now.AddMinutes(20)
},
new Raspuns {
IdObservator = listaObservatori[3].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 1, IdSectieDeVotare = 11, DataUltimeiModificari = DateTime.Now
},
new Raspuns {
IdObservator = listaObservatori[3].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 5, IdSectieDeVotare = 11, DataUltimeiModificari = DateTime.Now
},
new Raspuns {
IdObservator = listaObservatori[3].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 8, IdSectieDeVotare = 11, DataUltimeiModificari = DateTime.Now
},
new Raspuns {
IdObservator = listaObservatori[3].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 13, IdSectieDeVotare = 11, DataUltimeiModificari = DateTime.Now
},
new Raspuns {
IdObservator = listaObservatori[4].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 1, IdSectieDeVotare = 11, DataUltimeiModificari = DateTime.Now
},
new Raspuns {
IdObservator = listaObservatori[4].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 5, IdSectieDeVotare = 11, DataUltimeiModificari = DateTime.Now
},
new Raspuns {
IdObservator = listaObservatori[4].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 8, IdSectieDeVotare = 11, DataUltimeiModificari = DateTime.Now
},
new Raspuns {
IdObservator = listaObservatori[4].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 13, IdSectieDeVotare = 11, DataUltimeiModificari = DateTime.Now
},
new Raspuns {
IdObservator = listaObservatori[5].IdObservator, IdRaspunsDisponibil = 'B' * 20 + 1, IdSectieDeVotare = 14, DataUltimeiModificari = DateTime.Now
},
new Raspuns {
IdObservator = listaObservatori[5].IdObservator, IdRaspunsDisponibil = 'B' * 20 + 5, IdSectieDeVotare = 14, DataUltimeiModificari = DateTime.Now
},
new Raspuns {
IdObservator = listaObservatori[5].IdObservator, IdRaspunsDisponibil = 'B' * 20 + 8, IdSectieDeVotare = 14, DataUltimeiModificari = DateTime.Now
},
new Raspuns {
IdObservator = listaObservatori[5].IdObservator, IdRaspunsDisponibil = 'B' * 20 + 13, IdSectieDeVotare = 14, DataUltimeiModificari = DateTime.Now
},
new Raspuns {
IdObservator = listaObservatori[6].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 2, IdSectieDeVotare = 15, DataUltimeiModificari = DateTime.Now.AddMinutes(30)
},
new Raspuns {
IdObservator = listaObservatori[6].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 4, IdSectieDeVotare = 15, DataUltimeiModificari = DateTime.Now.AddMinutes(30)
},
new Raspuns {
IdObservator = listaObservatori[6].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 7, IdSectieDeVotare = 15, DataUltimeiModificari = DateTime.Now.AddMinutes(30)
},
new Raspuns {
IdObservator = listaObservatori[6].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 11, IdSectieDeVotare = 15, DataUltimeiModificari = DateTime.Now.AddMinutes(30)
},
new Raspuns {
IdObservator = listaObservatori[6].IdObservator, IdRaspunsDisponibil = 'B' * 20 + 2, IdSectieDeVotare = 15, DataUltimeiModificari = DateTime.Now.AddMinutes(-25)
},
new Raspuns {
IdObservator = listaObservatori[6].IdObservator, IdRaspunsDisponibil = 'B' * 20 + 5, IdSectieDeVotare = 15, DataUltimeiModificari = DateTime.Now.AddMinutes(-25)
},
new Raspuns {
IdObservator = listaObservatori[6].IdObservator, IdRaspunsDisponibil = 'B' * 20 + 9, IdSectieDeVotare = 15, DataUltimeiModificari = DateTime.Now.AddMinutes(-25)
},
new Raspuns {
IdObservator = listaObservatori[6].IdObservator, IdRaspunsDisponibil = 'B' * 20 + 12, IdSectieDeVotare = 15, DataUltimeiModificari = DateTime.Now.AddMinutes(-25)
},
new Raspuns {
IdObservator = listaObservatori[7].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 1, IdSectieDeVotare = 25, DataUltimeiModificari = DateTime.Now.AddMinutes(40)
},
new Raspuns {
IdObservator = listaObservatori[7].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 5, IdSectieDeVotare = 25, DataUltimeiModificari = DateTime.Now.AddMinutes(40)
},
new Raspuns {
IdObservator = listaObservatori[7].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 7, IdSectieDeVotare = 25, DataUltimeiModificari = DateTime.Now.AddMinutes(40)
},
new Raspuns {
IdObservator = listaObservatori[7].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 13, IdSectieDeVotare = 25, DataUltimeiModificari = DateTime.Now.AddMinutes(40)
},
new Raspuns {
IdObservator = listaObservatori[7].IdObservator, IdRaspunsDisponibil = 'B' * 20 + 2, IdSectieDeVotare = 25, DataUltimeiModificari = DateTime.Now.AddMinutes(-25)
},
new Raspuns {
IdObservator = listaObservatori[7].IdObservator, IdRaspunsDisponibil = 'B' * 20 + 4, IdSectieDeVotare = 25, DataUltimeiModificari = DateTime.Now.AddMinutes(-25)
},
new Raspuns {
IdObservator = listaObservatori[7].IdObservator, IdRaspunsDisponibil = 'B' * 20 + 8, IdSectieDeVotare = 25, DataUltimeiModificari = DateTime.Now.AddMinutes(-25)
},
new Raspuns {
IdObservator = listaObservatori[7].IdObservator, IdRaspunsDisponibil = 'B' * 20 + 11, IdSectieDeVotare = 25, DataUltimeiModificari = DateTime.Now.AddMinutes(-25)
},
new Raspuns {
IdObservator = listaObservatori[8].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 1, IdSectieDeVotare = 22, DataUltimeiModificari = DateTime.Now.AddMinutes(30)
},
new Raspuns {
IdObservator = listaObservatori[8].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 5, IdSectieDeVotare = 22, DataUltimeiModificari = DateTime.Now.AddMinutes(30)
},
new Raspuns {
IdObservator = listaObservatori[8].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 9, IdSectieDeVotare = 22, DataUltimeiModificari = DateTime.Now.AddMinutes(30)
},
new Raspuns {
IdObservator = listaObservatori[8].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 11, IdSectieDeVotare = 22, DataUltimeiModificari = DateTime.Now.AddMinutes(30)
},
new Raspuns {
IdObservator = listaObservatori[8].IdObservator, IdRaspunsDisponibil = 'C' * 20 + 3, IdSectieDeVotare = 22, DataUltimeiModificari = DateTime.Now.AddMinutes(-20)
},
new Raspuns {
IdObservator = listaObservatori[8].IdObservator, IdRaspunsDisponibil = 'C' * 20 + 5, IdSectieDeVotare = 22, DataUltimeiModificari = DateTime.Now.AddMinutes(-20)
},
new Raspuns {
IdObservator = listaObservatori[8].IdObservator, IdRaspunsDisponibil = 'C' * 20 + 7, IdSectieDeVotare = 22, DataUltimeiModificari = DateTime.Now.AddMinutes(-20)
},
new Raspuns {
IdObservator = listaObservatori[8].IdObservator, IdRaspunsDisponibil = 'C' * 20 + 12, IdSectieDeVotare = 22, DataUltimeiModificari = DateTime.Now.AddMinutes(-20)
},
new Raspuns {
IdObservator = listaObservatori[8].IdObservator, IdRaspunsDisponibil = 'B' * 20 + 1, IdSectieDeVotare = 22, DataUltimeiModificari = DateTime.Now.AddMinutes(20)
},
new Raspuns {
IdObservator = listaObservatori[8].IdObservator, IdRaspunsDisponibil = 'B' * 20 + 5, IdSectieDeVotare = 22, DataUltimeiModificari = DateTime.Now.AddMinutes(20)
},
new Raspuns {
IdObservator = listaObservatori[8].IdObservator, IdRaspunsDisponibil = 'B' * 20 + 8, IdSectieDeVotare = 22, DataUltimeiModificari = DateTime.Now.AddMinutes(20)
},
new Raspuns {
IdObservator = listaObservatori[8].IdObservator, IdRaspunsDisponibil = 'B' * 20 + 11, IdSectieDeVotare = 22, DataUltimeiModificari = DateTime.Now.AddMinutes(20)
},
new Raspuns {
IdObservator = listaObservatori[8].IdObservator, IdRaspunsDisponibil = 'C' * 20 + 3, IdSectieDeVotare = 23, DataUltimeiModificari = DateTime.Now.AddMinutes(-20)
},
new Raspuns {
IdObservator = listaObservatori[8].IdObservator, IdRaspunsDisponibil = 'C' * 20 + 6, IdSectieDeVotare = 23, DataUltimeiModificari = DateTime.Now.AddMinutes(-20)
},
new Raspuns {
IdObservator = listaObservatori[8].IdObservator, IdRaspunsDisponibil = 'C' * 20 + 8, IdSectieDeVotare = 23, DataUltimeiModificari = DateTime.Now.AddMinutes(-20)
},
new Raspuns {
IdObservator = listaObservatori[8].IdObservator, IdRaspunsDisponibil = 'C' * 20 + 12, IdSectieDeVotare = 23, DataUltimeiModificari = DateTime.Now.AddMinutes(-20)
},
new Raspuns {
IdObservator = listaObservatori[9].IdObservator, IdRaspunsDisponibil = 'C' * 20 + 1, IdSectieDeVotare = 11, DataUltimeiModificari = DateTime.Now
},
new Raspuns {
IdObservator = listaObservatori[9].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 5, IdSectieDeVotare = 11, DataUltimeiModificari = DateTime.Now
},
new Raspuns {
IdObservator = listaObservatori[9].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 9, IdSectieDeVotare = 11, DataUltimeiModificari = DateTime.Now
},
new Raspuns {
IdObservator = listaObservatori[9].IdObservator, IdRaspunsDisponibil = 'A' * 20 + 11, IdSectieDeVotare = 11, DataUltimeiModificari = DateTime.Now
},
};
context.Raspuns.AddRange(listaRaspunsuri);
context.SaveChanges();
}
private static void SeedJudete(this OngContext context)
{
if (context.Judet.Any())
{
return;
}
context.Judet.AddRange(
new Judet {
IdJudet = 0, CodJudet = "AB", Nume = "ALBA"
},
new Judet {
IdJudet = 1, CodJudet = "AR", Nume = "ARAD"
},
new Judet {
IdJudet = 2, CodJudet = "AG", Nume = "ARGES"
},
new Judet {
IdJudet = 3, CodJudet = "BC", Nume = "BACAU"
},
new Judet {
IdJudet = 4, CodJudet = "BH", Nume = "BIHOR"
},
new Judet {
IdJudet = 5, CodJudet = "BN", Nume = "BISTRITA-NASAUD"
},
new Judet {
IdJudet = 6, CodJudet = "BT", Nume = "BOTOSANI"
},
new Judet {
IdJudet = 7, CodJudet = "BV", Nume = "BRASOV"
},
new Judet {
IdJudet = 8, CodJudet = "BR", Nume = "BRAILA"
},
new Judet {
IdJudet = 9, CodJudet = "BZ", Nume = "BUZAU"
},
new Judet {
IdJudet = 10, CodJudet = "CS", Nume = "CARAS-SEVERIN"
},
new Judet {
IdJudet = 11, CodJudet = "CL", Nume = "CALARASI"
},
new Judet {
IdJudet = 12, CodJudet = "CJ", Nume = "CLUJ"
},
new Judet {
IdJudet = 13, CodJudet = "CT", Nume = "CONSTANTA"
},
new Judet {
IdJudet = 14, CodJudet = "CV", Nume = "COVASNA"
},
new Judet {
IdJudet = 15, CodJudet = "DB", Nume = "DÂMBOVITA"
},
new Judet {
IdJudet = 16, CodJudet = "DJ", Nume = "DOLJ"
},
new Judet {
IdJudet = 17, CodJudet = "GL", Nume = "GALATI"
},
new Judet {
IdJudet = 18, CodJudet = "GR", Nume = "GIURGIU"
},
new Judet {
IdJudet = 19, CodJudet = "GJ", Nume = "GORJ"
},
new Judet {
IdJudet = 20, CodJudet = "HR", Nume = "HARGHITA"
},
new Judet {
IdJudet = 21, CodJudet = "HD", Nume = "HUNEDOARA"
},
new Judet {
IdJudet = 22, CodJudet = "IL", Nume = "IALOMITA"
},
new Judet {
IdJudet = 23, CodJudet = "IS", Nume = "IASI"
},
new Judet {
IdJudet = 24, CodJudet = "IF", Nume = "ILFOV"
},
new Judet {
IdJudet = 25, CodJudet = "MM", Nume = "MARAMURES"
},
new Judet {
IdJudet = 26, CodJudet = "MH", Nume = "MEHEDINTI"
},
new Judet {
IdJudet = 27, CodJudet = "B", Nume = "MUNICIPIUL BUCURESTI"
},
new Judet {
IdJudet = 28, CodJudet = "MS", Nume = "MURES"
},
new Judet {
IdJudet = 29, CodJudet = "NT", Nume = "NEAMT"
},
new Judet {
IdJudet = 30, CodJudet = "OT", Nume = "OLT"
},
new Judet {
IdJudet = 31, CodJudet = "PH", Nume = "PRAHOVA"
},
new Judet {
IdJudet = 32, CodJudet = "SM", Nume = "SATU MARE"
},
new Judet {
IdJudet = 33, CodJudet = "SJ", Nume = "SALAJ"
},
new Judet {
IdJudet = 34, CodJudet = "SB", Nume = "SIBIU"
},
new Judet {
IdJudet = 35, CodJudet = "SV", Nume = "SUCEAVA"
},
new Judet {
IdJudet = 36, CodJudet = "TR", Nume = "TELEORMAN"
},
new Judet {
IdJudet = 37, CodJudet = "TM", Nume = "TIMIS"
},
new Judet {
IdJudet = 38, CodJudet = "TL", Nume = "TULCEA"
},
new Judet {
IdJudet = 39, CodJudet = "VS", Nume = "VASLUI"
},
new Judet {
IdJudet = 40, CodJudet = "VL", Nume = "VÂLCEA"
},
new Judet {
IdJudet = 41, CodJudet = "VN", Nume = "VRANCEA"
}
);
}
public ObserverRequestsHandler(OngContext context, ILogger logger, IHashService hashService)
{
_context = context;
_logger = logger;
_hashService = hashService;
}
public StatisticiQueryHandler(OngContext context, IMapper mapper, ICacheService cacheService)
{
_context = context;
_mapper = mapper;
_cacheService = cacheService;
}
public FormulareQueryHandler(OngContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public NoteQueryHandler(OngContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
