public cCampaignList consultaCampanias()
{
cCampaignList campania = new cCampaignList();
campania.lstCampaingList = new List <cCampaignList.CampaignList>();
try
{
using (DbContextJulio db = new DbContextJulio())
{
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters = null;
DataSet dsConsulta = db.GetDataSet("[dbo].[usp_Consulta_Campaign]", CommandType.StoredProcedure, parameters);
foreach (DataRow item in dsConsulta.Tables[0].Rows)
{
campania.lstCampaingList.Add(new cCampaignList.CampaignList
{
id = item["id"].ToString(),
campaign_id = item["campaign_id"].ToString(),
clave = item["clave"].ToString(),
descripcion = item["descripcion"].ToString(),
descripcion_larga = item["descripcion_larga"].ToString()
});
}
}
}
catch (Exception ex)
{
}
return(campania);
}
public string ConsultaCampaniasLlamadas()
{
cCampaignList campania = new cCampaignList();
Campania campaign = new Campania();
campania = campaign.consultaCampanias();
return(JsonConvert.SerializeObject(campania.lstCampaingList));
}
