/*******************************************************************************************************/ #region DATABASE METHODS public static DataRow get(Guid?id) { SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.FillByAdapter, "Settings_get", new SqlQueryParameter(COL_DB_Id, SqlDbType.UniqueIdentifier, Util.wrapNullable(id)) ); return(Util.getFirstRow(result.Datatable)); }
public static bool isRegistered() { string hashedMACAddress = Util.hashStringWithoutSalt(Util.getMACAddress()); SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, false, false, false, true, false, "LicensedDevices_isExist_HashedMACAddress", new SqlQueryParameter(COL_DB_HashedMACAddress, SqlDbType.NVarChar, hashedMACAddress) ); isDeviceRegistered = result.ValueBoolean; return(result.ValueBoolean); }
public void execute() { isQueryCompleted = false; if (sqlConnection != null) { result = DBConnection.executeQuery(sqlConnection, querytype, hasReturnValueString, hasReturnValueInt, hasReturnValueDecimal, hasReturnValueBoolean, hasReturnValueGuid, storedprocedurename, tableparameters, parameters); } else { using (SqlConnection sqlConnection = new SqlConnection(DBConnection.ConnectionString)) result = DBConnection.executeQuery(sqlConnection, querytype, hasReturnValueString, hasReturnValueInt, hasReturnValueDecimal, hasReturnValueBoolean, hasReturnValueGuid, storedprocedurename, tableparameters, parameters); } isQueryCompleted = true; }
public static void update(Guid id, int?intValue, string stringValue, bool?boolValue, DateTime?datetimeValue) { if (boolValue != null) { intValue = Util.convertToInt((bool)boolValue); } SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "Settings_update", new SqlQueryParameter(COL_DB_Id, SqlDbType.UniqueIdentifier, id), new SqlQueryParameter(COL_DB_Value_Int, SqlDbType.Int, Util.wrapNullable(intValue)), new SqlQueryParameter(COL_DB_Value_String, SqlDbType.VarChar, Util.wrapNullable(stringValue)), new SqlQueryParameter(COL_DB_Value_DateTime, SqlDbType.DateTime, Util.wrapNullable(datetimeValue)) ); }
public static void addDevice() { string hashedMACAddress = Util.hashStringWithoutSalt(Util.getMACAddress()); Guid Id = Guid.NewGuid(); SqlQueryResult result = DBConnection.query( false, DBConnection.ActiveSqlConnection, QueryTypes.ExecuteNonQuery, "LicensedDevices_add", new SqlQueryParameter(COL_DB_Id, SqlDbType.UniqueIdentifier, Id), new SqlQueryParameter(COL_DB_HashedMACAddress, SqlDbType.NVarChar, hashedMACAddress) ); if (result.IsSuccessful) { isDeviceRegistered = true; Util.displayMessageBoxSuccess("License is valid. Thank you!"); } }
public static SqlQueryResult executeQuery(SqlConnection sqlConnection, QueryTypes querytype, bool hasReturnValueString, bool hasReturnValueInt, bool hasReturnValueDecimal, bool hasReturnValueBoolean, bool hasReturnValueGuid, string storedprocedurename, SqlQueryTableParameter[] tableparameters, params SqlQueryParameter[] parameters) { SqlQueryResult result = new SqlQueryResult(); SqlParameter returnValueString = null; SqlParameter returnValueInt = null; SqlParameter returnValueDecimal = null; SqlParameter returnValueBoolean = null; SqlParameter returnValueGuid = null; try { using (SqlCommand cmd = new SqlCommand(storedprocedurename, sqlConnection)) using (SqlDataAdapter adapter = new SqlDataAdapter()) { cmd.CommandType = CommandType.StoredProcedure; if (parameters != null && parameters.Length > 0) { foreach (SqlQueryParameter parameter in parameters) { cmd.Parameters.Add("@" + parameter.ColumnName, parameter.SqlDbType).Value = parameter.Value; } } if (tableparameters != null && tableparameters.Length > 0) { foreach (SqlQueryTableParameter tableparameter in tableparameters) { Util.addListParameter(cmd, "@" + tableparameter.ColumnName, tableparameter.Values); } } if (hasReturnValueString) { returnValueString = cmd.Parameters.Add("@returnValueString", SqlDbType.NVarChar, 100); returnValueString.Direction = ParameterDirection.Output; } if (hasReturnValueInt) { returnValueInt = cmd.Parameters.Add("@returnValueInt", SqlDbType.Int); returnValueInt.Direction = ParameterDirection.Output; } if (hasReturnValueDecimal) { returnValueDecimal = cmd.Parameters.Add("@returnValueDecimal", SqlDbType.Decimal); returnValueDecimal.Direction = ParameterDirection.Output; } if (hasReturnValueBoolean) { returnValueBoolean = cmd.Parameters.Add("@returnValueBoolean", SqlDbType.Bit); returnValueBoolean.Direction = ParameterDirection.Output; } if (hasReturnValueGuid) { returnValueGuid = cmd.Parameters.Add("@returnValueGuid", SqlDbType.UniqueIdentifier); returnValueGuid.Direction = ParameterDirection.Output; } //open connection if (sqlConnection.State != ConnectionState.Open) { sqlConnection.Open(); } //execute command if (querytype == QueryTypes.ExecuteNonQuery) { cmd.ExecuteNonQuery(); } else if (querytype == QueryTypes.FillByAdapter) { adapter.SelectCommand = cmd; result.Datatable = new DataTable(); adapter.Fill(result.Datatable); } if (hasReturnValueString) { result.ValueString = returnValueString.Value.ToString(); } if (hasReturnValueInt) { result.ValueInt = Convert.ToInt32(returnValueInt.Value); } if (hasReturnValueDecimal) { result.ValueDecimal = Convert.ToDecimal(returnValueDecimal.Value); } if (hasReturnValueBoolean) { result.ValueBoolean = Convert.ToBoolean(returnValueBoolean.Value); } if (hasReturnValueGuid) { if (returnValueGuid.Value != DBNull.Value) { result.ValueGuid = (Guid)returnValueGuid.Value; } } result.IsSuccessful = true; if (!_MultipleSQLConnectionUse) { sqlConnection.Close(); } } } catch (Exception ex) { result.IsSuccessful = false; Util.displayMessageBoxError(ex.Message); } return(result); }