public List <MAS_COMPANY> ListMasCompany() { IDbConnection conn = null; List <MAS_COMPANY> ret = new List <MAS_COMPANY>(); try { //SET CONNECTION conn = ConnectionFactory.GetConnection(); conn.ConnectionString = ConfigurationManager.GetConfiguration().DbConnectionString; //OPEN CONNECTION conn.Open(); Mas_CompanyBL bl = new Mas_CompanyBL(conn); ret = bl.ListCompanyName(); } catch (Exception ex) { logger.Error(ex.Message); logger.Error(ex.StackTrace); } finally { if (conn != null) { if (conn.State == ConnectionState.Open) { conn.Close(); } conn.Dispose(); } } return(ret); }