private static void DeleteComHelper(Person person)
{
HelperDAO <Person> .SqlBuilder sqlBuilder = delegate(HelperDAO <Person> helper)
{
return("DELETE FROM people");
};
new HelperDAO <Person>(person).Delete(sqlBuilder, secureMode: false); // Optional argument defaults to true. Only allows insecure deletion explicitly.
}
private static void InsertComHelper(Person person)
{
HelperDAO <Person> .SqlBuilder sqlBuilder = delegate(HelperDAO <Person> helper)
{
return("INSERT INTO people (name) VALUES ('" + helper.data.name + "')");
};
new HelperDAO <Person>(person).Insert(sqlBuilder);
}
public List <ProjetoViewModel> ListagemComFiltro(string nome)
{
var tabela = HelperDAO.ExecutaFuncSelect("dbo.func_consultarProjeto", nome);
var lista = new List <ProjetoViewModel>();
if (tabela.Rows.Count == 0)
{
return(lista);
}
foreach (DataRow registro in tabela.Rows)
{
lista.Add(MontaModel(registro));
}
return(lista);
}
public List <CarrinhoProdutoViewModel> Listagem(int idCliente)
{
var p = new SqlParameter[]
{
new SqlParameter("@id_Cliente", idCliente)
};
var tabela = HelperDAO.ExecutaProcSelect("spCarrinho_Produto", p);
List <CarrinhoProdutoViewModel> carrinho = new List <CarrinhoProdutoViewModel>();
foreach (DataRow row in tabela.Rows)
{
carrinho.Add(MontaModelProduto(row));
}
return(carrinho);
}
public CarrinhoViewModel Consulta_IdCliente(int id_Cliente)
{
var p = new SqlParameter[]
{
new SqlParameter("@id_Cliente", id_Cliente)
};
var tabela = HelperDAO.ExecutaProcSelect("spConsulta_Carrinho_IdCliente", p);
if (tabela.Rows.Count == 0)
{
return(null);
}
else
{
return(MontaModel(tabela.Rows[0]));
}
}
public IActionResult FazLogin(string usuario, string senha)
{
if (HelperDAO.ExecutaProcLogin(usuario, senha))
{
UsuarioDAO userDAO = new UsuarioDAO();
var userviewModel = userDAO.ConsultaEmail(usuario);
HttpContext.Session.SetString("Logado", "true");
HttpContext.Session.SetString("IdUsuario", userviewModel.Id.ToString());
HttpContext.Session.SetString("NomeUsuario", userviewModel.Nome);
HttpContext.Session.SetString("EmailUsuario", userviewModel.Email);
HttpContext.Session.SetString("TipoUsuario", (((int)userviewModel.Tipo)).ToString());
return(RedirectToAction("index", "Home"));
}
else
{
ViewBag.Erro = "Usuário ou senha inválidos!";
return(View("Index"));
}
}
public List <CustomerInfoByAirlineName> GetFlightsByFlightNum(long flightNum)
{
_HelperDAO = new HelperDAO();
return(_HelperDAO.GetFlightsByFlightNum(flightNum));
}
public List <CustomerInfoByAirlineName> GetFlightsByOriginCountryName(string originCountryName)
{
_HelperDAO = new HelperDAO();
return(_HelperDAO.GetFlightsByOriginCountryName(originCountryName));
}
public List <CustomerInfoByAirlineName> GetFlightsByAirlineName(string airlineName)
{
_HelperDAO = new HelperDAO();
return(_HelperDAO.GetFlightsByAirlineName(airlineName));
}
public List <FlightInfoFromDb> GetFlightsByDesCountryNameFromDb(string countryName)
{
_HelperDAO = new HelperDAO();
return(_HelperDAO.GetFlightsByDesCountryNameFromDb(countryName));
}
public List <ArrivalsPoco> GetArrivalsDetails()
{
_HelperDAO = new HelperDAO();
return(_HelperDAO.ArrivalsDetails());
}
public List <DeparturesPoco> GetDepartureDetails()
{
_HelperDAO = new HelperDAO();
return(_HelperDAO.DeparturesDetails());
}
