public static FisioterapeutaComboBox ObtenerFisioterapuetasCombobox()
{
#region linq to class
//try
//{
// //RemoteModelDataContext dm = new RemoteModelDataContext();
// var collection = dm.SP_SeleccionarFisioterapuestasCombobox();
// FisioterapeutaComboBox fisioterapeutaComboBox = new FisioterapeutaComboBox();
// if (collection != null)
// {
// foreach (var fc in collection)
// {
// FisioterapeutaComboBox fisioterapeutaComboBoxBean = new FisioterapeutaComboBox();
// fisioterapeutaComboBoxBean.iCodigo = fc.iCodigoFisioterapeuta;
// fisioterapeutaComboBoxBean.strNombre = fc.vNombresFisioterapeuta;
// fisioterapeutaComboBoxBean.strApellidos = fc.VApellidosFisioterapeuta;
// fisioterapeutaComboBox.lstFisioterapeutasComboBox.Add(fisioterapeutaComboBoxBean);
// }
// return fisioterapeutaComboBox;
// }
// else
// return null;
//}
//catch (Exception ex)
//{
// return null;
//}
#endregion
#region SQL compact connection
SqlCeConnection conn = null;
SqlCeCommand cmd = null;
SqlCeDataReader rdr = null;
FisioterapeutaComboBox result = new FisioterapeutaComboBox();
try
{
conn = new SqlCeConnection("Data Source=" + System.IO.Path.Combine(Path.GetDirectoryName(System.Reflection.Assembly.GetEntryAssembly().Location), "HRNPCIData.sdf"));
conn.Open();
cmd = new SqlCeCommand("SELECT * From Fisioterapeuta", conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
if (rdr.GetInt32(12) == 0)
{
FisioterapeutaComboBox f = new FisioterapeutaComboBox();
f.iCodigo = rdr.GetInt32(0);
f.strNombre = rdr.GetString(1);
f.strApellidos = rdr.GetString(2);
result.lstFisioterapeutasComboBox.Add(f);
}
}
rdr.Close();
cmd.Dispose();
}
catch (Exception)
{
return(null);
}
finally
{
conn.Close();
}
return(result);
#endregion
}
public static FisioterapeutaComboBox ObtenerFisioterapuetasCombobox()
{
#region linq to class
//try
//{
// //RemoteModelDataContext dm = new RemoteModelDataContext();
// var collection = dm.SP_SeleccionarFisioterapuestasCombobox();
// FisioterapeutaComboBox fisioterapeutaComboBox = new FisioterapeutaComboBox();
// if (collection != null)
// {
// foreach (var fc in collection)
// {
// FisioterapeutaComboBox fisioterapeutaComboBoxBean = new FisioterapeutaComboBox();
// fisioterapeutaComboBoxBean.iCodigo = fc.iCodigoFisioterapeuta;
// fisioterapeutaComboBoxBean.strNombre = fc.vNombresFisioterapeuta;
// fisioterapeutaComboBoxBean.strApellidos = fc.VApellidosFisioterapeuta;
// fisioterapeutaComboBox.lstFisioterapeutasComboBox.Add(fisioterapeutaComboBoxBean);
// }
// return fisioterapeutaComboBox;
// }
// else
// return null;
//}
//catch (Exception ex)
//{
// return null;
//}
#endregion
#region SQL compact connection
SqlCeConnection conn = null;
SqlCeCommand cmd = null;
SqlCeDataReader rdr = null;
FisioterapeutaComboBox result = new FisioterapeutaComboBox();
try
{
conn = new SqlCeConnection("Data Source=" + System.IO.Path.Combine(Path.GetDirectoryName(System.Reflection.Assembly.GetEntryAssembly().Location), "HRNPCIData.sdf"));
conn.Open();
cmd = new SqlCeCommand("SELECT * From Fisioterapeuta", conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
if (rdr.GetInt32(12) == 0)
{
FisioterapeutaComboBox f = new FisioterapeutaComboBox();
f.iCodigo = rdr.GetInt32(0);
f.strNombre = rdr.GetString(1);
f.strApellidos = rdr.GetString(2);
result.lstFisioterapeutasComboBox.Add(f);
}
}
rdr.Close();
cmd.Dispose();
}
catch (Exception)
{
return null;
}
finally
{
conn.Close();
}
return result;
#endregion
}
