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