public RestoraniDomainModel GetRestoransByOffset(int offset, int take)
{
RestoraniDomainModel restoranDomainModels = new RestoraniDomainModel();
//var res = dbcontext.RestoranTbls.OrderBy(x => x.RestoranID).Skip(offset).Take(take).ToList();
//int count = res.Count;
//restoranDomainModels.TotalCount = dbcontext.RestoranTbls.ToList().Count;
//for (int i = 0, j = count - 1; i < count; i++, j--)
//{
// if (j < i) { break; }
// RestoranDomainModel restoranDomainModel = new RestoranDomainModel();
// restoranDomainModel.RestoranID = res[i].RestoranID;
// restoranDomainModel.Ime = res[i].Ime;
// restoranDomainModel.Koordinate = res[i].Koordinate;
// restoranDomainModel.Logo = res[i].Logo;
// restoranDomainModel.MinimalnaNarudzbina = res[i].MinimalnaNarudzbina;
// restoranDomainModel.Ocena = res[i].Ocena;
// RestoranDomainModel r = new RestoranDomainModel();
// r.RestoranID = res[j].RestoranID;
// r.Ime = res[j].Ime;
// r.Koordinate = res[j].Koordinate;
// r.Logo = res[j].Logo;
// r.MinimalnaNarudzbina = res[j].MinimalnaNarudzbina;
// r.Ocena = res[j].Ocena;
// restoranDomainModels.restoranDomainModels.Add(restoranDomainModel);
// restoranDomainModels.restoranDomainModels.Add(r);
//}
//restoranDomainModels.KuhinjeModels.AddRange(GetKuhinjes());
return(restoranDomainModels);
}
// GET: Ponuda
public ActionResult Index(AddressInfo addressInfo)
{
if (ModelState.IsValid)
{
RestoraniDomainModel restoraniDomainModel = _restoranBusiness.GetRestoransByAll(addressInfo.skip, 10, addressInfo.opstina, addressInfo.postCode, addressInfo.restoran, "1");
return(View(restoraniDomainModel));
}
RestoraniDomainModel restoran1 = _restoranBusiness.GetRestorans(10);
return(View(restoran1));
}
public ActionResult Search(string opstina, int postCode, string restoran, string kuhinje, int skip)
{
string [] kuhinjeObj = JsonConvert.DeserializeObject <string []>(kuhinje);
string kuhinjeNiz = "";
if (kuhinje.Length > 0)
{
int currentConveted = 0;
StringBuilder s = new StringBuilder();
for (int i = 0; i < kuhinjeObj.Length; i++)
{
if (kuhinjeObj[i] != null)
{
if (int.TryParse(kuhinjeObj[i], out currentConveted))
{
if (s.Length <= 0)
{
s.Append(kuhinjeObj[i]);
}
else if (i > 0 && i < kuhinjeObj.Length - 1)
{
s.Append(',');
s.Append(kuhinjeObj[i]);
}
else
{
s.Append(',');
s.Append(kuhinjeObj[i]);
}
}
}
}
kuhinjeNiz = s.ToString();
}
RestoraniDomainModel restoraniDomainModel = _restoranBusiness.GetRestoransByAll(skip, 10, opstina, postCode, restoran, kuhinjeNiz);
if (restoraniDomainModel.restoranDomainModels.Count > 0)
{
Response.StatusCode = (int)HttpStatusCode.OK;
}
else
{
Response.StatusCode = (int)HttpStatusCode.NoContent;
}
return(PartialView("~/Views/Shared/_RestoraniList.cshtml", restoraniDomainModel));
}
public RestoraniDomainModel GetRestorans(int initTake)
{
RestoraniDomainModel restoranDomainModels = new RestoraniDomainModel();
string conString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
try
{
DataSet ds = new DataSet();
using (SqlConnection con = new SqlConnection(conString))
{
using (SqlCommand com = new SqlCommand("spGetFirstElements", con))
{
com.CommandType = System.Data.CommandType.StoredProcedure;
com.Parameters.AddWithValue("@count", initTake);
if (con.State != System.Data.ConnectionState.Open)
{
con.Open();
}
if (con.State == System.Data.ConnectionState.Open)
{
using (SqlDataAdapter da = new SqlDataAdapter(com))
{
da.Fill(ds);
}
}
}
}
for (int i = 0, j = ds.Tables[0].Rows.Count - 1; i < ds.Tables[0].Rows.Count; i++, j--)
{
if (j < i)
{
break;
}
restoranDomainModels.restoranDomainModels.Add(RestoranDomainModel(ds, i));
restoranDomainModels.restoranDomainModels.Add(RestoranDomainModel(ds, j));
}
for (int i = 0, j = ds.Tables[1].Rows.Count - 1; i < ds.Tables[1].Rows.Count; i++, j--)
{
if (j < i)
{
break;
}
restoranDomainModels.KuhinjeModels.Add(KuhinjeModelsMethod(ds, i));
restoranDomainModels.KuhinjeModels.Add(KuhinjeModelsMethod(ds, j));
}
DataRow total = ds.Tables[2].Rows[0];
restoranDomainModels.TotalCount = (int)total["Total"];
}
catch (SqlException ex)
{
string sqlerro = ex.Message;
}
catch (Exception ex)
{
string regularException = ex.Message;
}
return(restoranDomainModels);
}
public RestoraniDomainModel GetRestoransPartialy(int offset, int take, string opstina, int postcode, string restoran, string kuhinje)
{
RestoraniDomainModel restoranDomainModels = new RestoraniDomainModel();
string conString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
try
{
DataSet ds = new DataSet();
using (SqlConnection con = new SqlConnection(conString))
{
using (SqlCommand com = new SqlCommand("spSearchBasicPartially", con))
{
com.CommandType = System.Data.CommandType.StoredProcedure;
com.Parameters.AddWithValue("@opstina", opstina);
com.Parameters.AddWithValue("@postCode", postcode);
com.Parameters.AddWithValue("@restorna", restoran);
com.Parameters.AddWithValue("@kuhinje", kuhinje);
com.Parameters.AddWithValue("@skip", offset);
if (con.State != System.Data.ConnectionState.Open)
{
con.Open();
}
if (con.State == System.Data.ConnectionState.Open)
{
using (SqlDataAdapter da = new SqlDataAdapter(com))
{
da.Fill(ds);
}
}
}
}
if (ds.Tables[0].Rows.Count > 1)
{
for (int i = 0, j = ds.Tables[0].Rows.Count - 1; i < ds.Tables[0].Rows.Count; i++, j--)
{
if (j < i)
{
break;
}
restoranDomainModels.restoranDomainModels.Add(RestoranDomainModel(ds, i));
restoranDomainModels.restoranDomainModels.Add(RestoranDomainModel(ds, j));
}
}
else
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
restoranDomainModels.restoranDomainModels.Add(RestoranDomainModel(ds, i));
}
}
}
catch (SqlException ex)
{
string sqlerro = ex.Message;
}
catch (Exception ex)
{
string regularException = ex.Message;
}
return(restoranDomainModels);
}
public RestoraniDomainModel GetRestoransByOffsetAndCity(int offset, int take, string city)
{
RestoraniDomainModel restoranDomainModels = new RestoraniDomainModel();
return(restoranDomainModels);
}
