Exemplos de SQLInformation.Data.ApplicationDataSet.LoginsRow em C# (CSharp)

Exemplo n.º 1

        private static SQLInformation.Data.ApplicationDataSet.LoginsRow Add(Guid instanceID, MSMO.Login login, string instanceName)
        {
            SQLInformation.Data.ApplicationDataSet.LoginsRow dataRow = null;

            try
            {
                dataRow = Common.ApplicationDataSet.Logins.NewLoginsRow();

                dataRow.ID               = Guid.NewGuid();
                dataRow.Name_Login       = login.Name;
                dataRow.Instance_ID      = instanceID;
                dataRow.Name_Instance    = instanceName;
                dataRow.CreateDate       = login.CreateDate;
                dataRow.DateLastModified = login.DateLastModified;
                dataRow.DefaultDatabase  = login.DefaultDatabase;
                dataRow.LoginType        = login.LoginType.ToString();

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

                Common.ApplicationDataSet.Logins.AddLoginsRow(dataRow);
                Common.ApplicationDataSet.LoginsTA.Update(Common.ApplicationDataSet.Logins);
            }
            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

        private static void Update(MSMO.Login login, SQLInformation.Data.ApplicationDataSet.LoginsRow dataRow)
        {
            try
            {
                login.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

        private static SQLInformation.Data.ApplicationDataSet.LoginsRow GetInfoFromSMO(Guid instanceID, MSMO.Login login, string instanceName)
        {
#if TRACE
            long startTicks = VNC.AppLog.Trace4("Enter", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 2);
#endif
            SQLInformation.Data.ApplicationDataSet.LoginsRow dataRow = null;

            try
            {
                var dbs = from tb in Common.ApplicationDataSet.Logins
                          where tb.Instance_ID == instanceID
                          select tb;

                var dbs2 = from db2 in dbs
                           where db2.Name_Login == login.Name
                           select db2;

                if (dbs2.Count() > 0)
                {
                    dataRow = dbs2.First();

                    Update(login, dataRow);
                }
                else
                {
                    dataRow = Add(instanceID, login, instanceName);
                }
            }
            catch (Exception ex)
            {
                VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 3);
            }
#if TRACE
            VNC.AppLog.Trace4("Exit", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 4, startTicks);
#endif
            return(dataRow);
        }