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); }
public ReservationForm() { InitializeComponent(); pas = PacientObj.getAll(); mes = MedicObj.getAll(); foreach (MedicObj m in mes) { medic.Items.Add(m.name + " " + m.lastname); } foreach (PacientObj p in pas) { pacient.Items.Add(p.name + " " + p.lastname); } if (action == 1) { btn_del.Enabled = false; } else if (action == 2) { label_title.Text = "Editar Cita"; Text = "Editar Cita"; btn_del.Enabled = true; ReservationObj p = ReservationObj.getById(id); if (p.id > 0) { title.Text = p.title; note.Text = p.note; date_at.Text = p.date_at; time_at.Text = p.time_at; int n = 0; foreach (MedicObj m in mes) { if (m.id == p.medic_id) { medic.SelectedIndex = n; break; } n++; } n = 0; foreach (PacientObj m in pas) { if (m.id == p.pacient_id) { pacient.SelectedIndex = n; break; } n++; } } else { MessageBox.Show("No se encontro el paciente."); } } }
private void button1_Click(object sender, EventArgs e) { String sql = " select * from reservation "; if (q.Text != "") { sql += "where title like '%" + q.Text + "%' "; } if (pacient.SelectedIndex != -1) { if (q.Text == "") { sql += " where "; } else { sql += " and "; } sql += " pacient_id = " + pas[pacient.SelectedIndex].id; } if (medic.SelectedIndex != -1) { if (q.Text == "" && pacient.SelectedIndex == -1) { sql += " where "; } else { sql += " and "; } sql += " medic_id = " + mes[medic.SelectedIndex].id; } if (q.Text == "" && pacient.SelectedIndex == -1 && medic.SelectedIndex == -1) { sql += " where "; } else { sql += " and "; } sql += " date_at=\"" + date_at.Value.ToString("yyyy-MM-dd") + "\""; fill(ReservationObj.getBySQL(sql)); }
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 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; }
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); }