/// <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; }
internal int DeletePermitByAgentID(int AgentID) { 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 = adap.DeletePermitByAgentID(AgentID); } catch (Exception ex) { Result = -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; }
/// <summary> /// /// </summary> /// <param name="PermitID"></param> /// <param name="AgentGroupID"></param> /// <param name="AgentID"></param> /// <param name="RoleID"></param> /// <returns></returns> internal bool UpdatePermit(int PermitID, int AgentGroupID, int AgentID, int RoleID) { bool Result = false; 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 Record = adap.UpdatePermit(AgentGroupID, AgentID, RoleID, PermitID); if (Record > 0) Result = true; } catch (Exception ex) { return false; } finally { adap.Connection.Close(); conn.Close(); } return Result; }
/// <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; }
/// <summary> /// /// </summary> /// <param name="PermitID"></param> /// <returns></returns> internal bool DeletePermitByID(int PermitID) { bool Result = true; 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; adap.DeletePermitByPermitID(PermitID); } catch (Exception ex) { Result = false; } finally { adap.Connection.Close(); conn.Close(); } return Result; }