public ActionResult EditStavka(StavkaFaktureTable stavkaEdit)
{
var result = _db.StavkaFaktureTables.SingleOrDefault(f => f.redniBr == stavkaEdit.redniBr);
if (!ModelState.IsValid)
{
return(View(stavkaEdit));
}
if (result != null)
{
result.kolicina = stavkaEdit.kolicina;
result.cena = stavkaEdit.cena;
result.ukupno = stavkaEdit.kolicina * stavkaEdit.cena;
_db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult CreateStavka(int ID, StavkaFaktureTable newStavkaFakture)
{
if (!ModelState.IsValid)
{
return(View());
}
var ukupno = newStavkaFakture.cena * newStavkaFakture.kolicina;
int redniBr = 0;
int redniBrmax = 0;
string sqlMax = "";
//broj redova u tabeli Stavke
string sqlCount = @"SELECT COUNT(*) FROM StavkaFaktureTable";
int count = _db.Database.SqlQuery <int>(sqlCount).Single();
if (count != 0)
{
sqlMax = @"SELECT MAX(redniBr) FROM StavkaFaktureTable";
redniBrmax = _db.Database.SqlQuery <int>(sqlMax).Single();
redniBr = redniBrmax + 1; //redni broj postavljano za 1 veci od max rednog broja u tabeli
}
_db.StavkaFaktureTables.Add(new StavkaFaktureTable
{
redniBr = redniBr,
fakturaID = ID,
kolicina = newStavkaFakture.kolicina,
cena = newStavkaFakture.cena,
ukupno = ukupno
});
_db.SaveChanges();
//kada se doda nova stavka treba vrednost ukupno_stavki u tabeli Faktura da promenimo i da dodamo tu stavku u listuStavki
int countSF = 0;
string esqlQuery = "";
int counter = 0;
using (EntityConnection conn = new EntityConnection("name=FaktureDBEntities"))
{
conn.Open();
esqlQuery = @"SELECT VALUE sf FROM FaktureDBEntities.StavkaFaktureTables as sf where sf.fakturaID = @id";
using (EntityCommand cmd = new EntityCommand(esqlQuery, conn))
{
//kreiramo parametar za parametarski upit
EntityParameter param1 = new EntityParameter();
param1.ParameterName = "id";
param1.Value = ID;
cmd.Parameters.Add(param1);
using (DbDataReader rdr = cmd.ExecuteReader(CommandBehavior.SequentialAccess))
{
while (rdr.Read())
{
//broj redova u tabeli Stavki za dati fakturaID
counter++;
}
}
}
}
countSF = counter;
var faktura = _db.FakturaTables.Find(ID);
var result = _db.FakturaTables.SingleOrDefault(f => f.fakturaID == faktura.fakturaID);
if (!ModelState.IsValid)
{
return(View(faktura));
}
if (result != null)
{
result.ukupno_stavki = countSF;
_db.SaveChanges();
}
faktura.StavkaFaktureTables.Add(newStavkaFakture);
return(RedirectToAction("Index"));
}
public ActionResult CreateStavka(int ID, StavkaFaktureTable newStavkaFakture)
{
if (!ModelState.IsValid)
{
return(View());
}
var ukupno = newStavkaFakture.cena * newStavkaFakture.kolicina;
int redniBr = 0;
int redniBrmax = 0;
string sqlMax = "";
string sqlCount = @"SELECT COUNT(*) FROM StavkaFaktureTable";
int count = _db.Database.SqlQuery <int>(sqlCount).Single();
if (count != 0)
{
sqlMax = @"SELECT MAX(redniBr) FROM StavkaFaktureTable";
redniBrmax = _db.Database.SqlQuery <int>(sqlMax).Single();
redniBr = redniBrmax + 1;
}
_db.StavkaFaktureTables.Add(new StavkaFaktureTable
{
redniBr = redniBr,
fakturaID = ID,
kolicina = newStavkaFakture.kolicina,
cena = newStavkaFakture.cena,
ukupno = ukupno
});
_db.SaveChanges();
int countSF = 0;
//string sqlCountStavkeFakture = "SELECT COUNT(*) FROM StavkaFaktureTables where fakturaID = {0}";
//string esqlQuery = @"SELECT COUNT(*) FROM StavkaFaktureTables where fakturaID = @id";
//using (EntityCommand cmd = new EntityCommand(esqlQuery))
//{
// // Create one parameter and add them to
// // the EntityCommand's Parameters collection
// EntityParameter param1 = new EntityParameter();
// param1.ParameterName = "id";
// param1.Value = ID;
// cmd.Parameters.Add(param1);
// using (EntityDataReader rdr = cmd.ExecuteReader(CommandBehavior.SequentialAccess, FaktureDBEntities))
// {
// while (rdr.Read())
// {
// countSF = rdr.GetInt32(0);
// }
// }
//}
string esqlQuery = "";
int counter = 0;
using (EntityConnection conn = new EntityConnection("name=FaktureDBEntities"))
{
conn.Open();
esqlQuery = @"SELECT VALUE sf FROM FaktureDBEntities.StavkaFaktureTables as sf where sf.fakturaID = @id";
using (EntityCommand cmd = new EntityCommand(esqlQuery, conn))
{
// Create one parameter and add them to
// the EntityCommand's Parameters collection
EntityParameter param1 = new EntityParameter();
param1.ParameterName = "id";
param1.Value = ID;
cmd.Parameters.Add(param1);
using (DbDataReader rdr = cmd.ExecuteReader(CommandBehavior.SequentialAccess))
{
while (rdr.Read())
{
//get rows
counter++;
}
//IExtendedDataRecord rdfdata = rdr as IExtendedDataRecord;
//countSF = rdfdata.DataRecordInfo.FieldMetadata.Count;
}
}
}
countSF = counter;
var faktura = _db.FakturaTables.Find(ID);
//faktura.StavkaFaktureTables.Add(newStavkaFakture);
var result = _db.FakturaTables.SingleOrDefault(f => f.fakturaID == faktura.fakturaID);
if (!ModelState.IsValid)
{
return(View(faktura));
}
if (result != null)
{
result.ukupno_stavki = countSF;
_db.SaveChanges();
}
faktura.StavkaFaktureTables.Add(newStavkaFakture);
return(RedirectToAction("Index"));
}
