public void CreateClient(ListManagementAffiliate affiliate)
{
try
{
using (var oenConnection = Connect())
{
log.InfoFormat("CreateClient({0})", affiliate.id);
oenConnection.Execute("uspClientCreate_MKT",
commandType: CommandType.StoredProcedure,
param: new
{
companyname = affiliate.company,
address1 = affiliate.address,
city = affiliate.city,
state = affiliate.state,
zip = affiliate.zip_code,
firstname = affiliate.firstname,
lastname = affiliate.lastname,
email = affiliate.email,
deliverythreshold = 500000,
marketaffiliateid = affiliate.id,
marketApiKey = affiliate.api_key
}
);
}
}
catch (Exception err)
{
affiliate.NoCache = true;
log.ErrorFormat("CreateClient failed for affiliate {0}: {1} ", affiliate, err);
}
}
public void DisableAffiliate(ListManagementAffiliate affiliate)
{
try
{
using (var oenConnection = Connect())
{
log.InfoFormat("DisableAffiliate({0})", affiliate);
oenConnection.Execute("uspDisableAffiliate_MKT",
commandType: CommandType.StoredProcedure,
param: new
{
marketAffiliateId = affiliate.id
}
);
}
}
catch (Exception err)
{
affiliate.NoCache = true;
log.ErrorFormat("DisableAffiliate failed for affiliate {0}: {1}", affiliate, err);
}
}
private static void UpdateCache(ListManagementAffiliate affiliate)
{
if (affiliate.NoCache && affiliateDataCache.ContainsKey(affiliate.id))
{
affiliateDataCache.Remove(affiliate.id);
}
if (!affiliate.NoCache)
{
if (affiliateDataCache.ContainsKey(affiliate.id))
{
affiliateDataCache[affiliate.id] = affiliate.Hash;
}
else
{
affiliateDataCache.Add(affiliate.id, affiliate.Hash);
}
}
}
public void UpdateClient(ListManagementAffiliate affiliate)
{
try
{
using (var oenConnection = Connect())
{
log.InfoFormat("UpdateClient({0})", affiliate.id);
oenConnection.Execute("sp_ClientDetailsUpdate_MKT",
commandType: CommandType.StoredProcedure,
param: new
{
marketaffiliateid = affiliate.id,
companyname = affiliate.company,
url = string.Empty,
address1 = affiliate.address,
address2 = string.Empty,
city = affiliate.city,
state = affiliate.state,
zip = affiliate.zip_code,
fax = string.Empty,
phone = string.Empty,
firstname = affiliate.firstname,
lastname = affiliate.lastname,
email = affiliate.email,
deliverythreshold = 500000,
ftpcheck = false,
redirectAOLFormat = false,
marketApiKey = affiliate.api_key
}
);
}
}
catch (Exception err)
{
affiliate.NoCache = true;
log.ErrorFormat("UpdateClient failed for affiliate {0}: {1}", affiliate, err);
}
}
