public List <String> getEmployeeNames() { List <String> names = new List <String>(); StaffDataSet.StaffDataTable table = staffTableAdapter.GetData(); foreach (StaffDataSet.StaffRow row in table) { names.Add(row.Name); } return(names); }
private static void LoadData() { var rows = _tableAdapter.GetData(); foreach (var row in rows) { var staff = new Staff() { ID = Convert.ToInt32(row["ID"]), LastName = Convert.ToString(row["LastName"]), FirstName = Convert.ToString(row["FirstName"]), MiddleName = Convert.ToString(row["MiddleName"]), Type = (UserType)Convert.ToByte(row["Type"]), Username = Convert.ToString(row["Username"]), Password = Convert.ToString(row["Password"]) }; _dictionary.Add(staff.ID, staff); } _isLoaded = true; }
public static void LoadData() { var userAdapter = new UserTableAdapter(); var userData = userAdapter.GetData(); foreach (var row in userData) { var newRow = DataSet.User.NewUserRow(); newRow.ID = row.ID; newRow.LastName = row.LastName; newRow.FirstName = row.FirstName; newRow.MiddleName = row.IsMiddleNameNull() ? "" : row.MiddleName; newRow.Type = row.Type; DataSet.User.AddUserRow(newRow); } var machineAdapter = new MachineTableAdapter(); var machineData = machineAdapter.GetData(); foreach (var row in machineData) { var newRow = DataSet.Machine.NewMachineRow(); newRow.ID = row.ID; newRow.IsFinalized = row.IsFinalized; newRow.IsResultsViewed = row.IsResultsViewed; newRow.Name = row.IsNameNull() ? "" : row.Name; DataSet.Machine.AddMachineRow(newRow); } var staffAdapter = new StaffTableAdapter(); var staffData = staffAdapter.GetData(); foreach (var row in staffData) { var newRow = DataSet.Staff.NewStaffRow(); newRow.UserRow = DataSet.User.FindByID(row.UserID); newRow.Username = row.Username; newRow.Password = row.Password; DataSet.Staff.AddStaffRow(newRow); } var voterAdapter = new VoterTableAdapter(); var voterData = voterAdapter.GetData(); foreach (var row in voterData) { var newRow = DataSet.Voter.NewVoterRow(); newRow.ID = row.ID; newRow.GradeLevel = row.GradeLevel; newRow.StrandSection = row.StrandSection; newRow.IsMale = row.IsMale; newRow.Birthday = row.Birthday; newRow.VoterID = row.VoterID; newRow.IsForeign = row.IsForeign; newRow.MachineRow = DataSet.Machine.FindByID(row.MachineID); DataSet.Voter.AddVoterRow(newRow); } }