private async void frm_Smjestaj_Load(object sender, EventArgs e) { dgv_Smjestaj.AutoGenerateColumns = false; var search = new SmjestajSearchRequest { GradId = 0, Naziv = null, IzdavacId = _IzdavacId }; var result = await _SmjestajService.Get <List <SmjestajModel> >(search); dgv_Smjestaj.DataSource = result; var lista = await _GradService.Get <List <GradModel> >(null); GradModel prazan = new GradModel { GradId = 0, Naziv = "Odaberite grad...." }; lista.Insert(0, prazan); cb_GradPretraga.DataSource = lista; cb_GradPretraga.DisplayMember = "Naziv"; cb_GradPretraga.ValueMember = "GradId"; }
public void SaveID([FromBody] GradModel grad) { try { HttpContext.Session.SetInt32("GradID", grad.PostanskiBrojID); } catch (Exception) { } }
// GET: City/Delete/5 public bool Delete([FromBody] GradModel grad) { try { return(GradDAO.DeleteCity(grad.PostanskiBrojID)); } catch (Exception) { } return(false); }
public ActionResult CreateCityPopup(GradModel grad) { try { GradDAO.CreateNewCity(grad); return(View("Register")); } catch (Exception e) { e.Message.ToString(); return(View("Register")); } }
private async void frm_DodajSmjestaj_Load(object sender, EventArgs e) { var lista = await _GradService.Get <List <GradModel> >(null); GradModel prazan = new GradModel { GradId = 0, Naziv = "Odaberite grad...." }; lista.Insert(0, prazan); cb_Grad.DataSource = lista; cb_Grad.DisplayMember = "Naziv"; cb_Grad.ValueMember = "GradId"; }
public async Task <List <GradModel> > GetGradDegrees() { using (var client2 = new HttpClient()) { client2.BaseAddress = new Uri("http://www.ist.rit.edu/"); client2.DefaultRequestHeaders.Accept.Clear(); client2.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); try { HttpResponseMessage response = await client2.GetAsync("api/degrees/graduate", HttpCompletionOption.ResponseHeadersRead); response.EnsureSuccessStatusCode(); var data = await response.Content.ReadAsStringAsync(); // Above three lines can be replaced with new helper method below // string responseBody = await client.GetStringAsync(uri); var rtnResults = JsonConvert.DeserializeObject <Dictionary <string, List <GradModel> > >(data); List <GradModel> gradList = new List <GradModel>(); GradModel gradMajors = new GradModel(); foreach (KeyValuePair <string, List <GradModel> > kvp in rtnResults) { foreach (var item in kvp.Value) { gradList.Add(item); } } return(gradList); } catch (HttpRequestException hre) { var msg = hre.Message; List <GradModel> gradMajorsList = new List <GradModel>(); return(gradMajorsList); } catch (Exception ex) { var msg = ex.Message; List <GradModel> gradMajorsList = new List <GradModel>(); return(gradMajorsList); } } }
public ActionResult Create(GradModel grad) { try { if (HttpContext.Session.GetObjectFromJson <KorisnikModel>("LogovaniKorisnik") == null) { return(View("~/Views/Login/Index.cshtml")); } GradDAO.CreateNewCity(grad); return(RedirectToAction(nameof(Index))); } catch (Exception e) { return(View()); } }
public ActionResult SaveEdit(GradModel grad) { try { if (HttpContext.Session.GetObjectFromJson <KorisnikModel>("LogovaniKorisnik") == null) { return(View("~/Views/Login/Index.cshtml")); } grad.PostanskiBrojID = Convert.ToInt32(HttpContext.Session.GetInt32("GradID")); GradDAO.UpdateCity(grad); return(RedirectToAction(nameof(Index))); } catch (Exception e) { return(RedirectToAction(nameof(Edit))); } }
// GET: City/Edit/5 public ActionResult Edit() { var grad = new GradModel(); try { grad = GradDAO.GetCityById(Convert.ToInt32(HttpContext.Session.GetInt32("GradID"))); if (HttpContext.Session.GetObjectFromJson <KorisnikModel>("LogovaniKorisnik") == null) { return(View("~/Views/Login/Index.cshtml")); } } catch (Exception) { } return(View(grad)); }
public static Boolean UpdateCity(GradModel grad) { Boolean updated; SqlConnection connection = Database.GetConnection(); SqlCommand cmd = null; connection.Open(); cmd = new SqlCommand(UPDATE_CITY, connection); cmd.Parameters.AddWithValue("@PostanskiBrojID", grad.PostanskiBrojID); cmd.Parameters.AddWithValue("@Naziv", grad.Naziv.Trim()); cmd.Parameters.AddWithValue("@OpstinaID", string.IsNullOrEmpty(grad.Opstina.OpstinaID) ? (object)DBNull.Value : grad.Opstina.OpstinaID); cmd.Parameters.AddWithValue("@Opis", string.IsNullOrEmpty(grad.Opis) ? (object)DBNull.Value : grad.Opis.Trim()); cmd.CommandTimeout = 60; updated = cmd.ExecuteNonQuery() > 0 ? true : false; connection.Close(); return(updated); }
public IActionResult RowUpdate(int key, string values) { try { GradModel updatedCity = GradDAO.GetCityById(key); JsonConvert.PopulateObject(values, updatedCity); if (!TryValidateModel(updatedCity)) { return(BadRequest()); } GradDAO.UpdateCity(updatedCity); } catch (Exception) { } return(Ok()); }
public IActionResult RowInsert(string values) { try { GradModel newCity = new GradModel(); JsonConvert.PopulateObject(values, newCity); if (!TryValidateModel(newCity)) { return(BadRequest()); } GradDAO.CreateNewCity(newCity); } catch (Exception) { } return(Ok()); }
public static List <GradModel> GetAllCitys() { List <GradModel> gradovi = new List <GradModel>(); GradModel grad = null; SqlConnection connection = Database.GetConnection(); SqlCommand cmd = null; SqlDataReader reader = null; connection.Open(); cmd = new SqlCommand(GET_ALL_CITYS, connection); cmd.CommandTimeout = 60; reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { grad = new GradModel(); grad.PostanskiBrojID = Convert.ToInt32(reader.GetString(0)); grad.Naziv = reader.GetString(1) + " " + grad.PostanskiBrojID; if (!reader.IsDBNull(2)) { grad.Opstina.OpstinaID = reader.GetString(2); } if (!reader.IsDBNull(4)) { grad.Opis = reader.GetString(4); } if (!reader.IsDBNull(5)) { grad.Opstina.Naziv = reader.GetString(5); } gradovi.Add(grad); } reader.Close(); } connection.Close(); return(gradovi); }
public static GradModel GetCityById(int Id) { GradModel grad = null; SqlConnection connection = Database.GetConnection(); SqlCommand cmd = null; SqlDataReader reader = null; connection.Open(); cmd = new SqlCommand(GET_CITY_BY_ID, connection); cmd.Parameters.AddWithValue("@PostanskiBrojID", Id); cmd.CommandTimeout = 60; reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { grad = new GradModel(); grad.PostanskiBrojID = Convert.ToInt32(reader.GetString(0)); grad.Naziv = reader.GetString(1); if (!reader.IsDBNull(2)) { grad.Opstina.OpstinaID = reader.GetString(2); } if (!reader.IsDBNull(4)) { grad.Opis = reader.GetString(4); } if (!reader.IsDBNull(5)) { grad.Opstina.Naziv = reader.GetString(5); } } reader.Close(); } connection.Close(); return(grad); }
public frm_Login() { InitializeComponent(); List <GradModel> lista = new List <GradModel>(); GradModel item = new GradModel { GradId = 1, Naziv = "Izdavač" }; lista.Add(item); item = new GradModel { GradId = 2, Naziv = "Administrator" }; lista.Add(item); cb_Uloga.DataSource = lista; cb_Uloga.ValueMember = "GradId"; cb_Uloga.DisplayMember = "Naziv"; cb_Uloga.DropDownStyle = ComboBoxStyle.DropDownList; }
public async Task Ucitaj() { if (Sorteri.Count == 0) { Sorteri.Add("Ocjena"); Sorteri.Add("Udaljenost"); } if (ListaGradova.Count == 0) { var sourceGrad = await _gradService.Get <List <GradModel> >(null); ListaGradova.Clear(); if (sourceGrad.Count > 0) { foreach (GradModel g in sourceGrad) { ListaGradova.Add(g); } } GradModel prazan = new GradModel { Naziv = "Odaberite grad...", GradId = 0 }; SelectedGrad = prazan; ListaGradova.Insert(0, prazan); } var source = new List <SmjestajModel>(); if (SelectedGrad != null || SelectedSort != null) { if (SelectedGrad != null) { if (_odabraniGrad.GradId > 0) { SmjestajSearchRequest request = new SmjestajSearchRequest { GradId = _odabraniGrad.GradId }; source = await _smjestajService.Get <List <SmjestajModel> >(request); } } else { source = await _smjestajService.Get <List <SmjestajModel> >(null); } if (SelectedSort != null) { if (SelectedSort == "Ocjena") { source.Sort((x, y) => { if (!y.Zvijezde.HasValue) { if (!x.Zvijezde.HasValue) { return(0); } else { return(-1); } } else { if (!x.Zvijezde.HasValue) { return(1); } if (y.Zvijezde.Value == x.Zvijezde.Value) { return(0); } if (y.Zvijezde.Value < x.Zvijezde.Value) { return(-1); } else { return(1); } } }); } else if (SelectedSort == "Udaljenost") { source.Sort((x, y) => { if (!x.Distanca.HasValue) { if (!y.Distanca.HasValue) { return(0); } else { return(-1); } } else { if (!y.Distanca.HasValue) { return(1); } if (x.Distanca.Value == y.Distanca.Value) { return(0); } if (x.Distanca.Value < y.Distanca.Value) { return(-1); } else { return(1); } } }); } ListaSmjestaja.Clear(); if (source.Count > 0) { foreach (SmjestajModel s in source) { ListaSmjestaja.Add(s); } } else { SmjestajModel prazan = new SmjestajModel { SmjestajId = 0, Naziv = "Nema unesenih smještaja u ovom gradu", GradNaziv = "", Zvijezde = 0 }; ListaSmjestaja.Add(prazan); } } else { source = await _smjestajService.Get <List <SmjestajModel> >(null); ListaSmjestaja.Clear(); if (source.Count > 0) { foreach (SmjestajModel s in source) { ListaSmjestaja.Add(s); } } else { SmjestajModel prazan = new SmjestajModel { SmjestajId = 0, Naziv = "Nema unesenih smještaja u ovom gradu", GradNaziv = "", Zvijezde = 0 }; ListaSmjestaja.Add(prazan); } } } }