/// <summary> /// /// </summary> /// <param name="AgentID"></param> /// <param name="ListRoleID"></param> /// <returns></returns> internal int AddListPermit(int AgentID, List<int> ListRoleID) { int Result = -1; System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection); DSTableAdapters.PermitTableAdapter adap = new DSTableAdapters.PermitTableAdapter(); try { conn.Open(); adap.Connection = conn; int count = ListRoleID.Count; for (int i = 0; i < count; i++) { Result = int.Parse(adap.AddNewPermit(null, AgentID, ListRoleID[i]).ToString()); } } catch (Exception ex) { return -1; } finally { adap.Connection.Close(); conn.Close(); } return Result; }
/// <summary> /// /// </summary> /// <param name="AgentGroupID"></param> /// <param name="AgentID"></param> /// <param name="RoleID"></param> /// <returns></returns> internal int AddNewPermit(int AgentGroupID, int AgentID, int RoleID) { int Result = -1; System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection); DSTableAdapters.PermitTableAdapter adap = new DSTableAdapters.PermitTableAdapter(); try { conn.Open(); adap.Connection = conn; Result = int.Parse(adap.AddNewPermit(AgentGroupID, AgentID, RoleID).ToString()); } catch (Exception ex) { return -1; } finally { adap.Connection.Close(); conn.Close(); } return Result; }