public async Task <int> Syn() { await Task.Delay(100); try { SynchroRef.SynchronizationClient client = new SynchroRef.SynchronizationClient(); if (client.SynchroToCentralDB().Equals("OK")) { MessageBox.Show("Successfully Synchroed to Central Database!!!"); List <SynchroRef.Synchro> synchros = client.GetRecords().ToList(); var groups1 = synchros.Where(x => x.TableName != "Synchroes").AsEnumerable().GroupBy(g => g.TableName).Select(g => new { TableName = g.Key, Records = g.Count() }).ToList(); dataGridView2.DataSource = groups1; label4.Text = null; MessageBox.Show("Your Last Synchro Date changed to " + synchros.Where(x => x.TableName.Equals("Synchroes")).FirstOrDefault().Operation.Substring(0, 10).ToString()); label4.Text = "Last Synchro Date : " + synchros.Where(x => x.TableName.Equals("Synchroes")).FirstOrDefault().Operation.Substring(0, 10).ToString(); } } catch (Exception exp) { MessageBox.Show(exp.ToString()); } button3.Enabled = true; label5.Text = ""; label6.Text = ""; return(await Task.Run <int>(() => { return 0; })); }
private void Synchronization_Load(object sender, EventArgs e) { Location = new Point(-7, 50); int w = SystemInformation.VirtualScreen.Width + 14; int h = SystemInformation.VirtualScreen.Height - 43; Size = new Size(w, h); dataGridView1.DefaultCellStyle.Font = new Font("Microsoft Sans Serif", 10); dataGridView2.DefaultCellStyle.Font = new Font("Microsoft Sans Serif", 10); SynchroRef.SynchronizationClient client = new SynchroRef.SynchronizationClient(); List <SynchroRef.Synchro> synchros = client.GetRecords().ToList(); label3.Text = label3.Text + " " + DateTime.Now.ToShortDateString(); label4.Text = label4.Text + " " + synchros.Where(x => x.TableName.Equals("Synchroes")).FirstOrDefault().Operation.Substring(0, 10).ToString(); var groups = synchros.Where(x => x.TableName != "Synchroes").AsEnumerable().GroupBy(g => g.TableName).Select(g => new { TableName = g.Key, Records = g.Count() }).ToList(); dataGridView2.DataSource = groups.ToList(); }