private void button1_Click(object sender, EventArgs e) { DateTime dateTime = DateTime.UtcNow.Date; var dob = session.Query <Dobavljac>().Select(a => a.NazivDobavljaca).Distinct().ToList(); foreach (var d in dob) { var map = new Dictionary <string, string>(); var novaNabava = new Nabava(); novaNabava.Salon = session.Get <Salon>(PocetnaForm.ID); var sum = 0; int id = 0; foreach (DataGridViewRow row in dataGridView1.Rows) { if (row.Cells["dob"].Value == null) { break; } if (row.Cells["dob"].Value.ToString() == d) { if (row.Cells["kolicina"].Value.ToString() != "0") { id = Convert.ToInt32(row.Cells["iddob"].Value); var idDob = session.Get <Dobavljac>(id); novaNabava.Dobavljac = idDob; map.Add(row.Cells["idart"].Value.ToString(), row.Cells["kolicina"].Value.ToString()); sum += Convert.ToInt32(row.Cells["kolicina"].Value) * Convert.ToInt32(row.Cells["Cijena"].Value); } } } if (id != 0) { novaNabava.Datum = dateTime; novaNabava.UkupnaCijena = sum; using (ITransaction transaction = session.BeginTransaction()) // Begin a transaction { session.Save(novaNabava); // Save the book in session transaction.Commit(); // Commit the changes to the database } int idnab = novaNabava.Idnabava; foreach (var pair in map) { int key = Convert.ToInt32(pair.Key); int value = Convert.ToInt32(pair.Value); var artnab = new Nabavaartikl(); artnab.Nabava = novaNabava; var idArtikl = session.Get <Artikl>(key); artnab.Artikl = idArtikl; artnab.Kolicina = value; using (ITransaction transaction = session.BeginTransaction()) // Begin a transaction { session.Save(artnab); // Save the book in session transaction.Commit(); // Commit the changes to the database } } } } MessageBox.Show("Nabava uspjesno pohranjena"); }
public ActionResult Create(ArtikliVM artikli) { if (ModelState.IsValid) { DateTime dateTime = DateTime.Today; var dob = session.Query <Dobavljac>().Select(a => a.Iddobavljac).Distinct().ToList(); foreach (var d in dob) { List <Tuple <decimal, int> > list = new List <Tuple <decimal, int> >(); var map = new Dictionary <int, int>(); var novaNabava = new Nabava { Salon = session.Get <Salon>(AktivniSalon.IdAktivniSalon) }; int id = 0; System.Diagnostics.Debug.WriteLine("Arts.Count: ", artikli.Arts.Count); for (int i = 0; i < artikli.Arts.Count; ++i) { if (artikli.Arts[i].Dobavljac.Iddobavljac == d) { System.Diagnostics.Debug.WriteLine("id dobavljac: ", d); System.Diagnostics.Debug.WriteLine("artikli.Kols[i]: ", artikli.Kols[i]); if (artikli.Kols[i] != 0) { novaNabava.Dobavljac = artikli.Arts[i].Dobavljac; map.Add(artikli.Arts[i].IdArtikl, artikli.Kols[i]); list.Add(Tuple.Create(artikli.Arts[i].Cijena, artikli.Kols[i])); id++; } } } if (id != 0) { novaNabava.Datum = dateTime; novaNabava.IzracunajUkupnuCijenu(list); using (ITransaction transaction = session.BeginTransaction()) // Begin a transaction { session.Save(novaNabava); // Save the book in session transaction.Commit(); // Commit the changes to the database } var idnab = novaNabava; foreach (var pair in map) { int key = pair.Key; int value = pair.Value; var artnab = new Nabavaartikl { Nabava = idnab }; Artikl artikl = session.Get <Artikl>(key); artnab.Artikl = artikl; artnab.Kolicina = value; using (ITransaction transaction = session.BeginTransaction()) // Begin a transaction { session.Save(artnab); // Save the book in session transaction.Commit(); // Commit the changes to the database } } } } return(RedirectToAction("Index")); } return(View(artikli)); }