private bool IsDoctor()
{
DataSet1TableAdapters.DoctorTableAdapter doctor = new DataSet1TableAdapters.DoctorTableAdapter();
DataSet1.DoctorDataTable dt = doctor.GetDataByUP(txtUserName.Text, txtPassword.Text);
if (dt.Rows.Count == 0)
{
return(false);
}
DataRow dr = dt.Rows[0];
if (Convert.ToBoolean(dr["IsAdmin"]))
{
Tools.userType = UserType.Admin;
}
else
{
Tools.userType = UserType.Doctor;
}
Tools.UserName = Convert.ToString(dr["UserName"]);
return(true);
}
private void txtBuscarDoctor_KeyPress(object sender, KeyPressEventArgs e)
{
try
{
DataSet1TableAdapters.DoctorTableAdapter ta = new DataSet1TableAdapters.DoctorTableAdapter();
DataSet1.DoctorDataTable dt = ta.GetDataByFilteringD(txtBuscarDoctor.Text, txtBuscarDoctor.Text);
// DataSet1.DoctorRow row = (DataSet1.DoctorRow)dt.Rows[0];
/**/
//Cargamos el resultado en el DataTable
// ta.Fill(dt);
ta.FillBy1FilteringD(dt, txtBuscarDoctor.Text, txtBuscarDoctor.Text);
//Cargamos el DGV
dataGridView1.DataSource = dt;
/**/
// txtNombre.Text = row.DoctorName;
// txtApellido.Text = row.DoctorLastName;
/*
* DataSet1TableAdapters.DoctorTableAdapter ta = new DataSet1TableAdapters.DoctorTableAdapter();
* DataSet1.DoctorDataTable dt = ta.GetDataByFilteringD(txtBuscarDoctor.Text, txtBuscarDoctor.Text);
* DataSet1.DoctorRow row = (DataSet1.DoctorRow)dt.Rows[0];
* txtNombre.Text = row.DoctorName;
* txtApellido.Text = row.DoctorLastName;
*/
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnGuardar_Click(object sender, EventArgs e)
{
MessageBox.Show(idd.ToString());
DataSet1TableAdapters.DoctorTableAdapter ta = new DataSet1TableAdapters.DoctorTableAdapter();
// MessageBox.Show(idd.ToString());
if (string.IsNullOrWhiteSpace(txtNombre.Text) || string.IsNullOrWhiteSpace(txtApellido.Text))
{
MessageBox.Show("Verifique que ningun campo este vacio");
}
else
if (idd == 0)
{
ta.InsertQueryDoctor(txtNombre.Text.Trim(), txtApellido.Text.Trim());
txtNombre.Clear();
txtApellido.Clear();
idd = 0;
Refresh();
}
else
{
ta.UpdateQueryDoctor(txtNombre.Text.Trim(), txtApellido.Text.Trim(), (int)idd);
txtNombre.Clear();
txtApellido.Clear();
idd = 0;
Refresh();
}
// this.Close();
}
private void Refresh()
{
DataSet1TableAdapters.DoctorTableAdapter ta =
new DataSet1TableAdapters.DoctorTableAdapter();
DataSet1.DoctorDataTable dt = ta.GetDataDoctor();
dataGridView1.DataSource = dt;
dataGridView1.Columns[0].HeaderText = "Id";
dataGridView1.Columns[1].HeaderText = "Nombre";
dataGridView1.Columns[2].HeaderText = "Apellido";
}
}//getdoctorLastName
private void btnEditar_Click(object sender, EventArgs e)
{
int?id = GetId();
// MessageBox.Show(id.ToString());
if (id != null)
{
DataSet1TableAdapters.DoctorTableAdapter ta = new DataSet1TableAdapters.DoctorTableAdapter();
DataSet1.DoctorDataTable dt = ta.GetDataByIdDoctor((int)id);
DataSet1.DoctorRow row = (DataSet1.DoctorRow)dt.Rows[0];
txtNombre.Text = row.DoctorName;
txtApellido.Text = row.DoctorLastName;
}
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.DoctorTableAdapter ta = new DataSet1TableAdapters.DoctorTableAdapter();
try
{
ta.DeleteQueryDoctor((int)id);
Refresh();
}
catch (Exception mensaje)
{
MessageBox.Show(mensaje.ToString());
}
}
}
else
{
// Do something
}
}
}
