public List <LeadGenSourceEntities> GetLeadSource()
{
List <LeadGenSourceEntities> sourceDetails = new List <LeadGenSourceEntities>();
SqlDataReader dr = null;
try
{
dr = SqlHelper.ExecuteReader(_sqlConnectionString, CommandType.StoredProcedure, "usp_LG_GetSourceDetails");
if (dr.HasRows)
{
while (dr.Read())
{
LeadGenSourceEntities entities = new LeadGenSourceEntities();
entities.LeadId = Convert.ToInt32(dr["LeadSourceId"]);
entities.Sourcename = Convert.ToString(dr["SourceName"]);
sourceDetails.Add(entities);
}
}
dr.Close();
}
finally
{
if (!dr.IsClosed && dr != null)
{
dr.Close();
}
}
return(sourceDetails);
}
private List <LeadGenSourceEntities> GetLeadGenSourceList()
{
List <LeadGenSourceEntities> _leadGenerationSourceCollection = new List <LeadGenSourceEntities>();
LeadGenSourceEntities leadGenSourceEntities1 = new LeadGenSourceEntities
{
LeadId = 1,
Sourcename = "ATM"
};
_leadGenerationSourceCollection.Add(leadGenSourceEntities1);
LeadGenSourceEntities leadGenSourceEntities2 = new LeadGenSourceEntities
{
LeadId = 2,
Sourcename = "Internet"
};
_leadGenerationSourceCollection.Add(leadGenSourceEntities2);
return(_leadGenerationSourceCollection);
}
