//delete a record
public static int Delete(string id)
{
int retorno = 0;
MySqlCommand comando = new MySqlCommand(string.Format("delete from contact where id='" + id + "'"), Conexion.ObtenerConexion());
retorno = comando.ExecuteNonQuery();
Conexion.CerrarConexion();
return(retorno);
}
//update a record
public static int update(string id, string name, string lastname, string address, string phone, string email)
{
int retorno = 0;
MySqlCommand comando = new MySqlCommand(string.Format("update contact set name='" + name + "', lastname='" + lastname + "', address='" + address + "', phone='" + phone + "', email='" + email + "' where id='" + id + "'"), Conexion.ObtenerConexion());
retorno = comando.ExecuteNonQuery();
Conexion.CerrarConexion();
return(retorno);
}
//consult all records
public static List <contact> Query()
{
List <contact> lista = new List <contact>();
MySqlCommand comando = new MySqlCommand(string.Format("select * from contact"), Conexion.ObtenerConexion());
MySqlDataReader reader = comando.ExecuteReader();
while (reader.Read())
{
contact c = new contact();
c.Idd = reader.GetString(0);
c.Name = reader.GetString(1);
c.LastName = reader.GetString(2);
c.Address = reader.GetString(3);
c.Phone = reader.GetString(4);
c.Email = reader.GetString(5);
c.Created = reader.GetString(6);
lista.Add(c);
}
Conexion.CerrarConexion();
return(lista);
}
//consult for ID
public static Array QueryID(int id)
{
string[] result = new string[] { };
MySqlCommand comando = new MySqlCommand(string.Format("select * from contact where id=" + id), Conexion.ObtenerConexion());
MySqlDataReader reader = comando.ExecuteReader();
if (reader.Read() == true)
{
contact c = new contact();
string i = c.Idd = reader.GetString(0);
string n = c.Name = reader.GetString(1);
string ln = c.LastName = reader.GetString(2);
string a = c.Address = reader.GetString(3);
string p = c.Phone = reader.GetString(4);
string e = c.Email = reader.GetString(5);
string cr = c.Created = reader.GetString(6);
result = new string[] { i, n, ln, a, p, e, cr };
}
Conexion.CerrarConexion();
return(result);
}
//insert new record
public static int Insertar(string name, string lastname, string address, string phone, string email)
{
int retorno = 0;
MySqlCommand comando = new MySqlCommand(string.Format("Insert into contact(name, lastname, address, phone, email, created_at) values('{0}','{1}','{2}', '{3}','{4}',now())", name, lastname, address, phone, email), Conexion.ObtenerConexion());
retorno = comando.ExecuteNonQuery();
Conexion.CerrarConexion();
return(retorno);
}