protected void bind()
{
DataClasses1DataContext financa_sh = new DataClasses1DataContext();
Kestet k = new Kestet();
Pagesa p = new Pagesa();
GridView1.SelectedIndex = -1;
var pag_n = from c in financa_sh.Kestets
from d in financa_sh.Pagesas
from pg in financa_sh.Prenotimis
where ((c.Id_nxenesi.ToString() == Nxenesiddl.SelectedValue) && (c.Id_pagesa == d.Id_pagesa) && (d.Anulluar == false)) || ((pg.Id_pagesa == d.Id_pagesa) && (pg.Id_nxenesi == Convert.ToInt64(Nxenesiddl.SelectedItem.Value)))
select new { d.Id_pagesa, d.Data, d.Totali, d.Monedha, d.Skonto, d.Penaliteti, d.Nr_kestesh, d.Koment, tr = (from t in financa_sh.Arkas
where (t.Id_transaksioni == d.Id_transaksioni)
select t).FirstOrDefault().Vendndodhja.ToString() };
GridView1.DataSource = pag_n.Distinct();
GridView1.DataBind();
if (GridView1.Rows.Count == 0)
{
Label6.Visible = false;
Label8.Visible = false;
}
else
{
Label6.Visible = true;
Label8.Visible = true;
}
}
protected void bind()
{
DataClasses1DataContext financa_sh = new DataClasses1DataContext();
Kestet k = new Kestet();
Pagesa p = new Pagesa();
//var pag_n = from c in financa_sh.Kestets
// from d in financa_sh.Pagesas
// where (c.Id_nxenesi.ToString() == Nxenesiddl.SelectedValue) && (c.Id_pagesa == d.Id_pagesa)
// select new
// {
// d.Id_pagesa,
// d.Data,
// d.Totali,
// d.Monedha,
// d.Skonto,
// d.Penaliteti,
// tr = (from t in financa_sh.Arkas
// where (t.Id_transaksioni == d.Id_transaksioni)
// select t).FirstOrDefault().Koment.ToString().Remove(0,7)
// };
var pag_n = from c in financa_sh.Transportis
from d in financa_sh.Pagesas
where (c.Id_nxenesi.ToString() == Nxenesiddl.SelectedValue) && (c.Id_pagesa == d.Id_pagesa) && (d.Anulluar == false)
select new { d.Id_pagesa, d.Data, d.Totali, d.Monedha, d.Skonto, d.Penaliteti, d.Nr_kestesh, d.Koment, tr = (from t in financa_sh.Arkas
where (t.Id_transaksioni == d.Id_transaksioni)
select t).FirstOrDefault().Vendndodhja.ToString() };
GridView1.DataSource = pag_n.Distinct();
GridView1.DataBind();
}
protected void in_koment(long id_tr, string koment)
{
DataClasses1DataContext financa_sh = new DataClasses1DataContext();
Kestet k = new Kestet();
Pagesa pag = new Pagesa();
Arka a = new Arka();
var kom_tr = from c in financa_sh.Arkas
where c.Id_transaksioni == id_tr
select c;
kom_tr.FirstOrDefault().Koment = koment;
financa_sh.SubmitChanges();
}
protected bool ka_pag_keste_tegjitha(Int64 id)
{
DataClasses1DataContext financa_sh = new DataClasses1DataContext();
Kestet sk = new Kestet();
var s_nxenesi = from c in financa_sh.Transportis
where (c.Id_nxenesi == id) && (c.Paguar == false)
select new { c.Id_nxenesi };
if (s_nxenesi.Count() == 0)
{
return(true);
}
else
{
return(false);
}
}
protected bool ka_keste(Int64 ID)
{
DataClasses1DataContext financa_sh = new DataClasses1DataContext();
Kestet nx_keste = new Kestet();
var nx_k = from c in financa_sh.Kestets
where (c.Id_nxenesi == ID)
select new { c.Id_nxenesi };
if (nx_k.Count() == 0)
{
return(false);
}
else
{
return(true);
}
}
protected void bind()
{
DataClasses1DataContext financa_sh = new DataClasses1DataContext();
Kestet k = new Kestet();
Nxenesi n = new Nxenesi();
var nxenesit_keste_1 = from d in financa_sh.Nxenesis
from c in financa_sh.Kestets
where (c.Id_nxenesi == d.Id_nxenesi) && (d.Viti_shkollor == vitiddl1.SelectedItem.Text) && (d.Klasa == Klasaddl.SelectedItem.Text) && (d.Indeksi == Indeksiddl.SelectedItem.Text)
group c by new { d.Emri, d.Mbiemri, c.Vlera } into kestet_sum_1
select new
{
emri1 = kestet_sum_1.Key.Emri, mbiemri1 = kestet_sum_1.Key.Mbiemri,
keste_pa = kestet_sum_1.Count(x => x.Paguar == true),
keste_paguar = kestet_sum_1.Count(x => ((x.Paguar == false) && (x.Aktiv == true))),
vlera_paguar = kestet_sum_1.Key.Vlera * kestet_sum_1.Count(x => ((x.Paguar == false) && (x.Aktiv == true))),
vlera_papag = kestet_sum_1.Key.Vlera * kestet_sum_1.Count(x => x.Paguar == true)
};
GridView1.DataSource = nxenesit_keste_1;
GridView1.DataBind();
if (GridView1.Rows.Count > 0)
{
Label4.Visible = true;
Label5.Visible = true;
Label6.Visible = true;
Label7.Visible = true;
Button1.Visible = true;
}
else
{
Button1.Visible = false;
Label4.Visible = false;
Label5.Visible = false;
Label6.Visible = false;
Label7.Visible = false;
}
Label2.Text = Convert.ToString(kesti_kuq());
}
protected bool ka_keste(Int64 ID)//shikon nqs ka keste
{
DataClasses1DataContext financa_sh = new DataClasses1DataContext();
Kestet nx_keste = new Kestet();
Transporti tr = new Transporti();
var nx_k = from c in financa_sh.Transportis
where (c.Id_nxenesi == ID)
select new { c.Id_nxenesi };
if (nx_k.Count() == 0)
{
return(false);
}
else
{
return(true);
}
}
public decimal gjej_kestin()
{
DataClasses1DataContext financa_sh = new DataClasses1DataContext();
Kestet nxenesi_kest = new Kestet();
decimal kesti = 0;
var nxenesi_k = from c in financa_sh.Kestets
where (c.Id_nxenesi.ToString() == Nxenesiddl.SelectedValue)
select new { c.Vlera };
if (nxenesi_k.Count() > 0)
{
kesti = nxenesi_k.FirstOrDefault().Vlera;
return(kesti);
}
else
{
return(0);
}
}
protected void bind1()
{
DataClasses1DataContext financa_sh = new DataClasses1DataContext();
Kestet k = new Kestet();
Nxenesi n = new Nxenesi();
var nxenesit_keste_11 = from d in financa_sh.Nxenesis
from c in financa_sh.Kestets
where (c.Id_nxenesi == d.Id_nxenesi) && (d.Viti_shkollor == vitiddl1.SelectedItem.Text)
group c by new { d.Emri, d.Mbiemri, c.Vlera } into kestet_sum_1
select new
{
emri1 = kestet_sum_1.Key.Emri,
mbiemri1 = kestet_sum_1.Key.Mbiemri,
keste_pa = kestet_sum_1.Count(x => x.Paguar == true),
keste_paguar = kestet_sum_1.Count(x => ((x.Paguar == false) && (x.Aktiv == true))),
vlera_paguar = kestet_sum_1.Key.Vlera * kestet_sum_1.Count(x => ((x.Paguar == false) && (x.Aktiv == true))),
vlera_papag = kestet_sum_1.Key.Vlera * kestet_sum_1.Count(x => x.Paguar == true)
};
if (nxenesit_keste_11.Count() == 0)
{
Label9.Text = "0";
}
Label11.Text = "0";
GridView2.DataSource = nxenesit_keste_11;
GridView2.DataBind();
//Label2.Text = Convert.ToString(kesti_kuq());
//if (nxenesit_keste_1.Count() >= 0)
// Button1.Visible = true;
//else
// Button1.Visible = false;
}
protected void bind()
{
DataClasses1DataContext financa_sh = new DataClasses1DataContext();
Kestet k = new Kestet();
Nxenesi n = new Nxenesi();
Transporti t = new Transporti();
var nxenesit_keste_1 = from d in financa_sh.Nxenesis
from c in financa_sh.Transportis
where (c.Id_nxenesi == d.Id_nxenesi) && (d.Viti_shkollor == vitiddl1.SelectedItem.Text) && (d.Klasa == Klasaddl.SelectedItem.Text) && (d.Indeksi == Indeksiddl.SelectedItem.Text)
group c by new { d.Emri, d.Mbiemri } into kestet_sum_1
select new
{
emri1 = kestet_sum_1.Key.Emri, mbiemri1 = kestet_sum_1.Key.Mbiemri,
keste_pa = kestet_sum_1.Count(x => x.Paguar == true),
keste_paguar = kestet_sum_1.Count(x => ((x.Paguar == false) && (x.Aktiv == true)))
};
GridView1.DataSource = nxenesit_keste_1;
GridView1.DataBind();
Label2.Text = Convert.ToString(kesti_kuq());
}
protected void Button1_Click(object sender, EventArgs e)
{
DataClasses1DataContext financa_sh = new DataClasses1DataContext();
Kestet k = new Kestet();
CheckBox chbTemp1 = GridView1.Rows[0].FindControl("CheckBox1") as CheckBox;
//aktiv = true ne tabelen e kesteve te transportit
var keste_pa = from c in financa_sh.Kestets
where (c.Id_nxenesi.ToString() == Nxenesiddl.SelectedValue) && (c.Paguar == false)
select c;
int count = 0;
foreach (var d in keste_pa)
{
CheckBox chbTemp = GridView1.Rows[count].FindControl("CheckBox1") as CheckBox;
if (chbTemp.Checked == false)
{
d.Aktiv = false;
}
else
{
d.Aktiv = true;
}
count = count + 1;
}
financa_sh.SubmitChanges();
GridViewRow row = GridView1.Rows[0];
msbox("Pagesa u krye !");
hide();
}
protected void Button1_Click(object sender, EventArgs e)
{
DataClasses1DataContext financa_sh = new DataClasses1DataContext();
Kestet k = new Kestet();
Pagesa pag = new Pagesa();
Arka a = new Arka();
CheckBox chbTemp1 = GridView1.Rows[0].FindControl("CheckBox1") as CheckBox;
int j = 0;
// gjen sa chckbox jane te chekuara
for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox chbTemp = GridView1.Rows[i].FindControl("CheckBox1") as CheckBox;
if ((chbTemp.Checked) && (chbTemp.Enabled == true))
{
j = j + 1;
}
}
if (j > 0)
{
//insert te tabela e arkes
var vlera_fundit = from t in financa_sh.Arkas
orderby t.Id_transaksioni descending
select new { t.Tot_E, t.Tot_L, t.Tot_S };
if (valutalbl0.Text == "EUR")
{
a.Tot_E = vlera_fundit.FirstOrDefault().Tot_E + Convert.ToDecimal(totalilbl.Text);
a.Tot_L = vlera_fundit.FirstOrDefault().Tot_L + 0;
a.Tot_S = vlera_fundit.FirstOrDefault().Tot_S + 0;
}
if (valutalbl0.Text == "USD")
{
a.Tot_S = vlera_fundit.FirstOrDefault().Tot_S + Convert.ToDecimal(totalilbl.Text);
a.Tot_L = vlera_fundit.FirstOrDefault().Tot_L + 0;
a.Tot_E = vlera_fundit.FirstOrDefault().Tot_E + 0;
}
if (valutalbl0.Text == "LEK")
{
a.Tot_L = vlera_fundit.FirstOrDefault().Tot_L + Convert.ToDecimal(totalilbl.Text);
a.Tot_E = vlera_fundit.FirstOrDefault().Tot_E + 0;
a.Tot_S = vlera_fundit.FirstOrDefault().Tot_S + 0;
}
a.Vendndodhja = DropDownList1.SelectedItem.Text;
a.Data = DateTime.Now;
a.Modifikuar_nga = HttpContext.Current.User.Identity.Name;
a.Vlera = Convert.ToDecimal(totalilbl.Text);
a.Valuta = valutalbl0.Text;
financa_sh.Arkas.InsertOnSubmit(a);
financa_sh.SubmitChanges();
// gjej id e transaksionit e fundit
var tr_fundit = from t in financa_sh.Arkas
orderby t.Id_transaksioni descending
select t.Id_transaksioni;
//insert te tabela e pageses
pag.Data = DateTime.Now;
pag.Monedha = valutalbl0.Text;
pag.Totali = Convert.ToDecimal(totalilbl.Text);
pag.Skonto = Convert.ToDecimal(skontolbl.Text);
pag.Penaliteti = Convert.ToDecimal(penlbl.Text);
pag.Id_transaksioni = tr_fundit.FirstOrDefault();
pag.Nr_kestesh = j;
pag.Koment = datepicker0.Text;
pag.Anulluar = false;
financa_sh.Pagesas.InsertOnSubmit(pag);
financa_sh.SubmitChanges();
// gjej id e pag e fundit
var pg_fundit = from t in financa_sh.Pagesas
orderby t.Id_pagesa descending
select t.Id_pagesa;
//paguar = true ne tabelen e kesteve te transportit
var keste_pa = from c in financa_sh.Transportis
where (c.Id_nxenesi.ToString() == Nxenesiddl.SelectedValue) //&& (c.Paguar == false)
select c;
int numer_keste = 0;
int count = 0;
foreach (var d in keste_pa)
{
CheckBox chbTemp = GridView1.Rows[count].FindControl("CheckBox1") as CheckBox;
if (chbTemp.Checked && chbTemp.Enabled)
{
d.Paguar = true;
d.Id_pagesa = pg_fundit.FirstOrDefault();
numer_keste = numer_keste + 1;
}
count = count + 1;
}
financa_sh.SubmitChanges();
GridViewRow row = GridView1.Rows[0];
string s;
s = (row.Cells[0].Text);
if (s != "0")
{
in_koment(tr_fundit.FirstOrDefault(), "Pagese trans Nr keste : " + numer_keste.ToString() + " Skonto : " + skontolbl.Text + "% Pen : " + penlbl.Text + "%");
}
else
{
in_koment(tr_fundit.FirstOrDefault(), "Pagese trans Nr keste : " + "P + " + (numer_keste - 1).ToString() + " Skonto : " + skontolbl.Text + "% Pen : " + penlbl.Text + "%");
}
msbox("Pagesa u krye !");
hide();
}
else
{
msbox("Duhet te zgjidhni te pakten nje kest !");
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
DataClasses1DataContext financa_sh = new DataClasses1DataContext();
long id = Convert.ToInt64(GridView1.DataKeys[e.RowIndex].Value);
Skonto sk = new Skonto();
Kestet k = new Kestet();
Pagesa pag = new Pagesa();
Arka a = new Arka();
//fshin skontot nga tabela e skontove
var skonto_id = from c in financa_sh.Skontos
where (c.Id_nxenesi == id)
select c;
//kontrollon nese ka pagesa
var join_pg = from pg in financa_sh.Pagesas
from ks in financa_sh.Kestets
where (pg.Id_pagesa == ks.Id_pagesa) && (pg.Anulluar == false)
select pg;
//foreach (var v in join_pg)
//{
// v.Anulluar = true;
// v.Koment = "Anulluar";
//};
//var join_pg1 = from pg in financa_sh.Pagesas
// from ks in financa_sh.Kestets
// where (pg.Id_pagesa == ks.Id_pagesa)
// select ks;
//foreach (var v in join_pg1)
//{
// v.Paguar = false;
//};
//fshin kestet
var kestet_id = from p in financa_sh.Kestets
where (p.Id_nxenesi == id)
select p;
if (join_pg.Count() == 0)
{
financa_sh.Skontos.DeleteAllOnSubmit(skonto_id);
financa_sh.Kestets.DeleteAllOnSubmit(kestet_id);
//financa_sh.Pagesas.DeleteAllOnSubmit(join_pg);
financa_sh.SubmitChanges();
bind();
}
else
{
msbox("Kestet nuk u fshine pasi jane bere pagesa !");
}
////ANULLON transaksionet e bera e bera
//var ar = from ak in financa_sh.Arkas
// from p in join_pg
// where (ak.Id_transaksioni == p.Id_transaksioni)
// select ak;
//foreach (var v in ar)
//{
// v.Anulluar = true;
// v.Koment = "Fshirje kestesh";
//};
}
protected void Krijo_Click(object sender, EventArgs e)
{
DataClasses1DataContext financa_sh = new DataClasses1DataContext();
Skonto skoto = new Skonto();
Kestet kesti3 = new Kestet();
Kestet kesti4 = new Kestet();
Kestet kesti5 = new Kestet();
Kestet kesti6 = new Kestet();
Kestet kesti7 = new Kestet();
Kestet kesti8 = new Kestet();
Kestet kesti9 = new Kestet();
Kestet kesti10 = new Kestet();
//fut skontot te tabela e skontove
skoto.Id_nxenesi = Convert.ToInt32(Nxenesiddl.SelectedValue);
if (b1.Text != "")
{
skoto.Ulje_1 = Convert.ToDecimal(b1.Text);
}
if (b2.Text != "")
{
skoto.Ulje_2 = Convert.ToDecimal(b2.Text);
}
if (b3.Text != "")
{
skoto.Ulje_3 = Convert.ToDecimal(b3.Text);
}
if (b4.Text != "")
{
skoto.Ulje_4 = Convert.ToDecimal(b4.Text);
}
if (b5.Text != "")
{
skoto.Ulje_5 = Convert.ToDecimal(b5.Text);
}
if (b6.Text != "")
{
skoto.Ulje_6 = Convert.ToDecimal(b6.Text);
}
if (u1.Text != "")
{
skoto.Ulje_7 = Convert.ToDecimal(u1.Text);
}
if (u2.Text != "")
{
skoto.Ulje_8 = Convert.ToDecimal(u2.Text);
}
if (u3.Text != "")
{
skoto.Ulje_9 = Convert.ToDecimal(u3.Text);
}
if (u4.Text != "")
{
skoto.Ulje_10 = Convert.ToDecimal(u4.Text);
}
if (u5.Text != "")
{
skoto.Ulje_11 = Convert.ToDecimal(u5.Text);
}
if (u6.Text != "")
{
skoto.Ulje_12 = Convert.ToDecimal(u6.Text);
}
financa_sh.Skontos.InsertOnSubmit(skoto);
//fut kestet te tabela e kesteve
//Kestet prenotimi = new Kestet();
//prenotimi.Id_nxenesi = Convert.ToInt32(Nxenesiddl.SelectedValue);
//prenotimi.Nr_kesti = 0;
//prenotimi.Vlera = Convert.ToInt32(Prenotimilbl.Text.Remove(0, 25));
//prenotimi.Skonto = 0;
//prenotimi.Penaliteti = 0;
//prenotimi.Paguar = false;
//prenotimi.Aktiv = true;
// prenotimi.Fillestar = false;
//financa_sh.Kestets.InsertOnSubmit(prenotimi);
//if (Convert.ToInt16(fillestarddl.SelectedItem.Text) <= 1)
//{
Kestet kesti1 = new Kestet();
kesti1.Id_nxenesi = Convert.ToInt32(Nxenesiddl.SelectedValue);
kesti1.Nr_kesti = 1;
kesti1.Vlera = Convert.ToDecimal(kestetlbl.Text.Remove(0, 18));
kesti1.Skonto = 0;
kesti1.Penaliteti = 0;
kesti1.Paguar = false;
kesti1.Aktiv = true;
// kesti1.Fillestar = false;
financa_sh.Kestets.InsertOnSubmit(kesti1);
// }
//if (Convert.ToInt16(fillestarddl.SelectedItem.Text) <= 2)
//{
Kestet kesti2 = new Kestet();
kesti2.Id_nxenesi = Convert.ToInt32(Nxenesiddl.SelectedValue);
kesti2.Nr_kesti = 2;
kesti2.Vlera = Convert.ToDecimal(kestetlbl.Text.Remove(0, 18));
kesti2.Skonto = 0;
kesti2.Penaliteti = 0;
kesti2.Paguar = false;
kesti2.Aktiv = true;
// kesti2.Fillestar = false;
financa_sh.Kestets.InsertOnSubmit(kesti2);
// }
//if (Convert.ToInt16(fillestarddl.SelectedItem.Text) <= 3)
//{
kesti3.Id_nxenesi = Convert.ToInt32(Nxenesiddl.SelectedValue);
kesti3.Nr_kesti = 3;
kesti3.Vlera = Convert.ToDecimal(kestetlbl.Text.Remove(0, 18));
kesti3.Skonto = 0;
kesti3.Penaliteti = 0;
kesti3.Paguar = false;
kesti3.Aktiv = true;
// kesti3.Fillestar = false;
financa_sh.Kestets.InsertOnSubmit(kesti3);
//}
//if (Convert.ToInt16(fillestarddl.SelectedItem.Text) <= 4)
//{
kesti4.Id_nxenesi = Convert.ToInt32(Nxenesiddl.SelectedValue);
kesti4.Nr_kesti = 4;
kesti4.Vlera = Convert.ToDecimal(kestetlbl.Text.Remove(0, 18));
kesti4.Skonto = 0;
kesti4.Penaliteti = 0;
kesti4.Paguar = false;
kesti4.Aktiv = true;
// kesti4.Fillestar = false;
financa_sh.Kestets.InsertOnSubmit(kesti4);
//}
//if (Convert.ToInt16(fillestarddl.SelectedItem.Text) <= 5)
//{
kesti5.Id_nxenesi = Convert.ToInt32(Nxenesiddl.SelectedValue);
kesti5.Nr_kesti = 5;
kesti5.Vlera = Convert.ToDecimal(kestetlbl.Text.Remove(0, 18));
kesti5.Skonto = 0;
kesti5.Penaliteti = 0;
kesti5.Paguar = false;
kesti5.Aktiv = true;
// kesti5.Fillestar = false;
financa_sh.Kestets.InsertOnSubmit(kesti5);
//}
//if (Convert.ToInt16(fillestarddl.SelectedItem.Text) <= 6)
//{
kesti6.Id_nxenesi = Convert.ToInt32(Nxenesiddl.SelectedValue);
kesti6.Nr_kesti = 6;
kesti6.Vlera = Convert.ToDecimal(kestetlbl.Text.Remove(0, 18));
kesti6.Skonto = 0;
kesti6.Penaliteti = 0;
kesti6.Paguar = false;
kesti6.Aktiv = true;
// kesti6.Fillestar = false;
financa_sh.Kestets.InsertOnSubmit(kesti6);
//}
//if (Convert.ToInt16(fillestarddl.SelectedItem.Text) <= 7)
//{
kesti7.Id_nxenesi = Convert.ToInt32(Nxenesiddl.SelectedValue);
kesti7.Nr_kesti = 7;
kesti7.Vlera = Convert.ToDecimal(kestetlbl.Text.Remove(0, 18));
kesti7.Skonto = 0;
kesti7.Penaliteti = 0;
kesti7.Paguar = false;
kesti7.Aktiv = true;
// kesti7.Fillestar = false;
financa_sh.Kestets.InsertOnSubmit(kesti7);
//}
//if (Convert.ToInt16(fillestarddl.SelectedItem.Text) <= 8)
//{
kesti8.Id_nxenesi = Convert.ToInt32(Nxenesiddl.SelectedValue);
kesti8.Nr_kesti = 8;
kesti8.Vlera = Convert.ToDecimal(kestetlbl.Text.Remove(0, 18));
kesti8.Skonto = 0;
kesti8.Penaliteti = 0;
kesti8.Paguar = false;
kesti8.Aktiv = true;
// kesti8.Fillestar = false;
financa_sh.Kestets.InsertOnSubmit(kesti8);
//}
//if (Convert.ToInt16(fillestarddl.SelectedItem.Text) <= 9)
//{
kesti9.Id_nxenesi = Convert.ToInt32(Nxenesiddl.SelectedValue);
kesti9.Nr_kesti = 9;
kesti9.Vlera = Convert.ToDecimal(kestetlbl.Text.Remove(0, 18));
kesti9.Skonto = 0;
kesti9.Penaliteti = 0;
kesti9.Paguar = false;
kesti9.Aktiv = true;
// kesti9.Fillestar = false;
financa_sh.Kestets.InsertOnSubmit(kesti9);
//}
//if (Convert.ToInt16(fillestarddl.SelectedItem.Text) <= 10)
//{
kesti10.Id_nxenesi = Convert.ToInt32(Nxenesiddl.SelectedValue);
kesti10.Nr_kesti = 10;
kesti10.Vlera = Convert.ToDecimal(kestetlbl.Text.Remove(0, 18));
kesti10.Skonto = 0;
kesti10.Penaliteti = 0;
kesti10.Paguar = false;
kesti10.Aktiv = true;
// kesti10.Fillestar = false;
financa_sh.Kestets.InsertOnSubmit(kesti10);
// }
financa_sh.SubmitChanges();
// ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + "Nxenesit " + Nxenesiddl.SelectedItem.Text + " iu krijuan kestet !" + "');", true);
msbox("Nxenesit " + Nxenesiddl.SelectedItem.Text + " iu krijuan kestet !");
vendos_cmimin(Klasaddl.Text);
}
protected void anullo_keste_shkolla()
{
DataClasses1DataContext financa_sh = new DataClasses1DataContext();
Pagesa p = new Pagesa();
Kestet k = new Kestet();
Arka a = new Arka();
//anullon pagesen
if (TextBox1.Text == "")
{
return;
}
var pag_id = from c in financa_sh.Pagesas
where (c.Id_pagesa == Convert.ToInt64(TextBox1.Text))
select c;
if (pag_id.Count() == 0)
{
return;
}
foreach (var v in pag_id)
{
v.Anulluar = true;
v.Koment = TextBox2.Text;
}
//fshin kestet nqs ka
var kestet_p = from c in financa_sh.Kestets
where (c.Id_pagesa == Convert.ToInt64(TextBox1.Text))
select c;
foreach (var v in kestet_p)
{
v.Paguar = false;
v.Id_pagesa = 0;
}
//anullon transaksionin
var arka_pag = from c in financa_sh.Arkas
where (c.Id_transaksioni == pag_id.FirstOrDefault().Id_transaksioni)
select c;
var vlera_fundit = from t in financa_sh.Arkas
orderby t.Id_transaksioni descending
select new { t.Tot_E, t.Tot_L, t.Tot_S };
if (pag_id.FirstOrDefault().Monedha.Trim() == "EUR")
{
a.Tot_E = vlera_fundit.FirstOrDefault().Tot_E - pag_id.FirstOrDefault().Totali;
a.Tot_L = vlera_fundit.FirstOrDefault().Tot_L + 0;
a.Tot_S = vlera_fundit.FirstOrDefault().Tot_S + 0;
}
if (pag_id.FirstOrDefault().Monedha.Trim() == "USD")
{
a.Tot_S = vlera_fundit.FirstOrDefault().Tot_S - pag_id.FirstOrDefault().Totali;
a.Tot_L = vlera_fundit.FirstOrDefault().Tot_L + 0;
a.Tot_E = vlera_fundit.FirstOrDefault().Tot_E + 0;
}
if (pag_id.FirstOrDefault().Monedha.Trim() == "LEK")
{
a.Tot_L = vlera_fundit.FirstOrDefault().Tot_L - pag_id.FirstOrDefault().Totali;
a.Tot_S = vlera_fundit.FirstOrDefault().Tot_S + 0;
a.Tot_E = vlera_fundit.FirstOrDefault().Tot_E + 0;
}
a.Data = DateTime.Now;
a.Modifikuar_nga = HttpContext.Current.User.Identity.Name;
a.Vendndodhja = arka_pag.FirstOrDefault().Vendndodhja;
a.Vlera = -pag_id.FirstOrDefault().Totali;
a.Valuta = arka_pag.FirstOrDefault().Valuta;
a.Koment = "Anulluar pagesa shkolla nr : " + pag_id.FirstOrDefault().Id_pagesa.ToString();
financa_sh.Arkas.InsertOnSubmit(a);
//a.Anulluar = true;
//a.Koment = "Anulluar pagese nr :" +TextBox1.Text;
//if (pag_id.FirstOrDefault().Monedha.Trim() == "EUR")
// a.Tot_E = a.Tot_E - pag_id.FirstOrDefault().Totali;
//if (pag_id.FirstOrDefault().Monedha.Trim() == "USD")
// a.Tot_S = a.Tot_S - pag_id.FirstOrDefault().Totali;
//if (pag_id.FirstOrDefault().Monedha.Trim() == "LEK")
// a.Tot_L = a.Tot_L - pag_id.FirstOrDefault().Totali;
//financa_sh.Arkas.InsertOnSubmit(a);
// gjen pagesat qe ka bere nxenesi
var kestet_id = from c in financa_sh.Kestets
where (c.Id_nxenesi == kestet_p.FirstOrDefault().Id_nxenesi)
select c;
//nqs ka bere pagesa te mevoneshme nuk ben submit
int i = kestet_id.Count();
foreach (var v in kestet_id)
{
if (v.Id_pagesa > Convert.ToInt64(TextBox1.Text))
{
msbox("Pagesa nuk mund te anullohet sepse nxenesi ka pagesa te metejshme !");
return;
}
}
financa_sh.SubmitChanges();
msbox("Pagesa u anullua me sukses !");
}
