public static void nuevoCliente(ENTCliente cli)
{
ObjConnection.Open();
string sql = "insert into cliente values (null,'" +
cli.nombre + "','" +
cli.direccion + "','" +
cli.telefono + "'" +
");";
SQLiteCommand command = new SQLiteCommand(sql, ObjConnection);
command.ExecuteNonQuery();
ObjConnection.Close();
}
public static ENTCliente buscarIdCliente(Int32 id)
{
ENTCliente equi = null;
ObjConnection.Open();
SQLiteCommand ObjCommand = new SQLiteCommand("SELECT * FROM cliente where id=" + id + "", ObjConnection);
ObjCommand.CommandType = CommandType.Text;
SQLiteDataAdapter ObjDataAdapter = new SQLiteDataAdapter(ObjCommand);
DataTable dt = new DataTable("cliente");
ObjDataAdapter.Fill(dt);
ObjConnection.Close();
foreach (DataRow dr in dt.Rows)
{
equi = new ENTCliente
(
Convert.ToInt32(dr["id"].ToString()),
dr["nombre"].ToString(),
dr["direccion"].ToString(),
dr["telefono"].ToString()
);
}
return equi;
}
