/// <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>
