コード例 #1
0
ファイル: ResultadoApp.cs プロジェクト: EriksonGM/CVControl
        public object GerarDataEstadoCivil()
        {
            try
            {
                var data = new Charts.Data();

                var connString = ConfigurationManager.ConnectionStrings["Conn"].ConnectionString;

                var qry = @"Select ec.Estado as Estado, COUNT(*) as Total from Resultado r inner join EstadoCivil ec on r.IdEstadoCivil = ec.IdEstadoCivil Group by ec.Estado Order By ec.Estado ";

                using (SqlConnection conn = new SqlConnection(connString))
                {
                    var cmd = new SqlCommand(qry, conn);

                    conn.Open();

                    var reader = cmd.ExecuteReader();

                    var dsEstadoCivilo = new DonutDataSet()
                    {
                        label           = "Estado Civil",
                        backgroundColor = new List <string>
                        {
                            Color.DodgerBlue.Name, Color.DarkGray.Name, Color.Moccasin.Name, Color.DarkSalmon.Name, Color.Wheat.Name
                        },
                        hoverBackgroundColor = new List <string>
                        {
                            Color.DodgerBlue.Name, Color.DarkGray.Name, Color.Moccasin.Name, Color.DarkSalmon.Name, Color.Wheat.Name
                        }
                    };

                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            data.labels.Add(reader["Estado"].ToString());
                            dsEstadoCivilo.data.Add(Convert.ToInt32(reader["Total"]));
                        }
                    }

                    conn.Close();

                    data.datasets.Add(dsEstadoCivilo);
                }

                return(data);
            }
            catch (Exception e)
            {
                SystemLog.Erro(e);
                return(null);
            }
        }
コード例 #2
0
ファイル: ResultadoApp.cs プロジェクト: EriksonGM/CVControl
        public object GerarDataFilhos()
        {
            try
            {
                var data = new Charts.Data();

                var connString = ConfigurationManager.ConnectionStrings["Conn"].ConnectionString;

                var qry = @"Select ifi.Intervalo, COUNT(*) as Total from Resultado r inner join IntervaloFilhos ifi on r.IdIntervaloFilhos = ifi.IdIntervaloFilhos group by ifi.Intervalo, ifi.IdIntervaloFilhos Order By ifi.IdIntervaloFilhos";

                using (SqlConnection conn = new SqlConnection(connString))
                {
                    var cmd = new SqlCommand(qry, conn);

                    conn.Open();

                    var reader = cmd.ExecuteReader();

                    var ds = new DonutDataSet()
                    {
                        label           = "Estado Civil",
                        backgroundColor = new List <string>
                        {
                            "#e1bcc3", "#a1cde8", "#757da4", "#b9e5e8", "#c6b6d1"
                        },
                        hoverBackgroundColor = new List <string>
                        {
                            "#e1bcc3", "#a1cde8", "#757da4", "#b9e5e8", "#c6b6d1"
                        }
                    };

                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            data.labels.Add(reader["Intervalo"].ToString());
                            ds.data.Add(Convert.ToInt32(reader["Total"]));
                        }
                    }

                    conn.Close();

                    data.datasets.Add(ds);
                }

                return(data);
            }
            catch (Exception e)
            {
                SystemLog.Erro(e);
                return(null);
            }
        }
コード例 #3
0
ファイル: ResultadoApp.cs プロジェクト: EriksonGM/CVControl
        public object GerarDataGenero()
        {
            try
            {
                var data = new Charts.Data();

                var connString = ConfigurationManager.ConnectionStrings["Conn"].ConnectionString;

                var qry = @"Select g.Nome as Genero, Count(*) as Total from Resultado r inner join Genero g on r.IdGenero = g.IdGenero Group By g.Nome Order By g.Nome";

                using (SqlConnection conn = new SqlConnection(connString))
                {
                    var cmd = new SqlCommand(qry, conn);

                    conn.Open();

                    var reader = cmd.ExecuteReader();

                    var dsGenero = new DonutDataSet()
                    {
                        label           = "Generos",
                        backgroundColor = new List <string>
                        {
                            Color.Pink.Name, Color.DodgerBlue.Name
                        },
                        hoverBackgroundColor = new List <string>
                        {
                            Color.Pink.Name, Color.DodgerBlue.Name
                        }
                    };

                    if (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            data.labels.Add(reader["Genero"].ToString());
                            dsGenero.data.Add(Convert.ToInt32(reader["Total"]));
                        }
                    }

                    conn.Close();

                    data.datasets.Add(dsGenero);
                }

                return(data);
            }
            catch (Exception e)
            {
                SystemLog.Erro(e);
                return(null);
            }
        }