public static List<Statistic> DrawChart(int surveyId) { List<Statistic> statList = new List<Statistic>(); String connStr = ConfigurationManager.ConnectionStrings["inzSNMConnectionString"].ConnectionString; string query = "select ocena , id_zdjecia,tytuł from Ocena inner join Dzieło on id_zdjecia = id_dzieło where id_ankiety =" + surveyId; using (SqlConnection Sqlcon = new SqlConnection(connStr)) { SqlCommand command = new SqlCommand(query, Sqlcon); Sqlcon.Open(); SqlDataReader reader = command.ExecuteReader(); try { while (reader.Read()) { Statistic s = new Statistic(); s.mark = Convert.ToInt32(reader[0]); s.photoId = Convert.ToInt32(reader[1]); s.photoName = reader[2].ToString(); statList.Add(s); } } catch (Exception e) { throw new Exception(e.Message); } finally { Sqlcon.Close(); } //using (SqlCommand cmd = new SqlCommand()) //wykres source //{ //try //{ //Sqlcon.Open(); //cmd.Connection = Sqlcon; //cmd.CommandType = CommandType.StoredProcedure; //cmd.CommandText = "wykres_glosy"; //cmd.Parameters.Add("@ankietaId", SqlDbType.Int); //cmd.Parameters["@ankietaId"].Value = surveyId; //cmd.ExecuteNonQuery(); //} //catch (Exception e) //{ // throw new Exception(e.Message); //} //finally //{ Sqlcon.Close(); //} //} } return statList; }
public static Statistic AvgImagesInSurveys() { String connStr = ConfigurationManager.ConnectionStrings["inzSNMConnectionString"].ConnectionString; Statistic s = new Statistic(); using (SqlConnection Sqlcon = new SqlConnection(connStr)) { using (SqlCommand cmd = new SqlCommand("OverallStatistics", Sqlcon)) //statystyki ogólne { cmd.CommandType = CommandType.StoredProcedure; SqlParameter outPutParameter = new SqlParameter(); cmd.Parameters.Add("@avgImgInSurv", SqlDbType.Int); cmd.Parameters["@avgImgInSurv"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@avgVoteNum", SqlDbType.Int); cmd.Parameters["@avgVoteNum"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@voteNum", SqlDbType.Int); cmd.Parameters["@voteNum"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@numOfCreatedSurv", SqlDbType.Int); cmd.Parameters["@numOfCreatedSurv"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@numOfVisitors", SqlDbType.Int); cmd.Parameters["@numOfVisitors"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@numOfEmails", SqlDbType.Int); cmd.Parameters["@numOfEmails"].Direction = ParameterDirection.Output; try { Sqlcon.Open(); cmd.ExecuteNonQuery(); s.avgImgInSurv = Convert.ToInt32(cmd.Parameters["@avgImgInSurv"].Value); s.avgVoteNum = Convert.ToInt32(cmd.Parameters["@avgVoteNum"].Value); s.voteNum = Convert.ToInt32(cmd.Parameters["@voteNum"].Value); s.numOfCreatedSurv = Convert.ToInt32(cmd.Parameters["@numOfCreatedSurv"].Value); s.numOfVisitors = Convert.ToInt32(cmd.Parameters["@numOfVisitors"].Value); s.numOfEmails = Convert.ToInt32(cmd.Parameters["@numOfEmails"].Value); } catch (Exception e) { throw new Exception("Błąd podczas aktualizacji statystyk!"); } finally { Sqlcon.Close(); } } } return s; }
public void FillStatisticsPerSurvey(int surverId) { //try //{ inzPJATKSNM.Controllers.Statistic s = new Controllers.Statistic(); s = inzPJATKSNM.Controllers.StatisticsController.StatisticPerSurvey(surverId); Lbl1.Text = "Liczba głosujących : " + Convert.ToString(s.NumOfVotersOnSurvey); Lbl2.Text = "Liczba odwiedzających : " + Convert.ToString(s.NumOfVisitors); Lbl3.Text = "Liczba subskrybentów po ankiecie : " + Convert.ToString(s.NumOfSubs); Lbl4.Text = "Nazwa zdjęcia z największą sumą głosów : " + Convert.ToString(s.ImgMaxVoteNumName); Lbl5.Text = "Nazwa zdjęcia z najmniejszą sumą głosów : " + Convert.ToString(s.ImgMinVoteNumName); Lbl6.Visible = false; StatButton.Visible = false; //} //catch (Exception e) //{ // throw new Exception(e.Message); //} }
public void FillStatistics() { try { inzPJATKSNM.Controllers.Statistic s = new Controllers.Statistic(); s = inzPJATKSNM.Controllers.StatisticsController.AvgImagesInSurveys(); Lbl1.Text = "Średnia ilość dzieł w ankietach : " + Convert.ToString(s.avgImgInSurv); Lbl2.Text = "Średnia ilość głosów : " + Convert.ToString(s.avgVoteNum); Lbl3.Text = "Ogólna liczba głosów : " + Convert.ToString(s.voteNum); Lbl4.Text = "Ilość stworzonych ankiet : " + Convert.ToString(s.numOfCreatedSurv); Lbl5.Text = "Ilość odwiedzin : " + Convert.ToString(s.numOfVisitors); Lbl6.Text = "Ilość subskrybentów : " + Convert.ToString(s.numOfEmails); BackButton.Visible = false; Chart1.Visible = false; } catch (Exception e) { throw new Exception("Błąd podczas aktualizacji statystyk!"); } }
public static Statistic StatisticPerSurvey(int surveyId) { String connStr = ConfigurationManager.ConnectionStrings["inzSNMConnectionString"].ConnectionString; Statistic s = new Statistic(); using (SqlConnection Sqlcon = new SqlConnection(connStr)) { using (SqlCommand cmd = new SqlCommand("StatisticsPerSurvey", Sqlcon)) //statystyki oper ankieta { cmd.CommandType = CommandType.StoredProcedure; SqlParameter outPutParameter = new SqlParameter(); cmd.Parameters.Add("@NumOfVotersOnSurvey", SqlDbType.Int); cmd.Parameters["@NumOfVotersOnSurvey"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@NumOfVisitors", SqlDbType.Int); cmd.Parameters["@NumOfVisitors"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@NumOfSubs", SqlDbType.Int); cmd.Parameters["@NumOfSubs"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@ImgMaxVoteNumName", SqlDbType.VarChar); cmd.Parameters["@ImgMaxVoteNumName"].Direction = ParameterDirection.Output; cmd.Parameters["@ImgMaxVoteNumName"].Size = 250; cmd.Parameters.Add("@ImgMinVoteNumName", SqlDbType.VarChar); cmd.Parameters["@ImgMinVoteNumName"].Direction = ParameterDirection.Output; cmd.Parameters["@ImgMinVoteNumName"].Size = 250; cmd.Parameters.Add("@ImgMaxVoteNumUrl", SqlDbType.VarChar); cmd.Parameters["@ImgMaxVoteNumUrl"].Direction = ParameterDirection.Output; cmd.Parameters["@ImgMaxVoteNumUrl"].Size = 250; cmd.Parameters.Add("@ImgMinVoteNumUrl", SqlDbType.VarChar); cmd.Parameters["@ImgMinVoteNumUrl"].Direction = ParameterDirection.Output; cmd.Parameters["@ImgMinVoteNumUrl"].Size = 250; // try // { Sqlcon.Open(); cmd.Parameters.Add("@SurveyId", SqlDbType.Int); cmd.Parameters["@SurveyId"].Value = surveyId; cmd.ExecuteNonQuery(); s.NumOfVotersOnSurvey = Convert.ToInt32(cmd.Parameters["@NumOfVotersOnSurvey"].Value); s.NumOfVisitors = Convert.ToInt32(cmd.Parameters["@NumOfVisitors"].Value); s.NumOfSubs = Convert.ToInt32(cmd.Parameters["@NumOfSubs"].Value); s.ImgMaxVoteNumName = Convert.ToString(cmd.Parameters["@ImgMaxVoteNumName"].Value); s.ImgMinVoteNumName = Convert.ToString(cmd.Parameters["@ImgMinVoteNumName"].Value); s.ImgMaxVoteNumUrl = Convert.ToString(cmd.Parameters["@ImgMaxVoteNumUrl"].Value); s.ImgMinVoteNumUrl = Convert.ToString(cmd.Parameters["@ImgMinVoteNumUrl"].Value); // } // catch (Exception e) // { // throw new Exception(e.Message); // } // finally //{ Sqlcon.Close(); // } } } return s; }