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