public static double UcitajCilj(int?korisnikId, int?magacinId)
{
if (korisnikId == null || magacinId == null)
{
return(-1);
}
double d = 0;
using (FbConnection con = new FbConnection(M.Baza.connectionString))
{
con.Open();
using (FbCommand cmd = new FbCommand("SELECT JSONSTRING FROM JSON WHERE TITLE = 'CiljMagacina' AND KORISNIKID = @KorisnikID AND MAGACINID = @MagacinID", con))
{
cmd.Parameters.AddWithValue("@KorisnikID", korisnikId);
cmd.Parameters.AddWithValue("@MagacinID", magacinId);
FbDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
CiljMagacina cm = JsonConvert.DeserializeObject <CiljMagacina>(dr[0].ToString());
d = cm.godisnjiRast;
}
}
con.Close();
}
return(d);
}
private void DesifrujJson(string jsonString)
{
CiljMagacina cm = JsonConvert.DeserializeObject <CiljMagacina>(jsonString);
this.id = cm.id;
this.isGlobal = cm.isGlobal;
this.godisnjiRabat = cm.godisnjiRabat;
this.godisnjiRast = cm.godisnjiRast;
this.procentualno = cm.procentualno;
}
private void sacuvaj_btn_Click(object sender, EventArgs e)
{
if (!isGlobal)
{
switch (magacinId)
{
case 12:
cm.godisnjiRast = Convert.ToDouble(m12_txt.Text);
cm.procentualno = (m12_cmb.SelectedIndex == 1) ? true : false;
break;
case 13:
cm.godisnjiRast = Convert.ToDouble(m13_txt.Text);
cm.procentualno = (m13_cmb.SelectedIndex == 1) ? true : false;
break;
case 14:
cm.godisnjiRast = Convert.ToDouble(m14_txt.Text);
cm.procentualno = (m14_cmb.SelectedIndex == 1) ? true : false;
break;
case 15:
cm.godisnjiRast = Convert.ToDouble(m15_txt.Text);
cm.procentualno = (m15_cmb.SelectedIndex == 1) ? true : false;
break;
case 16:
cm.godisnjiRast = Convert.ToDouble(m16_txt.Text);
cm.procentualno = (m16_cmb.SelectedIndex == 1) ? true : false;
break;
case 17:
cm.godisnjiRast = Convert.ToDouble(m17_txt.Text);
cm.procentualno = (m17_cmb.SelectedIndex == 1) ? true : false;
break;
case 18:
cm.godisnjiRast = Convert.ToDouble(m18_txt.Text);
cm.procentualno = (m18_cmb.SelectedIndex == 1) ? true : false;
break;
case 19:
cm.godisnjiRast = Convert.ToDouble(m19_txt.Text);
cm.procentualno = (m19_cmb.SelectedIndex == 1) ? true : false;
break;
case 20:
cm.godisnjiRast = Convert.ToDouble(m20_txt.Text);
cm.procentualno = (m20_cmb.SelectedIndex == 1) ? true : false;
break;
case 21:
cm.godisnjiRast = Convert.ToDouble(m21_txt.Text);
cm.procentualno = (m21_cmb.SelectedIndex == 1) ? true : false;
break;
case 22:
cm.godisnjiRast = Convert.ToDouble(m22_txt.Text);
cm.procentualno = (m22_cmb.SelectedIndex == 1) ? true : false;
break;
case 23:
cm.godisnjiRast = Convert.ToDouble(m23_txt.Text);
cm.procentualno = (m23_cmb.SelectedIndex == 1) ? true : false;
break;
case 24:
cm.godisnjiRast = Convert.ToDouble(m24_txt.Text);
cm.procentualno = (m24_cmb.SelectedIndex == 1) ? true : false;
break;
case 25:
cm.godisnjiRast = Convert.ToDouble(m25_txt.Text);
cm.procentualno = (m25_cmb.SelectedIndex == 1) ? true : false;
break;
case 26:
cm.godisnjiRast = Convert.ToDouble(m26_txt.Text);
cm.procentualno = (m26_cmb.SelectedIndex == 1) ? true : false;
break;
case 27:
cm.godisnjiRast = Convert.ToDouble(m27_txt.Text);
cm.procentualno = (m27_cmb.SelectedIndex == 1) ? true : false;
break;
case 28:
cm.godisnjiRast = Convert.ToDouble(m28_txt.Text);
cm.procentualno = (m28_cmb.SelectedIndex == 1) ? true : false;
break;
}
cm.Zapisi(isGlobal, korisnikId, magacinId);
}
else
{
for (int i = 12; i < 28; i++)
{
CiljMagacina c = cm_g[i - 12];
switch (i)
{
case 12:
c.godisnjiRast = (string.IsNullOrWhiteSpace(m12_txt.Text)) ? 0 : Convert.ToDouble(m12_txt.Text);
c.procentualno = (m12_cmb.SelectedIndex == 1) ? true : false;
break;
case 13:
c.godisnjiRast = (string.IsNullOrWhiteSpace(m13_txt.Text)) ? 0 : Convert.ToDouble(m13_txt.Text);
c.procentualno = (m13_cmb.SelectedIndex == 1) ? true : false;
break;
case 14:
c.godisnjiRast = (string.IsNullOrWhiteSpace(m14_txt.Text)) ? 0 : Convert.ToDouble(m14_txt.Text);
c.procentualno = (m14_cmb.SelectedIndex == 1) ? true : false;
break;
case 15:
c.godisnjiRast = (string.IsNullOrWhiteSpace(m15_txt.Text)) ? 0 : Convert.ToDouble(m15_txt.Text);
c.procentualno = (m15_cmb.SelectedIndex == 1) ? true : false;
break;
case 16:
c.godisnjiRast = (string.IsNullOrWhiteSpace(m16_txt.Text)) ? 0 : Convert.ToDouble(m16_txt.Text);
c.procentualno = (m16_cmb.SelectedIndex == 1) ? true : false;
break;
case 17:
c.godisnjiRast = (string.IsNullOrWhiteSpace(m17_txt.Text)) ? 0 : Convert.ToDouble(m17_txt.Text);
c.procentualno = (m17_cmb.SelectedIndex == 1) ? true : false;
break;
case 18:
c.godisnjiRast = (string.IsNullOrWhiteSpace(m18_txt.Text)) ? 0 : Convert.ToDouble(m18_txt.Text);
c.procentualno = (m18_cmb.SelectedIndex == 1) ? true : false;
break;
case 19:
c.godisnjiRast = (string.IsNullOrWhiteSpace(m19_txt.Text)) ? 0 : Convert.ToDouble(m19_txt.Text);
c.procentualno = (m19_cmb.SelectedIndex == 1) ? true : false;
break;
case 20:
c.godisnjiRast = (string.IsNullOrWhiteSpace(m20_txt.Text)) ? 0 : Convert.ToDouble(m20_txt.Text);
c.procentualno = (m20_cmb.SelectedIndex == 1) ? true : false;
break;
case 21:
c.godisnjiRast = (string.IsNullOrWhiteSpace(m21_txt.Text)) ? 0 : Convert.ToDouble(m21_txt.Text);
c.procentualno = (m21_cmb.SelectedIndex == 1) ? true : false;
break;
case 22:
c.godisnjiRast = (string.IsNullOrWhiteSpace(m22_txt.Text)) ? 0 : Convert.ToDouble(m22_txt.Text);
c.procentualno = (m22_cmb.SelectedIndex == 1) ? true : false;
break;
case 23:
c.godisnjiRast = (string.IsNullOrWhiteSpace(m23_txt.Text)) ? 0 : Convert.ToDouble(m23_txt.Text);
c.procentualno = (m23_cmb.SelectedIndex == 1) ? true : false;
break;
case 24:
c.godisnjiRast = (string.IsNullOrWhiteSpace(m24_txt.Text)) ? 0 : Convert.ToDouble(m24_txt.Text);
c.procentualno = (m24_cmb.SelectedIndex == 1) ? true : false;
break;
case 25:
c.godisnjiRast = (string.IsNullOrWhiteSpace(m25_txt.Text)) ? 0 : Convert.ToDouble(m25_txt.Text);
c.procentualno = (m25_cmb.SelectedIndex == 1) ? true : false;
break;
case 26:
c.godisnjiRast = (string.IsNullOrWhiteSpace(m26_txt.Text)) ? 0 : Convert.ToDouble(m26_txt.Text);
c.procentualno = (m26_cmb.SelectedIndex == 1) ? true : false;
break;
case 27:
c.godisnjiRast = (string.IsNullOrWhiteSpace(m27_txt.Text)) ? 0 : Convert.ToDouble(m27_txt.Text);
c.procentualno = (m27_cmb.SelectedIndex == 1) ? true : false;
break;
case 28:
c.godisnjiRast = (string.IsNullOrWhiteSpace(m28_txt.Text)) ? 0 : Convert.ToDouble(m28_txt.Text);
c.procentualno = (m28_cmb.SelectedIndex == 1) ? true : false;
break;
}
c.Zapisi(isGlobal, -1, i);
}
}
}
private void UcitajGlobalniCilj()
{
for (int i = 12; i < 29; i++)
{
CiljMagacina c = new CiljMagacina();
c.Initialize(-1, i);
cm_g.Add(c);
switch (i)
{
case 12:
m12_txt.Text = String.Format("{0:##}", c.godisnjiRast);
m12_cmb.SelectedIndex = (c.procentualno) ? 1 : 0;
break;
case 13:
m13_txt.Text = String.Format("{0:##}", c.godisnjiRast);
m13_cmb.SelectedIndex = (c.procentualno) ? 1 : 0;
break;
case 14:
m14_txt.Text = String.Format("{0:##}", c.godisnjiRast);
m14_cmb.SelectedIndex = (c.procentualno) ? 1 : 0;
break;
case 15:
m15_txt.Text = String.Format("{0:##}", c.godisnjiRast);
m15_cmb.SelectedIndex = (c.procentualno) ? 1 : 0;
break;
case 16:
m16_txt.Text = String.Format("{0:##}", c.godisnjiRast);
m16_cmb.SelectedIndex = (c.procentualno) ? 1 : 0;
break;
case 17:
m17_txt.Text = String.Format("{0:##}", c.godisnjiRast);
m17_cmb.SelectedIndex = (c.procentualno) ? 1 : 0;
break;
case 18:
m18_txt.Text = String.Format("{0:##}", c.godisnjiRast);
m18_cmb.SelectedIndex = (c.procentualno) ? 1 : 0;
break;
case 19:
m19_txt.Text = String.Format("{0:##}", c.godisnjiRast);
m19_cmb.SelectedIndex = (c.procentualno) ? 1 : 0;
break;
case 20:
m20_txt.Text = String.Format("{0:##}", c.godisnjiRast);
m20_cmb.SelectedIndex = (c.procentualno) ? 1 : 0;
break;
case 21:
m21_txt.Text = String.Format("{0:##}", c.godisnjiRast);
m21_cmb.SelectedIndex = (c.procentualno) ? 1 : 0;
break;
case 22:
m22_txt.Text = String.Format("{0:##}", c.godisnjiRast);
m22_cmb.SelectedIndex = (c.procentualno) ? 1 : 0;
break;
case 23:
m23_txt.Text = String.Format("{0:##}", c.godisnjiRast);
m23_cmb.SelectedIndex = (c.procentualno) ? 1 : 0;
break;
case 24:
m24_txt.Text = String.Format("{0:##}", c.godisnjiRast);
m24_cmb.SelectedIndex = (c.procentualno) ? 1 : 0;
break;
case 25:
m25_txt.Text = String.Format("{0:##}", c.godisnjiRast);
m25_cmb.SelectedIndex = (c.procentualno) ? 1 : 0;
break;
case 26:
m26_txt.Text = String.Format("{0:##}", c.godisnjiRast);
m26_cmb.SelectedIndex = (c.procentualno) ? 1 : 0;
break;
case 27:
m27_txt.Text = String.Format("{0:##}", c.godisnjiRast);
m27_cmb.SelectedIndex = (c.procentualno) ? 1 : 0;
break;
case 28:
m28_txt.Text = String.Format("{0:##}", c.godisnjiRast);
m28_cmb.SelectedIndex = (c.procentualno) ? 1 : 0;
break;
}
}
}