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