public Login Logar(_Database db, Login acesso) { var query = string.Format("SELECT NOME, IDENTIFICAO, SENHA FROM dbo.Usuarios WHERE IDENTIFICACAO='{0}' AND SENHA='{1}'", acesso.identificacao, acesso.senha); Login result = db.Database.SqlQuery <Login>(query).FirstOrDefault(); return(result); }
public UrlBackendMobile PegarPorId(_Database db, int id) { var query = String.Format("SELECT * FROM dbo.UrlBackendMobile WHERE id = {0}", id); var url = db.Database.SqlQuery <UrlBackendMobile>(query).FirstOrDefault(); return(url); }
public List <UrlBackendMobile> PegarTodos(_Database db) { var query = "SELECT * FROM dbo.UrlBackendMobile"; var url = db.Database.SqlQuery <UrlBackendMobile>(query).ToList(); return(url); }
public bool Inserir(_Database db, UrlBackendMobile url) { try { var query = String.Format("INSERT INTO dbo.UrlBackendMobile VALUES ('{0}', '{1}', {2}, {3})", url.CNPJ, url.URL, url.PortaRetaguarda, url.PortaApp); db.Database.ExecuteSqlCommand(query); return(true); } catch (Exception) { return(false); } }
public bool Atualizar(_Database db, UrlBackendMobile url) { try { var query = String.Format("UPDATE dbo.UrlBackendMobile SET CNPJ = '{0}', URL = '{1}', PortaRetaguarda = {2}, PortaApp = {3} WHERE id = {4}" , url.CNPJ, url.URL, url.PortaRetaguarda, url.PortaApp, url.id); db.Database.ExecuteSqlCommand(query); return(true); } catch (Exception e) { return(false); } }