public DataSet getticketnodehistory(string ticketid) { TicketDao ticketdao = new TicketDao(); Ticket ticket = ticketdao.getticketid(ticketid); ConnectionDao ConnectionDao = new ConnectionDao(); SqlDataAdapter adp = new SqlDataAdapter("select * from TicketNote where ticketid='" + ticket.ticketgetid + "'", ConnectionDao.getConnection()); DataSet ds2 = new DataSet(); adp.Fill(ds2); return ds2; }
public DataSet getticketassignmenthistory(string ticketid) { TicketDao ticketdao = new TicketDao(); Ticket ticket = ticketdao.getticketid(ticketid); ConnectionDao ConnectionDao = new ConnectionDao(); SqlDataAdapter adp = new SqlDataAdapter("select * from TicketAssignment where ticketid='" + ticket.ticketgetid + "'", ConnectionDao.getConnection()); DataSet ds3 = new DataSet(); adp.Fill(ds3); return ds3; }