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 }