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