/// <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;
}
