public List <BlogBll> getBlog(BlogBll obj)
{
List <BlogBll> list = new List <BlogBll>();
DataSet ds = new DataSet();
SqlDataReader dr;
using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))
{
try
{
SqlParameter[] para = new SqlParameter[1];
para[0] = new SqlParameter("@id", obj.bgId);
dr = SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "uspBlogInfo", para);
if (dr.HasRows)
{
while (dr.Read())
{
BlogBll bg = new BlogBll();
bg.bgId = Convert.ToInt32(dr ["bgId"]);
bg.BgWriter = Convert.ToString(dr ["BgWriter"]);
bg.Bg = Convert.ToString(dr ["Bg"]);
bg.BgDate = Convert.ToDateTime(dr ["BgDate"]);
bg.aggri = Convert.ToInt32(dr ["aggri"]);
bg.notAggri = Convert.ToInt32(dr ["notAggri"]);
bg.photo = Convert.ToString(dr ["photo"]);
list.Add(bg);
}
}
}
catch (SqlException ex)
{
throw ex;
}
finally
{
con.Close();
}
}
return(list);
}
public List <BlogBll> getBlogData(BlogBll obj)
{
return(blogDalObj.getBlog(obj));
}
