/// <summary> /// /// </summary> /// <returns></returns> internal List<Business.Role> GetAllRole() { List<Business.Role> Result = new List<Business.Role>(); System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection); DSTableAdapters.RoleTableAdapter adap = new DSTableAdapters.RoleTableAdapter(); DS.RoleDataTable tbRole = new DS.RoleDataTable(); try { conn.Open(); adap.Connection = conn; tbRole = adap.GetData(); if (tbRole != null) { int count = tbRole.Count; for (int i = 0; i < count; i++) { Business.Role newRole = new Business.Role(); newRole.Code = tbRole[i].Code; newRole.Comment = tbRole[i].Comment; newRole.Name = tbRole[i].Name; newRole.RoleID = tbRole[i].RoleID; Result.Add(newRole); } } } catch (Exception ex) { return null; } finally { adap.Connection.Close(); conn.Close(); } return Result; }
/// <summary> /// /// </summary> /// <param name="RoleID"></param> /// <returns></returns> internal Business.Role GetRoleByRoleID(int RoleID) { Business.Role Result = new Business.Role(); System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection); DSTableAdapters.RoleTableAdapter adap = new DSTableAdapters.RoleTableAdapter(); DS.RoleDataTable tbRole = new DS.RoleDataTable(); try { conn.Open(); adap.Connection = conn; tbRole = adap.GetRoleByRoleID(RoleID); if (tbRole != null) { Result.Code = tbRole[0].Code; Result.Comment = tbRole[0].Comment; Result.Name = tbRole[0].Name; Result.RoleID = tbRole[0].RoleID; } } catch (Exception ex) { return null; } finally { adap.Connection.Close(); conn.Close(); } return Result; }