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