/// <summary>
/// Method to get Questions based on User_Code
/// </summary>
/// <param name="companyCode"></param>
/// <param name="userCode"></param>
/// <returns></returns>
public QuestionParameterModel GetICEQuestionsByUserCode(string companyCode, string userCode)
{
QuestionParameterModel lstqstnbyuser = new QuestionParameterModel();
try
{
List <QuestionModel> lstquestions = null;
List <ParametersModel> lstparameters = null;
using (IDbConnection connection = IDbOpenConnection())
{
var p = new DynamicParameters();
p.Add("@Company_Code", companyCode);
p.Add("@User_Code", userCode);
using (var multiselect = connection.QueryMultiple(SP_HD_ICE_GETALLMAPPEDQUESTIONSBYUSERCODE, p, commandType: CommandType.StoredProcedure))
{
lstquestions = multiselect.Read <QuestionModel>().ToList();
lstparameters = multiselect.Read <ParametersModel>().ToList();
}
// lstqstnbyuser = connection.Query<QuestionModel>(SP_HD_ICE_GETALLMAPPEDQUESTIONSBYUSERCODE, p, commandType: CommandType.StoredProcedure);
lstqstnbyuser.lstQuestions = lstquestions;
lstqstnbyuser.lstParameters = lstparameters;
}
}
catch (Exception ex)
{
throw;
}
return(lstqstnbyuser);
}
/// <summary>
/// Method to get Questions based on User_Code
/// </summary>
/// <param name="companyCode"></param>
/// <param name="userCode"></param>
/// <returns></returns>
public QuestionParameterModel GetICEQuestionsByUserCode(string companyCode, string userCode)
{
QuestionParameterModel lstqstns = null;
try
{
DAL_ICE objqstnlst = new DAL_ICE();
lstqstns = objqstnlst.GetICEQuestionsByUserCode(companyCode, userCode);
}
catch (Exception ex)
{
throw;
}
return(lstqstns);
}
