public void Execute(CreatePorudzbinaDto request)
{
_validator.ValidateAndThrow(request);
int idKlijent = _actor.Id;
var porudzbina = new Porudzbina
{
DatumPorudzbine = request.PorudzbinaDatum,
KlijentId = idKlijent,
Adresa = request.Adresa
};
foreach (var i in request.Items)
{
var cena = _context.Cene.Find(i.IdCena);
var proizvod = _context.Proizvodi.Find(i.ProizvodId);
var konacnaCenaProizvoda = cena.CenaP;
proizvod.KolicinaProizvoda -= i.Kolicina;
porudzbina.DetaljiPorudzbina.Add(new DetaljiPorudzbine
{
Naziv = proizvod.NazivProizvoda,
Kolicina = i.Kolicina,
Cena = konacnaCenaProizvoda,
ProizvodId = i.ProizvodId
});
_context.Porudzbine.Add(porudzbina);
_context.SaveChanges();
}
}
public Porudzbina SelectObject(Porudzbina objekat)
{
try
{
_broker.OpenConnection();
_broker.BeginTransaction();
Porudzbina porudzbina = _broker.SelectObjectJoin(objekat) as Porudzbina;
porudzbina.Stavke = _broker.ReturnByCriteriaJoin($"WHERE SifraPorudzbine={porudzbina.Id}", new StavkaPorudzbine()).OfType <StavkaPorudzbine>().ToList();
_broker.Commit();
return(porudzbina);
}
catch (SqlException ex)
{
Debug.Write(">>>>>>>> " + ex.Message);
_broker.Rollback();
throw new Exception(ex.Message);
}
catch (Exception ex)
{
Debug.WriteLine(">>>> " + ex.Message);
_broker.Rollback();
throw new Exception(ex.Message);
}
finally
{
_broker.CloseConnection();
}
}
public List <Porudzbina> SelectAll(Porudzbina objekat)
{
try
{
_broker.OpenConnection();
_broker.BeginTransaction();
List <Porudzbina> list = _broker.SelectAllJoin(objekat).OfType <Porudzbina>().ToList();
_broker.Commit();
return(list);
}
catch (SqlException ex)
{
Debug.Write(">>>>>>>> " + ex.Message);
_broker.Rollback();
throw new Exception(ex.Message);
}
catch (Exception ex)
{
Debug.WriteLine(">>>> " + ex.Message);
_broker.Rollback();
throw new Exception(ex.Message);
}
finally
{
_broker.CloseConnection();
}
}
//-----------------------------------------OnPostPostvrdi------------------------------------------------
public async Task <IActionResult> OnPostPotvrdi(InputBuyConfirmed BuyConfirmed)
{
if (ModelState.IsValid)
{
string userId = signInManager.UserManager.GetUserId(User);
Porudzbina porudzbina = new Porudzbina
{
UserId = userId,
VremePosiljke = DateTime.Now,
BrojPorucenihStripova = BuyConfirmed.IdPorucenihStripova.Count,
Pitanje = BuyConfirmed.Pitanje,
Grad = BuyConfirmed.Grad,
KucniBroj = BuyConfirmed.KucniBroj,
Placanje = BuyConfirmed.Placanje,
UkupnaCena = BuyConfirmed.UkupnaCena,
Ulica = BuyConfirmed.Ulica,
PostanskiBroj = BuyConfirmed.PostanskiBroj.Value,
Status = "Pakovanje"
};
await porudzbinaRepository.AddPorudzbinu(porudzbina, BuyConfirmed.IdPorucenihStripova);
await korpaRepository.DeleteSveUKorpi(userId);
TempData["message"] = "Uspesno ste izvrsili porudzbinu!";
return(RedirectToPage("Index"));
}
await GetSveInformacije();
return(Page());
}
private void Ukupno_Click(object sender, EventArgs e)
{
try
{
ISession sesija = DataLayer.GetSession();
Porudzbina p = sesija.Load <Porudzbina>(13);
MessageBox.Show("Narudzbina broj: " + p.Idp + "\n");
string podaci = "";
int ukupno = 0;
int cena = 0;
foreach (Sadrzi podatak in p.Sadrzaj)
{
Pizza pizza = podatak.PizzaId;
VelicinaPizze velicina = podatak.VelicinaId;
podaci += pizza.Naziv + " cena: " + pizza.Cena + " velicina: " + velicina.Velicina + " bodovi: " + velicina.Bodovi + "\n";
ukupno += velicina.Bodovi;
cena += pizza.Cena;
}
MessageBox.Show(podaci + "\nUkupna cena: " + cena + "\nUkupno bodova: " + ukupno);
sesija.Close();
}
catch (Exception exc) { MessageBox.Show(exc.Message); }
}
public void Izvrsi(NapraviPorudzbinuDto dto)
{
_validator.ValidateAndThrow(dto);
var korisnikId = 4;
var porudzbina = new Porudzbina
{
KorisnikId = korisnikId,
Adresa = dto.Adresa,
VremePorudzbine = dto.VremePorudzbine,
};
foreach (var item in dto.StavkePorudzbine)
{
var product = _context.Proizvodi.Find(item.ProizvodId);
product.Kolicina -= item.Kolicina;
porudzbina.StavkaPorudzbine.Add(new StavkaPorudzbine
{
ProizvodId = item.ProizvodId,
Kolicina = item.Kolicina,
Naziv = product.Naziv,
Cena = product.Cena
});
}
_context.Porudzbine.Add(porudzbina);
_context.SaveChanges();
}
public async Task <Porudzbina> DodajPorudzbinu(Porudzbina d)
{
var porudzbina = unitOfWork.PorudzbinaRepository.Add(d);
await unitOfWork.Commit();
return(porudzbina);
}
public List <Porudzbina> SelectByCriteria(string criteria, Porudzbina objekat)
{
try
{
_broker.OpenConnection();
_broker.BeginTransaction();
List <Porudzbina> porudzbine = _broker.ReturnByCriteriaJoin(criteria, objekat).OfType <Porudzbina>().ToList();
_broker.Commit();
return(porudzbine);
}
catch (SqlException ex)
{
Debug.Write(">>>>>>>> " + ex.Message);
_broker.Rollback();
throw new Exception(ex.Message);
}
catch (Exception ex)
{
Debug.WriteLine(">>>> " + ex.Message);
_broker.Rollback();
throw new Exception(ex.Message);
}
finally
{
_broker.CloseConnection();
}
}
public void Execute(PravljenjePorudzbineDto request)
{
validator.ValidateAndThrow(request);
int IdKorisnik = actor.Id;
var porudzbina = new Porudzbina
{
IdKorisnik = IdKorisnik,
Adresa = request.Adresa,
DatumPorudzbine = request.DatumPorudzbine
};
foreach (var item in request.Stavke)
{
var proizvod = _context.Proizvodi.Find(item.IdProduct);
var cena = _context.Cenovnici.Find(item.IdCenovnik);
var CenaProizvod = cena.CenaProizvod;
proizvod.Kolicina -= item.Kolicina;
porudzbina.DetaljiPorudzbina.Add(new DetaljiPorudzbine
{
NazivProizvoda = proizvod.Naziv,
Kolicina = item.Kolicina,
Cena = CenaProizvod,
IdProizvod = item.IdProduct,
});;
}
_context.Porudzbine.Add(porudzbina);
_context.SaveChanges();
}
public async Task UpisPorudzbine(int idRestoran, [FromBody] Porudzbina porudzbina)
{
var restoran = await Context.Restorani.FindAsync(idRestoran);
porudzbina.Restoran = restoran;
Context.Porudzbine.Add(porudzbina);
await Context.SaveChangesAsync();
}
public void Update(Porudzbina entity)
{
using (var db = new Entities())
{
db.Entry(entity).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public void Insert(Porudzbina entity)
{
using (var db = new Entities())
{
db.Porudzbinas.Add(entity);
db.SaveChanges();
}
}
public Porudzbina GetById(string id)
{
using (var db = new Entities())
{
Porudzbina porudzbina = db.Porudzbinas.Where(p => p.ID.Equals(id)).Include(x => x.Nalazi_se).FirstOrDefault();
return(porudzbina);
}
}
public async Task AzurirajPorudzbinu(Porudzbina p)
{
Porudzbina porudzbina = unitOfWork.PorudzbinaRepository.Get(p.Id);
if (porudzbina != null)
{
unitOfWork.PorudzbinaRepository.Update(p);
await unitOfWork.Commit();
}
}
public IHttpActionResult PostPorudzbina(Porudzbina porudzbina)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_manager.Insert(porudzbina);
return(Ok(porudzbina));
}
public void Delete(string id)
{
using (var db = new Entities())
{
Porudzbina porudzbina = db.Porudzbinas.Where(p => p.ID.Equals(id)).FirstOrDefault();
db.Entry(porudzbina).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
public async Task ObrisiPorudzbinu(int id)
{
Porudzbina p = unitOfWork.PorudzbinaRepository.Get(id);
if (p != null)
{
unitOfWork.PorudzbinaRepository.Delete(p);
await unitOfWork.Commit();
}
}
private void ListBox1_SelectedPorudzbina(object sender, EventArgs e)
{
if (listBox1.SelectedValue != null && listBox1.DataSource != null)
{
Porudzbina p = Client.vratiPorudzbinu(int.Parse(listBox1.SelectedValue.ToString()));
tbPorudzbineIDKnjige.Text = p.Id_knjige.ToString();
tbPorudzbineIDKorisnika.Text = p.Id_korisnika.ToString();
tbPorudzbineKolicina.Text = p.Kolicina.ToString();
}
}
public IHttpActionResult GetPorudzbina(string id)
{
Porudzbina porudzbina = _manager.GetById(id);
if (porudzbina == null)
{
return(NotFound());
}
return(Ok(porudzbina));
}
public void Insert(Porudzbina entity)
{
if (entity.ID == null)
{
entity.ID = Guid.NewGuid().ToString();
}
entity.DAT = DateTime.Now;
_provider.Insert(entity);
}
public bool Update(Porudzbina entity)
{
if (_provider.GetById(entity.ID) == null)
{
return(false);
}
else
{
_provider.Update(entity);
return(true);
}
}
public void Update(Dostava entity)
{
using (var db = new Entities())
{
db.Entry(entity).State = System.Data.Entity.EntityState.Modified;
Porudzbina por = db.Porudzbinas.Where(p => p.ID.Equals(entity.ID)).FirstOrDefault();
db.Entry(por).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
protected override void IzvrsiKonkretnuOperaciju(IDomenskiObjekat objekat)
{
Porudzbina porudzbina = (Porudzbina)objekat;
broker.Sacuvaj(porudzbina);
Porudzbina = porudzbina;
foreach (StavkaPorudzbine sp in porudzbina.StavkePorudzbine)
{
sp.SifraPorudzbine = broker.VratiID(porudzbina);
broker.Sacuvaj(sp);
}
}
public async Task <IActionResult> Index()
{
Korpa korpa = kServis.CitajKorpu();
if (korpa.Stavke.Count() == 0)
{
return(RedirectToAction("Index", "Home"));
}
ApplicationUser user = await um.GetUserAsync(User);
string id = user.Id;
Porudzbina p1 = new Porudzbina {
KupacId = id,
DatumKupovine = DateTime.Now
};
decimal ukupnaCena = 0;
try
{
db.Porudzbine.Add(p1);
db.SaveChanges();
int pId = p1.PorudzbinaId;
foreach (StavkaKorpe st in korpa.Stavke)
{
Stavka st1 = new Stavka {
PorudzbinaId = pId,
ProizvodId = st.Proizvod.ProizvodId,
Kolicina = st.Kolicina
};
ukupnaCena = st.Proizvod.Cena * st.Kolicina + ukupnaCena;
db.Stavke.Add(st1);
db.SaveChanges();
}
kServis.ObrisiKorpu();
ViewBag.UkupnaCena = ukupnaCena;
return(View(korpa));
}
catch (Exception)
{
return(RedirectToAction("Index", "Home"));
}
}
private void KreirajPorudzbinu(List <Pizza> pizzeZaDodati)
{
_porudzbina = new Porudzbina();
_porudzbina.KreirajPorucioca();
foreach (Pizza element in pizzeZaDodati)
{
_porudzbina.Pizze.Add(new PorucenaPizza()
{
Velicina = element.Velicina(), Kora = element.Kora(), Zacini = imaLiDodataka(element), Cena = element.Cena()
});
_porudzbina.Cena += element.Cena();
}
}
public void Prikaz(int idPorudzbine)
{
porudzbina = db.Porudzbine.Find(idPorudzbine);
Console.WriteLine("\nBroj porudzbine: {0}\n\nNarucilac: {1}\nTelefon: {2}\nAdressa: {3}\nDatum: {4}", porudzbina.PorudzbinaId, porudzbina.PorucilacIme, porudzbina.Telefon, porudzbina.Adressa, porudzbina.Datum);
Console.WriteLine();
foreach (PorucenaPizza element in db.Pizze.Where(p => p.PorudzbinaId == idPorudzbine))
{
Console.WriteLine("{0} --- {1} --- {2} --- {3:C}", element.Velicina, element.Kora, element.Zacini, element.Cena);
}
Console.WriteLine("\nUkupno za uplatu: {0:C}", porudzbina.Cena);
Console.WriteLine("------------------------------------------------");
}
private Porudzbina ValidacijaPorudzbine(Label lblDatumPorudzbine, TextBox txtRok, TextBox txtUkupanIznos, DataGridView dgvProizvodi, Label lblRokPrispeca)
{
Porudzbina porudzbina = new Porudzbina();
bool dobro = true;
porudzbina.DatumPorudzbine = DateTime.Now;
if (int.TryParse(txtRok.Text, out int brDana))
{
porudzbina.RokPrispeca = porudzbina.DatumPorudzbine.AddDays(brDana);
}
else
{
dobro = false;
MessageBox.Show("Unesite ponovo broj dana.");
lblRokPrispeca.ForeColor = Color.FromArgb(250, 62, 62);
}
if (double.TryParse(txtUkupanIznos.Text, out double ukupno))
{
porudzbina.UkupanIznos = ukupno;
}
else
{
dobro = false;
MessageBox.Show("Greska prilikom upisa ukupnog iznosa.");
txtUkupanIznos.ForeColor = Color.FromArgb(250, 62, 62);
}
Korisnik k = FrmGlavnaFormaKorisnik.k;
porudzbina.Korisnik1 = k;
try
{
porudzbina.StavkePorudzbine = listaStavkiBinding.ToList();
}
catch (Exception)
{
dobro = false;
MessageBox.Show("Greska sa listom stavki.");
}
if (!dobro)
{
return(null);
}
return(porudzbina);
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
Porudzbina = await _context.Porudzbina
.Include(p => p.User).FirstOrDefaultAsync(m => m.IdPorudzbine == id);
if (Porudzbina == null)
{
return(NotFound());
}
return(Page());
}
public async Task <IActionResult> Index()
{
Narucivanje narucivanje = nServis.CitajSpisak();
if (narucivanje.Kartas.Count() == 0)
{
return(RedirectToAction("Index", "Home"));
}
ApplicationUser user = await um.GetUserAsync(User);
string id = user.Id;
Porudzbina p1 = new Porudzbina
{
KorisnikId = id,
DatumPorucivanja = DateTime.Now
};
try
{
db.Porudzbina.Add(p1);
db.SaveChanges();
int pId = p1.PorudzbinaId;
foreach (NarucenaKarta kr in narucivanje.Kartas)
{
Karta kr1 = new Karta
{
PorudzbinaId = pId,
PredstavaId = kr.Predstava.PredstavaId,
Kolicina = kr.Kolicina
};
db.Karta.Add(kr1);
db.SaveChanges();
}
nServis.ObrisiSpisak();
return(View());
}
catch (Exception)
{
return(RedirectToAction("Index", "Home"));
}
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
Porudzbina = await _context.Porudzbina.FindAsync(id);
if (Porudzbina != null)
{
_context.Porudzbina.Remove(Porudzbina);
await _context.SaveChangesAsync();
}
return(RedirectToPage("./Index"));
}
