private bool CheckandInjectCode(clsVariableSettings cvs) { bool result = false; try { string SQLSelectSystemInfo = "select Count(*) from tbl_system_info where isEnabled = 1 and ProgramCode='" + cv.Crypt(programname) + "' and LicenseCode = '" + cvs.LicenseCode + "' and ActivationCode = '" + cvs.ActivationCode + "'"; cdt = new clsDatabaseTransactions(); DataTable dtResult = cdt.SelectData(SQLSelectSystemInfo); int RowAffected = dtResult.Rows.Count; RowAffected = RowAffected == 1 ? int.Parse(dtResult.Rows[0][0].ToString()) : 0; if (RowAffected == 0) { string SQLInsertSystemInfo = "Insert into tbl_system_info(ProgramCode,LicenseCode,ActivationCode)" + " Values ('" + cv.Crypt(programname) + "','" + cvs.LicenseCode + "','" + cvs.ActivationCode + "')"; result = cdt.InsertData(SQLInsertSystemInfo); } else { result = true; } } catch { } return(result); }
private void GetDBSettings() { tmrLoading.Stop(); try { cvs = new clsVariableSettings(); cvs = cv.ValidateIni(); if (cvs != null) { Servername = cvs.ServerName; Databasename = cvs.DatabaseName; DBUsername = cvs.UserName; DBPassword = cvs.Password; SystemName = cvs.SystemCode; } } catch { } tmrLoading.Start(); }
private void LoadINI() { try { cvs = new clsVariableSettings(); cvs = cv.ValidateIni(); if (cvs != null) { tbCompanyName.Text = cvs.CompanyName; tbLicense.Text = cvs.LicenseCode; tbActivation.Text = cvs.ActivationCode; tbServerName.Text = cvs.ServerName; tbDatabasename.Text = cvs.DatabaseName; tbDBUsername.Text = cvs.UserName; tbDBPassword.Text = cvs.Password; } } catch { } }