public List <ActivitieListObj> GetActivityList(ActivitieList data) { List <ActivitieListObj> ResultSet = new List <ActivitieListObj>(); using (IDbConnection connection = GetOpenConnection()) { try { string sql = @"select a.TVActivityID, a.ProcessStatusID, b.ProcessStatusSeq, b.ProcessStatusName, a.ProcessOn from TruckVisualActivities as a, MasterProcessStatus as b, Users as c where a.ProcessStatusID = b.ProcessStatusID And a.DriverID = c.DriverID And a.JobOrderID = @JobOrderID And c.UserID = @UserID "; ResultSet = connection.Query <ActivitieListObj>(sql, new { JobOrderID = data.JobOrderID, UserID = data.UserID }, commandType: CommandType.Text).ToList(); } catch (Exception ex) { throw ex; } } return(ResultSet); }
public ResponseInfo <ResActivitieList> GetActivitieList(ActivitieList data) { ResponseInfo <ResActivitieList> res = new ResponseInfo <ResActivitieList>(); try { res.ResponseData = new ResActivitieList(); res.ResponseData.ObjActivitiesList = EPODDAL.GetActivityList(data); } catch (Exception ex) { throw ex; } return(res); }