public RestoranDomainModel GetRestoranById(int restoranId) { RestoranDomainModel restoranDomainModel = new RestoranDomainModel(); string conString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; using (SqlConnection con = new SqlConnection(conString)) { if (con.State == ConnectionState.Closed) { con.Open(); } if (con.State == ConnectionState.Open) { using (SqlCommand com = new SqlCommand("SELECT RestoranID,Ime,Koordinate,Logo,MinimalnaNarudzbina,Ocena FROM RestoranTbl WHERE RestoranID=@id", con)) { com.Parameters.AddWithValue("@id", restoranId); SqlDataReader r = com.ExecuteReader(); if (r.HasRows) { restoranDomainModel.RestoranID = Convert.ToInt32(r["RestoranID"]); restoranDomainModel.Ime = Convert.ToString(r["Ime"]); restoranDomainModel.Koordinate = Convert.ToString(r["Koordinate"]); restoranDomainModel.Logo = Convert.ToString(r["Logo"]); restoranDomainModel.MinimalnaNarudzbina = Convert.ToDecimal(r["MinimalnaNarudzbina"]); restoranDomainModel.Ocena = Convert.ToDecimal(r["Ocena"]); } } } } return(restoranDomainModel); }
public ActionResult GetRestoranDetails(string id) { RestoranDomainModel restoranDomainModel = new RestoranDomainModel(); int _id = 0; if (int.TryParse(id, out _id)) { restoranDomainModel = _restoranBusiness.GetRestoranById(_id); } return(PartialView("~/Views/Shared/_loadCard_Restoran_area.cshtml", restoranDomainModel)); }
private RestoranDomainModel RestoranDomainModel(DataSet ds, int i) { RestoranDomainModel rdm = new RestoranDomainModel(); DataRow r = ds.Tables[0].Rows[i]; rdm.RestoranID = (int)r["RestoranID"]; rdm.Ime = Convert.ToString(r["Ime"]); rdm.Logo = Convert.ToString(r["Logo"]); if (r["Koordinate"] != null) { rdm.Koordinate = Convert.ToString(r["Koordinate"]); } rdm.MinimalnaNarudzbina = Convert.ToDecimal(r["MinimalnaNarudzbina"]); rdm.DostavaSeNaplacuje = Convert.ToBoolean(r["DostavaSeNaplacuje"]); rdm.Ocena = Convert.ToDecimal(r["Ocena"]); if (r["Kuhinja"] != null) { rdm.Kuhinja = Convert.ToString(r["Kuhinja"]); } return(rdm); }