public void addOre(int a, int b, int c, int d, int e, int f, int g, int h, int i, int j, int k, int l,
int m, int n, int o, int p, bool compress, bool stockType)
{
int ark = 0, bis = 0, cro = 0, dar = 0, gne = 0, hed = 0, hem = 0, jas = 0, ker = 0, omb = 0, pla = 0, pyr = 0, sco = 0, spod = 0, vel = 0, mer = 0 ;
string connectionString = getConnString();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("SELECT * FROM ore WHERE recent = 1", conn))
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
ark = reader.GetInt32(0);
bis = reader.GetInt32(1);
cro = reader.GetInt32(2);
dar = reader.GetInt32(3);
gne = reader.GetInt32(4);
hed = reader.GetInt32(5);
hem = reader.GetInt32(6);
jas = reader.GetInt32(7);
ker = reader.GetInt32(8);
mer = reader.GetInt32(9);
omb = reader.GetInt32(10);
pla = reader.GetInt32(11);
pyr = reader.GetInt32(12);
sco = reader.GetInt32(13);
spod = reader.GetInt32(14);
vel = reader.GetInt32(15);
}
}
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.ToString());
}
updater update = new updater();
update.recentOre(connectionString);
/* a = a + ark;
b = b + bis;
c = c + cro;
d = d + dar;
e = e + gne;
f = f + hed;
g = g + hem;
h = h + jas;
i = i + ker;
j = j + mer;
k = k + omb;
l = l + pla;
m = m + pyr;
n = n + sco;
o = o + spod;
p = p + vel;*/
string date = DateTime.Now.ToString();
int recent = 1;
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("INSERT into ore(Arkanor, Bistot, Crokite, Dark_Ochre, Gneiss, Hedbergite, Hemorphite, Jaspet, Kernite, Mercoxit, Omber, Plagioclase, Pyroxeres, Scordite, Spodumain, Veldspar, date, recent) Values(@a, @b, @c, @d, @g, @hed, @hem, @j, @k, @mer, @o, @pl, @py, @sc, @sp, @v, @date, @new)", conn))
{
cmd.Parameters.Add(new SqlParameter("@a", a));
cmd.Parameters.Add(new SqlParameter("@b", b));
cmd.Parameters.Add(new SqlParameter("@c", c));
cmd.Parameters.Add(new SqlParameter("@d", d));
cmd.Parameters.Add(new SqlParameter("@g", e));
cmd.Parameters.Add(new SqlParameter("@hed", f));
cmd.Parameters.Add(new SqlParameter("@hem", g));
cmd.Parameters.Add(new SqlParameter("@j", h));
cmd.Parameters.Add(new SqlParameter("@k", i));
cmd.Parameters.Add(new SqlParameter("@mer", j));
cmd.Parameters.Add(new SqlParameter("@o", k));
cmd.Parameters.Add(new SqlParameter("@pl", l));
cmd.Parameters.Add(new SqlParameter("@py", m));
cmd.Parameters.Add(new SqlParameter("@sc", n));
cmd.Parameters.Add(new SqlParameter("@sp", o));
cmd.Parameters.Add(new SqlParameter("@v", p));
cmd.Parameters.Add(new SqlParameter("@date", date));
cmd.Parameters.Add(new SqlParameter("@new", recent));
cmd.ExecuteNonQuery();
}
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.ToString(), "Something is broken", MessageBoxButtons.OK);
}
}
public void addMinerals(int trit, int pye, int iso, int mex, int noc, int zy, int mega, int mor, bool stockType)
{
int t = 0, p = 0, me = 0, i = 0, n = 0, z = 0, meg = 0, mo = 0;
string connectionString = getConnString();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("SELECT * FROM minerals WHERE recent = 1", conn))
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
t = reader.GetInt32(0);
p = reader.GetInt32(1);
me = reader.GetInt32(2);
i = reader.GetInt32(3);
n = reader.GetInt32(4);
z = reader.GetInt32(5);
meg = reader.GetInt32(6);
mo = reader.GetInt32(7);
}
}
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.ToString(), "Something Broke", MessageBoxButtons.OK);
}
updater update = new updater();
update.recentMinerals(connectionString);
/*t = trit + t;
p = pye + p;
me = mex + me;
i = iso + i;
n = noc + n;
z = zy + z;
meg = mega + meg;
mo = mor + mo;
*/
string date = DateTime.Now.ToString();
string recent = "1";
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("INSERT INTO minerals(Tritanium, Pyerite, Mexallon, Isogen, Nocxium, Zydrine, Megacyte, Morphite, date, recent) Values(@t, @p, @mex, @i, @n, @z, @meg, @mor, @date, @new)", conn))
{
cmd.Parameters.Add(new SqlParameter("@t", trit));
cmd.Parameters.Add(new SqlParameter("@p", pye));
cmd.Parameters.Add(new SqlParameter("@mex", mex));
cmd.Parameters.Add(new SqlParameter("@i", iso));
cmd.Parameters.Add(new SqlParameter("@n", noc));
cmd.Parameters.Add(new SqlParameter("@z", zy));
cmd.Parameters.Add(new SqlParameter("@meg", mega));
cmd.Parameters.Add(new SqlParameter("@mor", mor));
cmd.Parameters.Add(new SqlParameter("@date", date));
cmd.Parameters.Add(new SqlParameter("@new", recent));
cmd.ExecuteNonQuery();
conn.Close();
}
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.ToString(), "Something broke", MessageBoxButtons.OK);
}
}
