public static void AddUser(User user)
{
using (var db = new FinalProjectContext())
{
db.Add(user);
db.SaveChanges();
}
}
public UnitOfWork(string connectionString = null)
{
if (String.IsNullOrWhiteSpace(connectionString))
{
Context = new FinalProjectContext();
}
else
{
Context = new FinalProjectContext(connectionString);
}
}
public OperationController(FinalProjectContext context)
{
_context = context;
_repo = new OperationRepository(_context);
if (_context.Operations.Count() == 0)
{
TimeSpan span = new TimeSpan(0, 0, 0, 30, 50);
_context.Operations.Add(new Operation {
Name = "Method Test1", ExecutionDate = DateTime.Now, ExecutionTime = span
});
_context.SaveChanges();
}
}
public static List <Drug> GetDrugs()
{
List <Drug> drugs = new List <Drug>();
using (var db = new FinalProjectContext())
{
var collection = db.Drugs.Include(t => t.User);
foreach (Drug item in collection)
{
drugs.Add(item);
}
db.SaveChanges();
}
return(drugs);
}
public static List <User> GetUsers()
{
List <User> users = new List <User>();
using (var db = new FinalProjectContext())
{
var collection = db.Users;
foreach (User item in collection)
{
users.Add(item);
}
db.SaveChanges();
}
return(users);
}
public static void AddDrug(Drug drug, int userId)
{
using (var db = new FinalProjectContext())
{
var users = db.Users.
Where(x => (x.UserId == userId));
List <User> users__ = new List <User>();
foreach (User x in users)
{
users__.Add(x);
}
User user = users__.ElementAt(0);
drug.Time = DateTime.Now;
drug.User = user;
db.Add(drug);
db.SaveChanges();
}
}
public DummyController(FinalProjectContext ctx)
{
_ctx = ctx;
}
public MovieService(FinalProjectContext context)
{
_context = context;
}
public DashboardModel(FinalProjectContext context)
{
_context = context;
}
public IndexModel(FinalProjectContext context)
{
_context = context;
}
public StockPurchaseEntryController(FinalProjectContext context)
{
_context = context;
}
public ChatController(FinalProjectContext context)
{
_context = context;
}
public CatalogModel(FinalProjectContext context)
{
_context = context;
}
public MusclesController(FinalProjectContext context)
{
_context = context;
}
public UserService(FinalProjectContext context)
{
_context = context;
}
public CategoriesController(FinalProjectContext context)
{
_context = context;
}
public GenreDetailModel(FinalProjectContext context)
{
_context = context;
}
public CSSystemsController(FinalProjectContext context)
{
_context = context;
}
public RatingsModel(FinalProjectContext context)
{
_context = context;
}
public ProjectProfileModel(FinalProjectContext context)
{
_context = context;
}
public ProjectOverviewModel(FinalProjectContext context)
{
_context = context;
}
public SetContractorStatusModel(FinalProjectContext context)
{
_context = context;
}
public FamilyRepository(FinalProjectContext context)
{
_context = context;
}
public BusinessProfileModel(FinalProjectContext context)
{
_context = context;
}
public ProfessorsController(FinalProjectContext context)
{
_context = context;
}
public FavoriteService(FinalProjectContext context)
{
_context = context;
}
public CheckOutPageModel(FinalProjectContext context)
{
_context = context;
}
public ProjectsAllController(FinalProjectContext context)
{
_context = context;
}
public UsersController(FinalProjectContext context)
{
_context = context;
}
public ContractorProfileModel(FinalProjectContext context)
{
_context = context;
}
