public static void eliminarConeccion(int id) { using (MapWorldSystemEntities entity = new MapWorldSystemEntities()) { entity.Entry(entity.ConecionServidores.First(x => x.id == id)).State = System.Data.Entity.EntityState.Deleted; entity.SaveChanges(); } }
public static List <vSysDataBaseViewModel> getListConeccionesServidor() { using (MapWorldSystemEntities entity = new MapWorldSystemEntities()) { var listVBaseDatos = from l in entity.vSysDataBase select new vSysDataBaseViewModel() { database_id = l.database_id, create_date = l.create_date, name = l.name }; return(listVBaseDatos.ToList()); } }
public static ConecionServidorViewModel getConeccionServidor(int id) { using (MapWorldSystemEntities entity = new MapWorldSystemEntities()) { var listConeccionServidor = from l in entity.ConecionServidores where l.id == id select new ConecionServidorViewModel() { id = l.id, baseDatos = l.baseDatos, contrasena = l.contrasena, nombreConeccion = l.nombreConeccion, servidor = l.servidor, usuario = l.usuario }; return(listConeccionServidor.FirstOrDefault()); } }
public static List <ConecionServidorViewModel> getListConeccionesServidor() { using (MapWorldSystemEntities entity = new MapWorldSystemEntities()) { var listConeccionServidor = from l in entity.ConecionServidores select new ConecionServidorViewModel() { id = l.id, baseDatos = l.baseDatos, contrasena = l.contrasena, nombreConeccion = l.nombreConeccion, servidor = l.servidor, usuario = l.usuario }; return(listConeccionServidor.ToList()); } }
public static void guardar(ConecionServidores model, ref string error) { using (MapWorldSystemEntities entity = new MapWorldSystemEntities()) { entity.ConecionServidores.Add(model); try { entity.SaveChanges(); } catch (Exception ex) { error = ex.Message; } } }
internal static void Actualizar(ConecionServidores model, ref string error) { using (MapWorldSystemEntities entity = new MapWorldSystemEntities()) { entity.Entry(model).State = System.Data.Entity.EntityState.Modified; try { entity.SaveChanges(); } catch (Exception ex) { error = ex.Message; } } }