public static void saveBudget(Budzet_lacza budzet)
{
using (IDbConnection cnn = new SQLiteConnection(loadConnectionString()))
{
cnn.Execute("insert into Budzet_lacza (fsl_db, odleglosc_km, czestotliwosc_MHz, wartosc) values (@fsl_db, @odleglosc_km, @czestotliwosc_MHz, @wartosc)", budzet);
}
}
private void button1_Click(object sender, EventArgs e)
{
switch (comboBox1.SelectedItem.ToString())
{
case "Urządzenie":
case "Devices":
string value1 = textBox3.Text;
string value2 = textBox4.Text;
string value3 = textBox5.Text;
string query1 = "SELECT Zlacze.id FROM Zlacze WHERE Zlacze.symbol = '" + value1 + "'";
string query2 = "SELECT Kabel.id FROM Kabel WHERE Kabel.symbol = '" + value2 + "'";
string query3 = "SELECT Antena.id FROM Antena WHERE Antena.nazwa = '" + value3 + "'";
int id_kab = 0, id_zlacz = 0, id_ant = 0;
using (var cnn = new SQLiteConnection(loadConnectionString()))
{
var a = cnn.ExecuteScalar <int>(query1);
id_kab = a;
}
using (var cnn = new SQLiteConnection(loadConnectionString()))
{
var b = cnn.ExecuteScalar <int>(query2);
id_zlacz = b;
}
using (var cnn = new SQLiteConnection(loadConnectionString()))
{
var c = cnn.ExecuteScalar <int>(query3);
id_ant = c;
}
if (id_kab != 0 && id_zlacz != 0 && id_ant != 0)
{
try
{
Urzadzenie urz = new Urzadzenie
{
nazwa = textBox1.Text,
moc = Convert.ToInt32(textBox2.Text),
id_kabla = id_kab,
id_zlacza = id_zlacz,
id_anteny = id_ant,
czulosc = Convert.ToDouble(textBox6.Text)
};
label8.ForeColor = Color.Green; label8.Text = "Dodano do bazy"; label8.Show();
SqliteDataAccess.saveDevices(urz);
lista_urz = SqliteDataAccess.ListUrzadzenie();
dataGridView1.DataSource = lista_urz;
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";
textBox6.Text = "";
}
catch (Exception ex) when(ex is ArgumentNullException || ex is FormatException)
{
label8.ForeColor = Color.Red; label8.Text = "Wprowadzono błędne dane"; label8.Show();
}
}
else
{
label8.ForeColor = Color.Red; label8.Text = "Złe dane."; label8.Show();
}
break;
case "Materiały":
case "Materials":
try
{
tl_materialow mat = new tl_materialow
{
nazwa = textBox1.Text,
tlumiennosc_db = Convert.ToDouble(textBox2.Text),
grubosc_cm = Convert.ToDouble(textBox3.Text),
czestotliwosc_MHz = Convert.ToDouble(textBox4.Text)
};
SqliteDataAccess.saveMaterials(mat);
label8.ForeColor = Color.Green; label8.Text = "Dodano do bazy"; label8.Show();
lista_mat = SqliteDataAccess.listMaterials();
dataGridView1.DataSource = lista_mat;
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
}
catch (Exception ex) when(ex is ArgumentNullException || ex is FormatException)
{
label8.ForeColor = Color.Red; label8.Text = "Wprowadzono błędne dane"; label8.Show();
}
break;
case "Anteny":
case "Antennas":
string zlacze_id = textBox4.Text;
string query_zlacze = "SELECT Zlacze.id FROM Zlacze WHERE Zlacze.symbol = '" + zlacze_id + "'";
int id_zlacza = 0;
using (var cnn = new SQLiteConnection(loadConnectionString()))
{
var a = cnn.ExecuteScalar <int>(query_zlacze);
id_zlacza = a;
}
if (id_zlacza != 0)
{
try
{
parametry_anteny par = new parametry_anteny
{
zysk_dBi = Convert.ToDouble(textBox2.Text),
nazwa = textBox1.Text,
czestotliwosc_MHz = Convert.ToInt32(textBox3.Text),
id_zlacza = id_zlacza
};
SqliteDataAccess.saveParameters(par);
label8.ForeColor = Color.Green; label8.Text = "Dodano do bazy"; label8.Show();
lista_ant = SqliteDataAccess.ListParameters();
dataGridView1.DataSource = lista_ant;
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";
}
catch (Exception ex) when(ex is ArgumentNullException || ex is FormatException)
{
label8.ForeColor = Color.Red; label8.Text = "Wprowadzono błędne dane"; label8.Show();
}
}
else
{
label8.ForeColor = Color.Red; label8.Text = "Nie znaleziono takiego zlacza";
}
break;
case "Kable":
case "Cables":
string symbol = textBox4.Text;
string query_zlaczee = "SELECT id FROM zlacze WHERE symbol = '" + symbol + "'";
int id = 0;
using (var cnn = new SQLiteConnection(loadConnectionString()))
{
var a = cnn.ExecuteScalar <int>(query_zlaczee);
id = a;
}
if (id != 0)
{
try
{
kabel kab = new kabel
{
czestotliwosc_MHz = Convert.ToInt32(textBox1.Text),
symbol = textBox2.Text,
tlumiennosc_db1m = Convert.ToDouble(textBox3.Text),
id_zlacza = id
};
SqliteDataAccess.saveCables(kab);
label8.ForeColor = Color.Green; label8.Text = "Dodano do bazy"; label8.Show();
lista_kab = SqliteDataAccess.ListCables();
dataGridView1.DataSource = lista_kab;
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
}
catch (Exception ex) { label8.ForeColor = Color.Red; label8.Text = "Wprowadzono błędne dane"; label8.Show(); }
}
else
{
label8.ForeColor = Color.Red; label8.Text = "Wprowadzono błędne dane"; label8.Show();
}
break;
case "Złącza":
case "Connectors":
var lines = File.ReadAllLines("available_connectors.txt");
if (lines.Contains(textBox1.Text))
{
try
{
zlacze zl = new zlacze
{
symbol = textBox1.Text,
tlumiennosc_db = Convert.ToDouble(textBox2.Text),
czestotliwosc_MHz = Convert.ToInt32(textBox3.Text)
};
SqliteDataAccess.saveZlacza(zl);
label8.ForeColor = Color.Green; label8.Text = "Dodano do bazy"; label8.Show();
lista_zla = SqliteDataAccess.ListZlacza();
dataGridView1.DataSource = lista_zla;
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
}
catch (Exception ex) when(ex is ArgumentNullException || ex is FormatException)
{
label8.ForeColor = Color.Red; label8.Text = "Wprowadzono błędne dane"; label8.Show();
}
}
else
{
label8.ForeColor = Color.Red; label8.Text = "Wprowadzono błędne dane"; label8.Show();
}
break;
case "Budżet łącza":
case "Link Budget":
try
{
Budzet_lacza budzet = new Budzet_lacza
{
fsl_db = Convert.ToDouble(textBox1.Text),
odleglosc_km = Convert.ToDouble(textBox2.Text),
czestotliwosc_MHz = Convert.ToInt32(textBox3.Text),
};
label8.ForeColor = Color.Green; label8.Text = "Dodano do bazy"; label8.Show();
SqliteDataAccess.saveBudget(budzet);
lista_bud = SqliteDataAccess.ListBudzet();
dataGridView1.DataSource = lista_bud;
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
}
catch (Exception ex) when(ex is ArgumentNullException || ex is FormatException)
{
label8.ForeColor = Color.Red; label8.Text = "Wprowadzono błędne dane"; label8.Show();
}
break;
}
}
//przyciski
private void CountButton1_Click(object sender, EventArgs e)
{
double TN = 0;
double MOC;
double TO = 0;
double ZN;
double ZO;
double FSL;
double MAT = 0;
if (!IsEmptyTextBox(textBoxTN))
{
string[] subs = textBoxTN.Text.Split('+');
for (int i = 0; i < subs.Length; i++)
{
TN += Convert.ToDouble(subs[i]);
}
}
else
{
TN = 0;
}
if (!IsEmptyTextBox(textBoxMOC))
{
MOC = Convert.ToDouble(textBoxMOC.Text);
}
else
{
MOC = 0;
}
if (!IsEmptyTextBox(textBoxTO))
{
string[] subs = textBoxTO.Text.Split('+');
for (int i = 0; i < subs.Length; i++)
{
TO += Convert.ToDouble(subs[i]);
}
}
else
{
TO = 0;
}
if (!IsEmptyTextBox(textBoxZN))
{
ZN = Convert.ToDouble(textBoxZN.Text);
}
else
{
ZN = 0;
}
if (!IsEmptyTextBox(textBoxZO))
{
ZO = Convert.ToDouble(textBoxZO.Text);
}
else
{
ZO = 0;
}
if (!IsEmptyTextBox(textBoxFSL))
{
FSL = Math.Round(Convert.ToDouble(textBoxFSL.Text), 2);
}
else
{
FSL = 0;
}
if (checkBox1.Checked)
{
if (!IsEmptyTextBox(textBox4))
{
string[] subs = textBox4.Text.Split('+');
for (int i = 0; i < subs.Length; i++)
{
MAT += Convert.ToDouble(subs[i]);
}
}
else
{
MAT = 0;
}
double BL = Math.Round(MOC + ZN - TN - FSL + ZO - TO - MAT, 2);
string czestotliwosc_txt = comboBox6.GetItemText(comboBox6.SelectedItem);
string[] subs2 = czestotliwosc_txt.Split('.');
Int32 czestotliwosc = Convert.ToInt32(subs2[0]);
Budzet_lacza budzet = new Budzet_lacza
{
fsl_db = FSL,
odleglosc_km = Convert.ToDouble(textBox8.Text),
czestotliwosc_MHz = czestotliwosc,
wartosc = BL
};
SqliteDataAccess.saveBudget(budzet);
textBox1.Text = MOC.ToString() + " + " + ZN.ToString() + " - " + TN.ToString() + " - " + FSL.ToString() + " + " + ZO.ToString() + " - " + TO.ToString() + " - " + MAT.ToString() + " = " + BL.ToString();
}
else
{
double BL = Math.Round(MOC + ZN - TN - FSL + ZO - TO, 2);
string czestotliwosc_txt = comboBox6.GetItemText(comboBox6.SelectedItem);
string[] subs3 = czestotliwosc_txt.Split('.');
Int32 czestotliwosc = Convert.ToInt32(subs3[0]);
Budzet_lacza budzet = new Budzet_lacza
{
fsl_db = FSL,
odleglosc_km = Convert.ToDouble(textBox8.Text),
czestotliwosc_MHz = czestotliwosc,
wartosc = BL
};
SqliteDataAccess.saveBudget(budzet);
textBox1.Text = MOC.ToString() + " + " + ZN.ToString() + " - " + TN.ToString() + " - " + FSL.ToString() + " + " + ZO.ToString() + " - " + TO.ToString() + " = " + BL.ToString();
}
}
