private void btn_del_Click(object sender, EventArgs e) { if (action == 2 && id>0) { DialogResult r = MessageBox.Show("Al eliminar un paciente se elimina tambien su historial de citas.", "Estas seguro?", MessageBoxButtons.YesNo); if (r == DialogResult.Yes) { Connection c = new Connection(); c.execute("delete from reservation where pacient_id=" + id); c.execute("delete from pacient where id=" + id); MessageBox.Show("Eliminado exitosamente!"); Dispose(); } } }
private void btn_del_Click(object sender, EventArgs e) { if (action == 2 && id > 0) { DialogResult r = MessageBox.Show("Al eliminar un paciente se elimina tambien su historial de citas.", "Estas seguro?", MessageBoxButtons.YesNo); if (r == DialogResult.Yes) { Connection c = new Connection(); c.execute("delete from reservation where pacient_id=" + id); c.execute("delete from pacient 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"); } }
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"); } }
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"); } }
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"); } }