/// <summary>
/// Lấy danh sách đối tượng Actions từ DbDataReader
/// </summary>
/// <param name="cmd">DbCommand</param>
/// <returns>list</returns>
private List <Actions> Init(DbCommand cmd)
{
List <Actions> listActions = new List <Actions>();
try
{
using (DbDataReader reader = db.ExecuteReader(cmd))
{
while (reader.Read())
{
Actions mActions = new Actions
{
ActionId = reader.ReadAs <short>("ActionId"),
ActionName = reader.ReadAs <string>("ActionName"),
ActionDesc = reader.ReadAs <string>("ActionDesc"),
ParentActionId = reader.ReadAs <short>("ParentActionId"),
Url = reader.ReadAs <string>("Url"),
ActionStatusId = reader.ReadAs <byte>("ActionStatusId"),
Display = reader.ReadAs <byte>("Display"),
DisplayOrder = reader.ReadAs <short>("DisplayOrder"),
TreeOrder = reader.ReadAs <int>("TreeOrder"),
CrDateTime = reader.ReadAs <DateTime>("CrDateTime"),
};
listActions.Add(mActions);
}
}
return(listActions);
}
catch (Exception err)
{
throw new Exception("Data error: " + err.Message);
}
}
/// <summary>
/// Lấy danh sách đối tượng Users từ DbDataReader
/// </summary>
/// <param name="cmd">DbCommand</param>
/// <returns>list</returns>
private List <Users> Init(DbCommand cmd)
{
List <Users> listUsers = new List <Users>();
try
{
using (DbDataReader reader = db.ExecuteReader(cmd))
{
while (reader.Read())
{
Users mUsers = new Users
{
UserId = reader.ReadAs <int>("UserId"),
UserName = reader.ReadAs <string>("UserName"),
Password = reader.ReadAs <string>("Password"),
FullName = reader.ReadAs <string>("FullName"),
Address = reader.ReadAs <string>("Address"),
Email = reader.ReadAs <string>("Email"),
Mobile = reader.ReadAs <string>("Mobile"),
GenderId = reader.ReadAs <byte>("GenderId"),
UserStatusId = reader.ReadAs <byte>("UserStatusId"),
UserTypeId = reader.ReadAs <byte>("UserTypeId"),
DefaultActionId = reader.ReadAs <short>("DefaultActionId"),
BirthDay = reader.ReadAs <DateTime>("BirthDay"),
CrDateTime = reader.ReadAs <DateTime>("CrDateTime"),
};
listUsers.Add(mUsers);
}
}
return(listUsers);
}
catch (Exception err)
{
throw new Exception("Data error: " + err.Message);
}
}
