/// <summary>
 /// Method that returns all companies used in this example
 /// </summary>
 /// <returns>List of companies</returns>
 public static IList<TBL_COMPANIES> GetCompanies()
 {
     CompanyRepository compRepo = null;
     compRepo = new CompanyRepository();
     var companies = compRepo.GetAll().ToList();
     return companies;
 }
 public ActionResult GetAllCompanies()
 {
     //Get the View Repository
     CompanyRepository companyRepo = new CompanyRepository();
     //Get the Report Data
     var _companyData = from company in companyRepo.GetAll().Distinct()
                        select company;
     //return the data
     return PartialView("_companyRecords", _companyData.ToList());
 }