public ActionResult AvtoSearch(int skip, string query)
{
List <GetAvtoNumber> result = new List <GetAvtoNumber>();
string connectionstring = "Server=158.181.37.45;port=3306;Database=otoyol;Uid=root;Pwd=123123123;";
var queryString = String.Format("select * from otoyol_canli_ezleme where plaka like '%{0}%'", query);
using (MySqlConnection con = new MySqlConnection(connectionstring))
{
MySqlCommand cmd = new MySqlCommand(queryString, con);
con.Open();
MySqlDataReader reader = cmd.ExecuteReader();
try
{
while (reader.Read())
{
result.Add(new GetAvtoNumber
{
plaka = (string)reader[5],
tarih = (DateTime)reader[4],
kam_no = (int)reader[3],
durum = reader[7]
});
}
}
finally
{
reader.Close();
}
}
IEnumerable <GetAvtoNumber> data = result.AsEnumerable <GetAvtoNumber>();
GetAvtoNumberViewModel vm;
if (data.Count() <= 10)
{
vm = new GetAvtoNumberViewModel()
{
list = data.ToList(),
pagecount = 0,
currentpage = skip + 1
};
}
else
{
vm = new GetAvtoNumberViewModel()
{
list = data.ToList().Skip(skip * 10).Take(10),
pagecount = Math.Ceiling(Decimal.Divide(data.Count(), 10)) - 1,
currentpage = skip + 1
};
}
return(PartialView("_PartialAvtoSearch", vm));
}
public ActionResult AvtoLoad(int skip, string type)
{
List <GetAvtoNumber> result = new List <GetAvtoNumber>();
string connectionstring = "Server=158.181.37.45;port=3306;Database=otoyol;Uid=root;Pwd=123123123;";
string queryString = null;
if (type == "normal")
{
queryString = "select * from otoyol_canli_ezleme";
using (MySqlConnection con = new MySqlConnection(connectionstring))
{
MySqlCommand cmd = new MySqlCommand(queryString, con);
con.Open();
MySqlDataReader reader = cmd.ExecuteReader();
try
{
while (reader.Read())
{
result.Add(new GetAvtoNumber
{
plaka = (string)reader[5],
tarih = (DateTime)reader[4],
kam_no = (int)reader[3],
durum = reader[7]
});
}
}
finally
{
reader.Close();
}
}
}
else if (type == "ordered")
{
queryString = "select poce. *, (select count(*) from otoyol_canli_ezleme as oce where oce.plaka=poce.plaka) as n_count from otoyol_canli_ezleme poce where id_id in (select MAX(id_id) from otoyol_canli_ezleme group by plaka) order by tarih desc";
using (MySqlConnection con = new MySqlConnection(connectionstring))
{
MySqlCommand cmd = new MySqlCommand(queryString, con);
con.Open();
MySqlDataReader reader = cmd.ExecuteReader();
try
{
while (reader.Read())
{
result.Add(new GetAvtoNumber
{
plaka = (string)reader[5],
tarih = (DateTime)reader[4],
kam_no = (int)reader[3],
durum = reader[7],
count = Convert.ToInt32(reader[10])
});
}
}
finally
{
reader.Close();
}
}
}
IEnumerable <GetAvtoNumber> data = result.AsEnumerable <GetAvtoNumber>();
GetAvtoNumberViewModel vm = new GetAvtoNumberViewModel()
{
list = data.ToList().Skip(skip * 10).Take(10),
pagecount = Math.Ceiling(Decimal.Divide(data.Count(), 10)),
currentpage = skip + 1
};
if (type == "normal")
{
return(PartialView("_PartialAvtoArxiv", vm));
}
else
{
return(PartialView("_PartialAvtoOrdered", vm));
}
}
