//protected override void UpdateStatusValuesInDB(int accountId, int channelId, string campaignName, int status, int campaignID)
//{
// using (DataManager.Current.OpenConnection())
// {
// COMMENT HADASG
// MY BEST COMMENT
// try
// {
// //SqlCommand SPCmd = DataManager.CreateCommand(@"GkManager_SetCampaignStatus
// SqlCommand SPCmd = DataManager.CreateCommand(@"GkManager_SetCampaignStatus(@Account_ID:Int,@Channel_ID:Int,@campaign:NVarChar,@campaignStatus:Int,@campaignid:Int)",
// CommandType.StoredProcedure);
// SPCmd.CommandTimeout = 120;
// SPCmd.Parameters["@Account_ID"].Value = accountId;
// SPCmd.Parameters["@Channel_ID"].Value = channelId;
// SPCmd.Parameters["@campaign"].Value = campaignName;
// SPCmd.Parameters["@campaignStatus"].Value = status;
// SPCmd.Parameters["@campaignid"].Value = campaignID;
// object result = SPCmd.ExecuteScalar();
// try
// {
// if (result != null)
// {
// int _campaignID = Convert.ToInt32(result);
// Console.WriteLine("campaignID: " + campaignID + " , campaignName: " + campaignName);
// }
// }
// catch (Exception e)
// {
// Console.WriteLine("failed to upadte in db: campaign id=" + campaignID + " , campaignName: " + campaignName);
// }
// }
// catch (Exception ex)
// {
// Log.Write("Failed to write keepalive time to DB.", ex);
// }
// }
//}
protected override bool InitObject()
{
try
{
_updateStatusSqlCommand = @"GkManager_SetCampaignStatus(@Account_ID:Int,@Channel_ID:Int,@campaign:NVarChar,@campaignStatus:Int,@campaignid:Int)";
_sp_SelecConsts = @"Select * from Constant_CampaignStatus";
selector = new CampaignWebService.CampaignSelector();
selector.campaignStatuses = new Easynet.Edge.Services.StatusManager.CampaignWebService.CampaignStatus[3];
selector.campaignStatuses[0] = Easynet.Edge.Services.StatusManager.CampaignWebService.CampaignStatus.ACTIVE;
selector.campaignStatuses[1] = Easynet.Edge.Services.StatusManager.CampaignWebService.CampaignStatus.PAUSED;
selector.campaignStatuses[2] = Easynet.Edge.Services.StatusManager.CampaignWebService.CampaignStatus.DELETED;
InitalizeServiceData();
CampaignService = new CampaignWebService.CampaignServiceInterfaceClient();
page = new CampaignWebService.CampaignPage();
header = new CampaignWebService.MySoapHeader();
status = new CampaignWebService.CampaignStatus();
return(true);
}
catch (Exception ex)
{
Core.Utilities.Log.Write("error in InitObject(): " + ex.Message, Core.Utilities.LogMessageType.Error);
return(false);
}
}
protected override bool RunOnResults()
{
try
{
foreach (var item in page.entries)
{
status = item.status;
campaignID = Convert.ToInt32(item.id);
campaignName = item.name;
commandType = CommandType.StoredProcedure;
BuildSqlParamsDictionray();
UpdateStatusValuesInDB();
}
return(true);
}
catch (Exception ex)
{
Core.Utilities.Log.Write("error in RunOnResults(): " + ex.Message, Core.Utilities.LogMessageType.Error);
return(false);
}
}
