public void loadFull(String owner, Ticket t) { if (loadCompetencias(owner, t)) { foreach (Competencia comp in competencias.Values) { comp.loadFull(owner); } } }
public bool GenerateReport(String templatePath, String destinationPath, DateTime dataDocumento, Pessoa self, Ticket ticket, Projecto proj, string endMarker) { try { this.rootPath = templatePath; this.destPath = destinationPath; this._self = self; this._ticket = ticket; this._projecto = proj; this._endMarker = endMarker; _Modelo = ModeloCompetencias.getDBModelo("JC", ModeloCompetencias.getPessoaModelo(_self.PessoaID, _projecto.ProjectoID)); _Modelo.loadFull(_projecto.owner, null); repCalcs = new RamkoersCalculations(_Modelo, _self.PessoaID, _projecto); if (!repCalcs.Init()) repCalcs = null; CountUps = 0; CountHoriz = 0; CountDown = 0; } catch (Exception e) { return false; } // tudo inicializado, podemos iniciar a geração do relatório this.Start(); return true; }
/// <summary> /// Carrega competências de uma família /// </summary> public bool loadCompetencias(string owner, Ticket t) { SqlConnection conn = new SqlConnection(DBHelper.ConnectionString); SqlCommand command = new SqlCommand(); command.Connection = conn; command.CommandText = "getCompetencias"; command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("familiaID", familiaID)); command.Parameters.Add(new SqlParameter("modeloID", modelo.ModeloID)); command.Parameters.Add(new SqlParameter("owner", owner)); SqlDataAdapter da = new SqlDataAdapter(command); DataSet ds = new DataSet(); conn.Open(); da.Fill(ds); conn.Close(); if (ds.Tables[0].Rows.Count <= 0) return false; // se estamos com tickets que necessitam de retirar partes do modelo String[] toRemove; List<int> IDsToRemove = new List<int>(); if (t != null) { if (t.QuestionPattern != null && t.QuestionPattern.Trim() != "") { toRemove = t.QuestionPattern.Split(';'); foreach (string remove in toRemove) { if (remove.StartsWith("C")) { IDsToRemove.Add(int.Parse(remove.Replace("C", ""))); } } } } Competencia com; int allow; Boolean temCompetencias = false; foreach (DataRow dr in ds.Tables[0].Rows) { if (IDsToRemove.Contains(Convert.ToInt32(dr["ID"]))) continue; temCompetencias = true; com = new Competencia(); com.CreationDate = Convert.ToDateTime(dr["creationDate"]); com.Description = Convert.IsDBNull(dr["Description"]) ? null : Convert.ToString(dr["Description"]); com.IntroText = Convert.IsDBNull(dr["IntroText"]) ? null : Convert.ToString(dr["IntroText"]); com.Name = Convert.ToString(dr["Name"]); com.PublicName = Convert.ToString(dr["PublicName"]); com.CompetenciaID = Convert.ToInt32(dr["ID"]); com.SortIndex = Convert.ToInt32(dr["sortIndex"]); ; allow = Convert.IsDBNull(dr["AllowComments"]) ? 0 : Convert.ToInt32(dr["AllowComments"]) == 0 ? 0 : 1; com.AllowRespondentComments = allow == 0 ? false : true; com.CommentsText = Convert.IsDBNull(dr["commentsText"]) ? null : Convert.ToString(dr["commentsText"]); allow = Convert.IsDBNull(dr["criticalidade"]) ? 0 : Convert.ToInt32(dr["criticalidade"]) == 0 ? 0 : 1; com.Criticalidade = allow == 0 ? false : true; if (com.Criticalidade) com.CriticalidadeScale = Convert.IsDBNull(dr["criticalidadeScale"]) ? null : Convert.ToString(dr["criticalidadeScale"]); com.CriticalidadeText = Convert.IsDBNull(dr["criticalidadeText"]) ? null : Convert.ToString(dr["criticalidadeText"]); com.PlainText = Convert.IsDBNull(dr["plainText"]) ? null : Convert.ToString(dr["plainText"]); com.PlainText = com.CriticalidadeText; com.Type = Convert.IsDBNull(dr["Type"]) ? null : Convert.ToString(dr["Type"]); com.NR = Convert.IsDBNull(dr["NR"]) ? false : Convert.ToBoolean(dr["NR"]); com.Opcional = Convert.IsDBNull(dr["Opcional"]) ? false : Convert.ToBoolean(dr["Opcional"]); com.Familia = this; addCompetencia(com); } return temCompetencias; }
public void loadFull(String owner, Ticket t) { if (fullLoad) return; loadFamilias(owner); if (this.familias.Count == 0 && owner != "TEMPLATE") { loadFull("TEMPLATE", t); return; } foreach (FamiliaCompetencias fam in familias.Values) { fam.loadFull(owner, t); } // verifica se todas as famílias têm competências // se não tiverem remove a compe int[] chaves = new int[familias.Count]; int count = 0; foreach (int key in familias.Keys) { chaves[count++] = key; } foreach (int i in chaves) { if (familias[i].Competencias.Count == 0) familias.Remove(i); } fullLoad = true; if (t != null) { if (t.LangCode != this.langCode) { this.traslateTo(t.LangCode); } } }
public bool GenerateReport(String templatePath, String destinationPath, DateTime dataDocumento, Pessoa self, Ticket ticket, Projecto proj, string endMarker) { throw new NotImplementedException(); }
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; }