public List <CSBAdWord> GetAdWords() { List <CSBAdWord> adWords = new List <CSBAdWord>(); SqlConnection sqlConnection = new SqlConnection(); System.Data.SqlClient.SqlDataReader sqlDataReader = null; try { sqlConnection.Command.CommandText = "SELECT hitbl_FilterAdWords_FAW.*, hitbl_FilterAdCampaigns_FAC.FAC_Company FROM hitbl_FilterAdWords_FAW JOIN hitbl_FilterAdCampaigns_FAC ON hitbl_FilterAdWords_FAW.FAW_CampaignId = hitbl_FilterAdCampaigns_FAC.FAC_ID ORDER BY FAW_Word"; sqlDataReader = sqlConnection.Command.ExecuteReader(); while (sqlDataReader.Read()) { CSBAdWord adWord = new CSBAdWord(); adWord.AdWordId = (Guid)sqlDataReader["FAW_ID"]; adWord.Word = (string)sqlDataReader["FAW_Word"]; adWord.IsExact = (bool)sqlDataReader["FAW_IsExactMatch"]; adWord.Action = (AdWordFilterActions)Enum.Parse(typeof(AdWordFilterActions), sqlDataReader["FAW_Action"].ToString()); adWord.CampaignId = (Guid)sqlDataReader["FAW_CampaignId"]; adWord.CampaignDescription = (string)sqlDataReader["FAC_Company"]; adWords.Add(adWord); } } catch (Exception e) { throw new SoapException("Anfrage konnte nicht bearbeitet werden -> " + e.Message, SoapException.ServerFaultCode); } finally { try { sqlDataReader.Close(); } finally { sqlConnection.Close(); } } return(adWords); }
public bool SaveAdWord(CSBAdWord adWord) { SqlConnection sqlConnection = new SqlConnection(); try { sqlConnection.Command.CommandText = "hisp_Filter_AdWords_Save"; sqlConnection.Command.CommandType = CommandType.StoredProcedure; sqlConnection.Command.Parameters.Add("@WordId", SqlDbType.UniqueIdentifier); sqlConnection.Command.Parameters["@WordId"].Value = adWord.AdWordId; sqlConnection.Command.Parameters.Add("@Word", SqlDbType.NVarChar); sqlConnection.Command.Parameters["@Word"].Value = adWord.Word; sqlConnection.Command.Parameters.Add("@IsExact", SqlDbType.Bit); sqlConnection.Command.Parameters["@IsExact"].Value = adWord.IsExact; sqlConnection.Command.Parameters.Add("@Action", SqlDbType.NVarChar); sqlConnection.Command.Parameters["@Action"].Value = adWord.Action.ToString(); sqlConnection.Command.Parameters.Add("@CampaignId", SqlDbType.UniqueIdentifier); sqlConnection.Command.Parameters["@CampaignId"].Value = adWord.CampaignId; sqlConnection.Command.ExecuteNonQuery(); return(true); } catch { return(false); } finally { sqlConnection.Close(); } }
public bool SaveAdWord(CSBAdWord adWord) { if (authHeader != null) { return(adCampaigns.SaveAdWord(adWord)); } else { throw new Exception("No authentication header found!"); } }