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);
}
