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); }