public object Get()
{
var dbContext = new CustomDBContext();
var schools = dbContext.Schools.ToList();
return(schools);
}
public bool IsUserExits(string email)
{
using (var context = new CustomDBContext())
{
return(context.Users.Where(p => p.Email == email).Count() == 1);
}
}
public User get(int id)
{
using (var context = new CustomDBContext())
{
var data = context.Users.Where(p => p.ID == id).First();
return(data);
}
}
public void AddUser(User user)
{
using (var context = new CustomDBContext())
{
context.Users.Add(user);
context.SaveChanges();
}
}
public IEnumerable <User> getAll()
{
using (var context = new CustomDBContext())
{
var data = context.Users.ToList().AsEnumerable();
return(data);
}
}
public BaseRepository(CustomDBContext context)
{
if (context == null)
{
throw new ArgumentNullException("context", "The given parameter cannot be null.");
}
this.Context = context;
}
public void SaveUser(User user)
{
using (var context = new CustomDBContext())
{
context.Users.Attach(user);
context.Entry(user).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public CardController(CustomDBContext db)
{
this.db = db;
this.db.Database.EnsureCreated();
}
public UserController(CustomDBContext db)
{
this.db = db;
//this.db.Database.EnsureCreated();
}
public UserRepository(CustomDBContext dataContext)
{
_dbContext = dataContext;
DbSet = dataContext.Set <User>();
}
public TransactionController(CustomDBContext db)
{
this.db = db;
this.db.Database.EnsureCreated();
}
public SensorValueController(CustomDBContext context)
{
_context = context;
}
protected void Application_Start()
{
GlobalConfiguration.Configure(WebApiConfig.Register);
CustomDBContext db = new CustomDBContext();
}
public Repository()
{
dbContext = new CustomDBContext();
dbSet = dbContext.Set <T>();
}
public ErrorController(CustomDBContext context)
{
_context = context;
}
public NotificationEntryController(CustomDBContext context)
{
_context = context;
}
