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);
}
}
