public List <CPPeopleTalks> getPeopleTalks(int cPId)
{
SqlCommand dinsert = new SqlCommand("usp_GetPeopleTalksForStoreFront");
dinsert.Parameters.AddWithValue("@CPId", SqlDbType.Int).Value = cPId;
DataSet dtList = objcon.GetDsByCommand(dinsert);
List <CPPeopleTalks> list1 = new List <CPPeopleTalks>();
foreach (DataRow dr in dtList.Tables[0].Rows)
{
CPPeopleTalks pd = new CPPeopleTalks();
pd.PeopleImage = dr["PeopleImage"].ToString();
pd.PeoplesTalk = dr["PeoplesTalk"].ToString();
pd.CustName = dr["CustName"].ToString();
list1.Add(pd);
}
return(list1);
}
public List <CPPeopleTalks> getCPPeopleTalks(string custName)
{
SqlCommand dinsert = new SqlCommand("usp_GetCPPeopleTalks");
if (!string.IsNullOrWhiteSpace(custName))
{
dinsert.Parameters.AddWithValue("@CPName", SqlDbType.VarChar).Value = custName;
}
DataSet dtList = objcon.GetDsByCommand(dinsert);
List <CPPeopleTalks> list = new List <CPPeopleTalks>();
foreach (DataRow dr in dtList.Tables[0].Rows)
{
CPPeopleTalks list1 = new CPPeopleTalks();
list1.CustName = Convert.ToString(dr["CustName"]);
list1.PeopleTalksId = Convert.ToInt32(dr["PeopleTalksId"]);
list1.CPId = Convert.ToInt32(dr["CPId"].ToString());
list1.PeoplesTalk = dr["PeoplesTalk"].ToString();
list1.PeopleImage = dr["PeopleImage"].ToString();
list.Add(list1);
}
return(list);
}
