async void Create(object sender, EventArgs args)
{
SendToDB.sendToDB("INSERT INTO round_ss " +
"(\"login_investor\", \"stage\", \"sum_money\", \"conditions\") " +
$"VALUES ('{Data.invLogin}', '{stage.SelectedItem}',{sum.Text}, '{condition.Text}');");
await Navigation.PopModalAsync();
}
void OnTextChanged(object sender, EventArgs e)
{
List <string> list = new List <string>();
list = SendToDB.GetInvestors($"SELECT \"{search.Text}\" FROM \"investor\"");
foreach (string i in list)
{
Console.WriteLine(list);
}
}
async void Next(object sender, EventArgs e)
{
SendToDB.sendToDB("INSERT INTO \"startup\" " +
"(\"login_startup\", \"pass\", \"name_startup\", " +
"description_startup, stage_startup) " +
$"VALUES ('{login.Text}', '{pass.Text}', '{name.Text}', '{description.Text}','{stage.SelectedItem}');");
SendToDB.sendToDB("INSERT INTO startup_tags" +
"(\"login_startup\", \"tag_text\") " +
$"VALUES ('{login.Text}', '{tag.SelectedItem}');");
await Navigation.PushAsync(new startupHome());
}
async void Save(object sender, EventArgs e)
{
SendToDB.sendToDB("INSERT INTO \"investor_tags\"" +
$"(\"login_investor\", \"tag_text\") VALUES ('{login.Text}', '{tag.SelectedItem}');");
Data.invLogin = login.Text;
SendToDB.sendToDB("INSERT INTO \"investor\" " +
"(\"login_investor\", \"pass\", \"name_investor\", \"surname_investor\")" +
$"VALUES ('{name.Text}', '{surname.Text}', '{login.Text}', '{pass.Text}');");
SendToDB.sendToDB("INSERT INTO \"investor_stages\" " +
"(\"login_investor\", \"stage_text\")" +
$"VALUES ('{login.Text}', '{stage.SelectedItem}');");
await Navigation.PushAsync(new investorHome());
}
public investorHome()
{
InitializeComponent();
rounds = new List <Round>();
List <SendToDB.info> round = new List <SendToDB.info>();
round = SendToDB.GtInvestorRounds("SELECT \"login_startup\", " +
"\"stage\", \"sum_money\", \"conditions\" " +
$"FROM \"round_ss\" WHERE \"login_investor\" = '{Data.invLogin}';");
foreach (var i in round)
{
rounds.Add(new Round
{
Sum = i.sum_money + "$"
});
BindingContext = this;
}
}