Example #1
0
        private static SQLInformation.Data.ApplicationDataSet.JSJobCategoriesRow Add(MSMOA.JobCategory jobCategory, SQLInformation.Data.ApplicationDataSet.JobServersRow jobServerRow)
        {
            SQLInformation.Data.ApplicationDataSet.JSJobCategoriesRow dataRow = null;

            try
            {
                dataRow    = Common.ApplicationDataSet.JSJobCategories.NewJSJobCategoriesRow();
                dataRow.ID = Guid.NewGuid();

                dataRow.Name_JSJobCategory = jobCategory.Name;
                dataRow.JobServer_ID       = jobServerRow.ID;

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

                Common.ApplicationDataSet.JSJobCategories.AddJSJobCategoriesRow(dataRow);
                Common.ApplicationDataSet.JSJobCategoriesTA.Update(Common.ApplicationDataSet.JSJobCategories);
            }
            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);
        }
Example #2
0
 public static void UpdateDataSet(this MSMOA.JobCategory jobCategory, Data.ApplicationDataSet.JSJobCategoriesRow dataRow)
 {
     try
     {
         //dataRow.X = jobCategory.X;
     }
     catch (Exception ex)
     {
         VNC.AppLog.Error(ex, LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 7);
         // TODO(crhodes):
         // Wrap anything above that throws an exception that we want to ignore,
         // e.g. property not available because of SQL Edition.
     }
 }
Example #3
0
        private static void Update(MSMOA.JobCategory jobCategory, SQLInformation.Data.ApplicationDataSet.JSJobCategoriesRow dataRow)
        {
            try
            {
                jobCategory.UpdateDataSet(dataRow);

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

                UpdateDatabaseWithSnapShot(dataRow, ex.ToString().Substring(0, 256));
            }
        }
Example #4
0
        private static SQLInformation.Data.ApplicationDataSet.JSJobCategoriesRow GetInfoFromSMO(MSMOA.JobCategory jobCategory, SQLInformation.Data.ApplicationDataSet.JobServersRow jobServerRow)
        {
#if TRACE
            long startTicks = VNC.AppLog.Trace4(string.Format("Enter ({0})", jobCategory.Name), LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 2);
#endif

            SQLInformation.Data.ApplicationDataSet.JSJobCategoriesRow dataRow = null;

            try
            {
                var dbs = from db in Common.ApplicationDataSet.JSJobCategories
                          where db.JobServer_ID == jobServerRow.ID
                          select db;

                var dbs2 = from db2 in dbs
                           where db2.Name_JSJobCategory == jobCategory.Name
                           select db2;

                if (dbs2.Count() > 0)
                {
                    dataRow = dbs2.First();
                    Update(jobCategory, dataRow);
                }
                else
                {
                    dataRow = Add(jobCategory, jobServerRow);
                }
            }
            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);
        }