1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63
| private static SqlConnection conn1 = new SqlConnection("Data Source=..\\..; " +
"Initial Catalog=..;Integrated Security=True");
private static SqlConnection conn2 = new SqlConnection("Data Source=..\\..; " +
"Initial Catalog=..;Integrated Security=True");
#endregion
#region Methods
#region FetchAllUsers Method
public static List<UserBO> FetchAllUsers ()
{
List<UserBO> lstUsers = new List<UserBO>();
try
{
conn1.Open();
conn2.Open();
SqlCommand cmd1 = new SqlCommand("SELECT DISTINCT FIRSTNAME, LASTNAME FROM USERS", conn1);
SqlCommand cmd2 = new SqlCommand("SELECT DISTINCT FIRSTNAME, LASTNAME FROM USERS", conn2);
SqlDataReader reader1 = cmd1.ExecuteReader();
SqlDataReader reader2 = cmd2.ExecuteReader();
while (reader1.Read())
{
lstUsers .Add(
new UserBO()
{
Nom= reader1 ["FIRSTNAME"].ToString(),
Prenom= reader1 ["LASTNAME"].ToString()
}
);
}
while (reader2.Read())
{
lstUsers .Add(
new UserBO()
{
Nom= reader2 ["FIRSTNAME"].ToString(),
Prenom= reader2 ["LASTNAME"].ToString()
}
);
}
reader1.Close();
conn1.Close();
reader2.Close();
conn2.Close();
return lstUsers ;
}
catch (Exception e)
{
throw e;
}
}
#endregion |
Partager