/// <summary> /// /// </summary> /// <returns></returns> internal List<Business.Permit> GetAllPermit() { List<Business.Permit> Result = new List<Business.Permit>(); System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection); DSTableAdapters.PermitTableAdapter adap = new DSTableAdapters.PermitTableAdapter(); DS.PermitDataTable tbPermit = new DS.PermitDataTable(); try { conn.Open(); adap.Connection = conn; tbPermit = adap.GetData(); if (tbPermit != null) { int count = tbPermit.Count; for (int i = 0; i < count; i++) { Business.Permit newPermit = new Business.Permit(); newPermit.AgentGroupID = tbPermit[i].AgentGroupID; newPermit.AgentID = tbPermit[i].AgentID; newPermit.PermitID = tbPermit[i].PermitID; newPermit.Role = new Business.Role(); newPermit.Role.RoleID = tbPermit[i].RoleID; Result.Add(newPermit); } } } catch (Exception ex) { return null; } finally { adap.Connection.Close(); conn.Close(); } return Result; }