Exemplo n.º 1
0
        private static SQLInformation.Data.ApplicationDataSet.VWColumnsRow Add(Guid viewID, MSMO.Column column)
        {
            SQLInformation.Data.ApplicationDataSet.VWColumnsRow dataRow = null;

            try
            {
                dataRow             = Common.ApplicationDataSet.VWColumns.NewVWColumnsRow();
                dataRow.ID          = Guid.NewGuid();
                dataRow.Name_Column = column.Name;

                dataRow.DBView_ID    = viewID;
                dataRow.DataType     = column.DataType.ToString();
                dataRow.Identity     = column.Identity;
                dataRow.IsForeignKey = column.IsForeignKey;
                dataRow.Nullable     = column.Nullable;

                dataRow.SnapShotDate  = DateTime.Now;
                dataRow.SnapShotError = "";

                Common.ApplicationDataSet.VWColumns.AddVWColumnsRow(dataRow);
                Common.ApplicationDataSet.VWColumnsTA.Update(Common.ApplicationDataSet.VWColumns);
            }
            catch (Exception ex)
            {
                VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 5);
                // TODO(crhodes):
                // Wrap anything above that throws an exception that we want to ignore,
                // e.g. property not available because of SQL Edition.

                UpdateDatabaseWithSnapShot(dataRow, ex.ToString().Substring(0, 256));
            }

            return(dataRow);
        }
Exemplo n.º 2
0
        private static void Update(MSMO.Column column, SQLInformation.Data.ApplicationDataSet.VWColumnsRow dataRow)
        {
            try
            {
                column.UpdateDataSet(dataRow);

                UpdateDatabaseWithSnapShot(dataRow, "");
            }
            catch (Exception ex)
            {
                VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 6);

                UpdateDatabaseWithSnapShot(dataRow, ex.ToString().Substring(0, 256));
            }
        }
Exemplo n.º 3
0
        private static SQLInformation.Data.ApplicationDataSet.VWColumnsRow GetInfoFromSMO(MSMO.Column column, Guid viewID)
        {
#if TRACE
            long startTicks = VNC.AppLog.Trace5("Enter", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 2);
#endif
            SQLInformation.Data.ApplicationDataSet.VWColumnsRow dataRow = null;

            try
            {
                var dbs = from tb in Common.ApplicationDataSet.VWColumns
                          where tb.DBView_ID == viewID
                          select tb;

                var dbs2 = from db2 in dbs
                           where db2.Name_Column == column.Name
                           select db2;

                if (dbs2.Count() > 0)
                {
                    dataRow = dbs2.First();
                    Update(column, dataRow);
                }
                else
                {
                    dataRow = Add(viewID, column);
                }
            }
            catch (Exception ex)
            {
                VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 3);
            }
#if TRACE
            VNC.AppLog.Trace5("Exit", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 4, startTicks);
#endif
            return(dataRow);
        }