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