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 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");
}
}
