Example #1
0
        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));
        }
Example #2
0
        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));
        }
Example #3
0
        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();
        }
Example #5
0
        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);
        }