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