public List <SurverListObj> GetSurveyList(SurverList data)
{
List <SurverListObj> ResultSet = new List <SurverListObj>();
using (IDbConnection connection = GetOpenConnection())
{
try
{
string sql = @"SELECT a.TVSurveyID,
a.SurveyID,
b.SurveySequence,
b.SurveyName ,
a.SurveyResult
FROM TruckVisualSurveys AS a,
MasterSurveys AS b
WHERE a.SurveyID = b.SurveyID
AND a.JobOrderID = @JobOrderID
AND b.IsActive = 1
";
ResultSet = connection.Query <SurverListObj>(sql, new { JobOrderID = data.JobOrderID }, commandType: CommandType.Text).ToList();
}
catch (Exception ex)
{
throw ex;
}
}
return(ResultSet);
}
public ResponseInfo <ResSurverList> GetSurverList(SurverList data)
{
ResponseInfo <ResSurverList> res = new ResponseInfo <ResSurverList>();
try
{
res.ResponseData = new ResSurverList();
res.ResponseData.ObjSurverList = EPODDAL.GetSurveyList(data);
}
catch (Exception ex)
{
throw ex;
}
return(res);
}
