private void btn_del_Click(object sender, EventArgs e) { if (action == 2 && id > 0) { DialogResult r = MessageBox.Show("Deseas Eliminar?.", "Estas seguro?", MessageBoxButtons.YesNo); if (r == DialogResult.Yes) { Connection c = new Connection(); c.execute("delete from reservation where id=" + id); MessageBox.Show("Eliminado exitosamente!"); Dispose(); } } }
private void button1_Click(object sender, EventArgs e) { if (name.Text != "" && lastname.Text != "") { Connection c = new Connection(); if (action == 1) { c.execute("insert into pacient (name,lastname,address,email,phone) value (\"" + name.Text + "\",\"" + lastname.Text + "\",\"" + address.Text + "\",\"" + email.Text + "\",\"" + phone.Text + "\")"); name.Text = lastname.Text = address.Text = email.Text = phone.Text = ""; MessageBox.Show("Agregado exitosamente!"); } else if (action == 2 && id>0) { c.execute("update pacient set name=\"" + name.Text + "\",lastname=\"" + lastname.Text + "\",address=\"" + address.Text + "\",email=\"" + email.Text + "\",phone=\"" + phone.Text + "\" where id=" + id); MessageBox.Show("Actualizado exitosamente!"); } } else { MessageBox.Show("Campos Obligatorios: Nombre, Apellidos"); } }
public static ReservationObj getById(int product_id) { Connection c = new Connection(); MySqlCommand cmd = c.con.CreateCommand(); cmd.CommandText = "select * from reservation where id=" + product_id; c.con.Open(); MySqlDataReader r = cmd.ExecuteReader(); ReservationObj product = new ReservationObj(); while (r.Read()) { product.id = r.GetInt32("id"); product.date_at = r.GetString("date_at"); product.time_at = r.GetString("time_at"); product.note = r.GetString("note"); product.title = r.GetString("title"); product.pacient_id = r.GetInt32("pacient_id"); product.medic_id = r.GetInt32("medic_id"); break; } return product; }
public static PacientObj getById(int product_id) { Connection c = new Connection(); MySqlCommand cmd = c.con.CreateCommand(); cmd.CommandText = "select * from pacient where id=" + product_id; c.con.Open(); MySqlDataReader r = cmd.ExecuteReader(); PacientObj product = new PacientObj(); while (r.Read()) { product.id = r.GetInt32("id"); product.name = r.GetString("name"); product.lastname = r.GetString("lastname"); product.address = r.GetString("address"); product.phone = r.GetString("phone"); product.email = r.GetString("email"); break; } return product; }
public static List<PacientObj> getAll() { List<PacientObj> list = new List<PacientObj>(); Connection c = new Connection(); MySqlCommand cmd = c.con.CreateCommand(); cmd.CommandText = "select * from pacient"; c.con.Open(); MySqlDataReader r = cmd.ExecuteReader(); while (r.Read()) { PacientObj product = new PacientObj(); product.id = r.GetInt32("id"); product.name = r.GetString("name"); product.lastname = r.GetString("lastname"); product.address = r.GetString("address"); product.phone = r.GetString("phone"); product.email = r.GetString("email"); list.Add(product); } return list; }
public static List<ReservationObj> getBySQL(String sql) { List<ReservationObj> list = new List<ReservationObj>(); Connection c = new Connection(); MySqlCommand cmd = c.con.CreateCommand(); cmd.CommandText = sql; c.con.Open(); MySqlDataReader r = cmd.ExecuteReader(); while (r.Read()) { ReservationObj product = new ReservationObj(); product.id = r.GetInt32("id"); product.date_at = r.GetString("date_at"); product.time_at = r.GetString("time_at"); product.note = r.GetString("note"); product.title = r.GetString("title"); product.pacient_id = r.GetInt32("pacient_id"); product.medic_id = r.GetInt32("medic_id"); list.Add(product); } return list; }
private void button1_Click(object sender, EventArgs e) { if (title.Text != "" && pacient.SelectedIndex != -1 && medic.SelectedIndex != -1 && date_at.Text != "" && time_at.Text != "") { Connection c = new Connection(); if (action == 1) { c.execute("insert into reservation (title,pacient_id,medic_id,date_at,time_at,note,created_at) value (\"" + title.Text + "\",\"" + pas[pacient.SelectedIndex].id + "\",\"" + mes[medic.SelectedIndex].id + "\",\"" + date_at.Text + "\",\"" + time_at.Text + "\",\"" + note.Text + "\",NOW())"); title.Text = note.Text = date_at.Text = time_at.Text = ""; pacient.SelectedIndex = medic.SelectedIndex = -1; MessageBox.Show("Cita Agregada Exitosamente!"); } else if (action == 2 && id > 0) { c.execute("update reservation set title=\"" + title.Text + "\",pacient_id=\"" + pas[pacient.SelectedIndex].id + "\",medic_id=\"" + mes[medic.SelectedIndex].id + "\",date_at=\"" + date_at.Text + "\",time_at=\"" + time_at.Text + "\",note=\"" + note.Text + "\" where id=" + id); MessageBox.Show("Cita Actualizaa Exitosamente!"); } } else { MessageBox.Show("Campos Obligatorios: Asunto, Paciente, Medico, Fecha y Hora"); } }