private DataTable getReviews(long reviewRefId)
{
DataAdapter dataAdapter = new DataAdapter();
SqlParameter[] parameters = new SqlParameter[1];
parameters[0]=new SqlParameter("@reviewRefId", reviewRefId);
DataSet ds = dataAdapter.ExecuteStoredProcedure("sp_GetReviewDetails", parameters);
return ds.Tables[0];
}
private void GetArtifactList()
{
DataAdapter dataAdapter = new DataAdapter();
DataSet ds = new DataSet();
//ds=dataAdapter.ExecuteSelectQuery("Select * from Artifact where Datalength(ArtifactText) <> 0 and ArtifactText like '%Wikipedia%' order by ArtifactId desc ");
ds = dataAdapter.ExecuteStoredProcedure("usp_getArtifactsWithTopReviews",new System.Data.SqlClient.SqlParameter[] { });
gv_SurveyMaster.DataSource = ds.Tables[0];
gv_SurveyMaster.DataBind();
}
private DataTable getQuestions()
{
DataAdapter da = new DataAdapter();
try
{
SqlParameter[] sqlParameter = new SqlParameter[1];
sqlParameter[0] = new SqlParameter("@reviewId", Convert.ToInt64(Session["ReviewRefId"]));
DataSet ds = da.ExecuteStoredProcedure("sp_GetSurveyQuestions", sqlParameter);
if (ds.Tables.Count > 0)
return ds.Tables[0];
}
catch
{
}
return new DataTable();
}
/// <summary>
/// get all the reviews for artifact
/// </summary>
/// <param name="id"></param>
private DataTable getReviewStatus(long id)
{
DataTable dt = new DataTable();
try
{
DataAdapter dataAdapter = new DataAdapter();
SqlParameter[] sqlParameter = new SqlParameter[1];
//sqlParameter[0] = new SqlParameter("@userId", Session["UserToken"]);
sqlParameter[0] = new SqlParameter("@artifactId", id);
DataSet ds = dataAdapter.ExecuteStoredProcedure("usp_getTopRatedReviews", sqlParameter);
dt = ds.Tables[0];
}
catch (Exception ex)
{
}
return dt;
}
