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