private void Method() { session1DataSetTableAdapters.UsersTableAdapter adapter = new session1DataSetTableAdapters.UsersTableAdapter(); var officeData = adapter.GetData(); var s = (from i in officeData select i); string str = ""; foreach (var i in s) { str += i.Password + " "; } MessageBox.Show(str); }
public static void Parser(string path) { var allLines = File.ReadLines(path); foreach (var item in allLines) { var arrValue = item.Split(','); if (arrValue.Length == 8) { User user = new User(); user.RoleID = arrValue[0] == "Administrator" ? 1 : 2; user.Email = arrValue[1]; user.Password = GetMd5Hash(arrValue[2]); //user.Password = arrValue[2]; user.FirstName = arrValue[3]; user.LastName = arrValue[4]; session1DataSetTableAdapters.OfficesTableAdapter adapter = new session1DataSetTableAdapters.OfficesTableAdapter(); var officeData = adapter.GetData(); int id = (from i in officeData where i.Title == arrValue[5] select i.ID).First(); user.OfficeID = id; user.Birthdate = DateTime.ParseExact(arrValue[6], "MM/dd/yyyy", CultureInfo.InvariantCulture); user.Active = arrValue[7] == "1" ? true : false; session1DataSetTableAdapters.UsersTableAdapter adapterUser = new session1DataSetTableAdapters.UsersTableAdapter(); var userData = adapterUser.GetData(); int UserID = 0; try { UserID = (from i in userData orderby i.ID descending select i.ID).First() + 1; } catch { } adapterUser.Insert(UserID, user.RoleID, user.Email, user.Password, user.FirstName, user.LastName, user.OfficeID, user.Birthdate, user.Active); } else { throw new Exception("CSVParser::Parser::invalidqtyparam"); } } }