public void Test1()
{
var SqLite = new SqliteConnection("Filename=:memory:");
var DBOptions = new DbContextOptionsBuilder <DBContextClass>().UseSqlite(SqLite).Options;
SqLite.Open();
using (var db = new DBContextClass(DBOptions))
{
db.Database.Migrate();
var clients = new Client();
clients.FName = "John";
clients.LName = "Smith";
clients.UserName = "******";
clients.Password = "******";
db.Add(clients);
db.SaveChanges();
}
using (var db = new DBContextClass(DBOptions))
{
var clients = db.Clients
.Where(b => b.FName == "John")
.OrderBy(b => b.ClientID)
.ToList()
.First();
Assert.Equal("John", clients.FName);
}
}
public Country GetCountryById(int?id)
{
DBContextClass db = new DBContextClass();
using (db)
{
return((from c in db.Countries where c.Id == id select c).FirstOrDefault());
}
}
public List <Country> GetCountries()
{
DBContextClass db = new DBContextClass();
using (db)
{
return((from u in db.Countries select u).ToList());
}
}
public int OrderCount()
{
DBContextClass db = new DBContextClass();
using (db)
{
return((from c in db.FinalOrders select c).Count());
}
}
//Garbage Colector and Disposing off Method
protected override void Dispose(bool disposing)
{
DBContextClass db = new DBContextClass();
if (disposing)
{
db.Dispose();
}
base.Dispose(disposing);
}
public void AddCountry(Country country)
{
DBContextClass db = new DBContextClass();
using (db)
{
db.Countries.Add(country);
db.SaveChanges();
}
}
// GET: Admin
public ActionResult AdminPanel()
{
DBContextClass db = new DBContextClass();
User u = (User)Session[WebUtil.CURRENT_USER];
if (!(u != null && u.IsInRole(WebUtil.ADMIN_ROLE)))
{
return(RedirectToAction("Login", "User", new { ctl = "Admin", act = "AdminPanel" }));
}
return(View());
}
public void AddCity(City city)
{
DBContextClass db = new DBContextClass();
using (db)
{
db.Entry(city.Country).State = EntityState.Unchanged;
db.Cities.Add(city);
db.SaveChanges();
}
}
public List <City> GetCitiesByCountryId(int id)
{
DBContextClass db = new DBContextClass();
using (db)
{
return((from c in db.Cities
where c.Country.Id == id
select c).ToList());
}
}
public List <City> GetCities(Country country)
{
DBContextClass db = new DBContextClass();
using (db)
{
return((from u in db.Cities
where u.Country.Id == country.Id
select u).ToList());
}
}
public void DeleteCountry(Country country)
{
DBContextClass db = new DBContextClass();
using (db)
{
db.Entry(country).State = EntityState.Deleted;
db.Countries.Remove(country);
db.SaveChanges();
}
}
public TestRepository(DBContextClass context)
: base(context)
{
this.Context = context;
}
public NotesController(DBContextClass context)
{
_context = context;
}
public TableRepository(DBContextClass context)
: base(context)
{
}
