private void BtnLoadOptions_Click(object sender, EventArgs e) { CrmConnManager.Connect(); OptionSetManager.LoadMeta(); OptionSetManager.Compare(); DisplayOptionTree(); }
private static void DeltaDelete() { CrmConnManager.Connect(); var con = "Server=KCITSV0PPPJMI02;Database=JMSStaging;Trusted_Connection=True;Connection Timeout=180"; using (SqlConnection myConnection = new SqlConnection(con)) { myConnection.Open(); var entities = new List <CrmEntity>(); var query = $"select * from common.deltaentities"; SqlCommand cmd = new SqlCommand(query, myConnection); using (SqlDataReader oReader = cmd.ExecuteReader()) { while (oReader.Read()) { var vn = oReader["JMSView"].ToString(); var en = oReader["EntityName"].ToString(); var pan = $"{en}id"; var e = new CrmEntity() { EntityName = en, PrimaryAttributeName = pan, JMSView = vn }; entities.Add(e); } } var sb = new StringBuilder(); foreach (var en in entities) { if (en.EntityName != "tri_offendercontact") { query = $"Select {en.PrimaryAttributeName} from {en.JMSView}"; cmd = new SqlCommand(query, myConnection); cmd.CommandTimeout = 180; try { using (SqlDataReader oReader = cmd.ExecuteReader()) { while (oReader.Read()) { var jmsid = oReader[en.PrimaryAttributeName].ToString(); en.PartialDeleteList.Add(jmsid); //Console.WriteLine($"JMSId: {jmsid}"); } } var count = en.RetrieveRecords(CrmConnManager.Service); Console.WriteLine($"JMSViewname: {en.JMSView}, DestEntityName: {en.EntityName}, PrimaryAttrName: {en.PrimaryAttributeName} - Count: {count}"); en.DeleteRecords(CrmConnManager.Service); } catch (Exception ex) { sb.Append($"query: {query}, exception: {ex.Message}{Environment.NewLine}"); } } } Console.WriteLine("Errors =================================================================================="); Console.WriteLine(sb.ToString()); Console.ReadKey(); myConnection.Close(); } }