public List <UserRoleItem> GetUserRoles(User user)
{
var parameters = new List <DbQueryParameter>()
{
new DbQueryParameter("InsCode", user.InsCode),
new DbQueryParameter("UserId", user.Id)
};
List <UserRoleItem> userRoleItems = new List <UserRoleItem>();
var result = SqlDbManager.Instance().ExecuteProcedureDataSets(UserSpHelper.GetUserRolesSpName(), parameters, SqlDbManager.SqlConnectionMode.QUERYBOOK);
if (result != null)
{
if (result.Tables.Count > 0 && result.Tables[0].Rows.Count > 0)
{
foreach (DataRow item in result.Tables[0].Rows)
{
UserRoleItem userRoleItem = new UserRoleItem {
RoleName = item["RoleName"].ToString()
};
userRoleItems.Add(userRoleItem);
}
}
}
return(userRoleItems);
}
public User Get(User filter)
{
var parameters = new List <DbQueryParameter>()
{
new DbQueryParameter("InsCode", filter.InsCode),
new DbQueryParameter("Email", filter.Email)
};
return(LoadDataSetUser(SqlDbManager.Instance().ExecuteProcedureDataSets(UserSpHelper.GetSpName(), parameters, SqlDbManager.SqlConnectionMode.QUERYBOOK)));
}
