public IHttpActionResult ViewAirlinesByPage(int max, int page, string sort_col, string sort_dir, string search = null) { Paged_ACRF_AirlinesModel objList = new Paged_ACRF_AirlinesModel(); try { objList = objAirlinesVM.ListAirlines(max, page, search, sort_col, sort_dir); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(Ok(new { results = objList })); }
public Paged_ACRF_AirlinesModel ListAirlines(int max, int page, string search, string sort_col, string sort_dir) { Paged_ACRF_AirlinesModel objPaged = new Paged_ACRF_AirlinesModel(); List <ACRF_AirlinesModel> objList = new List <ACRF_AirlinesModel>(); try { if (search == null) { search = ""; } int startIndex = max * (page - 1); string sqlstr = "ACRF_GetAirlinesByPage"; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@startRowIndex", startIndex); cmd.Parameters.AddWithValue("@pageSize", max); cmd.Parameters.AddWithValue("@search", search); cmd.Parameters.AddWithValue("@sort_col", sort_col); cmd.Parameters.AddWithValue("@sort_dir", sort_dir); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { ACRF_AirlinesModel tempobj = new ACRF_AirlinesModel(); tempobj.Id = Convert.ToInt32(sdr["Id"].ToString()); tempobj.AirlineCode = sdr["AirlineCode"].ToString(); tempobj.SubCode = sdr["SubCode"].ToString(); tempobj.AirlineName = sdr["AirlineName"].ToString(); tempobj.HQAddress = sdr["HQAddress"].ToString(); tempobj.HQPhone = sdr["HQPhone"].ToString(); tempobj.HQFAX = sdr["HQFAX"].ToString(); tempobj.HQEmail = sdr["HQEmail"].ToString(); tempobj.HQIATAMember = sdr["HQIATAMember"].ToString(); tempobj.SalGsaCsaName = sdr["SalGsaCsaName"].ToString(); tempobj.SalAddress = sdr["SalAddress"].ToString(); tempobj.SalPhone = sdr["SalPhone"].ToString(); tempobj.SalFAX = sdr["SalFAX"].ToString(); tempobj.SalEmail = sdr["SalEmail"].ToString(); tempobj.OprAddress = sdr["OprAddress"].ToString(); tempobj.OprPhone = sdr["OprPhone"].ToString(); tempobj.OprFAX = sdr["OprFAX"].ToString(); tempobj.OprEmail = sdr["OprEmail"].ToString(); tempobj.CreatedBy = sdr["CreatedBy"].ToString(); tempobj.CreatedOn = Convert.ToDateTime(sdr["CreatedOn"].ToString()); if (sdr["AirlinePhoto"].ToString() == "") { tempobj.AirlinePhoto = ""; tempobj.AirlineDemoPhoto = tempobj.AirlineName[0].ToString(); } else { tempobj.AirlinePhoto = GlobalFunction.GetAPIUrl() + sdr["AirlinePhoto"].ToString(); } objList.Add(tempobj); } sdr.Close(); objPaged.ACRF_AirlinesModelList = objList; sqlstr = "select count(*) as cnt from ACRF_Airlines where AirlineName like @search "; cmd.Parameters.Clear(); cmd.CommandText = sqlstr; cmd.Connection = connection; cmd.CommandType = System.Data.CommandType.Text; cmd.Parameters.AddWithValue("@search", '%' + search + '%'); sdr = cmd.ExecuteReader(); while (sdr.Read()) { objPaged.PageCount = Convert.ToInt32(sdr["cnt"].ToString()); } connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objPaged); }