public static YellowstonePathology.Business.User.SystemUserCollection GetSystemUserCollection()
{
/*SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select su.UserId, su.Active, su.UserName, su.FirstName, su.LastName, su.Initials, su.Signature, su.DisplayName, su.EmailAddress, su.NationalProviderId, (select sr.* from tblSystemUserRole sr where sr.UserId = su.UserId " +
"for xml Path('SystemUserRole'), type) [SystemUserRoleCollection] from tblSystemUser su order by su.UserName for xml Path('SystemUser'), root('SystemUserCollection')";
cmd.CommandType = System.Data.CommandType.Text;
YellowstonePathology.Business.User.SystemUserCollection systemUserCollection = Persistence.SqlCommandHelper.ExecuteCollectionCommand<YellowstonePathology.Business.User.SystemUserCollection>(cmd);
return systemUserCollection;*/
Type t = typeof(YellowstonePathology.Business.User.SystemUserCollection);
ConstructorInfo ci = t.GetConstructor(BindingFlags.Instance | BindingFlags.NonPublic, null, new Type[0], null);
YellowstonePathology.Business.User.SystemUserCollection systemUserCollection = (YellowstonePathology.Business.User.SystemUserCollection)ci.Invoke(null);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select UserId, Active, UserName, FirstName, LastName, Initials, Signature, DisplayName, " +
"EmailAddress, NationalProviderId from tblSystemUser order by UserName " +
"select * from tblSystemUserRole";
cmd.CommandType = System.Data.CommandType.Text;
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.User.SystemUser systemUser = new SystemUser();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(systemUser, dr);
sqlDataReaderPropertyWriter.WriteProperties();
systemUserCollection.Add(systemUser);
}
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.Business.User.SystemUserRole systemUserRole = new SystemUserRole();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(systemUserRole, dr);
sqlDataReaderPropertyWriter.WriteProperties();
foreach (SystemUser systemUser in systemUserCollection)
{
if (systemUser.UserId == systemUserRole.UserID)
{
systemUser.SystemUserRoleCollection.Add(systemUserRole);
break;
}
}
}
}
}
return systemUserCollection;
}
public static YellowstonePathology.Business.User.SystemUserCollection GetSystemUserCollection()
{
Type t = typeof(YellowstonePathology.Business.User.SystemUserCollection);
ConstructorInfo ci = t.GetConstructor(BindingFlags.Instance | BindingFlags.NonPublic, null, new Type[0], null);
YellowstonePathology.Business.User.SystemUserCollection systemUserCollection = (YellowstonePathology.Business.User.SystemUserCollection)ci.Invoke(null);
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "select UserId, Active, UserName, FirstName, LastName, MiddleInitial, Initials, Signature, DisplayName, " +
"EmailAddress, NationalProviderId from tblSystemUser order by UserName; " +
"select * from tblSystemUserRole;";
cmd.CommandType = System.Data.CommandType.Text;
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.User.SystemUser systemUser = new SystemUser();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(systemUser, dr);
sqlDataReaderPropertyWriter.WriteProperties();
systemUserCollection.Add(systemUser);
}
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.Business.User.SystemUserRole systemUserRole = new SystemUserRole();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(systemUserRole, dr);
sqlDataReaderPropertyWriter.WriteProperties();
foreach (SystemUser systemUser in systemUserCollection)
{
if (systemUser.UserId == systemUserRole.UserID)
{
systemUser.SystemUserRoleCollection.Add(systemUserRole);
break;
}
}
}
}
}
return(systemUserCollection);
}