public DataSet SurveyDetails(string startDate, string enddate, string clientId, int ProviderId)
{
SqlParameter[] objSqlParam = new SqlParameter[5];
objSqlParam[0] = new SqlParameter("@V_StartDate", SqlDbType.VarChar, 20);
objSqlParam[0].Value = startDate;
objSqlParam[1] = new SqlParameter("@V_EndDate", SqlDbType.VarChar, 20);
objSqlParam[1].Value = enddate;
objSqlParam[2] = new SqlParameter("@V_ClientId", SqlDbType.VarChar, 20);
objSqlParam[2].Value = clientId;
objSqlParam[3] = new SqlParameter("@I_ProviderId", SqlDbType.BigInt);
objSqlParam[3].Value = ProviderId;
return(SQLHelper.ExecuteDataset(DConConfig.ConnectionStringPortal, CommandType.StoredProcedure, "USP_ExamitySurveyDetails_Provider", objSqlParam));
}
public DataSet GetSurveyIndividualReport(string clientId, string studentName, int examID, DateTime fromDate, DateTime toDate)
{
SqlParameter[] objSqlParam = new SqlParameter[5];
objSqlParam[0] = new SqlParameter("@V_ClientID", SqlDbType.VarChar, 8000);
objSqlParam[0].Value = clientId;
objSqlParam[1] = new SqlParameter("@V_Name", SqlDbType.VarChar, 8000);
objSqlParam[1].Value = studentName;
objSqlParam[2] = new SqlParameter("@V_ExamID", SqlDbType.BigInt);
objSqlParam[2].Value = examID;
objSqlParam[3] = new SqlParameter("@V_FromDate", SqlDbType.VarChar, 100);
objSqlParam[3].Value = fromDate.ToShortDateString();
objSqlParam[4] = new SqlParameter("@V_ToDate", SqlDbType.VarChar, 100);
objSqlParam[4].Value = toDate.ToShortDateString();
return(SQLHelper.ExecuteDataset(DConConfig.ConnectionStringPortal, CommandType.StoredProcedure, "USP_GETSurveyIndividualReport", objSqlParam));
}
public DataSet GetSurveyResponsePercentage(int clientId, int templateId, int qId, DateTime startdate, DateTime enddate, int isgolivedate)
{
SqlParameter[] objSqlParam = new SqlParameter[8];
objSqlParam[0] = new SqlParameter("@V_ClientId", SqlDbType.Int);
objSqlParam[0].Value = clientId;
objSqlParam[1] = new SqlParameter("@V_Tid", SqlDbType.Int);
objSqlParam[1].Value = templateId;
objSqlParam[2] = new SqlParameter("@V_Qid", SqlDbType.Int);
objSqlParam[2].Value = qId;
objSqlParam[3] = new SqlParameter("@V_FromDate", SqlDbType.DateTime);
objSqlParam[3].Value = startdate;
objSqlParam[4] = new SqlParameter("@V_ToDate", SqlDbType.DateTime);
objSqlParam[4].Value = enddate;
objSqlParam[5] = new SqlParameter("@I_isgolivedate", SqlDbType.Int);
objSqlParam[5].Value = isgolivedate;
return(SQLHelper.ExecuteDataset(DConConfig.ConnectionStringPortal, CommandType.StoredProcedure, "USP_GetExamitySurveyResponsePercentage_new", objSqlParam));
}
