public ResponseModel UpdateCampaignMaxClickTimer([FromBody] StoreCampaignSettingTimer storeCampaignSettingTimer)
{
StoreCampaignCaller storecampaigncaller = new StoreCampaignCaller();
ResponseModel objResponseModel = new ResponseModel();
int UpdateCount = 0;
int statusCode = 0;
string statusMessage = "";
try
{
string token = Convert.ToString(Request.Headers["X-Authorized-Token"]);
Authenticate authenticate = new Authenticate();
authenticate = SecurityService.GetAuthenticateDataFromToken(_radisCacheServerAddress, SecurityService.DecryptStringAES(token));
UpdateCount = storecampaigncaller.UpdateCampaignMaxClickTimer(new StoreCampaignService(_connectioSting), storeCampaignSettingTimer, authenticate.UserMasterID);
statusCode = UpdateCount.Equals(0) ?
(int)EnumMaster.StatusCode.InternalServiceNotWorking : (int)EnumMaster.StatusCode.Success;
statusMessage = CommonFunction.GetEnumDescription((EnumMaster.StatusCode)statusCode);
objResponseModel.Status = true;
objResponseModel.StatusCode = statusCode;
objResponseModel.Message = statusMessage;
objResponseModel.ResponseData = UpdateCount;
}
catch (Exception)
{
throw;
}
return(objResponseModel);
}
/// <summary>
/// Update Campaign Setting
/// </summary>
/// <param name="CampaignModel"></param>
/// <returns></returns>
public int UpdateCampaignMaxClickTimer(StoreCampaignSettingTimer storeCampaignSettingTimer, int ModifiedBy)
{
int UpdateCount = 0;
try
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("SP_HSUpdateCampaignMaxClickTimer", conn);
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@timerID", storeCampaignSettingTimer.ID);
cmd.Parameters.AddWithValue("@_MaxClickAllowed", storeCampaignSettingTimer.MaxClickAllowed);
cmd.Parameters.AddWithValue("@_EnableClickAfterValue", storeCampaignSettingTimer.EnableClickAfterValue);
cmd.Parameters.AddWithValue("@_EnableClickAfterDuration", storeCampaignSettingTimer.EnableClickAfterDuration);
cmd.Parameters.AddWithValue("@_ModifiedBy", ModifiedBy);
cmd.Parameters.AddWithValue("@_SmsFlag", Convert.ToInt16(storeCampaignSettingTimer.SmsFlag));
cmd.Parameters.AddWithValue("@_EmailFlag", Convert.ToInt16(storeCampaignSettingTimer.EmailFlag));
cmd.Parameters.AddWithValue("@_MessengerFlag", Convert.ToInt16(storeCampaignSettingTimer.MessengerFlag));
cmd.Parameters.AddWithValue("@_BotFlag", Convert.ToInt16(storeCampaignSettingTimer.BotFlag));
cmd.Parameters.AddWithValue("@_ProviderName", Convert.ToString(storeCampaignSettingTimer.ProviderName));
cmd.CommandType = CommandType.StoredProcedure;
UpdateCount = Convert.ToInt32(cmd.ExecuteNonQuery());
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(UpdateCount);
}
public int UpdateCampaignMaxClickTimer(IStoreCampaign Campaign, StoreCampaignSettingTimer storeCampaignSettingTimer, int ModifiedBy)
{
_CampaignRepository = Campaign;
return(_CampaignRepository.UpdateCampaignMaxClickTimer(storeCampaignSettingTimer, ModifiedBy));
}
/// <summary>
/// Get Campaign Setting List
/// </summary>
/// <returns></returns>
public StoreCampaignModel3 GetStoreCampignSetting(int TenantId, int UserId, string ProgramCode)
{
DataSet ds = new DataSet();
List <StoreCampaignSettingModel> lstCampaignSetting = new List <StoreCampaignSettingModel>();
StoreCampaignSettingTimer CampaignSettingTimer = new StoreCampaignSettingTimer();
StoreCampaignModel3 campaignObj = new StoreCampaignModel3();
try
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("SP_HSGetCampaignSettingList", conn)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@_tenantID", TenantId);
cmd.Parameters.AddWithValue("@UserID", UserId);
cmd.Parameters.AddWithValue("@_prgramCode", ProgramCode);
MySqlDataAdapter da = new MySqlDataAdapter
{
SelectCommand = cmd
};
da.Fill(ds);
//if (ds != null && ds.Tables[0] != null)
//{
//for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
//{
// StoreCampaignSettingModel storecampaign = new StoreCampaignSettingModel()
// {
// ID = Convert.ToInt32(ds.Tables[0].Rows[i]["ID"]),
// CampaignName = ds.Tables[0].Rows[i]["CampaignName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["CampaignName"]),
// CampaignCode = ds.Tables[0].Rows[i]["CampaignCode"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["CampaignCode"]),
// Programcode = ds.Tables[0].Rows[i]["Programcode"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["Programcode"]),
// SmsFlag = ds.Tables[0].Rows[i]["SmsFlag"] == DBNull.Value ? false : Convert.ToBoolean(ds.Tables[0].Rows[i]["SmsFlag"]),
// EmailFlag = ds.Tables[0].Rows[i]["EmailFlag"] == DBNull.Value ? false : Convert.ToBoolean(ds.Tables[0].Rows[i]["EmailFlag"]),
// MessengerFlag = ds.Tables[0].Rows[i]["MessengerFlag"] == DBNull.Value ? false : Convert.ToBoolean(ds.Tables[0].Rows[i]["MessengerFlag"]),
// BotFlag = ds.Tables[0].Rows[i]["BotFlag"] == DBNull.Value ? false : Convert.ToBoolean(ds.Tables[0].Rows[i]["BotFlag"]),
// };
// lstCampaignSetting.Add(storecampaign);
//}
//campaignObj.CampaignSetting = lstCampaignSetting;
// }
if (ds != null && ds.Tables[0] != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
CampaignSettingTimer.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"]);
CampaignSettingTimer.MaxClickAllowed = ds.Tables[0].Rows[0]["MaxClickAllowed"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[0]["MaxClickAllowed"]);
CampaignSettingTimer.EnableClickAfterValue = ds.Tables[0].Rows[0]["EnableClickAfterValue"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[0]["EnableClickAfterValue"]);
CampaignSettingTimer.EnableClickAfterDuration = ds.Tables[0].Rows[0]["EnableClickAfterDuration"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[0]["EnableClickAfterDuration"]);
CampaignSettingTimer.Programcode = ds.Tables[0].Rows[0]["Programcode"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[0]["Programcode"]);
CampaignSettingTimer.SmsFlag = ds.Tables[0].Rows[0]["SmsFlag"] == DBNull.Value ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["SmsFlag"]);
CampaignSettingTimer.EmailFlag = ds.Tables[0].Rows[0]["EmailFlag"] == DBNull.Value ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["EmailFlag"]);
CampaignSettingTimer.MessengerFlag = ds.Tables[0].Rows[0]["MessengerFlag"] == DBNull.Value ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["MessengerFlag"]);
CampaignSettingTimer.BotFlag = ds.Tables[0].Rows[0]["BotFlag"] == DBNull.Value ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["BotFlag"]);
CampaignSettingTimer.ProviderName = ds.Tables[0].Rows[0]["ProviderName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[0]["ProviderName"]);
}
campaignObj.CampaignSettingTimer = CampaignSettingTimer;
}
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
if (ds != null)
{
ds.Dispose();
}
}
return(campaignObj);
}
