public Pantalla_Profesionales_Menos_Horas_Trabajo(decimal anio, decimal semestre)
{
InitializeComponent();
anioConsulta = anio;
semestreConsulta = semestre;
espeAdapter = new GD2C2016DataSetTableAdapters.EspecialidadTableAdapter();
espeData = espeAdapter.obtenerEspecialidades();
foreach (DataRow espe in espeData.Rows)
{
comboBox2.Items.Add(espe.Field <string>("descripcion"));
}
planAdapter = new GD2C2016DataSetTableAdapters.Plan_MedicoTableAdapter();
planData = planAdapter.obtenerPlanesMedicos();
foreach (DataRow plan in planData.Rows)
{
comboBox1.Items.Add(plan.Field <string>("descripcion"));
}
topPMHadapter = new GD2C2016DataSetTableAdapters.topProfesionalesMenosHorasTableAdapter();
}
public Pantalla_Historial_Cambio_Plan(decimal idUser)
{
InitializeComponent();
planAdapter = new GD2C2016DataSetTableAdapters.Plan_MedicoTableAdapter();
planData = planAdapter.consultarCambiosDePlan(idUser);
foreach (DataRow plan in planData.Rows)
{
dataGridView1.Rows.Add(plan.Field <DateTime>("fecha_baja"),
plan.Field <string>("motivo"),
plan.Field <decimal>("codigo_plan"));
}
}
public Pantalla_Creacion_Afiliado()
{
InitializeComponent();
dateTimePicker1.Format = DateTimePickerFormat.Custom;
dateTimePicker1.CustomFormat = "dd/MM/yyyy";
var MyReader = new System.Configuration.AppSettingsReader();
fechaHoy = MyReader.GetValue("Datekey", typeof(string)).ToString();
dateTimePicker1.MaxDate = Convert.ToDateTime(fechaHoy);
comboBox1.Items.Add("DNI");
comboBox1.Items.Add("CI");
comboBox1.Items.Add("LE");
comboBox1.Items.Add("LC");
comboBox2.Items.Add("Masculino");
comboBox2.Items.Add("Femenino");
comboBox3.Items.Add("Soltero/a");
comboBox3.Items.Add("Casado/a");
comboBox3.Items.Add("Viudo/a");
comboBox3.Items.Add("Concubinato");
comboBox3.Items.Add("Divorciado/a");
planAdapter = new GD2C2016DataSetTableAdapters.Plan_MedicoTableAdapter();
planData = planAdapter.obtenerPlanesMedicos();
foreach (DataRow plan in planData.Rows)
{
comboBox4.Items.Add(plan.Field <string>("descripcion"));
}
}
public Pantalla_Modificacion_Datos_Afiliado(decimal idUser)
{
InitializeComponent();
planAdapter = new GD2C2016DataSetTableAdapters.Plan_MedicoTableAdapter();
planData = planAdapter.obtenerPlanesMedicos();
afiAdapter = new GD2C2016DataSetTableAdapters.AfiliadoTableAdapter();
afiData = afiAdapter.afiliadosPorID(idUser);
textBox1.Text = Convert.ToString(afiData.Rows[0].Field <decimal>("telefono"));
textBox2.Text = Convert.ToString(afiData.Rows[0].Field <string>("mail"));
textBox4.Text = Convert.ToString(afiData.Rows[0].Field <string>("Direccion"));
decimal plan = afiData.Rows[0].Field <decimal>("codigo_plan");
bool? sexo = afiData.Rows[0].Field <bool?>("sexo");
decimal?estadoCivil = afiData.Rows[0].Field <decimal?>("estado_civil");
nroAfiliado = afiData.Rows[0].Field <decimal>("numero_afiliado");
foreach (DataRow planM in planData.Rows)
{
comboBox4.Items.Add(planM.Field <string>("descripcion"));
}
nombrePlan = Convert.ToString(planAdapter.obtenerPlanMedicoPorID(plan));
comboBox2.Items.Add("Masculino");
comboBox2.Items.Add("Femenino");
comboBox3.Items.Add("Soltero/a");
comboBox3.Items.Add("Casado/a");
comboBox3.Items.Add("Viudo/a");
comboBox3.Items.Add("Concubinato");
comboBox3.Items.Add("Divorciado/a");
for (int i = 0; i < comboBox4.Items.Count; i++)
{
if (Convert.ToString(comboBox4.Items[i]) == nombrePlan)
{
comboBox4.SelectedIndex = i;
}
}
if (sexo == Convert.ToBoolean(1))
{
comboBox2.SelectedIndex = 0;
}
else
{
comboBox2.SelectedIndex = 1;
}
if (estadoCivil == 0)
{
comboBox3.SelectedIndex = 0;
}
else
{
if (estadoCivil == 1)
{
comboBox3.SelectedIndex = 1;
}
else
{
if (estadoCivil == 2)
{
comboBox3.SelectedIndex = 2;
}
else
{
if (estadoCivil == 3)
{
comboBox3.SelectedIndex = 3;
}
else
{
comboBox3.SelectedIndex = 4;
}
}
}
}
}
