private void merNjesite() { chkNjesite.Items.Clear(); chkNjesite.DataSource = null; lidhesi = new Requirenments(); if (RadioButtonList1.Items[0].Selected) { if (tegjitha.Checked) { chkNjesite.DataSource = lidhesi.merLgu().Copy(); chkNjesite.DataValueField = "nrrendor"; chkNjesite.DataTextField = "lgu"; chkNjesite.DataBind(); grafiku.InnerHtml = ""; } else { chkNjesite.DataSource = lidhesi.merLguByRegion(dropGrupNjesite.Text.ToString()).Copy(); chkNjesite.DataValueField = "nrrendor"; chkNjesite.DataTextField = "lgu"; chkNjesite.DataBind(); grafiku.InnerHtml = ""; } } else { chkNjesite.DataSource = lidhesi.MerMunicipality().Copy(); chkNjesite.DataTextField = "municipality"; chkNjesite.DataValueField = null; chkNjesite.DataBind(); } }
private void LoadGraph() { string data = "";//"{ \"hc-key\": \"BELSH\",\"value\": 156},{\"hc-key\":\"BERAT\",\"value\": 158}"; //{ \"hc-key\": \"Belsh\",\"value\": 267.4},{ \"hc-key\": \"Berat\",\"value\": 16722.44}, //{ \"hc-key\": \"Bulqizë\",\"value\": 446},{ \"hc-key\": \"Cërrik\",\"value\": 5125.35}, //{ \"hc-key\": \"Delvinë\",\"value\": 1571.55},{ \"hc-key\": \"Devoll\",\"value\": 2347.97},{ \"hc-key\": \"Dibër\",\"value\": 4130},{ \"hc-key\": \"Divjakë\",\"value\": 5011.34},{ \"hc-key\": \"Dropulli\",\"value\": 4392.63},{ \"hc-key\": \"Durrës\",\"value\": 122584},{ \"hc-key\": \"Elbasan\",\"value\": 74472.63},{ \"hc-key\": \"Fier\",\"value\": 44344.91},{ \"hc-key\": \"Finiq\",\"value\": 2118.86},{ \"hc-key\": \"Fushë_Arrëz\",\"value\": 1567.5},{ \"hc-key\": \"Gjirokastër\",\"value\": 13583.4},{ \"hc-key\": \"Gramsh\",\"value\": 4477.25},{ \"hc-key\": \"Has\",\"value\": 778},{ \"hc-key\": \"Himarë\",\"value\": 3416.5},{ \"hc-key\": \"Kamëz\",\"value\": 29979.35},{ \"hc-key\": \"Kavajë\",\"value\": 18172.83},{ \"hc-key\": \"Këlcyrë\",\"value\": 945},{ \"hc-key\": \"Klos\",\"value\": 894.13},{ \"hc-key\": \"Kolonjë\",\"value\": 2981.47},{ \"hc-key\": \"Konispol\",\"value\": 1283.55},{ \"hc-key\": \"Korçë\",\"value\": 43221.26},{ \"hc-key\": \"Krujë\",\"value\": 25488.8},{ \"hc-key\": \"Kuçovë\",\"value\": 6806.54},{ \"hc-key\": \"Kukës\",\"value\": 2584},{ \"hc-key\": \"Kurbin\",\"value\": 5268.34},{ \"hc-key\": \"Lezhë\",\"value\": 9929.41},{ \"hc-key\": \"Libohovë\",\"value\": 620.57},{ \"hc-key\": \"Librazhd\",\"value\": 3792},{ \"hc-key\": \"Lushnjë\",\"value\": 21700.04},{ \"hc-key\": \"Malësi e Madhe\",\"value\": 2114.14},{ \"hc-key\": \"Maliq\",\"value\": 5018.51},{ \"hc-key\": \"Mallakaster\",\"value\": 21067.66},{ \"hc-key\": \"Mat\",\"value\": 5107.06},{ \"hc-key\": \"Memaliaj\",\"value\": 952.97},{ \"hc-key\": \"Mirditë\",\"value\": 1569.1},{ \"hc-key\": \"Patos\",\"value\": 21537.85},{ \"hc-key\": \"Peqin\",\"value\": 3438.55},{ \"hc-key\": \"Përmet\",\"value\": 3247},{ \"hc-key\": \"Pogradec\",\"value\": 14904.12},{ \"hc-key\": \"Poliçan\",\"value\": 2388.85},{ \"hc-key\": \"Prrenjas\",\"value\": 519},{ \"hc-key\": \"Pukë\",\"value\": 1813.4},{ \"hc-key\": \"Pustec\",\"value\": 212.36},{ \"hc-key\": \"Roskovec\",\"value\": 5042.17},{ \"hc-key\": \"Rrogozhinë\",\"value\": 5666.32},{ \"hc-key\": \"Sarandë\",\"value\": 13657.52},{ \"hc-key\": \"Selenicë\",\"value\": 6707.07},{ \"hc-key\": \"Shijak\",\"value\": 9024},{ \"hc-key\": \"Shkodër\",\"value\": 33257.22},{ \"hc-key\": \"Skrapar\",\"value\": 1649.03},{ \"hc-key\": \"Tepelenë\",\"value\": 2157.6},{ \"hc-key\": \"Tiranë\",\"value\": 406772.49},{ \"hc-key\": \"Tropojë\",\"value\": 939.94},{ \"hc-key\": \"Ura_Vajgurore\",\"value\": 4433.03},{ \"hc-key\": \"Vau I Dejës\",\"value\": 7461.57},{ \"hc-key\": \"Vlorë\",\"value\": 41223.78},{ \"hc-key\": \"Vorë\",\"value\": 8531.71} lidhesi = new Requirenments(); DataTable tedhenatPerGrafik = lidhesi.MerTeDhenatGrupMunicipalityByPeriudha(dropViti.SelectedValue.ToString(), dropIndikatori.SelectedValue.ToString()).Copy(); for (int i = 0; i < tedhenatPerGrafik.Rows.Count; i++) { data += "{ \"hc-key\": \"" + tedhenatPerGrafik.Rows[i].ItemArray[0].ToString().ToUpper() + "\",\"value\": " + tedhenatPerGrafik.Rows[i].ItemArray[2].ToString() + "}"; if (i < tedhenatPerGrafik.Rows.Count - 1) { data += ","; } } string s = File.ReadAllText(@"c:\data\d.txt"); s = s.Replace("<%Title%>", "Shperndarja sipas 61 Bashkive per Indikatorin " + dropIndikatori.SelectedItem.Text + " gjate Vitit " + dropViti.SelectedItem.Text); s = s.Replace("<%color%>", "#eeeeee"); s = s.Replace("<%data%>", data); form1.InnerHtml = s; }
private void merRegjione() { lidhesi = new Requirenments(); dropGrupNjesite.Enabled = true; dropGrupNjesite.DataSource = lidhesi.MerRegjione().Copy(); dropGrupNjesite.DataTextField = "region"; dropGrupNjesite.DataBind(); }
private void merVitet() { lidhesi = new Requirenments(); chkVitet.DataSource = lidhesi.MerPeriudha().Copy(); chkVitet.DataValueField = "nrrendor"; chkVitet.DataTextField = "year"; chkVitet.DataBind(); }
protected void dropGrupTreguesi_SelectedIndexChanged(object sender, EventArgs e) { lidhesi = new Requirenments(); dropIndikatori.DataSource = lidhesi.MerIndikatoretEGrupit(dropGrupTreguesi.SelectedValue.ToString()).Copy(); dropIndikatori.DataValueField = "nrrendor"; dropIndikatori.DataTextField = "nomination"; dropIndikatori.DataBind(); }
protected void dropIndikator_SelectedIndexChanged(object sender, EventArgs e) { lidhesi = new Requirenments(); chkIndikatoret.DataSource = lidhesi.MerIndikatoretEGrupit(dropIndikator.SelectedValue.ToString()).Copy(); chkIndikatoret.DataValueField = "nrrendor"; chkIndikatoret.DataTextField = "nomination"; chkIndikatoret.DataBind(); grafiku.InnerHtml = ""; }
protected void dropRegjione_TextChanged(object sender, EventArgs e) { if (dropRegjione.Text != null) { lidhesi = new Requirenments(); chkNjesite.DataSource = lidhesi.merLguByRegion(dropRegjione.Text.ToString()).Copy(); chkNjesite.DataValueField = "nrrendor"; chkNjesite.DataTextField = "lgu"; chkNjesite.DataBind(); grafiku.InnerHtml = ""; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { lidhesi = new Requirenments(); dropGrupTreguesi.DataSource = lidhesi.MerGrupIndikatore().Copy(); dropGrupTreguesi.DataValueField = "nrrendor"; dropGrupTreguesi.DataTextField = "IndGropu"; dropGrupTreguesi.DataBind(); dropViti.DataSource = lidhesi.MerPeriudha().Copy(); dropViti.DataValueField = "nrrendor"; dropViti.DataTextField = "year"; dropViti.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { lidhesi = new Requirenments(); dropGrupTreguesi.DataSource = lidhesi.MerGrupIndikatore().Copy(); dropGrupTreguesi.DataValueField = "nrrendor"; dropGrupTreguesi.DataTextField = "IndGropu"; dropGrupTreguesi.DataBind(); dropRegjione.DataSource = lidhesi.MerRegjione().Copy(); dropRegjione.DataTextField = "region"; dropRegjione.DataBind(); chkVitet.DataSource = lidhesi.MerPeriudha().Copy(); chkVitet.DataValueField = "nrrendor"; chkVitet.DataTextField = "year"; chkVitet.DataBind(); chkNjesite.Items.Clear(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { lidhesi = new Requirenments(); dropIndikator.DataSource = lidhesi.MerGrupIndikatore().Copy(); dropIndikator.DataValueField = "nrrendor"; dropIndikator.DataTextField = "IndGropu"; dropIndikator.DataBind(); chkNjesite.DataSource = lidhesi.MerMunicipality().Copy(); chkNjesite.DataTextField = "municipality"; chkNjesite.DataBind(); dropVitet.DataSource = lidhesi.MerPeriudha().Copy(); dropVitet.DataValueField = "nrrendor"; dropVitet.DataTextField = "year"; dropVitet.DataBind(); chkIndikatoret.Items.Clear(); grafiku.InnerHtml = ""; } }
protected void tegjitha_CheckedChanged(object sender, EventArgs e) { if (tegjitha.Checked) { dropRegjione.Enabled = false; lidhesi = new Requirenments(); chkNjesite.DataSource = lidhesi.merLgu().Copy(); chkNjesite.DataValueField = "nrrendor"; chkNjesite.DataTextField = "lgu"; chkNjesite.DataBind(); grafiku.InnerHtml = ""; } else { dropRegjione.Enabled = true; lidhesi = new Requirenments(); chkNjesite.DataSource = lidhesi.merLguByRegion(dropRegjione.Text.ToString()).Copy(); chkNjesite.DataValueField = "nrrendor"; chkNjesite.DataTextField = "lgu"; chkNjesite.DataBind(); grafiku.InnerHtml = ""; } }
private void GjeneroGrafik4() { //ErrorLabel.Text = ""; grafiku.InnerHtml = ""; string selectedValueNjesite = ""; foreach (ListItem item in chkNjesite.Items) { if (item.Selected) { selectedValueNjesite += "'" + item.Text.ToString() + "',"; } } if (selectedValueNjesite.Length == 0) { //throw error ska njesi vendore te zgjedhura //ErrorLabel.Text = "Zgjidhni te pakten nje Njesi Vendore"; return; } ////////////////////// string selectedValueIndikatoret = dropIndikatoret.SelectedValue.ToString(); string selectedValueVitet = ""; foreach (ListItem item in chkVitet.Items) { if (item.Selected) { selectedValueVitet += item.Value.ToString() + ","; } } if (selectedValueVitet.Length == 0) { //throw error ska njesi vendore te zgjedhura //ErrorLabel.Text = "Zgjidhni te pakten nje Njesi Vendore"; return; } selectedValueNjesite = selectedValueNjesite.Substring(0, selectedValueNjesite.Length - 1); selectedValueVitet = selectedValueVitet.Substring(0, selectedValueVitet.Length - 1); ////////////////////// lidhesi = new Requirenments(); DataTable tedhenatPerGrafik = lidhesi.MerTeDhenatByMunicipalityPeriudha(selectedValueVitet, selectedValueNjesite, selectedValueIndikatoret).Copy(); if (tedhenatPerGrafik.Rows.Count > 0) { string zevendesimi = ""; string[] njesite = selectedValueNjesite.Split(','); string[] vitet = selectedValueVitet.Split(','); zevendesimi += "['Vitet',"; for (int i = 0; i < njesite.Length; i++) { zevendesimi += njesite[i].ToString(); if (i < njesite.Length - 1) { zevendesimi += ","; } } zevendesimi += "]," + Environment.NewLine; DataTable Mesataret = lidhesi.MerTeDhenatMesatareVitIndikator(selectedValueVitet, selectedValueIndikatoret).Copy(); for (int j = 0; j < vitet.Length; j++) { zevendesimi += "["; DataTable emriVitet = lidhesi.MerVitinSipasIndex(vitet[j]).Copy(); if (emriVitet.Rows.Count > 0) { zevendesimi += "'" + emriVitet.Rows[0].ItemArray[0].ToString() + "'"; } for (int k = 0; k < njesite.Length; k++) { int z = 0; for (int m = 0; m < tedhenatPerGrafik.Rows.Count; m++) { if (tedhenatPerGrafik.Rows[m].ItemArray[1].ToString().Equals(vitet[j]) && tedhenatPerGrafik.Rows[m].ItemArray[0].ToString().Equals(njesite[k].Replace("'", ""))) { zevendesimi += "," + tedhenatPerGrafik.Rows[m].ItemArray[2].ToString(); z++; } } if (z == 0) { zevendesimi += ",0"; } } zevendesimi += "],"; } zevendesimi = zevendesimi.Substring(0, zevendesimi.Length - 1); string s = File.ReadAllText(@"c:/data/b.txt"); s = s.Replace("<%Title%>", "Ecuria ne Vitet e Zgjedhura "); grafiku.InnerHtml = s.Replace("<%data%>", zevendesimi); } }
protected void Button1_Click(object sender, EventArgs e) { //ErrorLabel.Text = ""; grafiku.InnerHtml = ""; string selectedValueNjesite = ""; foreach (ListItem item in chkNjesite.Items) { if (item.Selected) { selectedValueNjesite += item.Value.ToString() + ","; } } if (selectedValueNjesite.Length == 0) { //throw error ska njesi vendore te zgjedhura //ErrorLabel.Text = "Zgjidhni te pakten nje Njesi Vendore"; return; } selectedValueNjesite = selectedValueNjesite.Substring(0, selectedValueNjesite.Length - 1); string selectedValueVitet = ""; foreach (ListItem item in chkVitet.Items) { if (item.Selected) { selectedValueVitet += item.Value.ToString() + ","; } } if (selectedValueVitet.Length == 0) { //throw error ska vite te zgjedhura //ErrorLabel.Text = "Zgjidhni te pakten nje Periudhe"; return; } selectedValueVitet = selectedValueVitet.Substring(0, selectedValueVitet.Length - 1); if (dropIndikatori.SelectedValue == null || dropIndikatori.SelectedValue == "") { //throw error ska indikator //ErrorLabel.Text = "Nuk keni zgjedhur Treguesin"; return; } lidhesi = new Requirenments(); DataTable tedhenatPerGrafik = lidhesi.MerTeDhenat(selectedValueVitet, selectedValueNjesite, dropIndikatori.SelectedValue.ToString()).Copy(); if (tedhenatPerGrafik.Rows.Count > 0) { string zevendesimi = ""; string[] vitet = selectedValueVitet.Split(','); string[] njesite = selectedValueNjesite.Split(','); zevendesimi += "['Vitet',"; for (int i = 0; i < njesite.Length; i++) { DataTable emriIndikatorit = lidhesi.MerLGUSipasIndex(njesite[i]).Copy(); if (emriIndikatorit.Rows.Count > 0) { zevendesimi += "'" + emriIndikatorit.Rows[0].ItemArray[0].ToString() + "'"; } if (i < njesite.Length - 1) { zevendesimi += ","; } } zevendesimi += "]," + Environment.NewLine; for (int j = 0; j < vitet.Length; j++) { zevendesimi += "["; DataTable emriIVitit = lidhesi.MerVitinSipasIndex(vitet[j]).Copy(); if (emriIVitit.Rows.Count > 0) { zevendesimi += "'" + emriIVitit.Rows[0].ItemArray[0].ToString() + "'"; } for (int k = 0; k < njesite.Length; k++) { for (int m = 0; m < tedhenatPerGrafik.Rows.Count; m++) { if (tedhenatPerGrafik.Rows[m].ItemArray[2].ToString().Equals(njesite[k])) { zevendesimi += "," + tedhenatPerGrafik.Rows[m].ItemArray[4].ToString(); } } } zevendesimi += "],"; } string s = File.ReadAllText(@"c:/data/a.txt"); grafiku.InnerHtml = s.Replace("<%data%>", zevendesimi); } }
protected void Button3_Click(object sender, EventArgs e) { //ErrorLabel.Text = ""; grafiku.InnerHtml = ""; string selectedValueNjesite = ""; foreach (ListItem item in chkNjesite.Items) { if (item.Selected) { selectedValueNjesite += "'" + item.Text.ToString() + "',"; } } if (selectedValueNjesite.Length == 0) { //throw error ska njesi vendore te zgjedhura //ErrorLabel.Text = "Zgjidhni te pakten nje Njesi Vendore"; return; } ////////////////////// string selectedValueIndikatoret = ""; foreach (ListItem item in chkIndikatoret.Items) { if (item.Selected) { selectedValueIndikatoret += item.Value.ToString() + ","; } } if (selectedValueIndikatoret.Length == 0) { //throw error ska njesi vendore te zgjedhura //ErrorLabel.Text = "Zgjidhni te pakten nje Njesi Vendore"; return; } /////////////////////// selectedValueNjesite = selectedValueNjesite.Substring(0, selectedValueNjesite.Length - 1); selectedValueIndikatoret = selectedValueIndikatoret.Substring(0, selectedValueIndikatoret.Length - 1); string selectedValueVitet = dropVitet.SelectedValue.ToString(); if (dropIndikator.SelectedValue == null || dropIndikator.SelectedValue == "") { //throw error ska indikator //ErrorLabel.Text = "Nuk keni zgjedhur Treguesin"; return; } lidhesi = new Requirenments(); DataTable tedhenatPerGrafik = lidhesi.MerTeDhenatByMunicipality(selectedValueVitet, selectedValueNjesite, selectedValueIndikatoret).Copy(); if (tedhenatPerGrafik.Rows.Count > 0) { string zevendesimi = ""; string[] njesite = selectedValueNjesite.Split(','); string[] indikatoret = selectedValueIndikatoret.Split(','); zevendesimi += "['Njesite Vendore',"; for (int i = 0; i < indikatoret.Length; i++) { DataTable emriIndikatorit = lidhesi.MerIndikatoretSipasIndex(indikatoret[i]).Copy(); if (emriIndikatorit.Rows.Count > 0) { zevendesimi += "'" + emriIndikatorit.Rows[0].ItemArray[0].ToString() + "'"; } if (i < indikatoret.Length - 1) { zevendesimi += ","; } } zevendesimi += "]," + Environment.NewLine; for (int j = 0; j < njesite.Length; j++) { zevendesimi += "["; zevendesimi += njesite[j].ToString(); for (int k = 0; k < indikatoret.Length; k++) { for (int m = 0; m < tedhenatPerGrafik.Rows.Count; m++) { if (tedhenatPerGrafik.Rows[m].ItemArray[0].ToString().Equals(njesite[j].Replace("'", "")) && tedhenatPerGrafik.Rows[m].ItemArray[1].ToString().Equals(indikatoret[k])) { zevendesimi += "," + tedhenatPerGrafik.Rows[m].ItemArray[2].ToString(); } } } zevendesimi += "],"; } string s = File.ReadAllText(@"c:/data/b.txt"); s = s.Replace("<%Title%>", "Ecuria per Vitin: " + dropVitet.Text); s = s.Replace("<%Subtitle%>", "Grafiku gjeneruar sipas indikatoreve te zgjedhur."); grafiku.InnerHtml = s.Replace("<%data%>", zevendesimi); } }