private static void AddStoreProcedure(ReservarionSystemDbContext context)
{
var sb = new StringBuilder();
sb.Append(@" CREATE PROCEDURE UpdateContactType @Description nvarchar(512), @Valid BIT, @DateOfChange DATETIME2 (7), @DateOfCreation DATETIME2 (7), @Id UNIQUEIDENTIFIER ");
sb.Append(@" AS ");
sb.Append(@" BEGIN ");
sb.Append(" SET NOCOUNT ON; ");
sb.Append(@" UPDATE [dbo].[ContactType] ");
sb.Append(@" SET ");
sb.Append(@" [Description] = @Description,");
sb.Append(@" [Valid] = @Valid, ");
sb.Append(@" [DateOfChange] = @DateOfChange , ");
sb.Append(@" [DateOfCreation] = @DateOfCreation ");
sb.Append(@" WHERE (Id = @Id); ");
sb.Append(@" END ");
try
{
context.Database.ExecuteSqlRaw(sb.ToString());
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static void CreateContactType(ReservarionSystemDbContext context)
{
if (!context.ContactTypes.Any())
{
return;
}
var faker = new Faker();
var quantity = faker.Random.Int(min: 10, max: 50);
var lengthDescription =
faker.Random.Int(min: ContactType.MinDescriptionSize, max: ContactType.MaxDescriptionSize);
for (var i = 1; i < quantity; i++)
{
faker = new Faker();
var description = faker.Random.AlphaNumeric(length: lengthDescription);
var contactType = new ContactType(description);
context.ContactTypes.Add(contactType);
}
context.SaveChanges();
}
public static ReservarionSystemDbContext GetDatabaseInMemory()
{
var InMemoryConnectionString = "DataSource=:memory:";
var connection = new SqliteConnection(InMemoryConnectionString);
connection.Open();
var options = new DbContextOptionsBuilder <ReservarionSystemDbContext>()
.UseSqlite(connection)
.Options;
var context = new ReservarionSystemDbContext(options);
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
DataSeeder.CreateContactType(context);
DataSeeder.CreateContacts(context);
DataSeeder.CreateReservations(context);
return(context);
}
public RepositoryContactTypeTest()
{
var dependencyResolver = DependencyResolverFaker.GetDependencyResolver();
_db = dependencyResolver.Resolve <ReservarionSystemDbContext>();
_contactTypeRepository = ContactTypeRepositoryFaker.GetContactTypeRepository();
}
public static void CreateContacts(ReservarionSystemDbContext context)
{
if (!context.ContactTypes.Any())
{
CreateContactType(context);
}
if (context.Contacts.Any())
{
return;
}
var faker = new Faker();
var quantity = faker.Random.Int(min: 10, max: 50);
for (var i = 0; i < quantity - 1; i++)
{
faker = new Faker();
var name = faker.Person.FullName;
var randomizerTextRegex = RandomizerFactory
.GetRandomizer(new FieldOptionsTextRegex
{
Pattern = @"^\(999\) 999-\d{4}$"
});
var phoneNumber = randomizerTextRegex.Generate().ToUpper();
var birthDate = faker.Person.DateOfBirth;
var contactType = faker.PickRandom <ContactType>(context.ContactTypes);
var contact = new Contact(
name: name,
phoneNumber: phoneNumber,
birthDate: birthDate,
contactType: contactType
);
var x = contact.IsValid();
context.Contacts.Add(contact);
}
context.SaveChanges();
}
public static void CreateReservations(ReservarionSystemDbContext context)
{
if (context.Reservations.Any())
{
return;
}
if (!context.Contacts.Any())
{
return;
}
var faker = new Faker();
var quantity = faker.Random.Int(min: 100, max: 500);
for (var i = 0; i < quantity - 1; i++)
{
faker = new Faker();
var lengthMessage = faker.Random.Int(min: Reservation.MinMessageSize, max: Reservation.MaxMessageSize);
var message = faker.Random.AlphaNumeric(length: lengthMessage);
var contact = faker.PickRandom(context.Contacts.AsNoTracking().ToList());
var ranking = faker.Random.Int(min: Reservation.MinRanking, max: Reservation.MaxRanking);
var favorited = faker.Random.Bool();
var reservation = new Reservation(
id: Guid.NewGuid(),
message: message,
contact: contact,
ranking: ranking,
favorited: favorited);
context.Reservations.Add(reservation);
}
context.SaveChanges();
}
private static void RemoveProcedureIfExists(ReservarionSystemDbContext context)
{
var sb = new StringBuilder();
sb.Append(@" IF EXISTS (SELECT * ");
sb.Append(@" FROM sysobjects ");
sb.Append(@" WHERE type = 'P' AND id = object_id('dbo.UpdateContactType'))");
sb.Append(@" EXEC('DROP PROCEDURE [dbo].[UpdateContactType] ')");
try
{
context.Database.ExecuteSqlRaw(sb.ToString());
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public RepositoryBase(IDependencyResolver dependencyResolver)
{
Context = dependencyResolver.Resolve <ReservarionSystemDbContext>();
DbSet = Context.Set <TEntity>();
}