private void ConnectToDb()
{
dBUtilities = new DBUtilities();
DataTable dt = dBUtilities.QueryTable(
"SELECT e.*, p.PositionName " +
"FROM tblEmployees e INNER JOIN tblPosition p " +
"ON e.PositionID = p.PositionID " +
"ORDER BY ID;");
foreach (DataRow row in dt.Rows)
{
ListViewItem item = new ListViewItem(row["ID"].ToString());
item.SubItems.Add(row["FirstName"].ToString());
item.SubItems.Add(row["LastName"].ToString());
item.SubItems.Add(row["MiddleName"].ToString());
item.SubItems.Add(row["PositionName"].ToString());
item.SubItems.Add(row["Gender"].ToString());
string bdate = Convert.ToDateTime(row["BDate"].ToString()).ToString("MMM dd, yyy");
item.SubItems.Add(bdate);
item.SubItems.Add(row["HomeAddress"].ToString());
item.SubItems.Add(row["TellNo"].ToString());
item.SubItems.Add(row["MobileNo"].ToString());
item.SubItems.Add(row["EmailAddress"].ToString());
lstEmployees.Items.Add(item);
}
}
public frmAddEmployee()
{
InitializeComponent();
utilities = new DBUtilities();
loadPositions();
}
public frmLogin()
{
InitializeComponent();
utilities = new DBUtilities();
}
public formAddPosition()
{
InitializeComponent();
utilities = new DBUtilities();
}
