public ActionResult Edit(int id)
{
if (Session["UserID"] != null)
{
SkontoBusiness sb = new SkontoBusiness();
Skonto sk = sb.Skontot.Single(s => s.id == id);
return(View(sk));
}
else
{
return(RedirectToAction("Index", "Hyrje"));
}
}
protected void bind()
{
DataClasses1DataContext financa_sh = new DataClasses1DataContext();
Skonto sk = new Skonto();
Nxenesi nx = new Nxenesi();
var sk_nx = from c in financa_sh.Skontos
from c1 in financa_sh.Nxenesis
where (c1.Id_nxenesi == c.Id_nxenesi) && (c1.Klasa == Klasaddl.SelectedItem.Text) && (c1.Indeksi == Indeksiddl.SelectedItem.Text) && (c1.Viti_shkollor == vitiddl1.SelectedItem.Text)
select new { c1.Id_nxenesi, c1.Emri, c1.Mbiemri, c.Ulje_1, c.Ulje_2, c.Ulje_3, c.Ulje_4, c.Ulje_5, c.Ulje_6, c.Ulje_7, c.Ulje_8, c.Ulje_9, c.Ulje_10, c.Ulje_11, c.Ulje_12 };
GridView1.DataSource = sk_nx;
GridView1.DataBind();
}
protected bool ka_pagesa(long id_nx)
{
DataClasses1DataContext financa_sh = new DataClasses1DataContext();
Nxenesi nxenesit = new Nxenesi();
Skonto sk = new Skonto();
Transporti tr = new Transporti();
bool ka_trans, ka_keste, ka_prenotim;
var trans = from c in financa_sh.Transportis
where (c.Id_nxenesi == id_nx)
select c;
if (trans.Count() == 0)
{
ka_trans = false;
}
else
{
ka_trans = true;
}
var ka_skonto = from c in financa_sh.Skontos
where (c.Id_nxenesi == id_nx)
select c;
if (ka_skonto.Count() == 0)
{
ka_keste = false;
}
else
{
ka_keste = true;
}
var prenotim = from c in financa_sh.Prenotimis
where (c.Id_nxenesi == id_nx)
select c;
if (prenotim.FirstOrDefault().Paguar == false)
{
ka_prenotim = false;
}
else
{
ka_prenotim = true;
}
return(ka_keste || ka_trans || ka_prenotim);
}
protected bool ka_keste1(Int64 id)
{
DataClasses1DataContext financa_sh = new DataClasses1DataContext();
Skonto sk = new Skonto();
var s_nxenesi = from c in financa_sh.Transportis
where (c.Id_nxenesi == id)
select new { c.Id_nxenesi };
if (s_nxenesi.Count() == 0)
{
return(false);
}
else
{
return(true);
}
}
protected void bind()
{
DataClasses1DataContext financa_sh = new DataClasses1DataContext();
Skonto sk = new Skonto();
Nxenesi nx = new Nxenesi();
var sk_nx = from c in financa_sh.Skontos
from c1 in financa_sh.Nxenesis
from c2 in financa_sh.Kestets
where (c1.Id_nxenesi == c.Id_nxenesi) && (c1.Viti_shkollor == vitiddl1.SelectedItem.Text) && (c2.Id_nxenesi == c.Id_nxenesi)
//group c by new { c1.Id_nxenesi, c1.Emri, c1.Mbiemri, c2.Vlera, c.Ulje_1, c.Ulje_2, c.Ulje_3, c.Ulje_4, c.Ulje_5, c.Ulje_6, c.Ulje_7, c.Ulje_8, c.Ulje_9, c.Ulje_10, c.Ulje_11, c.Ulje_12 }
// into r
// select new {convert.to r.Key.Ulje_1.Value.ToString()*10};
select new { c1.Id_nxenesi, c1.Emri, c1.Mbiemri, c2.Vlera, s1 = c.Ulje_1 * c2.Vlera / 10, c.Ulje_2, c.Ulje_3, c.Ulje_4, c.Ulje_5, c.Ulje_6, c.Ulje_7, c.Ulje_8, c.Ulje_9, c.Ulje_10, c.Ulje_11, c.Ulje_12 };
GridView1.DataSource = sk_nx.Distinct();
GridView1.DataBind();
}
public ActionResult Edit(Skonto sk)
{
if (Session["UserID"] != null)
{
SkontoBusiness sb = new SkontoBusiness();
if (ModelState.IsValid)
{
sb.modifiko(sk);
return(RedirectToAction("Index", "Skonto"));
}
else
{
return(View());
}
}
{
return(RedirectToAction("Index", "Hyrje"));
}
}
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);
}
