private void Refresh()
{
DataSet1TableAdapters.PatientTableAdapter ta =
new DataSet1TableAdapters.PatientTableAdapter();
DataSet1.PatientDataTable dt = ta.GetDataPatient();
dataGridView1.DataSource = dt;
dataGridView1.Columns[0].HeaderText = "Id";
dataGridView1.Columns[1].HeaderText = "Nombre";
dataGridView1.Columns[2].HeaderText = "Apellido";
dataGridView1.Columns[3].HeaderText = "Email";
}
private bool IsPatient()
{
DataSet1TableAdapters.PatientTableAdapter patient = new DataSet1TableAdapters.PatientTableAdapter();
DataSet1.PatientDataTable dt = patient.GetDataByUP(txtUserName.Text, txtPassword.Text);
if (dt.Rows.Count == 0)
{
return(false);
}
Tools.userType = UserType.Patient;
DataRow dr = dt.Rows[0];
Tools.UserName = Convert.ToString(dr["UserName"]);
return(true);
}
private void txtBuscarPac_KeyPress(object sender, KeyPressEventArgs e)
{
try
{
DataSet1TableAdapters.PatientTableAdapter ta = new DataSet1TableAdapters.PatientTableAdapter();
DataSet1.PatientDataTable dt = ta.GetDataByFilteringP(txtBuscarPac.Text, txtBuscarPac.Text, txtBuscarPac.Text);
ta.FillBy1FilteringP(dt, txtBuscarPac.Text, txtBuscarPac.Text, txtBuscarPac.Text);
dataGridView1.DataSource = dt;
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnEditar_Click(object sender, EventArgs e)
{
int?id = GetId();
//MessageBox.Show(id.ToString());
if (id != null)
{
DataSet1TableAdapters.PatientTableAdapter ta = new DataSet1TableAdapters.PatientTableAdapter();
DataSet1.PatientDataTable pt = ta.GetDataByIdPatient((int)id);
DataSet1.PatientRow row = (DataSet1.PatientRow)pt.Rows[0];
txtNombre.Text = row.patientName;
txtApellido.Text = row.patientLastName;
txtEmail.Text = row.patientEmail;
}
else
{
MessageBox.Show("No hay registros");
}
}
private void btnEliminar_Click(object sender, EventArgs e)
{
string message = "Esta seguro que desea eliminar este registro?";
string title = "Advertencia";
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
//
int?id = GetId();
if (id == null)
{
MessageBox.Show("No hay registros");
}
else
{
DialogResult result = MessageBox.Show(message, title, buttons);
if (result == DialogResult.Yes)
{
if (id != null)
{
DataSet1TableAdapters.PatientTableAdapter ta = new DataSet1TableAdapters.PatientTableAdapter();
try
{
ta.DeleteQueryPatient((int)id);
Refresh();
}
catch (Exception mensaje)
{
MessageBox.Show(mensaje.ToString());
}
}
}
else
{
// Do something
}
}
}
private void btnOK_Click(object sender, EventArgs e)
{
if (userNameTextBox.Text.Trim() == "" || passwordTextBox.Text.Trim() == "")
{
MessageBox.Show("Username & password Error");
return;
}
DataSet1TableAdapters.PatientTableAdapter patient = new DataSet1TableAdapters.PatientTableAdapter();
DataSet1.PatientDataTable dt = patient.GetDataByUserName(userNameTextBox.Text);
if (dt.Rows.Count > 0 && UserName.Trim() == "")
{
MessageBox.Show("Username Error");
return;
}
else
{
this.Validate();
this.patientBindingSource.EndEdit();
this.patientTableAdapter.Update(this.dataSet1.Patient);
DialogResult = DialogResult.OK;
}
}
private void btnGuardar_Click(object sender, EventArgs e)
{
MessageBox.Show(idd.ToString());
DataSet1TableAdapters.PatientTableAdapter ta = new DataSet1TableAdapters.PatientTableAdapter();
MessageBox.Show(idd.ToString());
if (string.IsNullOrWhiteSpace(txtNombre.Text) || string.IsNullOrWhiteSpace(txtApellido.Text) ||
string.IsNullOrWhiteSpace(txtEmail.Text) || (!(txtEmail.Text.Contains('@'))) || (!(txtEmail.Text.Contains('.')))
)
{
MessageBox.Show("Verifique que todos los campos hayan sido llenados correctamente");
}
else
if (idd == 0)
{
ta.InsertQueryPatient(txtNombre.Text.Trim(), txtApellido.Text.Trim(), txtEmail.Text.Trim());
txtNombre.Clear();
txtApellido.Clear();
txtEmail.Clear();
idd = 0;
Refresh();
}
else
{
ta.UpdateQueryPatient(txtNombre.Text.Trim(), txtApellido.Text.Trim(), txtEmail.Text.Trim(), (int)idd);
txtNombre.Clear();
txtApellido.Clear();
txtEmail.Clear();
idd = 0;
Refresh();
}
}
