public void bindData()
{
using (OleDbConnection con = new OleDbConnection(connectString))
{
con.Open();
SimpleLookupObject lookup = new SimpleLookupObject();
lookup.DBTable = "status";
SimpleDAO <SimpleLookupObject> sdaolookup = new SimpleDAO <SimpleLookupObject>();
List <SimpleLookupObject> lookuplist = sdaolookup.SimpleSelectList(con, lookup);
cbStatus.DisplayMember = "Name";
cbStatus.ValueMember = "Id";
cbStatus.DataSource = lookuplist;
Employee emp = new Employee();
emp.DBTable = "vw_Employee";
SortedList <int, SortedColumn> sorts = new SortedList <int, SortedColumn>();
sorts.Add(1, new SortedColumn("Last_Name", SimpleDAO.SortOrder.Ascending));
sorts.Add(2, new SortedColumn("First_Name", SimpleDAO.SortOrder.Ascending));
emp.DBOrderBy = sorts;
Dictionary <string, string> props = emp.Describe();
SimpleDAO <Employee> sdaoemp = new SimpleDAO <Employee>();
List <Employee> list = (List <Employee>)sdaoemp.SimpleSelectList(con, emp);
dgData.DataSource = list;
}
}
public void TestAttributeSimpleSelect()
{
Employee criteria = new Employee();
criteria.Id = 5;
OleDbConnection con = new OleDbConnection(connectString);
con.Open();
SimpleDAO<MockObject> dao = new SimpleDAO<MockObject>();
MockObject returned = dao.SimpleSelect(con, criteria);
Assert.AreEqual(returned.Id, criteria.Id);
}
public void TestAttributeSimpleSelect()
{
Employee criteria = new Employee();
criteria.Id = 5;
OleDbConnection con = new OleDbConnection(connectString);
con.Open();
SimpleDAO <MockObject> dao = new SimpleDAO <MockObject>();
MockObject returned = dao.SimpleSelect(con, criteria);
Assert.AreEqual(returned.Id, criteria.Id);
}
private void bindDataGrid()
{
using (OleDbConnection con = new OleDbConnection(connectString))
{
con.Open();
Employee emp = new Employee();
emp.DBTable = "vw_Employee";
SortedList <int, SortedColumn> sorts = new SortedList <int, SortedColumn>();
sorts.Add(1, new SortedColumn("Last_Name", SimpleDAO.SortOrder.Ascending));
sorts.Add(2, new SortedColumn("First_Name", SimpleDAO.SortOrder.Ascending));
emp.DBOrderBy = sorts;
Dictionary <string, string> props = emp.Describe();
SimpleDAO <Employee> sdao = new SimpleDAO <Employee>();
List <Employee> list = (List <Employee>)sdao.SimpleSelectList(con, emp);
dgData.DataSource = list;
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
Employee emp = new Employee();
Dictionary <string, string> props = emp.Describe();
props.Remove("StatusName");
emp.FirstName = tbFirst.Text;
emp.LastName = tbLast.Text;
emp.Status = (int)cbStatus.SelectedValue;
SimpleDAO <Employee> sdao = new SimpleDAO <Employee>();
using (OleDbConnection con = new OleDbConnection(connectString))
{
con.Open();
sdao.SimpleInsert(con, emp);
}
bindDataGrid();
}
