public DataSet UpdateDatabaseTable(string sSQL, int nUserID)
{
Command.CommandText = ActivityLogsDA.GetDynamicObjectList(sSQL, nUserID);
SqlDataAdapter da = new SqlDataAdapter(Command.CommandText, Command.Connection);
da.SelectCommand = Command;
DataSet oDataSet = new DataSet();
Connection.Open();
da.Fill(oDataSet);
Connection.Close();
return(oDataSet);
}
public List <ActivityLogs> Gets(string sSQL, int nUserID)
{
Connection.Open();
Command.CommandText = ActivityLogsDA.Gets(sSQL, nUserID);
SqlDataReader reader = Command.ExecuteReader();
ActivityLogs _oActivityLogs = new ActivityLogs();
List <ActivityLogs> _oActivityLogss = new List <ActivityLogs>();
if (reader.HasRows)
{
_oActivityLogss = MakeObjects(reader);
}
reader.Close();
Connection.Close();
return(_oActivityLogss);
}
