public IHttpActionResult GetAllClients(string name, string phone, string email, string clientType, string fax, int?orgId, int?page, int?count) { try { using (MaxMasterDbEntities db = new MaxMasterDbEntities()) { var totalCount = 0; /* get list of clients through stored procedure db.GetClients */ var Clients = db.GetClients(name, phone, email, clientType, fax, orgId, page, count).ToList(); if (Clients.Count > 0) { totalCount = (int)Clients.FirstOrDefault().TotalCount; } return(Content(HttpStatusCode.OK, new { Clients, totalCount })); } } catch (Exception ex) { new Error().logAPIError(System.Reflection.MethodBase.GetCurrentMethod().Name, ex.ToString(), ex.StackTrace); return(Content(HttpStatusCode.InternalServerError, ex.ToString())); } }