private OrganisationKey OnPopulateResultListCallBack(DbDataReader dataReader) { OrganisationKey organisationKey = new OrganisationKey(); PopulateOrganisationKey(organisationKey, dataReader); return(organisationKey); }
public void DeleteOrganisationKey(OrganisationKey organisationKey) { try { SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter(OrganisationKeyParameter.ID, GetDBValue(organisationKey.Id)) }; string sqlQuery = string.Format("DELETE FROM {0} WHERE {1} = {2}", TableName, OrganisationKeyColumn.ID, OrganisationKeyParameter.ID); using (MssqlDbEngine mssqlDbEngine = GetMssqlDbEngine(sqlQuery, sqlParameters, connectionString)) { mssqlDbEngine.ExecuteQuery(); } } catch (Exception exception) { string eMessage = string.Format("Error encountered when executing {0} function in OrganisationKeyRepositoryMsSql. Error\n{1}", "Delete-OrganisationKey", exception.Message); WriteErrorLog(eMessage); throw; } }
private Tuple <string, SqlParameter[]> GetUpdateOrganisationKeyQuery(OrganisationKey organisationKey) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter(OrganisationKeyParameter.ID, GetDBValue(organisationKey.Id)), new SqlParameter(OrganisationKeyParameter.NAME, GetDBValue(organisationKey.Name)), new SqlParameter(OrganisationKeyParameter.OKEY, GetDBValue(organisationKey.OKey)), }; string updateTable = string.Format("UPDATE {0} SET", TableName); string setName = string.Format("{0} = {1}", OrganisationKeyColumn.NAME, OrganisationKeyParameter.NAME); string setOKey = string.Format("{0} = {1}", OrganisationKeyColumn.OKEY, OrganisationKeyParameter.OKEY); string whereId = string.Format("WHERE {0} = {1}", OrganisationKeyColumn.ID, OrganisationKeyParameter.ID); string query = string.Format("{0} {1}, {2} {3}", updateTable, setName, setOKey, whereId); return(Tuple.Create(query, parameters)); }
public void UpdateOrganisationKey(OrganisationKey organisationKey) { try { Tuple <string, SqlParameter[]> query = GetUpdateOrganisationKeyQuery(organisationKey); using (MssqlDbEngine dbEngine = GetMssqlDbEngine(query.Item1, query.Item2, connectionString)) { dbEngine.ExecuteQuery(); } } catch (Exception exception) { string message = string.Format("Error encountered when executing {0} function in OrganisationKeyRepositoryMsSql. Error\n{1}", "Update-OrganisationKey", exception.ToString()); WriteErrorLog(message); throw; } }
private Tuple <string, SqlParameter[]> InsertOrganisationQuery(OrganisationKey organisationKey) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter(OrganisationKeyParameter.NAME, GetDBValue(organisationKey.Name)), new SqlParameter(OrganisationKeyParameter.OKEY, GetDBValue(organisationKey.OKey)), }; string insert = string.Format("INSERT INTO {0}({1}, {2})", TableName, OrganisationKeyColumn.NAME, OrganisationKeyColumn.OKEY); string values = string.Format("VALUES ({0}, {1})", OrganisationKeyParameter.NAME, OrganisationKeyParameter.OKEY); string stringquery = string.Format("{0} {1}", insert, values); return(Tuple.Create(stringquery, parameters)); }
private void CheckKeyIsValid(string organisationName, string encrytedRequestOKey) { IOrganisationKeyRepository organisationKeyRepo = OrganisationKeyRepoFactory.GetOrganisationKeyRepository(DatabaseOption.DatabaseEngine, DatabaseOption.DbConnectionString); OrganisationKey organisationKey = organisationKeyRepo.GetOrganisationKeyMatchingName(organisationName); if (organisationKey == null) { throw new ApplicationException("Could not find key matching rquested key name."); } //string requestOKey = SymmetricEncryption.Decrypt(encrytedRequestOKey); //string dbOKey = SymmetricEncryption.Decrypt(organisationKey.OKey); string requestOKey = encrytedRequestOKey; string dbOKey = organisationKey.OKey; if (requestOKey != dbOKey) { throw new ApplicationException("The request OKey does not match OKey from the database."); } }
private void PopulateOrganisationKey(OrganisationKey organisationKey, DbDataReader dataReader) { string idColumn = dataReader[OrganisationKeyColumn.ID] != null ? dataReader[OrganisationKeyColumn.ID].ToString() : string.Empty; long id; if (!string.IsNullOrEmpty(idColumn) && long.TryParse(idColumn, out id)) { organisationKey.Id = id; } if (dataReader[OrganisationKeyColumn.NAME] != null) { organisationKey.Name = dataReader[OrganisationKeyColumn.NAME].ToString(); } if (dataReader[OrganisationKeyColumn.OKEY] != null) { organisationKey.OKey = dataReader[OrganisationKeyColumn.OKEY].ToString(); } }
private void OnPopulateIdCallBack(OrganisationKey organisationKey, object result) { long id = Convert.ToInt64(result); organisationKey.Id = id; }