protected override void updateUIFromEntity(DomainObject entity)
{
Drzava drzava = (Drzava)entity;
txtNaziv.Text = drzava.Naziv;
txtKod.Text = drzava.Kod;
}
protected override void updateEntityFromUI(DomainObject entity)
{
Drzava drzava = (Drzava)entity;
drzava.Naziv = txtNaziv.Text.Trim();
drzava.Kod = txtKod.Text.Trim().ToUpper();
}
public IActionResult Create(Drzava drzava)
{
logger.LogTrace(JsonConvert.SerializeObject(drzava));
if (ModelState.IsValid)
{
try
{
ctx.Add(drzava);
ctx.SaveChanges();
logger.LogInformation($"Država {drzava.NazDrzave} dodana.");
TempData[Constants.Message] = $"Država {drzava.NazDrzave} dodana.";
TempData[Constants.ErrorOccurred] = false;
return(RedirectToAction(nameof(Index)));
}
catch (Exception exc)
{
logger.LogError("Pogreška prilikom dodavanje nove države: {0}", exc.CompleteExceptionMessage());
ModelState.AddModelError(string.Empty, exc.CompleteExceptionMessage());
return(View(drzava));
}
}
else
{
return(View(drzava));
}
}
protected override void saveOriginalData(DomainObject entity)
{
Drzava drzava = (Drzava)entity;
oldNaziv = drzava.Naziv;
oldKod = drzava.Kod;
}
/// <summary>
/// Representing method used for load data
/// </summary>
public static void LoadData()
{
string lineDrzava;
string lineWorldCup;
StreamReader citacDrzava = File.OpenText(lokacija + "\\" + "data" + "\\" + "drzave.csv");
while ((lineDrzava = citacDrzava.ReadLine()) != null)
{
Drzava drzava = new Drzava(lineDrzava);
listaDrzava.Add(drzava.ID, drzava);
}
citacDrzava.Close();
StreamReader citacSvetskihPrvenstava = File.OpenText(lokacija + "\\" + "data" + "\\" + "svetskaPrvenstva.csv");
while ((lineWorldCup = citacSvetskihPrvenstava.ReadLine()) != null)
{
SvetskoPrvenstvo worldCup = new SvetskoPrvenstvo(lineWorldCup, listaDrzava);
listaSvetskihPrvenstva.Add(worldCup.ID, worldCup);
}
citacSvetskihPrvenstava.Close();
}
public ActionResult Create([Bind(Include = "Id,Naziv")] Drzava drzava)
{
if (ModelState.IsValid)
{
// Check name
if (string.IsNullOrEmpty(drzava.Naziv))
{
ModelState.AddModelError("Naziv", "Ime drzave je obavezno polje.");
}
else
{
if (db.Drzavas.Any(x => x.Naziv.Equals(drzava.Naziv)))
{
ModelState.AddModelError("Naziv", "Drzava sa unetim nazivom već postoji.");
}
}
if (!ModelState.IsValid)
{
return(View(drzava));
}
db.Drzavas.Add(drzava);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(drzava));
}
public List <Drzava> vrniVseDrzave()
{
List <Drzava> seznam = new List <Drzava>();
// connection na bazo
string connStr = configuration.GetConnectionString("DefaultConnection");
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
// nastavitev query
string query = "SELECT * from Drzava;";
SqlCommand cmd = new SqlCommand(query, conn);
// if prazen
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Drzava d = new Drzava();
d.ID_drzava = Convert.ToInt16(reader[0]);
d.Ime = reader[1].ToString();
seznam.Add(d);
}
}
conn.Close();
return(seznam);
}
public IActionResult Snimi(DrzavaEditVM vm)
{
MojDbContext db = new MojDbContext();
Drzava d;
if (vm.DrzavaID == 0)
{
d = new Drzava();
db.Add(d);
}
else
{
d = db.Drzava.Find(vm.DrzavaID);
d.DrzavaID = vm.DrzavaID;
if (DaLiPostoji(vm.Naziv))
{
return(Redirect("/Drzava/?poruka=Drzava je vec pohranjena u bazu"));
}
}
d.Naziv = vm.Naziv;
d.Oznaka = vm.Oznaka;
db.SaveChanges();
db.Dispose();
return(Redirect("/Drzava/?poruka=Uspjesno ste pohranili podatke za drzavu"));
}
public IActionResult UrediSnimi(int id_drzava, string naziv, int sifra)
{
if (HttpContext.Session.GetInt32("user ID") == null)
{
TempData["poruka"] = poruka;
return(Redirect("/Auth/Index"));
}
if (HttpContext.Session.GetString("role") != "SuperAdmin")
{
TempData["poruka"] = poruka2;
return(Redirect("/Auth/Index"));
}
else
{
Drzava t = db.Drzava.Where(a => a.Drzava_ID == id_drzava).FirstOrDefault();
t.Naziv = naziv;
t.Sifra = sifra;
db.SaveChanges();
List <Drzava> lista_drzava = db.Drzava.ToList();
ViewData["drzave"] = lista_drzava;
return(View("Prikaz"));
}
}
public ActionResult Spremi(DrzavaEditModelView D)
{
if (Autentifikacija.KorisnikSesija == null)
{
return(RedirectToAction("Index", "Login", new { area = "" }));
}
if (!ModelState.IsValid)
{
return(View("Dodaj", D));
}
Drzava d;
if (D.Id == 0)
{
d = new Drzava();
ctx.Drzava.Add(d);
}
else
{
d = ctx.Drzava.Where(x => x.Id == D.Id).FirstOrDefault();
}
d.Naziv = D.Naziv;
d.Oznaka = D.Oznaka;
ctx.SaveChanges();
return(RedirectToAction("Prikazi"));
}
public IActionResult Ukloni(int id)
{
if (HttpContext.Session.GetInt32("user ID") == null)
{
TempData["poruka"] = poruka;
return(Redirect("/Auth/Index"));
}
if (HttpContext.Session.GetString("role") != "SuperAdmin")
{
TempData["poruka"] = poruka2;
return(Redirect("/Auth/Index"));
}
else
{
Drzava temp = db.Drzava.Where(x => x.Drzava_ID == id).FirstOrDefault();
if (temp != null)
{
db.Drzava.Remove(temp);
db.SaveChanges();
}
List <Drzava> lista_drzava = db.Drzava.ToList();
ViewData["drzave"] = lista_drzava;
return(View("Prikaz"));
}
}
public IActionResult UnosSnimi(int sifra, string naziv)
{
if (HttpContext.Session.GetInt32("user ID") == null)
{
TempData["poruka"] = poruka;
return(Redirect("/Auth/Index"));
}
if (HttpContext.Session.GetString("role") != "SuperAdmin")
{
TempData["poruka"] = poruka2;
return(Redirect("/Auth/Index"));
}
else
{
Drzava temp = new Drzava
{
Naziv = naziv,
Sifra = sifra
};
db.Drzava.Add(temp);
db.SaveChanges();
List <Drzava> lista_drzava = db.Drzava.ToList();
ViewData["drzave"] = lista_drzava;
return(View("Prikaz"));
}
}
public JsonResult Update(Drzava drzava)
{
try
{
if (!ModelState.IsValid)
{
return(Json(new { Result = "ERROR", Message = "Form is not valid! Please correct it and try again." }));
}
using (var context = new RezultatiContext())
{
Drzava drzavaUpdate = context.Drzavas.Find(drzava.DrzavaId);
drzavaUpdate.DrzavaId = drzava.DrzavaId;
drzavaUpdate.Naziv = drzava.Naziv;
context.SaveChanges();
}
return(Json(new { Result = "OK" }));
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", Message = ex.Message }));
}
}
public async Task <ActionResult <Drzava> > PostDrzava(Drzava drzava)
{
_context.Drzava.Add(drzava);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetDrzava", new { id = drzava.ID }, drzava));
}
public async Task <IActionResult> SaveDrzava(bool isAdd, string sifraDrzave, string imeDrzave)
{
var drzava = await _context.Drzava.FirstOrDefaultAsync(g => g.SifraDrzave == sifraDrzave.Trim());
if (isAdd)
{
if (drzava != null)
{
return(await GetDrzavaAddEdit(null));
}
else
{
drzava = new Drzava
{
SifraDrzave = sifraDrzave.Trim()
}
};
}
drzava.ImeDrzave = imeDrzave;
if (isAdd)
{
_context.Add(drzava);
}
await _context.SaveChangesAsync();
return(Ok(new { Success = true }));
}
public IActionResult Snimi(DrzavaUrediVM input)
{
if (!ModelState.IsValid)
{
input.regioniZaHTML = db.regioni.Select(r => new SelectListItem(r.Naziv, r.RegionId.ToString())).ToList();
return(View(nameof(UrediForm), input));
}
Drzava d;
if (input.DrzavaId == 0)
{
d = new Drzava();
db.Add(d);
TempData["poruka-success"] = "Uspjesno dodavanje nove drzave";
}
else
{
d = db.drzave.Find(input.DrzavaId);
TempData["poruka-success"] = "Uspjesno izmjena drzave";
}
d.Naziv = input.Naziv;
d.RegionId = input.RegionId;
db.SaveChanges();
db.Dispose();
return(RedirectToAction(nameof(Prikazi)));
}
public IHttpActionResult PutDrzava(int id, Drzava drzava)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != drzava.ID)
{
return(BadRequest());
}
db.Entry(drzava).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!DrzavaExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <IActionResult> PutDrzava(int id, Drzava drzava)
{
if (id != drzava.Id)
{
return(BadRequest());
}
_context.Entry(drzava).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DrzavaExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
private void FillDDLGRad()
{
Drzava d = lbDrzava.SelectedItem as Drzava;
lbGrad.Items.Clear();
SQLHelperIMpl.GetGradovi(d.IDDrzava).ForEach(g => lbGrad.Items.Add(g));
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Naziv")] Drzava drzava)
{
if (id != drzava.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(drzava);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DrzavaExists(drzava.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(drzava));
}
public IActionResult Uredi(Drzava drzava)
{
db.Drzave.Update(drzava);
db.SaveChanges();
return(Json(new { success = true }));
}
public IList <Sudija> FindSudije(string ime, string prezime, Pol?pol, Drzava drzava, Klub klub)
{
string query = @"
from Sudija s
left join fetch s.Klub
left join fetch s.Drzava";
string WHERE = " where ";
if (!String.IsNullOrEmpty(ime))
{
query += WHERE + "lower(s.Ime) like :ime";
WHERE = " and ";
}
if (!String.IsNullOrEmpty(prezime))
{
query += WHERE + "lower(s.Prezime) like :prezime";
WHERE = " and ";
}
if (pol != null)
{
query += WHERE + "s.Pol = :pol";
WHERE = " and ";
}
if (drzava != null)
{
query += WHERE + "s.Drzava = :drzava";
WHERE = " and ";
}
if (klub != null)
{
query += WHERE + "s.Klub = :klub";
WHERE = " and ";
}
query += " order by s.Prezime asc, s.Ime asc";
IQuery q = Session.CreateQuery(query);
if (!String.IsNullOrEmpty(ime))
{
q.SetString("ime", ime.ToLower() + '%');
}
if (!String.IsNullOrEmpty(prezime))
{
q.SetString("prezime", prezime.ToLower() + '%');
}
if (pol != null)
{
q.SetByte("pol", (byte)pol.Value);
}
if (drzava != null)
{
q.SetEntity("drzava", drzava);
}
if (klub != null)
{
q.SetEntity("klub", klub);
}
return(q.List <Sudija>());
}
public ActionResult DeleteConfirmed(int id)
{
Drzava drzava = db.Drzave.Find(id);
db.Drzave.Remove(drzava);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// POMOĆNE
// privatne metode za pretvaranje entiy <-> model
private static CountryVM convertEntityToViewModel(Drzava entity)
{
return(new CountryVM
{
IDCountry = entity.IDDrzava,
Name = entity.Naziv
});
}
public IActionResult Obrisi(int drzavaID)
{
Drzava drzava = _db.Drzava.Find(drzavaID);
_db.Drzava.Remove(drzava);
_db.SaveChanges();
return(Redirect("/Administrator/Lokacije/Index"));
}
/// <summary>
/// Representing method which write all countrys
/// </summary>
public static void WriteAllCountrys()
{
foreach (KeyValuePair <int, Drzava> drzava in listaDrzava)
{
Drzava drzavaWrite = drzava.Value;
Console.WriteLine(drzavaWrite.ID + " " + drzavaWrite.Naziv);
}
}
public IActionResult Obrisi(int Id)
{
Drzava x = _context.Drzava.Find(Id);
_context.Drzava.Remove(x);
_context.SaveChanges();
return(RedirectToAction("Index"));
}
public static DrzavaViewModel DataToViewModel(Drzava drzava)
{
return(new DrzavaViewModel
{
Id = drzava.Id,
Naziv = drzava.Naziv,
Sifra = drzava.Sifra
});
}
public ActionResult Edit([Bind(Include = "IDDrzava,Naziv")] Drzava drzava)
{
if (ModelState.IsValid)
{
db.Entry(drzava).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(drzava));
}
public ActionResult Edit(Guid?ID)
{
if (ID == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Drzava drzava = _context.Drzava.Find(ID);
return(View(drzava));
}
private IList<Gimnasticar> findGimnasticari(string ime, string prezime,
Nullable<int> godRodj, Nullable<Gimnastika> gimnastika, Drzava drzava,
KategorijaGimnasticara kategorija, Klub klub)
{
Query q = new Query();
if (!String.IsNullOrEmpty(ime))
q.Criteria.Add(new Criterion("Ime", CriteriaOperator.Like, ime, StringMatchMode.Start, true));
if (!String.IsNullOrEmpty(prezime))
q.Criteria.Add(new Criterion("Prezime", CriteriaOperator.Like, prezime, StringMatchMode.Start, true));
if (godRodj != null)
{
q.Criteria.Add(new Criterion("DatumRodjenja.Godina",
CriteriaOperator.Equal, (short)godRodj.Value));
}
if (gimnastika != null)
q.Criteria.Add(new Criterion("Gimnastika", CriteriaOperator.Equal, (byte)gimnastika.Value));
if (drzava != null)
q.Criteria.Add(new Criterion("Drzava", CriteriaOperator.Equal, drzava));
if (kategorija != null)
q.Criteria.Add(new Criterion("Kategorija", CriteriaOperator.Equal, kategorija));
if (klub != null)
q.Criteria.Add(new Criterion("Klub", CriteriaOperator.Equal, klub));
q.Operator = QueryOperator.And;
q.OrderClauses.Add(new OrderClause("Prezime", OrderClause.OrderClauseCriteria.Ascending));
q.OrderClauses.Add(new OrderClause("Ime", OrderClause.OrderClauseCriteria.Ascending));
foreach (AssociationFetch f in this.FetchModes)
{
q.FetchModes.Add(f);
}
return dataContext.GetByCriteria<Gimnasticar>(q);
}
private void insertDrzave()
{
DrzaveParser parser = new DrzaveParser();
parser.parse(@"..\..\test\Data\DrzaveSrb.txt");
foreach (object[] o in parser.Drzave)
{
Drzava drzava = new Drzava();
drzava.Kod = (string)o[0];
drzava.Naziv = (string)o[1];
dataContext.Add(drzava);
}
}
