public DataRaison GetDetailsSociete(int IdSoc) { OleDbDataReader reader = null; OleDbCommand cmd = null; DataRaison societe = new DataRaison(); string query = "SELECT * FROM Societe where Num = " + IdSoc; try { cnx.Open(); cmd = cnx.CreateCommand(); cmd.Connection = cnx; cmd.CommandText = query; reader = cmd.ExecuteReader(); if (reader.Read()) { societe.Num = int.Parse(reader["Num"].ToString()); societe.Societe = reader["NomSoc"].ToString(); societe.CodeSoc = reader["CodeSoc"].ToString(); societe.GrossToNetTableName = reader["GrossToNetTableName"].ToString(); } } catch (Exception ex) { //throw new Exception(ex.Message); } finally { if (reader != null) { reader.Close(); reader = null; } if (cmd != null) { cmd = null; } if (cnx != null) { cnx.Close(); } } return societe; }
public List<DataRaison> GetSociteList() { OleDbDataReader reader = null; OleDbCommand cmd = null; List<DataRaison> societes = new List<DataRaison>(); string query = "SELECT * FROM Societe ORDER BY NomSoc ASC"; try { cnx.Open(); cmd = cnx.CreateCommand(); cmd.Connection = cnx; cmd.CommandText = query; reader = cmd.ExecuteReader(); DataRaison societe; while (reader.Read()) { societe = new DataRaison(); societe.Num = int.Parse(reader["Num"].ToString()); societe.Societe = reader["NomSoc"].ToString(); societe.CodeSoc = reader["CodeSoc"].ToString(); societes.Add(societe); } } catch (Exception ex) { //throw new Exception(ex.Message); } finally { if (reader != null) { reader.Close(); reader = null; } if (cmd != null) { cmd = null; } if (cnx != null) { cnx.Close(); } } return societes; }