public static MemberDTO DataSetToMember(DataSet set, int rowIndex)
{
AddressMySQLContext a;
string connectionString = "Server=84.31.134.4;Database=barboekmain;User Id=newuser;Password=test;";
a = new AddressMySQLContext(connectionString); //Zorgt ervoor dat er een daadwerkelijk adres wordt opgeslagen in MemberDTO
return(new MemberDTO()
{
ID = (int)set.Tables[0].Rows[rowIndex][0],
Name = set.Tables[0].Rows[rowIndex][1].ToString(),
Address = (AddressDTO)a.FindAddressById((int)set.Tables[0].Rows[rowIndex][2]),
BirthDate = (DateTime)set.Tables[0].Rows[rowIndex][3],
Email = set.Tables[0].Rows[rowIndex][4].ToString(),
Password = set.Tables[0].Rows[rowIndex][5].ToString(),
Access = (MemberDTO.AccessLevel)set.Tables[0].Rows[rowIndex][6],
BondNummer = (int)set.Tables[0].Rows[rowIndex][7],
LastName = set.Tables[0].Rows[rowIndex][8].ToString(),
Initials = set.Tables[0].Rows[rowIndex][9].ToString(),
Insertion = set.Tables[0].Rows[rowIndex][10].ToString(),
PhoneNumber = set.Tables[0].Rows[rowIndex][9].ToString(),
Gender = set.Tables[0].Rows[rowIndex][10].ToString(),
PhoneWork = set.Tables[0].Rows[rowIndex][11].ToString(),
PhoneMobile = set.Tables[0].Rows[rowIndex][12].ToString()
});
}
public static MemberDTO DataSetToMember(DataSet set, int rowIndex)
{
AddressMySQLContext a;
string connectionString = "Server=84.31.134.4;Database=barboekmain;User Id=newuser;Password=test;";
a = new AddressMySQLContext(connectionString); //Zorgt ervoor dat er een daadwerkelijk adres wordt opgeslagen in MemberDTO
return(new MemberDTO()
{
ID = (int)set.Tables[0].Rows[rowIndex][0],
Name = set.Tables[0].Rows[rowIndex][1].ToString(),
Address = (AddressDTO)a.FindAddressById((int)set.Tables[0].Rows[rowIndex][2])
});
}
public static MemberDTO DataSetToMember(DataSet set, int rowIndex)
{
AddressMySQLContext a;
string connectionString = "Server=192.168.15.51;Database=dbi428513;User Id=dbi428513;Password=Udkingtrug4!;";
a = new AddressMySQLContext(connectionString); //Zorgt ervoor dat er een daadwerkelijk adres wordt opgeslagen in MemberDTO
return(new MemberDTO()
{
ID = (int)set.Tables[0].Rows[rowIndex][0],
Name = set.Tables[0].Rows[rowIndex][1].ToString(),
Address = (AddressDTO)a.FindAddressById((int)set.Tables[0].Rows[rowIndex][2])
});
}