public void Update(int advertismentId, IAdvertisment advertisment)
{
Console.WriteLine("[" + this.GetType().ToString() + "]" + " Updating advertisment");
if (storage.ContainsKey(advertismentId))
{
storage[advertismentId] = advertisment;
}
}
public int Save(IAdvertisment advertisment)
{
Console.WriteLine("[" + this.GetType().ToString() + "]" + " Saving advertiment");
int newId = ++id;
storage.Add(newId, advertisment);
return(newId);
}
public void FilterAdvertisment(IAdvertisment advertisment)
{
Console.WriteLine("[" + this.GetType().ToString() + "]" + " Filtering advertisment from swear words");
string messageToEdit = advertisment.Message;
foreach (string badWord in s_badWords)
{
messageToEdit.Replace(badWord, "");
}
advertisment.Message = messageToEdit;
}
public void Update(ref DBHelper dbInstance, IAdvertisment Advertisment)
{
try
{
AdvertismentDB.Instance.Update(ref dbInstance, Advertisment);
}
catch (Exception objExp)
{
throw objExp;
}
finally
{
}
}
public int CancelAdvertisment(int advertismentId)
{
Console.WriteLine("[" + this.GetType().ToString() + "]" + " Looking for Ad");
IAdvertisment toDelete = advertisments.Find(advertismentId);
if (null == toDelete)
{
return(-1);
}
Console.WriteLine("[" + this.GetType().ToString() + "]" + " Ad found");
Console.WriteLine("[" + this.GetType().ToString() + "]" + " Deleting Ad");
advertisments.Delete(advertismentId);
return(advertismentId);
}
public int AddAdvertisment(int campaignId, string message)
{
Console.WriteLine("[" + this.GetType().ToString() + "]" + " Looking for campaign");
ICampaign campaign = campaigns.Find(campaignId);
if (null == campaign)
{
return(-1);
}
Console.WriteLine("[" + this.GetType().ToString() + "]" + " Creating Ad");
IAdvertisment advertisment = marketingFactory.CreateAdvertisment(message);
advertisment.ApplyNewCampaign(campaign);
Console.WriteLine("[" + this.GetType().ToString() + "]" + " Saving Ad");
int advertismentId = advertisments.Save(advertisment);
return(0);
}
public void Insert(ref DBHelper dbInstance, IAdvertisment objAdvertisment)
{
try
{
dbInstance.AddInParameter("@DisplayOrder", objAdvertisment.DisplayOrder, DbType.Int32);
dbInstance.AddInParameter("@Heading", objAdvertisment.Heading, DbType.String);
dbInstance.AddInParameter("@WebUrl", objAdvertisment.WebUrl, DbType.String);
dbInstance.AddInParameter("@WebLink", objAdvertisment.WebLink, DbType.String);
dbInstance.AddInParameter("@ShortDesc", objAdvertisment.ShortDesc, DbType.String);
dbInstance.AddInParameter("@ImgUrl", objAdvertisment.ImgUrl, DbType.String);
dbInstance.AddInParameter("@AdvertismentType", objAdvertisment.AdvertismentType, DbType.Int32);
dbInstance.AddInParameter("@Position", objAdvertisment.Position, DbType.Int32);
dbInstance.ExecuteNonQuery(ProcedureName.InsertAdvertisment, CommandType.StoredProcedure);
}
catch (Exception objExp)
{
throw objExp;
}
}
public void Insert(ref DBHelper dbInstance, IAdvertisment objAdvertisment)
{
try
{
dbInstance.AddInParameter("@DisplayOrder", objAdvertisment.DisplayOrder, DbType.Int32);
dbInstance.AddInParameter("@Heading", objAdvertisment.Heading, DbType.String);
dbInstance.AddInParameter("@WebUrl", objAdvertisment.WebUrl, DbType.String);
dbInstance.AddInParameter("@WebLink", objAdvertisment.WebLink, DbType.String);
dbInstance.AddInParameter("@ShortDesc", objAdvertisment.ShortDesc, DbType.String);
dbInstance.AddInParameter("@ImgUrl", objAdvertisment.ImgUrl, DbType.String);
dbInstance.AddInParameter("@AdvertismentType", objAdvertisment.AdvertismentType, DbType.Int32);
dbInstance.AddInParameter("@Position", objAdvertisment.Position, DbType.Int32);
dbInstance.ExecuteNonQuery(ProcedureName.InsertAdvertisment, CommandType.StoredProcedure);
}
catch (Exception objExp)
{
throw objExp;
}
}
public void FilterAdvertisment(IAdvertisment advertisment)
{
Console.WriteLine("[" + this.GetType().ToString() + "]" + " Filtering advertisment from other brands mentioning");
}
public List <IAdvertisment> SelectAll(System.Int32 AdvertismentType, System.Int32 IsActive = -1, System.Int32 IsApproved = -1)
{
IDataReader objDataReader = null;
List <IAdvertisment> objAdvertismentList = null;
IAdvertisment objAdvertisment = null;
DBHelper dbInstance = DBHelper.Instance;
try
{
dbInstance.AddInParameter("@AddType", AdvertismentType, DbType.Int32);
dbInstance.AddInParameter("@IsActive", IsActive, DbType.Int32);
dbInstance.AddInParameter("@IsApproved", IsApproved, DbType.Int32);
objDataReader = dbInstance.ExecuteDataReader(ProcedureName.SelectAllAdvertisment, CommandType.StoredProcedure);
if (objDataReader != null)
{
objAdvertismentList = new List <IAdvertisment>();
do
{
while (objDataReader.Read())
{
objAdvertisment = new Advertisment();
if (!objDataReader.IsDBNull(0))
{
objAdvertisment.AdvertismentID = objDataReader.GetString(0);
}
if (!objDataReader.IsDBNull(1))
{
objAdvertisment.DisplayOrder = objDataReader.GetInt32(1);
}
if (!objDataReader.IsDBNull(2))
{
objAdvertisment.Heading = objDataReader.GetString(2);
}
if (!objDataReader.IsDBNull(3))
{
objAdvertisment.WebUrl = objDataReader.GetString(3);
}
if (!objDataReader.IsDBNull(4))
{
objAdvertisment.WebLink = objDataReader.GetString(4);
}
if (!objDataReader.IsDBNull(5))
{
objAdvertisment.ShortDesc = objDataReader.GetString(5);
}
if (!objDataReader.IsDBNull(6))
{
objAdvertisment.ImgUrl = objDataReader.GetString(6);
}
if (!objDataReader.IsDBNull(7))
{
objAdvertisment.AdvertismentType = objDataReader.GetInt32(7);
}
if (!objDataReader.IsDBNull(8))
{
objAdvertisment.Position = objDataReader.GetInt32(8);
}
if (!objDataReader.IsDBNull(9))
{
objAdvertisment.IsApproved = objDataReader.GetInt32(9);
}
if (!objDataReader.IsDBNull(10))
{
objAdvertisment.IsActive = objDataReader.GetInt32(10);
}
if (!objDataReader.IsDBNull(11))
{
objAdvertisment.DttmCreated = objDataReader.GetDateTime(11);
}
if (!objDataReader.IsDBNull(12))
{
objAdvertisment.DttmModified = objDataReader.GetDateTime(12);
}
objAdvertismentList.Add(objAdvertisment);
}
}while (objDataReader.NextResult());
}
if (!objDataReader.IsClosed)
{
objDataReader.Close();
}
}
catch (Exception objExp)
{
throw objExp;
}
finally
{
dbInstance.ClearAllParameters();
dbInstance.CloseConnection();
dbInstance.Dispose();
}
return(objAdvertismentList);
}
public IAdvertisment Select(string AdvertismentId)
{
IAdvertisment result = AdvertismentDB.Instance.Select(AdvertismentId);
return(result);
}
public void Update(int advertismentId, IAdvertisment advertisment)
{
return;
}
public int Save(IAdvertisment advertisment)
{
instance = advertisment;
return(1);
}
public Advertisment(IAdvertisment advertisment)
{
_advertisment = advertisment;
}
public void Update( ref DBHelper dbInstance, IAdvertisment Advertisment)
{
try
{
AdvertismentDB.Instance.Update(ref dbInstance, Advertisment);
}
catch (Exception objExp)
{
throw objExp;
}
finally
{
}
}
