How reflecting changes in the List back on the database?

See more:

C#

.NET

Binding

MVP

I have a DataGridView on the UI (a win form) and model objects stored in a List <earning> are shown in the Grid.

Since this is MVP pattern, the DataSet returned from the service is converted to a list of Models (Earning) by the manager class and then the it's passed to the view by the presenter as a BindingSource.

All objects in the List are properly shown on the grid. Now What I'm trying to do is when user do the changes in the grid those changes should be reflected in the list (in object properties) and then should be updated in the database.

Is it correct the way I've used data binding in this case?
Since I've bound the grid to list how I save the changes on the list back on the database?
Is it possible to use reflection to update the list from the view?


View

public System.Collections.Generic.IList<Earning> EarningDetails
{
   set {dgEmployeeEarnings.DataSource= value;}
}

Presenter Class

private void ShowEarnings()
{
   _WageView.EarningDetails= _WageManager.PrepareEarnings ();
}

WageManager Class

public List<Earning> PrepareEarnings()
{
   return GetEarningObjedtList(CalculateEarnings(WagePeriodStartDate, WagePeriodEndDate));
}
    
    
private DataTable CalculateEarnings(DateTime startDate, DateTime endDate)
{
   return _DataService.GetEarnings(startDate, endDate);
}
    
private List<Earning > GetEarningObjedtList(DataTable dt)
{
   var convertedList = (from rw in dt.AsEnumerable()
      select new Earning()
      {
         EmployeeID=Convert.ToInt32(rw[0]),
         WorkDays= Convert.ToInt32 (rw[2]),
         DayOffs = Convert.ToInt32(rw[3]),
         LeaveDays  = Convert.ToInt32(rw[4]),
         ExtraShifts = Convert.ToInt32(rw[5]),
         ExtraShiftAmount = Convert.ToDecimal (rw[7]),
         BasicSalaryAmount = Convert.ToDecimal(rw[8]),
         BudjetoryAllowance = Convert.ToDecimal(rw[9]),
         NoPayDays = Convert.ToInt32(rw[10]),
         LessNoPayAmount = Convert.ToDecimal(rw[11]),
         AmountForEPF = Convert.ToDecimal(rw[12]),
         OverTimeAmount = Convert.ToDecimal(rw[13]),
         BroughtForwardAmount = rw[14] == DBNull.Value ? 0 : Convert.ToDecimal(rw[14]),
      }).ToList();
    
   return convertedList;
}