private void button1_Click(object sender, EventArgs e)
{
Artikal a = new Artikal();
Korisnici_ k = new Korisnici_();
decimal uplaceno = 0;
bool break_point = true;
if (!string.IsNullOrWhiteSpace(textBox1.Text))
{
if (!string.IsNullOrWhiteSpace(textBox6.Text))
{
uplaceno = decimal.Parse(textBox1.Text) + decimal.Parse(textBox6.Text);
}
else
{
uplaceno = decimal.Parse(textBox1.Text);
}
}
decimal racun = decimal.Parse(label5.Text);
decimal povracaj = uplaceno - racun;
label8.Text = povracaj.ToString();
if (povracaj >= 0 || decimal.Parse(textBox6.Text) >= racun)
{
StringBuilder sb = new StringBuilder();
StringBuilder sb_knjizeno = new StringBuilder();
decimal sum = 0;
for (int i = 0; i < sifre.Count; i++)
{
if (knjizeno[i] == 1)
{
sum += cena[i] * kolicina[i];
}
}
for (int i = 0; i < sifre.Count; i++)
{
sb.Append(sifre[i].ToString() + " ");
sb.Append(artikli[i] + " ");
sb.Append(kolicina[i].ToString() + "X ");
sb.Append(cena[i].ToString());
sb.Append("\n");
if (knjizeno[i] == 1)
{
sb_knjizeno.Append(sifre[i].ToString() + " ");
sb_knjizeno.Append(artikli[i] + " ");
sb_knjizeno.Append(kolicina[i].ToString() + "X ");
sb_knjizeno.Append(cena[i].ToString());
sb_knjizeno.Append("\n");
}
}
Racun r = new Racun();
r.prodavac = prodavac;
r.datum_izdavanja = DateTime.Now;
r.artikli = sb.ToString();
decimal bonus = decimal.Parse(textBox5.Text); //trenutni bonus
decimal bonus_naplata;
if (!string.IsNullOrWhiteSpace(textBox6.Text))
{
bonus_naplata = decimal.Parse(textBox6.Text); //uneseni bonus
if (bonus_naplata > bonus)
{
MessageBox.Show("Prekoracili ste vas bonus!");
break_point = false;
}
else
{
decimal bonus_oduzeti = bonus_naplata - cena_sum; //bonus_uneti - iznos racuna
List <Korisnici_> korisnicis = k.daj_korisnika(prodavac);
if (bonus_oduzeti < 0)
{
decimal bonus_za_bazu = bonus - bonus_naplata;
k.update_bonus(korisnicis[0].id_korisnika, bonus_za_bazu);
r.iznos = cena_sum - bonus_naplata;
}
else
{
decimal uneti_bonus = decimal.Parse(textBox6.Text);
bonus_oduzeti = bonus - cena_sum;
k.update_bonus(korisnicis[0].id_korisnika, bonus_oduzeti);
r.iznos = 0;
}
r.artikli = sb.ToString();
}
}
else
{
r.iznos = cena_sum;
}
r.iznos_nabavna = nabavna_sum;
if (break_point)
{
if (r.unesi_racun())
{
MessageBox.Show("Racun je zaveden!");
r.artikli = sb_knjizeno.ToString();
r.datum_izdavanja = DateTime.Now;
r.iznos = sum;
r.iznos_nabavna = suma_zarada_knjizeno;
r.unesi_racun_knjizeno();
button1.Enabled = false;
for (int i = 0; i < knjizeno.Count; i++)
{
if (knjizeno[i] == 1)
{
a.update_artikli_knjizeno(sifre[i], kolicina[i]);
}
else if (knjizeno[i] == 0)
{
a.update_artikli(sifre[i], kolicina[i]);
}
}
}
else
{
MessageBox.Show("Racun nije zaveden!");
}
}
else
{
MessageBox.Show("Pogresan unos!");
}
}
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.ColumnIndex == 8)
{
int i = int.Parse(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());
Dug d = new Dug();
if (MessageBox.Show("Zelite li da otkazete dug sa brojem: " + i + " ?", "Poruka", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (d.del_dug(i))
{
MessageBox.Show("Artikal je izbrisan!");
}
else
{
MessageBox.Show("Artikal nije izbrisan!");
}
}
}
else if (e.ColumnIndex == 9)
{
int id = int.Parse(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());
string ime_p = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
string broj_mob = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
DateTime dt1 = DateTime.Parse(dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString());
DateTime dt2 = DateTime.Parse(dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString());
int sifra_art = int.Parse(dataGridView1.Rows[e.RowIndex].Cells[5].Value.ToString());
string artikal = dataGridView1.Rows[e.RowIndex].Cells[6].Value.ToString();
decimal cena = decimal.Parse(dataGridView1.Rows[e.RowIndex].Cells[7].Value.ToString());
Izmena_duga idf = new Izmena_duga(id, ime_p, broj_mob, dt1, dt2, sifra_art, artikal, cena);
idf.ShowDialog();
}
else if (e.ColumnIndex == 10)
{
int id_tmp = int.Parse(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());
int sifra_artikla = int.Parse(dataGridView1.Rows[e.RowIndex].Cells[5].Value.ToString());
if (sifra_artikla != 0)
{
Dug d = new Dug();
List <Dug> ls = d.get_jedan_dug(id_tmp);
if (ls[0].knjizeno == 1)
{
Racun r = new Racun();
r.artikli = ls[0].artikal;
r.datum_izdavanja = DateTime.Now;
r.iznos = ls[0].cena;
if (r.unesi_racun_knjizeno())
{
MessageBox.Show("Artikal naplacen");
d.del_dug(id_tmp);
}
else
{
MessageBox.Show("Artikal nije naplacen");
}
}
else if (ls[0].knjizeno == 0)
{
Racun r = new Racun();
r.prodavac = "dug";
r.artikli = ls[0].artikal;
r.datum_izdavanja = DateTime.Now;
r.iznos = ls[0].cena;
if (r.unesi_racun())
{
MessageBox.Show("Artikal naplacen");
d.del_dug(id_tmp);
}
else
{
MessageBox.Show("Artikal nije naplacen");
}
}
}
else if (sifra_artikla == 0)
{
Dug d = new Dug();
int id = int.Parse(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());
if (d.del_dug(id))
{
MessageBox.Show("Dug je izbrisan");
}
else
{
MessageBox.Show("Dug nije izbrisan");
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
Lista_duznika_Load(sender, e);
}
public List <Racun> daj_racun_prodavac_mesecni(string prodavac)
{
List <Racun> ls_a = new List <Racun>();
using (SqlConnection conn = new SqlConnection(connString))
{
try
{
conn.Open();
SqlCommand cmd;
if (prodavac.Equals("Svi"))
{
cmd = new SqlCommand("SELECT * FROM Racuni", conn);
}
else
{
cmd = new SqlCommand("SELECT * FROM Racuni WHERE prodavac = @prodavac", conn);
cmd.Parameters.AddWithValue("@prodavac", prodavac);
}
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
DateTime racun = new DateTime();
racun = DateTime.Parse(reader["datum_izdavanja"].ToString());
int mrr = (int)racun.Month;
int dmr = (int)DateTime.Now.Month;
int yr = (int)racun.Year;
int dyr = (int)DateTime.Now.Year;
if (yr == dyr && mrr == dmr)
{
Racun r = new Racun();
r.id_racuna = int.Parse(reader["id_racuna"].ToString());
r.prodavac = reader["prodavac"].ToString();
r.datum_izdavanja = DateTime.Parse(reader["datum_izdavanja"].ToString());
r.artikli = reader["artikli"].ToString();
r.iznos = decimal.Parse(reader["iznos"].ToString());
r.iznos_nabavna = decimal.Parse(reader["iznos_nabavna"].ToString());
ls_a.Add(r);
}
}
}
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
finally
{
conn.Close();
}
}
return(ls_a);
}
