Пример #1
0
        private static void DateUpdateFromOnlineServer()
        {
            //******************Check Internet connection*********************************************************
            if (CheckInternetconnection.CheckForInternetConnection())
            {
                //******************online date and system date same or not check*********************************************************
                DateTime?onlineDate = OnlineServerDateTimeTools.GetOnlineServerDate();
                if (onlineDate != null)
                {
                    if (DateTime.Now.Date == onlineDate.Value.Date)
                    {
                        #region Update datetime from online to offline server
                        //***********************Update datetime from online to offline server**************************************
                        string Activation_Key = "", StartDate = "", EndDate = "", msg = "";
                        string mEncryptStartDate = "", mEncryptEndDate = "", mEncryptCurrentDate = "";
                        if (OnlineActivationTools.IsValidLicenseDate(out Activation_Key))
                        {
                            //*******************GET ONLINE DATABASE <START DATE> AND <END DATE> PERIOD*********************
                            OnlineActivationTools.OutOlnActivationDate(Activation_Key, out StartDate, out EndDate);

                            //*******************ENCRIPT DATE ****************************************************************
                            string CurrentDate = DateTime.Now.ToString();
                            mEncryptStartDate   = CryptorEngine.Encrypt(StartDate, true);
                            mEncryptEndDate     = CryptorEngine.Encrypt(EndDate, true);
                            mEncryptCurrentDate = CryptorEngine.Encrypt(CurrentDate, true);


                            string qry = "update ApplicationInfo set StartDate='" + mEncryptStartDate + "',EndDate='" + mEncryptEndDate + "',CurrentDate='" + mEncryptCurrentDate + "'";
                            if (SQLHelper.GetInstance().ExcuteQuery(qry, out msg))
                            {
                            }
                        }
                        #endregion
                    }
                    else
                    {
                        if (MessageBox.Show("Your system Date and Time is not currect \n you can chang the Date and Time in now ? ", "Invalid Date", MessageBoxButtons.YesNo, MessageBoxIcon.Stop) == DialogResult.Yes)
                        {
                            //*******************Set System Date ****************************************************************
                            onlineDate.SetSystemDate();
                            DesktopNotify("System Date Changing Successfull", ToolTipIcon.Info);
                        }
                        else
                        {
                            DesktopNotify("Please Set Current Date and Time in Your system", ToolTipIcon.Warning);
                            Application.Exit();
                        }
                    }
                }
            }
        }
Пример #2
0
 public static AzureSQLHelper GetInstance()
 {
     if (mInstance == null)
     {
         CONNECTION_STRING = string.Empty;
         CONNECTION_STRING = "Server =tcp:dtl.database.windows.net,1433; Initial Catalog = DC_DAPRO; " +
                             "Persist Security Info = False;" + mUserPass + "MultipleActiveResultSets = False; Encrypt = True; " +
                             "TrustServerCertificate = False; Connection Timeout = 30";
         mInstance = new AzureSQLHelper();
         if (!CheckInternetconnection.CheckForInternetConnection())
         {
             MessageBox.Show("Internet connection not available.", "Please check your internet connection.", MessageBoxButtons.OK, MessageBoxIcon.Warning);
         }
     }
     return(mInstance);
 }