public async Task CreateDatabaseAsync() { CreateDatatableStrings str = new CreateDatatableStrings(); sqlexec.SQLCommandKey(Properties.Settings.Default.DBName, str.FOREIGN_KEY(0)); //await SQLCommand(Properties.Settings.Default.DBName, str.FOREIGN_KEY(0)); await sqlexec.SQLCommand(Properties.Settings.Default.DBName, str.PersonType()); await sqlexec.SQLCommand(Properties.Settings.Default.DBName, str.Person()); await sqlexec.SQLCommand(Properties.Settings.Default.DBName, str.Taxi()); await sqlexec.SQLCommand(Properties.Settings.Default.DBName, str.Expense()); await sqlexec.SQLCommand(Properties.Settings.Default.DBName, str.Income()); await sqlexec.SQLCommand(Properties.Settings.Default.DBName, str.TypeExpense()); await sqlexec.SQLCommand(Properties.Settings.Default.DBName, str.TypeIncome()); await sqlexec.SQLCommand(Properties.Settings.Default.DBName, str.TaxiPayment()); await sqlexec.SQLCommand(Properties.Settings.Default.DBName, str.PrimaryDriver()); await sqlexec.SQLCommand(Properties.Settings.Default.DBName, str.Kilometer()); await sqlexec.SQLCommand(Properties.Settings.Default.DBName, str.Shift()); await sqlexec.SQLCommand(Properties.Settings.Default.DBName, str.Depth()); //await SQLCommand(Properties.Settings.Default.DBName, str.FOREIGN_KEY(1)); sqlexec.SQLCommandKey(Properties.Settings.Default.DBName, str.FOREIGN_KEY(1)); }
private async void CreateDatabase2(object sender, EventArgs e) { DialogResult dialogResult = MessageBox.Show("Sure", "Title", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.No) { return; } int index = 20; CreateDatatableStrings str = new CreateDatatableStrings(); //System.Threading.Thread.Sleep(1000); sqlexec.SQLCommandKey(Properties.Settings.Default.DBName, str.FOREIGN_KEY(0)); for (int i = 1; i <= index; i++) { this.elementHost1.Child = new WPFControll("Repetition number : " + i.ToString(), $"Go to {index}"); await FillFakeDatabase(i); } sqlexec.SQLCommandKey(Properties.Settings.Default.DBName, str.FOREIGN_KEY(1)); }
private async void CreateDatabaseBTN(object sender, EventArgs e) { DialogResult dialogResult = MessageBox.Show("Sure", "Title", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.No) { return; } var watch = System.Diagnostics.Stopwatch.StartNew(); CreateDatatableStrings str = new CreateDatatableStrings(); //await CreateDatabaseAsync(); sqlexec.SQLCommandKey(Properties.Settings.Default.DBName, str.FOREIGN_KEY(0)); await CreateDatabaseAsync(); //sqlexec.SQLCommandKey(Properties.Settings.Default.DBName, str.FOREIGN_KEY(0)); //await FillFakeDatabase(0); //sqlexec.SQLCommandKey(Properties.Settings.Default.DBName, str.FOREIGN_KEY(1)); watch.Stop(); var elapsedMs = watch.ElapsedMilliseconds; MessageBox.Show(elapsedMs.ToString()); }
private async void ButtonSave_Click(object sender, RoutedEventArgs e) { //Create Shift Object Shift newshift = new Shift(); try { newshift.PersonID = Int32.Parse(cmbDriver.SelectedValue.ToString()); } catch { MessageBox.Show("You Must select a Driver"); return; } try { newshift.TaxiID = Int32.Parse(cmbTaxi.SelectedValue.ToString()); } catch { MessageBox.Show("You Must select a Taxi"); return; } if (!DatePicker1.Value.HasValue) { newshift.ShiftDate = DateTime.Today; } else { newshift.ShiftDate = DatePicker1.Value.Value; } if (TxtXZ.Text != "") { newshift.XZ = Convert.ToDecimal(TxtXZ.Text); } if (TxtOil.Text != "") { newshift.Oil = Convert.ToDecimal(TxtOil.Text); } if (TxtXZFpa.Text != "") { newshift.XZFPA = Convert.ToDecimal(TxtXZFpa.Text); } if (TxtOilFpa.Text != "") { newshift.OilFPA = Convert.ToDecimal(TxtOilFpa.Text); } if (TxtShift.Text != "") { newshift.ShiftPayment = Convert.ToDecimal(TxtShift.Text); } if (TxtIka.Text != "") { newshift.Insurance = Convert.ToDecimal(TxtIka.Text); } if (TxtFpa.Text != "") { newshift.FPA = Convert.ToDecimal(TxtFpa.Text); } if (TxtComment.Text != "") { newshift.Comment = TxtComment.Text; } shifts.Add(newshift); //Create kilometer object Kilometer newkilometer = new Kilometer(); if (TxtKmlFrom.Text != "") { newkilometer.KlmStart = Int32.Parse(TxtKmlFrom.Text); } if (TxtKmlTo.Text != "") { newkilometer.KlmFinish = Int32.Parse(TxtKmlTo.Text); } if (TxtKmlDifference.Text != "") { newkilometer.KlmShift = Int32.Parse(TxtKmlDifference.Text); } if (!DatePicker1.Value.HasValue) { newkilometer.ShiftDate = DateTime.Today; } else { newkilometer.ShiftDate = DatePicker1.Value.Value; } try { newkilometer.PersonID = Int32.Parse(cmbDriver.SelectedValue.ToString()); } catch { MessageBox.Show("You Must select a Driver"); return; } try { newkilometer.TaxiID = Int32.Parse(cmbTaxi.SelectedValue.ToString()); } catch { MessageBox.Show("You Must select a Taxi"); return; } kilometers.Add(newkilometer); //Create Depth object Depth newdepth = new Depth(); try { newdepth.Amount = Convert.ToDecimal(TxtAmount.Text); } catch { MessageBox.Show("The Total must be a decimal xxxx.xx "); return; } if (TxtComment.Text != "") { newdepth.Comment = TxtComment.Text; } newdepth.RepaidAmount = 0; newdepth.Paid = null; if (!DatePicker1.Value.HasValue) { newdepth.DepthDate = DateTime.Today; } else { newdepth.DepthDate = DatePicker1.Value.Value; } try { newdepth.PersonID = Int32.Parse(cmbDriver.SelectedValue.ToString()); } catch { MessageBox.Show("You Must select a Driver"); return; } try { newdepth.TaxiID = Int32.Parse(cmbTaxi.SelectedValue.ToString()); } catch { MessageBox.Show("You Must select a Taxi"); return; } List <PrimaryDriver> primedr = new List <PrimaryDriver>(); primedr.Add(new PrimaryDriver { TaxiID = Int32.Parse(cmbTaxi.SelectedValue.ToString()), PersonID = Int32.Parse(cmbDriver.SelectedValue.ToString()) }); depths.Add(newdepth); CreateDatatableStrings strings = new CreateDatatableStrings(); SQLExecute sqlexec = new SQLExecute(); await sqlexec.SQLCommand(Properties.Settings.Default.DBName, strings.FOREIGN_KEY(0)); await Task.Run(() => SaveKilometer()); await Task.Run(() => SaveShift()); await Task.Run(() => SaveDepth()); await Task.Run(() => SaveIfPrimaryDriver(primedr)); await sqlexec.SQLCommand(Properties.Settings.Default.DBName, strings.FOREIGN_KEY(1)); ClearAll(); }
private async Task FillFakeDatabase(int i) { DateTime da = DateTime.Now.AddDays(-i); CreateDatatableStrings str = new CreateDatatableStrings(); List <Taxi> taxi = new List <Taxi>(); //List<Owner> owner = new List<Owner>(); //List<Driver> driver = new List<Driver>(); List <Person> person = new List <Person>(); List <PersonType> personType = new List <PersonType>(); List <Expense> expense = new List <Expense>(); List <Income> income = new List <Income>(); List <TypeExpense> typeExpense = new List <TypeExpense>(); List <TypeIncome> typeIncome = new List <TypeIncome>(); List <TaxiPayment> taxiPayment = new List <TaxiPayment>(); List <PrimaryDriver> primaryDriver = new List <PrimaryDriver>(); List <Kilometer> kilometer = new List <Kilometer>(); List <Shift> shift = new List <Shift>(); List <Depth> depth = new List <Depth>(); taxiPayment.Add(new TaxiPayment { TaxiID = 1, PersonID = 2, RentPrice = 100, PaymentsPerMonth = 1 }); primaryDriver.Add(new PrimaryDriver { TaxiID = i - 1, PersonID = i - 1 }); kilometer.Add(new Kilometer { TaxiID = 1, PersonID = 1, ShiftDate = da, KlmStart = 200000, KlmFinish = 200000, KlmShift = 200000 }); shift.Add(new Shift { TaxiID = 1, PersonID = 1, ShiftDate = da, XZ = 10.25m, Oil = 10.25m, XZFPA = 10.25m, OilFPA = 10.25m, ShiftPayment = 10.25m, Insurance = 10.25m, FPA = 10.25m, Comment = "comment" }); depth.Add(new Depth { TaxiID = 1, PersonID = 1, DepthDate = da, Paid = null, Amount = 15.25m, RepaidAmount = 5.25m, Comment = "comment" }); typeIncome.Add(new TypeIncome { Name = "MR test" }); typeExpense.Add(new TypeExpense { Name = "MR test" }); income.Add(new Income { PersonID = 1, Amount = 2105873695.25m, Comment = "Dis is a comment ", Date = da, TypeIncomeID = 1 }); expense.Add(new Expense { PersonID = 1, Amount = 2105873695.25m, Comment = "Dis is a comment ", Date = da, TypeExpenseID = 1 }); //driver.Add(new Driver { IdCard = "AA 15"+i, Name = "MR test"+i, Surname = "Smith", PhoneNumber1 = 2105873695, PhoneNumber2 = 251855512, Email = "*****@*****.**", AFM = 123456789, BirthDate = da }); //owner.Add(new Owner { IdCard = "AA 15"+i, Name = "MR test" + i, Surname = "Smith", PhoneNumber1 = 2105873695, PhoneNumber2 = 251855512, Email = "*****@*****.**", AFM = 123456789, BirthDate = da }); person.Add(new Person { IdCard = "AA 15" + i, Reserve = 0.0m, Name = "Αλέξανδρος" + i, Surname = "Ανδρικόπουλος driver", PhoneNumber1 = 2105873695, PhoneNumber2 = 251855512, Email = "*****@*****.**", AFM = 123456789, BirthDate = da, PersonTypeID = 1 }); person.Add(new Person { IdCard = "AA 15" + i, Reserve = 0.0m, Name = "Αλέξανδρος" + i, Surname = "Ανδρικόπουλος", PhoneNumber1 = 2105873695, PhoneNumber2 = 251855512, Email = "*****@*****.**", AFM = 123456789, BirthDate = da, PersonTypeID = 2 }); //personType.Add(new PersonType { Name = "Driver"}); taxi.Add(new Taxi { LicensePlate = "taa" + i, Make = "BMW", Model = "i14", MakeDate = 2004, InsuranceCompany = "URair", InsurancePrice = 300.14m, reg_date = da, PersonID = 1 }); personType = await sqlexec.SQLGetPersonType(Properties.Settings.Default.DBName, 0, "none", true); if (personType.Count != 2) { personType.Clear(); personType.Add(new PersonType { Name = "Driver" }); personType.Add(new PersonType { Name = "Owner" }); await sqlexec.SqlInsertPersonType(Properties.Settings.Default.DBName, personType); } personType.Clear(); List <Task> tasks = new List <Task>(); tasks.Add(Task.Run(() => sqlexec.SqlInsertTypeIncome(Properties.Settings.Default.DBName, typeIncome))); tasks.Add(Task.Run(() => sqlexec.SqlInsertTypeExpense(Properties.Settings.Default.DBName, typeExpense))); tasks.Add(Task.Run(() => sqlexec.SqlInsertIncome(Properties.Settings.Default.DBName, income))); tasks.Add(Task.Run(() => sqlexec.SqlInsertExpense(Properties.Settings.Default.DBName, expense))); //tasks.Add(Task.Run(() => sqlexec.SqlInsertDriver(Properties.Settings.Default.DBName, driver))); //tasks.Add(Task.Run(() => sqlexec.SqlInsertOwner(Properties.Settings.Default.DBName, owner))); tasks.Add(Task.Run(() => sqlexec.SqlInsertPerson(Properties.Settings.Default.DBName, person))); //tasks.Add(Task.Run(() => sqlexec.SqlInsertPersonType(Properties.Settings.Default.DBName, personType))); tasks.Add(Task.Run(() => sqlexec.SqlInsertTaxi(Properties.Settings.Default.DBName, taxi))); tasks.Add(Task.Run(() => sqlexec.SqlInsertTaxiPayment(Properties.Settings.Default.DBName, taxiPayment))); tasks.Add(Task.Run(() => sqlexec.SqlInsertPrimaryDriver(Properties.Settings.Default.DBName, primaryDriver))); tasks.Add(Task.Run(() => sqlexec.SqlInsertKilometer(Properties.Settings.Default.DBName, kilometer))); tasks.Add(Task.Run(() => sqlexec.SqlInsertShift(Properties.Settings.Default.DBName, shift))); tasks.Add(Task.Run(() => sqlexec.SqlInsertDepth(Properties.Settings.Default.DBName, depth))); await Task.WhenAll(tasks); }