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