public static ListaFilial ListaFilial(String filial) { SqlConnection conn = new SqlConnection("IMPUT STRING CONNECTION"); try { conn.Open(); String sqlFilial = "Select Endereco, Bairro, Uf, Telefone, Cidade"; sqlFilial += " from filial "; sqlFilial += " where Ativo = 'S' "; SqlDataAdapter dapFilial = new SqlDataAdapter(sqlFilial, conn); DataTable dtsFilial = new DataTable(); dapFilial.Fill(dtsFilial); List<Filial> lus = new List<Filial>(); Filial us = null; if (dtsFilial.Rows.Count != 0) { for (int i = 0; i <= dtsFilial.Rows.Count - 1; i++) { us = new Filial(); us.Endereco = dtsFilial.Rows[i]["Endereco"].ToString(); us.Bairro = dtsFilial.Rows[i]["Bairro"].ToString(); us.UF = dtsFilial.Rows[i]["UF"].ToString(); us.Telefone = dtsFilial.Rows[i]["Telefone"].ToString(); us.Cidade = dtsFilial.Rows[i]["Cidade"].ToString(); lus.Add(us); } } ListaFilial list = new ListaFilial(); list.Filial = lus; return list; } finally { conn.Close(); } }
public HttpResponseMessage GetAllFilial(String Token) { try { ListaFilial listaFilial = new ListaFilial(); listaFilial = FilialDAL.ListaFilial("0"); return Request.CreateResponse(HttpStatusCode.OK, listaFilial); } catch (HttpResponseException ex) { return ex.Response; } catch (InvalidCastException ex) { return Request.CreateErrorResponse(HttpStatusCode.BadGateway, ex.Message); } }