Beispiel #1
0
        private void Apply(RowAdapter d)
        {
            foreach (PropertyInfo propertyInfo in this.columnProperties)
            {
                ColumnAttribute a = Reflex.GetColumnAttribute(propertyInfo);
                if (a != null && d.Row.Table.Columns.Contains(a.ColumnNameSaved))
                {
                    if (propertyInfo.GetValue(this, null) == null)
                    {
                        d.Row[a.ColumnNameSaved] = System.DBNull.Value;
                    }
                    else
                    {
                        d.Row[a.ColumnNameSaved] = propertyInfo.GetValue(this, null);
                    }
                }
            }

            d.Fill();
        }
Beispiel #2
0
        public virtual bool Save(Selector columnNames, RowChangedHandler rowHandler, ValueChangedHandler columnHandler)
        {
            if (dataTable == null || dataTable.Rows.Count == 0)
            {
                return(false);
            }

            //update this.dataTable
            // this.AcceptChanges();

            objectPermission = ObjectPermission.DenyUpdateObject;
            RowAdapter d = this.NewSqlRow(columnNames);

            d.RowChanged += RowChanged;

            if (rowHandler != null)
            {
                d.RowChanged += rowHandler;
            }

            if (columnHandler != null)
            {
                d.ValueChangedHandler = columnHandler;
            }
            else
            {
                d.ValueChangedHandler = ValueChanged;
            }

            int count = 0;

            foreach (DataRow dataRow in dataTable.Rows)
            {
                BeforeSave(dataRow);

                if (dataRow.RowState != DataRowState.Deleted)
                {
                    if (dataRow.RowState != DataRowState.Unchanged)
                    {
                        d.CopyFrom(dataRow);
                        d.Fill();
                        d.Save();
                        if (dataRow.RowState == DataRowState.Added)   //in case of existing identity columns
                        {
                            d.CopyTo(dataRow);
                            UpdateObject(dataRow);
                        }

                        //slow version
                        //T t = this[dataRow];
                        //t.Save(d);
                        count++;
                    }
                }
                else
                {
                    dataRow.RejectChanges();
                    d.CopyFrom(dataRow);
                    d.Fill();
                    d.Delete();

                    //slow version
                    //T t = this[dataRow];
                    //t.Delete();
                    dataRow.Delete();
                }

                AfterSave(dataRow);
            }

            dataTable.AcceptChanges();

            objectPermission = ObjectPermission.AllowUpdateObject;
            return(true);
        }