public List <FriendViewModel> GetOneFriendByName(string name)
{
List <FriendViewModel> lista = new List <FriendViewModel>();
FriendViewModel auxiliar = new FriendViewModel();
DataTable dataTable = new DataTable();
Conexao.Conexao conect = new Conexao.Conexao();
conect.string_conexao = stringDeConexao;
if (conect.conectar())
{
conect.Executar("select * " +
"from Friends " +
"where " +
"FirstName like '%" + name + "%'", true);
dataTable = conect.GetData("Friends");
conect.desconectar();
}
foreach (DataRow dr in dataTable.Rows)
{
auxiliar.FriendId = (int)dr["FriendId"];
auxiliar.FirstName = dr["FirstName"].ToString();
auxiliar.LastName = dr["LastName"].ToString();
auxiliar.BirthDate = DateTime.Parse(dr["BirthDate"].ToString());
lista.Add(auxiliar);
}
return(lista);
}
public List <FriendViewModel> GetAllFriends()
{
List <FriendViewModel> lst = new List <FriendViewModel>();
FriendViewModel aux = new FriendViewModel();
DataTable dt = new DataTable();
Conexao.Conexao banco = new Conexao.Conexao();
banco.string_conexao = stringDeConexao;
if (banco.conectar())
{
banco.Executar("select * " +
"from Friends", true);
dt = banco.GetData("Friends");
banco.desconectar();
}
foreach (DataRow dr in dt.Rows)
{
aux = new FriendViewModel();
aux.FriendId = (int)dr["FriendId"];
aux.FirstName = dr["FirstName"].ToString();
aux.LastName = dr["LastName"].ToString();
aux.BirthDate = DateTime.Parse(dr["BirthDate"].ToString());
lst.Add(aux);
}
return(lst);
}
public bool DeleteAFriendById(int id)
{
bool res = false;
Conexao.Conexao connect = new Conexao.Conexao();
connect.string_conexao = stringDeConexao;
if (connect.conectar())
{
res = connect.Executar(string.Format(
"delete Pessoa " +
" where id = {0}",
id.ToString()), false);
connect.desconectar();
}
return(res);
}
public bool InsertFriends(FriendViewModel newFriend)
{
bool result = false;
string dataformatada = string.Format(newFriend.BirthDate.ToString("yyyy-MM-dd"));
string sql = "insert into dbo.Friends " +
" ( FirstName, LastName, BirthDate )" +
" values " +
" ('" + newFriend.FirstName + "','" + newFriend.LastName + "','" + dataformatada + "') ";
Conexao.Conexao BD = new Conexao.Conexao();
BD.string_conexao = stringDeConexao;
BD.conectar();
result = BD.Executar(sql, false);
BD.desconectar();
return(result);
}
public bool UpdateAFriend(FriendViewModel friendViewModel)
{
bool res = false;
Conexao.Conexao Connect = new Conexao.Conexao();
Connect.string_conexao = stringDeConexao;
if (Connect.conectar())
{
res = Connect.Executar(string.Format("update Friends " +
" set FirstName = '{0}', " +
" LastName = '{1}'," +
" BirthDate = '{2}'" +
" where FriendId = {3}",
friendViewModel.FirstName,
friendViewModel.LastName,
friendViewModel.BirthDate,
friendViewModel.FriendId), false);
Connect.desconectar();
}
return(res);
}