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