/// <summary> /// Gets the mail chimp campaigns. /// </summary> /// <param name="branchId">The branch id.</param> /// <returns></returns> public List <Table.MailChimpCampaign> GetMailChimpCampaigns(string branchId) { var mailChimpCampaigns = new List <Table.MailChimpCampaign>(); string SQLString = string.Format(@"SELECT [CID] ,[Name] ,[BranchId] FROM dbo.MailChimpCampaigns WHERE BranchId={0}", branchId); SqlDataReader dataReader = null; try { dataReader = DbHelperSQL.ExecuteReader(SQLString); Table.MailChimpCampaign chimpCampaign = null; while (dataReader.Read()) { chimpCampaign = new Table.MailChimpCampaign(); chimpCampaign.CId = dataReader.IsDBNull(0) ? string.Empty : dataReader.GetString(0); chimpCampaign.Name = dataReader.IsDBNull(1) ? string.Empty : dataReader.GetString(1); chimpCampaign.BranchId = dataReader.IsDBNull(2) ? 0 : dataReader.GetInt32(2); mailChimpCampaigns.Add(chimpCampaign); } } finally { if (dataReader != null) { dataReader.Close(); dataReader.Dispose(); } } return(mailChimpCampaigns); }
public void AddMailChimpCampaigns(Table.MailChimpCampaign mailChimpCampaign) { string err = ""; bool logErr = false; string sqlCmd = string.Format(@"INSERT INTO [dbo].[MailChimpCampaigns] ([CID] ,[Name] ,[BranchId]) VALUES (@CID ,@Name ,@Branchid)"); SqlParameter[] parameters = { new SqlParameter("@CID", SqlDbType.NVarChar, 255), new SqlParameter("@Name", SqlDbType.NVarChar, 255), new SqlParameter("@BranchId", SqlDbType.Int) }; parameters[0].Value = mailChimpCampaign.CId; parameters[1].Value = mailChimpCampaign.Name; parameters[2].Value = mailChimpCampaign.BranchId; try { DbHelperSQL.ExecuteSql(sqlCmd, parameters); } catch (Exception ex) { //err = "AddMailChimpCampaigns, Exception: " + ex.Message; //int Event_id = 2017; //EventLog.WriteEntry(InfoHubEventLog.LogSource, err, EventLogEntryType.Warning, Event_id, Category); } finally { if (logErr) { //Trace.TraceError(err); //int Event_id = 2017; //EventLog.WriteEntry(InfoHubEventLog.LogSource, err, EventLogEntryType.Warning, Event_id, Category); } } }