/// <summary> /// Filter company using name and url using stored procedure /// </summary> /// <param name="searchName"></param> /// <param name="searchUrl"></param> /// <returns></returns> public List <CompanyVM> GetFilteredList(string searchName = "", string searchUrl = "") { List <CompanyVM> list = new List <CompanyVM>(); try { using (CMS_DbEntities db = new CMS_DbEntities()) { List <Tbl_Company> companies = new List <Tbl_Company>(); companies = db.UserSP_GetCompanyByName_URL(searchName, searchUrl).ToList(); foreach (Tbl_Company company in companies) { list.Add(converter.ConvertToModel(company)); } } } catch (Exception ex) { // we can add a method to log all exception messages throw; } return(list); }/// <summary>