public static void SynchT() { using (ClientsContext db = new ClientsContext()) using (SqlConnection con = new SqlConnection(Param.ConnectionString)) try { con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandText = "SELECT * FROM rate_list"; SqlDataReader dr = cmd.ExecuteReader(); List <TarifED> tarifsED = new List <TarifED>(); while (dr.Read()) { if (dr["Name"].ToString() != "") { var tarif = new TarifED { SQLGuid = dr["id_org"].ToString(), Name = dr["Name"].ToString(), DateApply = Convert.ToDateTime(dr["Date"]), LetterFileName = dr["letter_filename"] == DBNull.Value ? null : dr["Letter_filename"].ToString() }; tarifsED.Add(tarif); Console.WriteLine(db.Organizations.Where(o => EF.Functions.Like(o.SQLGuid, $"%{tarif.SQLGuid}%")).Count()); } } ; dr.Close(); db.SaveChanges(); } catch (SystemException ex) { Console.WriteLine(ex.Message); } }
static bool SynchTarifs() { using (ClientsContext db = new ClientsContext()) using (SqlConnection con = new SqlConnection(Param.ConnectionString)) try { con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandText = "SELECT * FROM rate_list"; SqlDataReader dr = cmd.ExecuteReader(); List <TarifED> tarifsED = new List <TarifED>(); while (dr.Read()) { if (dr["Name"].ToString() != "") { var tarif = new TarifED { SQLGuid = dr["id_org"].ToString(), Name = dr["Name"].ToString(), DateApply = Convert.ToDateTime(dr["Date"]), LetterFileName = dr["letter_filename"] == DBNull.Value ? null : dr["Letter_filename"].ToString() }; tarifsED.Add(tarif); foreach (var o in db.Organizations) { if (tarif.SQLGuid == o.SQLGuid) { o.TarifsED.Add(tarif); } } } } ; dr.Close(); foreach (var t in tarifsED) { foreach (var o in db.Organizations) { if (o.SQLGuid == t.SQLGuid) { Console.WriteLine(t.SQLGuid); o.TarifsED.Add(t); } } } db.SaveChanges(); } catch (SystemException ex) { Console.WriteLine(ex.Message); return(false); } return(true); }