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);
}
}
