public DataTable CarregaLista(HomeEntity entity) { try { CriarConexao(); Abrir(); SqlDataAdapter Cmd = new SqlDataAdapter("BuscaListaCurtir", con); Cmd.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure; Cmd.SelectCommand.Parameters.Add("@EMAIL", SqlDbType.VarChar).Value = entity.Email; DataTable lista = new DataTable(); Cmd.Fill(lista); Fechar(); return lista; } catch (Exception e) { } finally { Fechar(); } return null; }
public DataTable CarregaPerfil(HomeEntity entity) { try { CriarConexao(); Abrir(); SqlDataAdapter Cmd = new SqlDataAdapter("CarregaPerfil", con); Cmd.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure; Cmd.SelectCommand.Parameters.Add("@USUARIO", SqlDbType.VarChar).Value = entity.Email; DataTable data = new DataTable(); Cmd.Fill(data); Fechar(); return data; } catch (Exception e) { } finally { Fechar(); } return null; }
public HomeEntity ModelToEntity(HomeModel model) { HomeEntity entity = new HomeEntity(); entity.Nome = model.Nome; entity.Email = model.Email; entity.Apelido = model.Apelido; entity.Url_foto = model.Url_foto; return entity; }