/// <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);
}
}
}
