public ActionResult Edit(Cena cena) { try { if (ModelState.IsValid) { Artikal artikalIzBaze = BrokerBaze.Sesija().VratiArtikal(cena.artikalID); Cena cenaIzBaze = artikalIzBaze.ListaCena.FirstOrDefault(c => c.datumOd == cena.datumOd); cenaIzBaze.iznos = cena.iznos; cenaIzBaze.Status = Status.Izmenjen; string rezultat = BrokerBaze.Sesija().SacuvajArtikal(artikalIzBaze); if (rezultat.Equals("Uspesno!")) { return(RedirectToAction("Details", "Artikal", new { artikalID = cena.artikalID })); } else { throw new Exception(); } } return(View(cena)); } catch (Exception) { return(View("Error", new ErrorViewModel { Poruka = "Sistem ne moze da sacuva cenu!" })); } }
public Cena Buscar_Cena(int Id) { using (SqlConnection conn = new SqlConnection(@"Initial Catalog=HNI;Data Source = localhost; Integrated Security=SSPI")) { string strSQL = @"SELECT * FROM Cena where Identi = '" + Id + "'"; using (SqlCommand cmd = new SqlCommand(strSQL)) { conn.Open(); cmd.Connection = conn; cmd.CommandText = strSQL; var dataReader = cmd.ExecuteReader(); var dt = new DataTable(); dt.Load(dataReader); conn.Close(); foreach (DataRow row in dt.Rows) { var C = new Cena() { Id = Convert.ToInt32(row["Id"]), Identidade = Convert.ToInt32(row["Identi"]), Fim = Convert.ToInt32(row["fim"]), }; return(C); } } } Cena Ce = new Cena(); return(Ce); }
public ActionResult Create(Cena cena) { try { if (ModelState.IsValid) { Artikal artikal = BrokerBaze.Sesija().VratiArtikal(cena.artikalID); Cena novaCena = new Cena { datumOd = cena.datumOd, iznos = cena.iznos, Status = Status.Dodat }; artikal.ListaCena.Add(novaCena); string rezultat = BrokerBaze.Sesija().SacuvajArtikal(artikal); if (rezultat.Equals("Uspesno!")) { return(RedirectToAction("Details", "Artikal", new { artikalID = cena.artikalID })); } else { throw new Exception(); } } return(View(cena)); } catch (Exception) { return(View("Error", new ErrorViewModel { Poruka = "Sistem ne moze da sacuva kupca!" })); } }
public ActionResult Create(Artikal artikal, Cena cena) { try { artikal.artikalID = BrokerBaze.Sesija().VratiSifru("artikalID", "Artikal"); cena.Status = Status.Dodat; artikal.ListaCena.Add(cena); artikal.Status = Status.Dodat; string rezultat = BrokerBaze.Sesija().SacuvajArtikal(artikal); if (rezultat.Equals("Uspesno!")) { return(RedirectToAction("Index", new { poruka = "Dodat je novi artikal!" })); } else { throw new Exception(); } } catch (Exception) { return(View("Error", new ErrorViewModel { Poruka = "Sistem ne moze da kreira artikal!" })); } }
public void CreateCenaTest() { bool expected = true; Cena cen = new Cena() { Number = "121212120", Creation = DateTime.Now, End = DateTime.Now, Client = "20295782K", TipoCena = TipoCena.CE001, EvType = 30, Start = DateTime.Now, Finish = DateTime.Now, Assist = 10, Additional = 20, Realized = true, Total = 987654321, Observation = "Probanding", IdTipoAmbientacion = 10, MusicaAmbiental = true, LocalOnBreak = true, OtroLocalOnBreak = false, ValorArriendo = 150000 }; bool result = cen.Create(); Assert.AreEqual(expected, result); }
public async Task <IActionResult> Edit(int id, [Bind("Id,Cenaa")] Cena Cenaa) { if (id != Cenaa.Id) { return(NotFound()); } if (Cenaa is null) { throw new ArgumentNullException(nameof(Cenaa)); } if (ModelState.IsValid) { try { _context.Update(Cenaa); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CenaExists(Cenaa.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(Cenaa)); }
public void UpdateCenaTest() { string expected = "Funco"; Cena cen = new Cena() { Number = "121212120", Creation = DateTime.Now, End = DateTime.Now, Client = "20295782K", TipoCena = TipoCena.CE001, EvType = 30, Start = DateTime.Now, Finish = DateTime.Now, Assist = 10, Additional = 20, Realized = true, Total = 987654321, Observation = "Funco", IdTipoAmbientacion = 10, MusicaAmbiental = true, LocalOnBreak = false, OtroLocalOnBreak = true, ValorArriendo = 120000 }; cen.Update(); string result = cen.Observation; //Preguntamos si son iguales Assert.AreEqual(expected, result); }
public List <Cena> SelectAll(Cena objekat) { try { _broker.OpenConnection(); _broker.BeginTransaction(); List <Cena> cene = _broker.ReturnByCriteriaJoin("WHERE DatumDo is null", objekat).OfType <Cena>().ToList(); _broker.Commit(); return(cene); } 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 Cena SelectObject(Cena objekat) { try { _broker.OpenConnection(); _broker.BeginTransaction(); Cena cene = _broker.ReturnByCriteriaJoin($"WHERE c.SifraLajsne={objekat.Lajsna.Id} and c.DatumDo is null", objekat).OfType <Cena>().ToList().FirstOrDefault(); _broker.Commit(); return(cene); } 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 bool CreateObject(Cena objekat) { try { objekat.DatumDo = null; _broker.OpenConnection(); _broker.BeginTransaction(); _broker.InsertObject(objekat); _broker.Commit(); return(true); } 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 bool DeleteObject(Cena objekat) { try { _broker.OpenConnection(); _broker.BeginTransaction(); _broker.DeleteObjectCriteria($"WHERE SifraLajsne={objekat.Lajsna.Id} and DatumDo is null", objekat); _broker.Commit(); return(true); } 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 DrvoSobnaVrata() { this.Cena = 200; string cenaStr = Cena.ToString(); this.Naziv = "drvo - sobna vrata"; this.Opis = this.Naziv + " , cena: " + cenaStr + " , a kolicina "; }
public PlastikaUlaznaVrata() { this.Cena = 280; string cenaStr = Cena.ToString(); this.Naziv = "plastika ulazna vrata"; this.Opis = this.Naziv + " , cena: " + cenaStr + " kolicina: "; }
public BetonskiKrov() { this.cena = Cena; string cenaStr = Cena.ToString(); this.Naziv = "betonski krov"; this.opis = this.Naziv + cenaStr; }
public LuksuzniTemelj() { this.cena = Cena; string cenaStr = Cena.ToString(); this.dodatak = "luksuzni"; this.opis = this.Naziv + " " + this.dodatak + " " + cenaStr; }
public CrepKrov() { this.cena = 7000; string cenaStr = Cena.ToString(); this.Naziv = "crep krov"; this.opis = this.Naziv + ", cena " + cenaStr; }
public KameniTemeljLux() { this.cena = Cena; string cenaStr = Cena.ToString(); this.Naziv = "kameni temelj"; this.opis = this.Naziv + " " + this.Dodatak + " " + cenaStr; }
public BetonskaPloca() { this.Cena = 6000; string cenaStr = Cena.ToString(); this.Naziv = "betonska ploca"; this.Opis = this.Naziv + " , a cena " + cenaStr; }
public PlastikaProzor() { this.Cena = 350; string cenaStr = Cena.ToString(); this.Naziv = "plastika prozor"; this.Opis = this.Naziv + " , cena: " + cenaStr + " kolicina: "; }
public SendvicZid() { this.cena = 8000; string cenaStr = Cena.ToString(); this.Naziv = "sendvic zid"; this.opis = this.Naziv + " cena " + cenaStr; }
public OsnovniTemelj() { this.cena = Cena; string cenaStr = Cena.ToString(); this.dodatak = "osnovni"; this.opis = this.Naziv + " " + this.dodatak + " , cena: " + cenaStr; }
public SobnaVrata() { this.cena = Cena; string cenaStr = Cena.ToString(); this.Naziv = "sobna vrata"; this.opis = this.Naziv + " , cena: " + cenaStr + " , a kolicina "; }
public AluminijumUlaznaVrata() { this.Cena = Cena; string cenaStr = Cena.ToString(); this.Naziv = "aluminijum ulazna vrata"; this.Opis = this.Naziv + " , cena: " + cenaStr; }
public DrveniKrov() { this.cena = 5000; string cenaStr = Cena.ToString(); this.Naziv = "drveni krov"; this.opis = this.Naziv + cenaStr; }
public AluminijumProzor() { this.Cena = Cena; string cenaStr = Cena.ToString(); this.Naziv = "aluminijum prozor"; this.Opis = this.Naziv + " , cena: " + cenaStr; }
public OpekaZid() { this.cena = Cena; string cenaStr = Cena.ToString(); this.Naziv = "opeka zid"; this.opis = this.Naziv + cenaStr; }
public AvramekoPloca() { this.Cena = 3000; string cenaStr = Cena.ToString(); this.Naziv = "avrameko ploca"; this.Opis = this.Naziv + cenaStr; }
public BetonskiTemeljLux() { this.cena = Cena; string cenaStr = Cena.ToString(); this.Naziv = "betonski temelj"; this.opis = this.Naziv + " " + this.Dodatak + " , cena: " + cenaStr; }
public PlastikaSobnaVrata() { this.Cena = 150; string cenaStr = Cena.ToString(); this.Naziv = "plastika sobna vrata"; this.Opis = this.Naziv + " , cena: " + cenaStr + " kolicina: "; }
public DrvoProzor() { this.Cena = 300; string cenaStr = Cena.ToString(); this.Naziv = "drvo - prozor"; // string kolicinaStr = Kolicina.ToString(); this.Opis = this.Naziv + " , cena: " + cenaStr + " , a kolicina:"; }
public void MudaCena(string novaCena) { Debug.Log("Mudando cena para "+novaCena); if(cenaAtual != "") { Encerra(); Destroy(GetComponent(string.Concat(cenaAtual, Globais.idioma))); } cenaAtual = novaCena; cena = gameObject.AddComponent(System.Type.GetType(string.Concat(cenaAtual, Globais.idioma))) as Cena; cena.SetaFalas(); contemAcoes = CenaTemAcoes(); }