Esempio n. 1
0
        private void save_Click(object sender, EventArgs e)
        {
            DataTable sysTmp   = systems.getSystemTable();
            DataTable secTmp   = sectors.getSectorTable();
            DataTable secObTmp = null;

            foreach (DataRow sysRow in sysTmp.Rows)
            {
                if (sysRow.RowState == DataRowState.Modified)
                {
                    sysRow.AcceptChanges();
                    systems.updateRow(sysRow);
                }
            }

            foreach (DataRow secRow in secTmp.Rows)
            {
                if (secRow.RowState == DataRowState.Modified)
                {
                    secRow.AcceptChanges();
                    sectors.updateRow(secRow);
                }
            }

            if (sectorWindow != null)
            {
                secObTmp = sectorWindow.getSectorObjectsSQL().getSectorObject();

                foreach (DataRow secObRow in secObTmp.Rows)
                {
                    if (secObRow.RowState == DataRowState.Modified)
                    {
                        secObRow.AcceptChanges();
                        sectorWindow.getSectorObjectsSQL().updateRow(secObRow);
                    }
                }
            }

            if (sectorWindow != null)
            {
                if (sectorWindow.getDeletedObjectsID().Count > 0)
                {
                    for (int i = 0; i < sectorWindow.getDeletedObjectsID().Count; i++)
                    {
                        int id   = (int)sectorWindow.getDeletedObjectsID()[i];
                        int type = (int)sectorWindow.getDeletedObjectsType()[i];
                        sectorWindow.getSectorObjectsSQL().deleteRow(id, type);
                    }
                    sectorWindow.clearDeletedHashTables();
                }
            }
        }