public V_EmployeeSurveySubject GetInfoByTitle(string masterTitle)
{
V_EmployeeSurveySubject listAll = new V_EmployeeSurveySubject();
string masterId=listAll.Master.REQUIREMASTERID;
using (EmployeeSurveysMasterBll masterBll = new EmployeeSurveysMasterBll())
{
IQueryable<T_OA_REQUIREMASTER> masterList = masterBll.GetInfoListByTitle(masterTitle);
if (masterList == null)
{
return null;
}
else
{
listAll.Master=masterList.ToList()[0];
}
}
using (EmployeeSurveySubjectBll questionBll = new EmployeeSurveySubjectBll())
{
IQueryable<T_OA_REQUIREDETAIL2> questionList = questionBll.GetInfoListByMasterId(masterId);
if (questionList == null)
{
return null;
}
else
{
listAll.Question = questionList.ToList()[0];
}
}
using(EmployeeSurveysAnswerBll answerBll=new EmployeeSurveysAnswerBll())
{
IQueryable<T_OA_REQUIREDETAIL> answerList =answerBll.GetInfoByMasterId(masterId);
if(answerList==null)
{
return null;
}
else
{
listAll.Answer=answerList.ToList()[0];
}
}
return listAll;
}
public V_EmployeeSurveySubject GetInfoByTitle(string masterTitle)
{
V_EmployeeSurveySubject listAll = new V_EmployeeSurveySubject();
string masterId = listAll.Master.REQUIREMASTERID;
using (EmployeeSurveysMasterBll masterBll = new EmployeeSurveysMasterBll())
{
IQueryable <T_OA_REQUIREMASTER> masterList = masterBll.GetInfoListByTitle(masterTitle);
if (masterList == null)
{
return(null);
}
else
{
listAll.Master = masterList.ToList()[0];
}
}
using (EmployeeSurveySubjectBll questionBll = new EmployeeSurveySubjectBll())
{
IQueryable <T_OA_REQUIREDETAIL2> questionList = questionBll.GetInfoListByMasterId(masterId);
if (questionList == null)
{
return(null);
}
else
{
listAll.Question = questionList.ToList()[0];
}
}
using (EmployeeSurveysAnswerBll answerBll = new EmployeeSurveysAnswerBll())
{
IQueryable <T_OA_REQUIREDETAIL> answerList = answerBll.GetInfoByMasterId(masterId);
if (answerList == null)
{
return(null);
}
else
{
listAll.Answer = answerList.ToList()[0];
}
}
return(listAll);
}
