public List <Agent> GetAgents()
{
using (var emlakOfiDbContext = new EmlakOfisiDbContext())
{
return(emlakOfiDbContext.Agents.ToList());
}
}
public List <Advertisement> GetAdvertisementsList(Expression <Func <Advertisement, bool> > expression)
{
using (var emlakOfiDbContext = new EmlakOfisiDbContext())
{
return(emlakOfiDbContext.Advertisements.Where(expression).ToList());
}
}
public Agent GetAgentById(int id)
{
using (var emlakOfiDbContext = new EmlakOfisiDbContext())
{
return(emlakOfiDbContext.Agents.Find(id));
}
}
public List <Advertisement> GetAdvertisements()
{
using (var emlakOfisDbContext = new EmlakOfisiDbContext())
{
return(emlakOfisDbContext.Advertisements.ToList());
}
}
public Advertisement GetAdvertisementByExpression(Expression <Func <Advertisement, bool> > expression)
{
using (var emlakOfisDbContext = new EmlakOfisiDbContext())
{
return(emlakOfisDbContext.Advertisements.Where(expression).FirstOrDefault());
}
}
public Agent UpdateAgent(Agent agent)
{
using (var emlakOfiDbContext = new EmlakOfisiDbContext())
{
emlakOfiDbContext.Agents.Update(agent);
emlakOfiDbContext.SaveChanges();
return(agent);
}
}
public void DeleteAgent(int id)
{
using (var emlakOfiDbContext = new EmlakOfisiDbContext())
{
var deleted = GetAgentById(id);
emlakOfiDbContext.Agents.Remove(deleted);
emlakOfiDbContext.SaveChanges();
}
}
public Advertisement UpdateAdvertisement(Advertisement advertisement)
{
using (var emlakOfiDbContext = new EmlakOfisiDbContext())
{
emlakOfiDbContext.Advertisements.Update(advertisement);
emlakOfiDbContext.SaveChanges();
return(advertisement);
}
}
public void DeleteAdvertisement(int id)
{
using (var emlakOfisDbContext = new EmlakOfisiDbContext())
{
var deleted = GetAdvertisementByExpression(x => x.Id == id);
emlakOfisDbContext.Advertisements.Remove(deleted);
emlakOfisDbContext.SaveChanges();
}
}
