public IQueryable <Breed> GetBreeds()
{
var db = new DogContext();
var query = db.Breeds;
return(query);
}
public AccountController(ILogger <AccountController> logger, SignInManager <User> signInManager,
UserManager <User> userManager, DogContext context)
{
this.logger = logger;
this.signInManager = signInManager;
this.userManager = userManager;
this.context = context;
}
public IQueryable <Dog> GetDogs([QueryString("Id")] int?breedId)
{
var db = new DogContext();
IQueryable <Dog> query = db.Dogs.Include("Breed");
if (breedId.HasValue && breedId > 0)
{
query = query.Where(d => d.BreedId == breedId);
}
return(query);
}
protected void Page_Load(object sender, EventArgs e)
{
int?dogId = Convert.ToInt32(Request.QueryString["DogId"]);
var db = new DogContext();
IQueryable <Dog> query = db.Dogs;
if (dogId.HasValue && dogId > 0)
{
Dog dog = query.Single(d => d.DogId == dogId);
showAllImages(dog);
}
}
public IQueryable <Dog> GetDog([QueryString("DogId")] int?dogId)
{
var db = new DogContext();
IQueryable <Dog> query = db.Dogs;
if (dogId.HasValue && dogId > 0)
{
query = query.Where(d => d.DogId == dogId);
//showAllImages(query, dogId);
}
else
{
query = null;
}
return(query);
}
public Form1()
{
InitializeComponent();
string dir = Directory.GetParent(Directory.GetParent(Directory.GetParent(Directory.GetParent(AppDomain.CurrentDomain.BaseDirectory).FullName).FullName).FullName).FullName;
string attachDBFilename = dir + @"\Task_1\DataSolution\Dogs.mdf";
builder = new SqlConnectionStringBuilder
{
DataSource = @"(localdb)\mssqllocaldb",
InitialCatalog = "Dogs",
AttachDBFilename = attachDBFilename,
IntegratedSecurity = true
};
db = new DogContext(builder.ConnectionString);
dataGridView1.DataSource = db.Dogs.Select(d => new { d.Nickname, Breed = d.Breed.BreedName, d.Height }).ToList();
comboBox1.DataSource = db.Breeds.Select(b => b.BreedName).ToList();
comboBox1.SelectedIndex = 0;
comboBox2.DataSource = db.Breeds.Select(b => b.BreedName).ToList();
comboBox2.SelectedIndex = 0;
comboBox3.DataSource = db.Dogs.Select(b => b.Nickname).ToList();
comboBox3.SelectedIndex = 0;
}
public DogRepository(DogContext dogContext)
{
this.dogContext = dogContext;
}
public BreedController(DogContext context)
{
this.context = context;
}
public DogRepository(DogContext context)
{
this.context = context;
}
public AccountRepository(IConfiguration configuration)
{
this.context = new DogContext(configuration);
}
public DogsController(DogContext context)
{
_context = context;
}
public BlogController(DogContext context)
{
_context = context;
}
public ColourController(DogContext context)
{
this.context = context;
}
public ActivityController(DogContext context)
{
_context = context;
}
public ParkController(DogContext context)
{
_context = context;
}
public ShopController(DogContext context)
{
this.context = context;
}
public OwnerRepository(IConfiguration configuration)
{
this.context = new DogContext(configuration);
}
public OwnersController(DogContext context)
{
_context = context;
}
public UserController(DogContext context)
{
_context = context;
}
public HomeController(DogContext context)
{
_context = context;
}
