public void Generators_are_associated_with_database_root()
{
var serviceProvider1 = new ServiceCollection()
.AddEntityFrameworkInMemoryDatabase()
.BuildServiceProvider();
var serviceProvider2 = new ServiceCollection()
.AddEntityFrameworkInMemoryDatabase()
.BuildServiceProvider();
var root = new InMemoryDatabaseRoot();
var olives = new Olive[2];
var toasts = new Toast[2];
using (var context = new PetsContext("Drink", root, serviceProvider1))
{
olives[0] = context.Add(new Olive()).Entity;
toasts[0] = context.Add(new Toast()).Entity;
Assert.Equal(1, olives[0].Id);
Assert.Equal(1, toasts[0].Id);
context.SaveChanges();
}
using (var context = new PetsContext("Drink", root, serviceProvider2))
{
olives[1] = context.Add(new Olive()).Entity;
toasts[1] = context.Add(new Toast()).Entity;
Assert.Equal(2, olives[1].Id);
Assert.Equal(2, toasts[1].Id);
context.SaveChanges();
}
Assert.Equal(1, olives[0].Id);
Assert.Equal(1, toasts[0].Id);
Assert.Equal(2, olives[1].Id);
Assert.Equal(2, toasts[1].Id);
}
private static void CreateDB()
{
IConfiguration config = new ConfigurationBuilder()
.AddJsonFile("appsettings.json")
.Build();
var options = new DbContextOptionsBuilder <PetsContext>()
.UseSqlServer(config.GetConnectionString("PetsDB"))
.Options;
using var db = new PetsContext(options);
db.Database.EnsureDeleted();
db.Database.EnsureCreated();
var owner = CreateData();
db.Owners.Add(owner);
db.SaveChanges();
}
public ActionResult List(string searchString, string all, string MoveGender = null)
{
PetsContext petsConx = new PetsContext();
var pets = from m in petsConx.Pets
select m;
if (!String.IsNullOrEmpty(searchString))
{
pets = pets.Where(s => s.Name.Contains(searchString));
}
//ViewBag.SelectedGender = gender;
if (MoveGender != null && MoveGender != "Выбрать пол")
{
pets = pets.Where(s => s.Gender == (MoveGender == "Женский" ? true: false));
}
List <SelectListItem> genderItems = new List <SelectListItem>();
genderItems.Add(new SelectListItem()
{
Text = "Выбрать пол", Selected = (MoveGender) == null ? true : false
});
genderItems.Add(new SelectListItem()
{
Text = "Мужской", Value = "Мужской", Selected = (MoveGender) == "Мужской" ? true : false
});
genderItems.Add(new SelectListItem()
{
Text = "Женский", Value = "Женский", Selected = (MoveGender) == "Женский" ? true : false
});
ViewBag.MoveGender = genderItems;
return(View(pets));
}
private static void ShowDBData()
{
IConfiguration config = new ConfigurationBuilder()
.AddJsonFile("appsettings.json")
.Build();
var options = new DbContextOptionsBuilder <PetsContext>()
.UseSqlServer(config.GetConnectionString("PetsDB"))
.Options;
using var db = new PetsContext(options);
Console.WriteLine("From Owner:");
Console.WriteLine(db.Owners.Include(o => o.Pets).First());
Console.WriteLine("All Pets:");
foreach (var p in db.Pets)
{
Console.WriteLine(p);
}
Console.WriteLine("\nAll Cats:");
foreach (var c in db.Cats)
{
Console.WriteLine(c);
}
Console.WriteLine("\nAll Dogs:");
foreach (var d in db.Dogs)
{
Console.WriteLine(d);
}
}
public PetRepository(PetsContext context)
{
db = context;
}
public void Each_property_gets_its_own_generator()
{
var macs = new Mac[4];
var toasts = new Toast[4];
using (var context = new PetsContext("Dance"))
{
macs[0] = context.Add(new Mac()).Entity;
toasts[0] = context.Add(new Toast()).Entity;
Assert.Equal(1, macs[0].Id);
Assert.Equal(1, toasts[0].Id);
macs[1] = context.Add(new Mac()).Entity;
toasts[1] = context.Add(new Toast()).Entity;
Assert.Equal(2, macs[1].Id);
Assert.Equal(2, toasts[1].Id);
context.SaveChanges();
Assert.Equal(1, macs[0].Id);
Assert.Equal(1, toasts[0].Id);
Assert.Equal(2, macs[1].Id);
Assert.Equal(2, toasts[1].Id);
macs[2] = context.Add(new Mac()).Entity;
toasts[2] = context.Add(new Toast()).Entity;
Assert.Equal(3, macs[2].Id);
Assert.Equal(3, toasts[2].Id);
context.SaveChanges();
}
using (var context = new PetsContext("Dance"))
{
macs[3] = context.Add(new Mac()).Entity;
toasts[3] = context.Add(new Toast()).Entity;
Assert.Equal(4, macs[3].Id);
Assert.Equal(4, toasts[3].Id);
context.SaveChanges();
}
Assert.Equal(1, macs[0].Id);
Assert.Equal(1, toasts[0].Id);
Assert.Equal(2, macs[1].Id);
Assert.Equal(2, toasts[1].Id);
Assert.Equal(3, macs[2].Id);
Assert.Equal(3, toasts[2].Id);
Assert.Equal(4, macs[3].Id);
Assert.Equal(4, toasts[3].Id);
using (var context = new PetsContext("Dance"))
{
macs = context.Macs.OrderBy(e => e.Id).ToArray();
toasts = context.CookedBreads.OrderBy(e => e.Id).ToArray();
}
Assert.Equal(1, macs[0].Id);
Assert.Equal(1, toasts[0].Id);
Assert.Equal(2, macs[1].Id);
Assert.Equal(2, toasts[1].Id);
Assert.Equal(3, macs[2].Id);
Assert.Equal(3, toasts[2].Id);
Assert.Equal(4, macs[3].Id);
Assert.Equal(4, toasts[3].Id);
}
private void AddPet(object sender, RoutedEventArgs e)
{
String name = Name.Text;
if (Age.Text == "")
{
MessageBox.Show("Fill all required fields!");
return;
}
int age = Int32.Parse(Age.Text);
String breed = Breed.Text;
String description = Description.Text;
EntAnimal animal = new EntAnimal();
if (name == "")
{
MessageBox.Show("Fill all required fields!");
return;
}
if (imageData == null)
{
MessageBox.Show("Fill all required fields!");
return;
}
animal.name = name;
animal.image = imageData;
animal.age = age;
int size_id = 0;
if (size == "Small")
{
size_id = 1;
}
else if (size == "Medium")
{
size_id = 2;
}
else
{
size_id = 3;
}
animal.sizeId = size_id;
int type_id = 0;
if (type == "Cat")
{
type_id = 2;
}
else
{
type_id = 1;
}
animal.typeId = type_id;
if (breed == "")
{
MessageBox.Show("Fill all required fields!");
return;
}
animal.breed = breed;
if (description == "")
{
MessageBox.Show("Fill all required fields!");
return;
}
animal.description = description;
animal.sex = sex;
PetsContext context = new PetsContext();
context.Animals.Add(animal);
context.SaveChanges();
petsImproved.MainWindow.AppWindow.getData();
this.Close();
}
public ActionResult Info()
{
PetsContext pets = new PetsContext();
return(View(pets.Pets));
}
public HomeController(ILogger <HomeController> logger, PetsContext petsContext, IWebHostEnvironment env)
{
_logger = logger;
_petsContext = petsContext;
_env = env;
}
public ProductsController(PetsContext context)
{
_context = context;
}
public AnimalRepository(PetsContext context)
{
_context = context;
}
public HomeController(PetsContext db)
{
_db = db;
}
public OwnersRepository(ILoggerFactory loggerFactory, PetsContext petsContext)
{
_logger = loggerFactory.CreateLogger <OwnersRepository>();
_petsContext = petsContext;
}
public PetsController(PetsContext db, IHostingEnvironment environment)
{
_db = db;
hostingEnvironment = environment;
}
public OwnersController(PetsContext context)
{
_context = context;
}
public OwnerRepository(PetsContext context)
{
db = context;
}
public PetsController(ILogger <PetsController> logger, PetsContext petsContext, IMapper mapper)
{
_logger = logger;
this.petsContext = petsContext;
this.mapper = mapper;
}
public UnitOfWork(PetsContext context)
{
db = context;
OwnerRepository = new OwnerRepository(context);
PetRepository = new PetRepository(context);
}
public BanhoPetsController(PetsContext context)
{
_context = context;
}
public UserRepository(PetsContext context)
{
_context = context;
}
