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