public void DeleteTicketByRowId(int rowId) { String query = String.Format("DELETE FROM [dbo].[tbTickets] where TicketId ={0}", rowId); DataAccessClient da = new DataAccessClient(); da.ExecuteQuery(ConnectionString, query); }
public void UpdateTicketDetails(string tDesc, string status, string assignedTo, int ticketId) { String query = String.Format("Update [dbo].[tbTickets] SET TicketDesc = '{0}', Status = '{1}', [AssignedTo]= " + "(SELECT Id from [TrackerDB].[dbo].[tbUser] WHERE UserName ='******') WHERE TicketId = {3}", tDesc, status, assignedTo, ticketId); DataAccessClient da = new DataAccessClient(); da.ExecuteQuery(ConnectionString, query); }
public DataSet GetTicketDetails() { string query = string.Empty; DataSet ds = new DataSet(); query = "SELECT [TicketId],[TicketDesc],[Status],[IsActive],[AssignedTo] FROM[TrackerDB].[dbo].[vwGetTicketList]"; DataAccessClient da = new DataAccessClient(); ds = da.ExecuteQuery(ConnectionString, query); return(ds); }