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