public static List <Advert> GetAdvertsByCategory(WorkHireContext dbContext,
MainCategory category)
{
_db = dbContext;
return(_db.Adverts.Where(a => a.MainCategory == category).ToList());
}
public HomeController(ILogger <HomeController> logger, WorkHireContext db, IWebHostEnvironment host)
{
_logger = logger;
_db = db;
_host = host;
}
public void SetRegistered(WorkHireContext dbContext)
{
_db = dbContext;
this.IsRegistered = true;
_db.SaveChanges();
}
public void SetLogOut(WorkHireContext dbContext)
{
_db = dbContext;
this.IsLogged = false;
_db.SaveChanges();
}
public WorkerController(WorkHireContext db, IWebHostEnvironment host)
{
_db = db;
_host = host;
}
public static void RemoveAllAdverts(WorkHireContext dbContext)
{
_db = dbContext;
_db.Adverts.RemoveRange(_db.Adverts);
_db.SaveChanges();
}
public static void RemoveWorker(WorkHireContext dbContext, Worker worker)
{
_db = dbContext;
_db.Workers.Remove(worker);
_db.SaveChanges();
}
public static Advert GetAdvertById(WorkHireContext dbContext, int id)
{
_db = dbContext;
var advert = GetAdverts(_db).FirstOrDefault(a => a.Id == id);
return(advert);
}
public static void RemoveAdvert(WorkHireContext dbContext, Advert advert)
{
_db = dbContext;
_db.Adverts.Remove(advert);
_db.SaveChanges();
}
public static void AddWorker(WorkHireContext dbContext, Worker worker)
{
_db = dbContext;
_db.Workers.Add(worker);
_db.SaveChanges();
}
public void SetLogIn(WorkHireContext dbContext)
{
_db = dbContext;
this.IsLogged = true;
_db.SaveChanges();
}
public static void RemoveAllWorkers(WorkHireContext dbContext)
{
_db = dbContext;
_db.Workers.RemoveRange(_db.Workers);
_db.SaveChanges();
}
public Worker(string username,
string password,
string emailAddress,
string firstName,
string lastName,
string phone,
string description,
string portfolio,
MainCategory category,
City city,
WorkHireContext db,
IFormFile picture = null,
decimal startingHourFee = 10)
{
this.Username = username;
this.Password = password;
this.EmailAddress = emailAddress;
this.FirstName = firstName;
this.LastName = lastName;
this.Phone = phone;
this.Description = description;
this.Portfolio = portfolio;
this.MainCategory = category;
this.City = city;
this.Picture = picture;
this.StartingHourFee = startingHourFee;
_db = db;
}
public static Worker GetWorkerById(WorkHireContext dbContext, int id)
{
_db = dbContext;
return(_db.Workers.FirstOrDefault(w => w.Id == id));
}
public static int GetTotalWorkersCount(WorkHireContext dbContext)
{
_db = dbContext;
return(_db.Workers.Count());
}
public static Worker GetWorkerByEmail(WorkHireContext dbContext, string email)
{
_db = dbContext;
return(_db.Workers.FirstOrDefault(w => w.EmailAddress.Equals(email)));
}
public static List <Advert> GetAdverts(WorkHireContext dbContext)
{
_db = dbContext;
return(_db.Adverts.ToList());
}
public static Advert GetAdvertByName(WorkHireContext dbContext, string advertName)
{
_db = dbContext;
return(_db.Adverts.FirstOrDefault(a => a.AdvertName.Equals(advertName)));
}
public Test(WorkHireContext db)
{
_db = db;
}
public static List <Advert> GetAdvertsByDate(WorkHireContext dbContext, DateTime date)
{
_db = dbContext;
return(_db.Adverts.Where(a => a.Date == date).ToList());
}
public static Worker GetWorkerByUsername(WorkHireContext dbContext, string username)
{
_db = dbContext;
return(_db.Workers.FirstOrDefault(w => w.Username.Equals(username)));
}
public static List <Advert> GetAdvertsByCity(WorkHireContext dbContext, City city)
{
_db = dbContext;
return(_db.Adverts.Where(a => a.City == city).ToList());
}
public static Worker GetWorkerByLastName(WorkHireContext dbContext, string lastName)
{
_db = dbContext;
return(_db.Workers.FirstOrDefault(w => w.LastName.Equals(lastName)));
}
public static int GetTotalAdvertsCount(WorkHireContext dbContext)
{
_db = dbContext;
return(_db.Adverts.Count());
}
public static List <Worker> GetWorkers(WorkHireContext dbContext)
{
_db = dbContext;
return(_db.Workers.ToList());
}
public static List <Worker> GetWorkersByCity(WorkHireContext dbContext, City city)
{
_db = dbContext;
return(_db.Workers.Where(w => w.City == city).ToList());
}
public void SetDbContext(WorkHireContext dbContext)
{
_db = dbContext;
}
