public ActionResult ListePublicitee()
{
ExamenContext db = new ExamenContext();
////List<Product> listprod = Session["Products"] as List<Product>;
//var produit = sp.GetMany();
return(View(db.Publicites.ToList()));
}
public List <Category> LstCategories()
{
List <Category> lstCategories;
using (var db = new ExamenContext())
{
lstCategories = db.Categories.ToList();
}
return(lstCategories);
}
public List <Project> LstProjects()
{
List <Project> lstProjects;
using (var db = new ExamenContext())
{
lstProjects = db.Projects.Include(x => x.Category).ToList();
}
return(lstProjects);
}
public Project GetProject(int idProject)
{
Project project;
try
{
using (var db = new ExamenContext())
{
project = db.Projects.Where(x => x.ProjectID == idProject).FirstOrDefault();
}
}
catch (Exception)
{
project = new Project();
//Log
}
return(project);
}
public bool AddProject(Project model)
{
bool res = false;
try
{
using (var db = new ExamenContext())
{
db.Projects.Add(model);
db.SaveChanges();
res = true;
}
}
catch (Exception ex)
{
res = false;
//log
}
return(res);
}
public bool DeleteProject(int idProject)
{
bool res = false;
try
{
using (var db = new ExamenContext())
{
Project projectRegistered = db.Projects.Where(x => x.ProjectID == idProject).FirstOrDefault();
if (projectRegistered != null)
{
db.Projects.Remove(projectRegistered);
res = (db.SaveChanges() > 0);
}
}
}
catch (Exception)
{
throw;
}
return(res);
}
public bool UpdateProject(Project model)
{
bool res = false;
try
{
using (var db = new ExamenContext())
{
Project projectRegistered = db.Projects.Where(x => x.ProjectID == model.ProjectID).FirstOrDefault();
if (projectRegistered != null)
{
projectRegistered.NameProject = model.NameProject;
projectRegistered.CategoryID = model.CategoryID;
res = (db.SaveChanges() > 0);
}
}
}
catch (Exception)
{
throw;
}
return(res);
}
public EmpleadosController(ExamenContext context)
{
_context = context;
}
public DatabaseFactory()
{
dataContext = new ExamenContext();
}
public AutoService(ExamenContext entities)
{
this.entities = entities;
}
public OrganizacionController(ExamenContext context)
{
_context = context;
}
public UserAppServices(ExamenContext examenContext, ILogger <UserAppServices> log)
{
this.examenContext = examenContext;
this.log = log;
}
public EmpleadoHabilidadesController(ExamenContext context)
{
_context = context;
}
public OpcionServices(ExamenContext examenContext, ILogger <OpcionServices> log)
{
this.examenContext = examenContext;
this.log = log;
}
public PersonaFisicaRepositorio(ExamenContext context)
{
_context = context;
}
public UnitOfWork(IDatabaseFactory dbFactory)
{
this.dbFactory = dbFactory;
dataContext = dbFactory.DataContext;
}
public AreasController(ExamenContext context)
{
_context = context;
}
public ArticuloServices(ExamenContext examenContext, ILogger <ArticuloServices> log)
{
this.examenContext = examenContext;
this.log = log;
}
