private void btnClassQuery_Click(object sender, EventArgs e)
{
Class queryobject = new Class();
if (!String.IsNullOrEmpty(txtClassID.Text))
{
queryobject.Class_id = int.Parse(txtClassID.Text);
}
queryobject.ClassDescription = txtClassDescription.Text;
queryobject.ClassName = txtClassName.Text;
List<object> dataRet = queryobject.get();
List<Class> data = new List<Class>();
foreach (object o in dataRet)
{
data.Add(o as Class);
}
var _bind = data.Select(a => new
{
ClassID = a.Class_id,
ClassName = a.ClassName,
ClassDescription = a.ClassDescription,
}).ToList();
dataGridClass.DataSource = _bind;
utility.AddDeleteAndEditButton(dataGridClass);
// Link for getting buttons working as part of grid.
// http://stackoverflow.com/questions/10769316/add-a-button-in-a-new-column-to-all-rows-in-a-datagrid
dataGridClass.Update();
}
private void btnAddClass_Click(object sender, EventArgs e)
{
// Create Object
Class newObj = new Class();
newObj.ClassDescription = txtClassDescription.Text;
newObj.ClassName = txtClassName.Text;
// Assign read form's fields to object's fields
// Call Save
newObj.save();
// http://tech.pro/tutorial/776/csharp-tutorial-binding-a-datagridview-to-a-collection
this.Close();
}
/// <summary>
/// Object Specific function
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
public override object convertFromReader(OleDbDataReader dr)
{
Class gotFromDB = new Class();
gotFromDB.Class_id = int.Parse(dr[DatabaseCoachingInst.Class.Class_id.ToString()].ToString());
gotFromDB.ClassDescription = dr[DatabaseCoachingInst.Class.ClassDescription.ToString()].ToString();
gotFromDB.ClassName = dr[DatabaseCoachingInst.Class.ClassName.ToString()].ToString();
// write similar code for other fields.
return gotFromDB;
}
