public static List<Ticket> getTicketsByIDs(string ListaIDs, String accSignature) { SqlConnection conn = new SqlConnection(DBHelper.ConnectionString); SqlCommand command = new SqlCommand(); command.Connection = conn; command.CommandType = CommandType.StoredProcedure; command.CommandText = "getTickets_byID"; command.Parameters.AddWithValue("listaTicketIDs", ListaIDs); SqlDataAdapter da = new SqlDataAdapter(command); DataSet ds = new DataSet(); conn.Open(); da.Fill(ds); conn.Close(); if (ds.Tables[0].Rows.Count == 0) return null; List<Ticket> theTicketList = new List<Ticket>(); Ticket theTicket; Pessoa proprio = new Pessoa(); Projecto proj = new Projecto(); proj = Projecto.getProjecto(Convert.ToInt32(ds.Tables[0].Rows[0]["projectoID"]), accSignature); foreach (DataRow dr in ds.Tables[0].Rows) { theTicket = new Ticket(); theTicket.projecto = proj; // Convert.IsDBNull(dr["projectoID"]) ? null : Projecto.getProjecto(Convert.ToInt32(dr["projectoID"]), accSignature); theTicket.modeloID = Convert.ToInt32(dr["modeloID"]); theTicket.proprio = Convert.IsDBNull(dr["proprioID"]) ? null : Pessoa.getPessoa(Convert.ToInt32(dr["proprioID"]), accSignature); theTicket.avaliado = Convert.IsDBNull(dr["avaliadoID"]) ? null : Pessoa.getPessoa(Convert.ToInt32(dr["avaliadoID"]), accSignature); theTicket.chave = Convert.IsDBNull(dr["chave"]) ? "" : Convert.ToString(dr["chave"]); theTicket.completo = Convert.IsDBNull(dr["completo"]) ? false : Convert.ToBoolean(dr["completo"]); theTicket.dataFim = Convert.IsDBNull(dr["dataFim"]) ? DateTime.MinValue : Convert.ToDateTime(dr["dataFim"]); theTicket.dataInicio = Convert.IsDBNull(dr["dataInicio"]) ? DateTime.MinValue : Convert.ToDateTime(dr["dataInicio"]); theTicket.qualidade = Convert.IsDBNull(dr["qualidade"]) ? "" : Convert.ToString(dr["qualidade"]); theTicket.resposta = Convert.IsDBNull(dr["resposta"]) ? "" : Convert.ToString(dr["resposta"]); theTicket.pagina = Convert.IsDBNull(dr["pagina"]) ? 0 : Convert.ToInt32(dr["pagina"]); theTicket.ticketID = Convert.ToInt32(dr["id"]); theTicket.ticketType = Convert.IsDBNull(dr["ticketType"]) ? "" : Convert.ToString(dr["ticketType"]); theTicket.Convite = Convert.IsDBNull(dr["Convite"]) ? "" : Convert.ToString(dr["Convite"]); theTicket.dataEntrada = Convert.IsDBNull(dr["dtEntrada"]) ? DateTime.MinValue : Convert.ToDateTime(dr["dtEntrada"]); theTicket.LangCode = Convert.IsDBNull(dr["langCode"]) ? null : Convert.ToString(dr["langCode"]); theTicket.QuestionPattern = Convert.IsDBNull(dr["QuestionPattern"]) ? "" : Convert.ToString(dr["QuestionPattern"]); theTicket.AA = Convert.IsDBNull(dr["AA"]) ? false : Convert.ToBoolean(dr["AA"]); if (theTicket.langCode != null) proj.traslateTo(theTicket.langCode); theTicket.projecto = proj; theTicket.processResposta(); theTicketList.Add(theTicket); } return theTicketList; }
public static Ticket getTicket(String chave, String owner) { SqlConnection conn = new SqlConnection(DBHelper.ConnectionString); SqlCommand command = new SqlCommand(); command.Connection = conn; command.CommandType = CommandType.StoredProcedure; command.CommandText = "getTicket"; command.Parameters.AddWithValue("chave", chave); SqlDataAdapter da = new SqlDataAdapter(command); DataSet ds = new DataSet(); conn.Open(); da.Fill(ds); conn.Close(); if (ds.Tables[0].Rows.Count == 0) return null; Ticket theTicket = new Ticket(); ; Pessoa proprio = new Pessoa(); Projecto proj = new Projecto(); DataRow dr = ds.Tables[0].Rows[0]; proprio = Pessoa.getPessoa(Convert.ToInt32(dr["proprioID"]), owner); proj = Projecto.getProjectoID(Convert.ToInt32(dr["projectoID"]), owner); theTicket.projecto = proj; theTicket.modeloID = Convert.ToInt32(dr["modeloID"]); theTicket.proprio = proprio; if (Convert.IsDBNull(dr["avaliadoID"])) theTicket.avaliado = null; else theTicket.avaliado = Pessoa.getPessoa(Convert.ToInt32(dr["avaliadoID"]),owner); theTicket.chave = Convert.IsDBNull(dr["chave"]) ? "" : Convert.ToString(dr["chave"]); theTicket.completo = Convert.IsDBNull(dr["completo"]) ? false : Convert.ToBoolean(dr["completo"]); theTicket.dataFim = Convert.IsDBNull(dr["dataFim"]) ? DateTime.MinValue : Convert.ToDateTime(dr["dataFim"]); theTicket.dataInicio = Convert.IsDBNull(dr["dataInicio"]) ? DateTime.MinValue : Convert.ToDateTime(dr["dataInicio"]); theTicket.qualidade = Convert.IsDBNull(dr["qualidade"]) ? "" : Convert.ToString(dr["qualidade"]); theTicket.resposta = Convert.IsDBNull(dr["resposta"]) ? "" : Convert.ToString(dr["resposta"]); theTicket.pagina = Convert.IsDBNull(dr["pagina"]) ? 0 : Convert.ToInt32(dr["pagina"]); theTicket.ticketID = Convert.ToInt32(dr["id"]); theTicket.ticketType = Convert.IsDBNull(dr["ticketType"]) ? "" : Convert.ToString(dr["ticketType"]); theTicket.Convite = Convert.IsDBNull(dr["Convite"]) ? "" : Convert.ToString(dr["Convite"]); theTicket.dataEntrada = Convert.IsDBNull(dr["dtEntrada"]) ? DateTime.MinValue : Convert.ToDateTime(dr["dtEntrada"]); theTicket.LangCode = Convert.IsDBNull(dr["langCode"]) ? null : Convert.ToString(dr["langCode"]); theTicket.QuestionPattern = Convert.IsDBNull(dr["QuestionPattern"]) ? "" : Convert.ToString(dr["QuestionPattern"]); theTicket.AA = Convert.IsDBNull(dr["AA"]) ? false : Convert.ToBoolean(dr["AA"]); if (theTicket.langCode != null) proj.traslateTo(theTicket.langCode); theTicket.projecto = proj; theTicket.processResposta(); return theTicket; }