public List <MAS_DEPARTMENT> ListDepartmentByComCode(string CompanyNo) { IDbConnection conn = null; List <MAS_DEPARTMENT> ret = new List <MAS_DEPARTMENT>(); try { //SET CONNECTION conn = ConnectionFactory.GetConnection(); conn.ConnectionString = ConfigurationManager.GetConfiguration().DbConnectionString; //OPEN CONNECTION conn.Open(); Mas_CompanyBL bl = new Mas_CompanyBL(conn); ret = bl.ListDeprtmentByCompany(CompanyNo); } 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); }
public MAS_COMPANY GetMasCompanyByID(string CompanyNo) { IDbConnection conn = null; MAS_COMPANY ret = new 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.GetCompanyByID(CompanyNo); } 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); }