加载视图与之前的现有数据进行编辑记录在运行update存储过程之前?

我有下面的控制器操作方法。

public int BulkUpdate(List employees) {

       Connection();
       employees = GetAllEmployees().ToList();
        // using reflection, i mean why did i use this ??
        //used it for converting the generic list into datatables.
       DataTable dt = new DataTable(typeof(Employee).Name);
       PropertyInfo[] props = typeof(Employee).GetProperties(BindingFlags.Public | BindingFlags.Instance);
       foreach (var prop in props)
       {
           dt.Columns.Add(prop.Name);
       }

       foreach (var employee in employees)
       {
           var values = new object[props.Length];
           for (int i = 0; i < props.Length; i++)
           {
               values[i] = props[i].GetValue(employee, null);
           }

           dt.Rows.Add(values);
       }
       //
       using (SqlCommand cmd = new SqlCommand("BulkUpdateEmployee", con))
       {
           cmd.CommandType = CommandType.StoredProcedure;
           SqlParameter parameter = cmd.Parameters.AddWithValue("@tblEmployeeType", dt);
           parameter.SqlDbType = SqlDbType.Structured;
           parameter.TypeName = "dbo.EmployeeType";


           con.Open();
           var rowsAffected = cmd.ExecuteNonQuery();
           con.Close();

           return rowsAffected;
       }//using ends here

   }

and this method is being called in main controller:

[AcceptVerbs(HttpVerbs.Get | HttpVerbs.Post)] public JsonResult BulkUpdateOrInsert(List employees) { int rowsAffected=empRepo.BulkUpdate(employees); return Json(rowsAffected, JsonRequestBehavior.AllowGet);

   }