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