public int InsertarWorkgroups(Dtos.workgroupsDTO dto) { try { using (var modelo = new PersistenciaDatos.SignalDBEntities()) { var entity = dto.ToEntity(); modelo.workgroups.Add(entity); modelo.SaveChanges(); return(entity.id_workgroup); } } catch (Exception) { throw new NotImplementedException(); } }
public bool InsertarActs_files(Dtos.acts_filesDTO dto) { try { using (var modelo = new PersistenciaDatos.SignalDBEntities()) { var entity = dto.ToEntity(); modelo.acts_files.Add(entity); modelo.SaveChanges(); return(true); } } catch (Exception) { throw new NotImplementedException(); } }
public string InsertarUsers(Dtos.usersDTO dto) { try { using (var modelo = new PersistenciaDatos.SignalDBEntities()) { var entity = dto.ToEntity(); modelo.users.Add(entity); modelo.SaveChanges(); return(entity.id_user); } } catch (Exception) { throw new NotImplementedException(); } }
public List <Dtos.workgroupsDTO> ListarWorkgroups(string param) { try { using (var modelo = new PersistenciaDatos.SignalDBEntities()) { var entity = modelo.workgroups.Where(q => q.name_workgroup.Contains(param)).Select(q => q).ToList(); if (entity == null) { return(null); } return(Dominio.Convertidores.workgroupsCONVERTIDOR.ToDTOs(entity)); } } catch (Exception) { throw new NotImplementedException(); } }
public Dtos.workgroupsDTO BuscarWorkgroups(int id) { try { using (var modelo = new PersistenciaDatos.SignalDBEntities()) { var entity = modelo.workgroups.Where(q => q.id_workgroup == id).Select(q => q).FirstOrDefault(); if (entity == null) { return(null); } return(Dominio.Convertidores.workgroupsCONVERTIDOR.ToDTO(entity)); } } catch (Exception) { throw new NotImplementedException(); }; }
public List <Dtos.workgroupsDTO> ListarTodosLosWorkgroup_Activos() { try { using (var modelo = new PersistenciaDatos.SignalDBEntities()) { var entity = modelo.workgroups.Where(q => q.status == 1).Select(q => q).ToList(); if (entity == null) { return(null); } return(Dominio.Convertidores.workgroupsCONVERTIDOR.ToDTOs(entity)); } } catch (Exception) { throw new NotImplementedException(); } }
public List <Dtos.acts_filesDTO> BuscarUsers_acts_IDUSER(int id) { try { using (var modelo = new PersistenciaDatos.SignalDBEntities()) { var entity = modelo.acts_files.Where(q => q.id_file == id).Select(q => q).ToList(); if (entity == null) { return(null); } return(Dominio.Convertidores.acts_filesCONVERTIDOR.ToDTOs(entity)); } } catch (Exception) { throw new NotImplementedException(); } }
public List <Dtos.usersDTO> ListarTodosLosUsers() { try { using (var modelo = new PersistenciaDatos.SignalDBEntities()) { var entity = modelo.users.ToList(); if (entity == null) { return(null); } return(Dominio.Convertidores.usersCONVERTIDOR.ToDTOs(entity)); } } catch (Exception) { throw new NotImplementedException(); } }
public bool EliminarWorkgroups(int id) { try { using (var modelo = new PersistenciaDatos.SignalDBEntities()) { PersistenciaDatos.workgroups x = modelo.workgroups.Where(q => q.id_workgroup == id).Select(q => q).FirstOrDefault(); if (x == null) { return(false); } modelo.workgroups.Remove(x); modelo.SaveChanges(); return(true); } } catch (Exception) { throw new NotImplementedException(); } }
public bool ActualizarWorkgroups(Dtos.workgroupsDTO dto) { try { using (var modelo = new PersistenciaDatos.SignalDBEntities()) { var w = modelo.workgroups.Where(q => q.id_workgroup == dto.id_workgroup).Select(q => q).FirstOrDefault(); if (w == null) { return(false); } Dominio.Convertidores.workgroupsCONVERTIDOR.Actualizar(dto, w); modelo.SaveChanges(); return(true); } } catch (Exception) { throw new NotImplementedException(); } }