/// <summary> /// /// </summary> /// <param name="RoleID"></param> /// <returns></returns> internal List<Business.Permit> GetPermitByRoleID(int RoleID) { 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.GetPermitByRoleID(RoleID); 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; }
/// <summary> /// /// </summary> /// <param name="PermitID"></param> /// <returns></returns> internal Business.Permit GetPermitByPermitID(int PermitID) { Business.Permit Result = new 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.GetPermitByPermitID(PermitID); if (tbPermit != null) { Result.AgentGroupID = tbPermit[0].AgentGroupID; Result.AgentID = tbPermit[0].AgentID; Result.PermitID = tbPermit[0].PermitID; Result.Role = new Business.Role(); Result.Role.RoleID = tbPermit[0].RoleID; } } catch (Exception ex) { return null; } finally { adap.Connection.Close(); conn.Close(); } return Result; }