public static RegistrationUser GetTestDataRegUser(string keyNameMartialStatus, string keyNameHobby, string keyNameRest) { using (var connection = new OleDbConnection(TestDataFileConnection())) { connection.Open(); RegistrationUser regUser = new RegistrationUser(); if (keyNameHobby != "") { var hobby_query = string.Format("select * from [RegistrationForm_Hobby$] where Key = '{0}'", keyNameHobby); OleDbDataAdapter oleDB = new OleDbDataAdapter(hobby_query, connection); DataTable dtOleDB = new DataTable(); oleDB.Fill(dtOleDB); foreach (DataRow row in dtOleDB.Rows) { string[] hobby = new string[dtOleDB.Rows.Count]; for (int m = 0; m < hobby.Length; m++) { hobby[m] = dtOleDB.Rows[m]["Hobby"].ToString(); } int[] int_hobby = new int[dtOleDB.Rows.Count]; for (int i = 0; i < hobby.Length; i++) { int_hobby[i] = int.Parse(hobby[i]); } regUser.Hobby = int_hobby; } } var martialstatus_query = string.Format("select * from [RegistrationForm_MartialStatus$] where Key = '{0}'", keyNameMartialStatus); var rest_query = string.Format("select * from [RegistrationFormTests$] where Key = '{0}'", keyNameRest); OleDbDataAdapter oleDA = new OleDbDataAdapter(martialstatus_query, connection); OleDbDataAdapter oleDC = new OleDbDataAdapter(rest_query, connection); DataTable dtOleDA = new DataTable(); DataTable dtOleDC = new DataTable(); oleDA.Fill(dtOleDA); oleDC.Fill(dtOleDC); foreach (DataRow row in dtOleDA.Rows) { string[] martial = new string[dtOleDA.Rows.Count]; for (int m = 0; m < martial.Length; m++) { martial[m] = dtOleDA.Rows[m]["MartialStatus"].ToString(); } int[] int_martial = new int[dtOleDA.Rows.Count]; for (int i = 0; i < martial.Length; i++) { int_martial[i] = int.Parse(martial[i]); } regUser.MatrialStatus = int_martial; } foreach (DataRow row in dtOleDC.Rows) { regUser.FirstName = row["FirstName"].ToString(); regUser.LastName = row["LastName"].ToString(); regUser.Country = row["Country"].ToString(); regUser.BirthMonth = row["BirthMonth"].ToString(); regUser.BirthDay = row["BirthDay"].ToString(); regUser.BirthYear = row["BirthYear"].ToString(); regUser.Phone = row["Phone"].ToString(); regUser.UserName = row["UserName"].ToString(); regUser.Email = row["Email"].ToString(); regUser.UploadPicDir = row["UploadPicDir"].ToString(); regUser.Description = row["Description"].ToString(); regUser.Password = row["Password"].ToString(); regUser.ConfirmPassword = row["ConfirmPassword"].ToString(); } connection.Close(); return(regUser); } }