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