private async Task FillCombosRun() { DateTime todayyo = DateTime.Today; string none = "none"; SQLExecute sqlexec = new SQLExecute(); taxi = await sqlexec.SQLGetTaxi(Properties.Settings.Default.DBName, 0, none, 0, none, none, none, 0, none, none, 0, todayyo, none, true); owner.Clear(); owner.Clear(); driver.Clear(); depthsAll.Clear(); depthsAllPaid.Clear(); person.Clear(); owner = await sqlexec.SQLGetPerson(Properties.Settings.Default.DBName, 0, none, none, none, 0, 0, none, 0, todayyo, none, 2, false); driver = await sqlexec.SQLGetPerson(Properties.Settings.Default.DBName, 0, none, none, none, 0, 0, none, 0, todayyo, none, 1, false); depthsAll = await sqlexec.SQLGetDepth(Properties.Settings.Default.DBName, 0, 0, none, todayyo, null, none, 0, none, 0, none, false); depthsAllPaid = await sqlexec.SQLGetDepth(Properties.Settings.Default.DBName, 0, 0, none, todayyo, "", none, 0, none, 0, none, false); person.AddRange(driver); person.AddRange(owner); }
private async void Button_Click_Save(object sender, RoutedEventArgs e) { //depthsUpdate string query = ""; if (depthsUpdate.Count == 0) { return; } foreach (Depth d in depthsUpdate) { //query += $"UPDATE Depth SET Paid = '{d.Paid}' WHERE DepthID = '{d.DepthID}'; "; query += $"UPDATE Depth SET RepaidAmount = '{d.RepaidAmount}' WHERE DepthID = '{d.DepthID}';"; if (d.Amount == d.RepaidAmount) { query += $"UPDATE Depth SET Paid = '' WHERE DepthID = '{d.DepthID}'; "; //Create Income's if (true) { } } else { query += $"UPDATE Depth SET Paid = NULL WHERE DepthID = '{d.DepthID}'; "; } } SQLExecute sqlexec = new SQLExecute(); await Task.Run(() => sqlexec.SQLCommand(Properties.Settings.Default.DBName, query)); string none = "none"; DateTime todayyo = DateTime.Today; //Create Income's depthsAll = await sqlexec.SQLGetDepth(Properties.Settings.Default.DBName, 0, 0, none, todayyo, null, none, 0, none, 0, none, false); depthsAllPaid = await sqlexec.SQLGetDepth(Properties.Settings.Default.DBName, 0, 0, none, todayyo, "", none, 0, none, 0, none, false); await refreshAll(); }