private void btnGetBatch_Click(object sender, EventArgs e)
{
Batch queryobject = new Batch();
if (!String.IsNullOrEmpty(txtBatchID.Text))
{
queryobject.Batch_Id = int.Parse(txtBatchID.Text);
}
queryobject.Batchname = txtBatchName.Text;
queryobject.Batchdescription = txtBatchDescription.Text;
List<object> dataRet = queryobject.get();
List<Batch> data = new List<Batch>();
foreach (object o in dataRet)
{
data.Add(o as Batch);
}
var _bind = data.Select(a => new
{
Batch_id = a.Batch_Id,
BatchName = a.Batchname,
Batchdescription = a.Batchdescription,
}).ToList();
batchGridView.DataSource = _bind;
utility.AddDeleteAndEditButton(batchGridView);
// 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
batchGridView.Update();
}
private void btnAddBatch_Click(object sender, EventArgs e)
{
// Create Object
Batch newObj = new Batch();
newObj.Batchname = txtBatchName.Text;
newObj.Batchdescription = txtBatchDescription.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)
{
Batch gotFromDB = new Batch();
gotFromDB.Batch_Id = int.Parse(dr[DatabaseCoachingInst.Batch.Batch_ID.ToString()].ToString());
gotFromDB.batchname = dr[DatabaseCoachingInst.Batch.BatchName.ToString()].ToString();
gotFromDB.Batchdescription = dr[DatabaseCoachingInst.Batch.BatchDescription.ToString()].ToString();
gotFromDB.class_id = int.Parse(dr[DatabaseCoachingInst.Batch.Class_ID.ToString()].ToString());
// write similar code for other fields.
return gotFromDB;
}