public static List<VODDetails> GetTargetedVODDetails(string UA, int Package)
{
List<VODDetails> lstobj = new List<VODDetails>();
using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["ConnString"]))
{
conn.Open();
SqlCommand objCommandToExec = new SqlCommand("uspGetRecommendations", conn);
objCommandToExec.CommandType = CommandType.StoredProcedure;
SqlParameter[] objarray = new SqlParameter[2];
SqlParameter objparam = new SqlParameter("@stbUA", SqlDbType.VarChar, 10);
objparam.Value = UA;
objarray[0] = objparam;
objparam = new SqlParameter("@Package", SqlDbType.Int);
objparam.Value = Package;
objarray[1] = objparam;
objCommandToExec.Parameters.AddRange(objarray);
SqlDataReader objSDR = objCommandToExec.ExecuteReader();
while (objSDR.Read())
{
VODDetails OBJ = new VODDetails();
OBJ.strAction = objSDR["strAction"].ToString();
OBJ.strAssetID = objSDR["strAssetID"].ToString();
OBJ.strHeaderText = objSDR["strHeaderText"].ToString();
lstobj.Add(OBJ);
}
}
return lstobj;
}
public static List<VODDetails> FetchData()
{
List<VODDetails> lstobj = new List<VODDetails>();
using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["ConnString"]))
{
conn.Open();
SqlCommand objCommandToExec = new SqlCommand("select * from VodDetails ", conn);
SqlDataReader objSDR = objCommandToExec.ExecuteReader();
while (objSDR.Read())
{
VODDetails OBJ = new VODDetails();
OBJ.strAction = objSDR["strAction"].ToString();
OBJ.strAssetID = objSDR["strAssetID"].ToString();
OBJ.strHeaderText = objSDR["strHeaderText"].ToString();
OBJ.AssentName = objSDR["AssetName"].ToString();
lstobj.Add(OBJ);
}
}
return lstobj;
}