//*************************************************************************
//Name:SrverSecurityToolsInsert;
//Description:create application info table and insert online server datetime in local sql server
//************************************************************************
private void SrverSecurityToolsInsert()
{
List <string> lstQuery = new List <string>();
string mEncryptStartDate = "", mEncryptEndDate = "", mEncryptCurrentDate = "";
if (rbtnServer.Checked)
{
string query = "IF EXISTS(SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ApplicationInfo]') AND type in (N'U')) " +
"DROP TABLE[dbo].[ApplicationInfo] " +
"SET ANSI_NULLS ON " +
"SET QUOTED_IDENTIFIER ON " +
"SET ANSI_PADDING ON " +
"CREATE TABLE[dbo].[ApplicationInfo]( " +
"[Id][int] IDENTITY(1, 1) NOT NULL, " +
" [ApplicationId] [varchar](200) NULL, " +
"[StartDate] [varchar](200) NOT NULL, [EndDate] [varchar](200) " +
" NOT NULL, [ApplicationKey] [varchar](200) NULL, " +
"[CurrentDate] [varchar](200) NULL,[STATUS] [varchar](50) NULL ) ON[PRIMARY] " +
"SET ANSI_PADDING OFF";
lstQuery.Add(query);
string CurrentDate = DateTime.Now.ToString();
string StartDate = "";
string EndDate = "";
//*******************IF VALID KEY THEN DATE TIME INSERT ONLIE SERVER TO OFFLINE SERVER*********************
if (mKey.Length == 19)
{
//*******************GET ONLINE DATABASE <START DATE> AND <END DATE> PERIOD*********************
OnlineActivationTools.OutOlnActivationDate(mKey, out StartDate, out EndDate);
}
else
{
//*******************TRAIL PERIOD*********************
StartDate = CurrentDate;
EndDate = ((DateTime.Now).AddDays(7d)).ToString();
}
//*******************ENCRIPT DATE *********************
mEncryptStartDate = CryptorEngine.Encrypt(StartDate, true);
mEncryptEndDate = CryptorEngine.Encrypt(EndDate, true);
mEncryptCurrentDate = CryptorEngine.Encrypt(CurrentDate, true);
query = "Insert into ApplicationInfo(ApplicationId,StartDate,EndDate,ApplicationKey,CurrentDate,STATUS) values('" + mApplicationGuid + "','" + mEncryptStartDate + "','" + mEncryptEndDate + "','','" + mEncryptCurrentDate + "','')";
lstQuery.Add(query);
if (SQLHelper.GetInstance().ExecuteTransection(lstQuery, out msg))
{
isConnectionSuccess = true;
DesktopNotify("Database Connected.", ToolTipIcon.Info);
}
else
{
isConnectionSuccess = false;
//********Desktop notification*********
DesktopNotify("Database connection failed.", ToolTipIcon.Error);
//this.Close();
}
}
}
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();
}
}
}
}
}
