protected void Button2_Click(object sender, EventArgs e) { DataClasses1DataContext financa_sh = new DataClasses1DataContext(); Nxenesi nxenesit = new Nxenesi(); Prenotimi p = new Prenotimi(); nxenesit.Emri = Convert.ToString(Emritxt.Text); nxenesit.Mbiemri = Convert.ToString(Mbiemritxt.Text); nxenesit.Atesia = Convert.ToString(Atesiatxt.Text); nxenesit.Memesia = Convert.ToString(Memesiatxt.Text); nxenesit.Nr_amza = Convert.ToString(Amzatxt.Text); nxenesit.Nr_tel = Convert.ToString(Teltxt.Text); nxenesit.Ditelindja = Convert.ToString(Ditelindjatxt.Text); nxenesit.Viti_shkollor = Convert.ToString(vitiddl0.SelectedItem.Text); nxenesit.Klasa = Convert.ToString(DropDownList1.SelectedItem.Text); nxenesit.Indeksi = Convert.ToString(DropDownList2.SelectedItem.Text); financa_sh.Nxenesis.InsertOnSubmit(nxenesit); financa_sh.SubmitChanges(); // insert te tebela e prenotimit var nx_fundit = from t in financa_sh.Nxenesis orderby t.Id_nxenesi descending select t.Id_nxenesi; p.Id_nxenesi = nx_fundit.FirstOrDefault(); p.Paguar = false; financa_sh.Prenotimis.InsertOnSubmit(p); financa_sh.SubmitChanges(); bind(); hide_control(); }
protected bool ka_prenotim(long ID) { DataClasses1DataContext financa_sh = new DataClasses1DataContext(); Prenotimi nxenesit = new Prenotimi(); var pr = from c in financa_sh.Prenotimis where (c.Id_nxenesi == ID) && (c.Paguar == false) select new { c }; if (pr.Count() == 0) { return(true); } else { return(false); } }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { DataClasses1DataContext financa_sh = new DataClasses1DataContext(); Nxenesi nxenesit = new Nxenesi(); Prenotimi p = new Prenotimi(); if (e.CommandName.Equals("Insert")) { nxenesit.Emri = Convert.ToString(((TextBox)GridView1.FooterRow.FindControl("TextBox5")).Text); nxenesit.Mbiemri = Convert.ToString(((TextBox)GridView1.FooterRow.FindControl("TextBox6")).Text); nxenesit.Atesia = Convert.ToString(((TextBox)GridView1.FooterRow.FindControl("TextBox7")).Text); nxenesit.Memesia = Convert.ToString(((TextBox)GridView1.FooterRow.FindControl("TextBox8")).Text); nxenesit.Ditelindja = Convert.ToString(((TextBox)GridView1.FooterRow.FindControl("TextBox33")).Text); nxenesit.Nr_amza = Convert.ToString(((TextBox)GridView1.FooterRow.FindControl("TextBox2")).Text); nxenesit.Nr_tel = Convert.ToString(((TextBox)GridView1.FooterRow.FindControl("TextBox9")).Text); nxenesit.Viti_shkollor = Convert.ToString(((DropDownList)GridView1.FooterRow.FindControl("vitiddl")).SelectedItem.Text); nxenesit.Klasa = Convert.ToString(((DropDownList)GridView1.FooterRow.FindControl("DropDownList11")).SelectedItem.Text); nxenesit.Indeksi = Convert.ToString(((DropDownList)GridView1.FooterRow.FindControl("DropDownList22")).SelectedItem.Text); financa_sh.Nxenesis.InsertOnSubmit(nxenesit); financa_sh.SubmitChanges(); var nx_fundit = from t in financa_sh.Nxenesis orderby t.Id_nxenesi descending select t.Id_nxenesi; p.Id_nxenesi = nx_fundit.FirstOrDefault(); p.Paguar = false; financa_sh.Prenotimis.InsertOnSubmit(p); financa_sh.SubmitChanges(); var pg_fundit = from t in financa_sh.Pagesas orderby t.Id_pagesa descending select t.Id_pagesa; p.Id_pagesa = pg_fundit.FirstOrDefault(); bind(); } }
protected void CheckBox1_CheckedChanged1(object sender, EventArgs e) { long id; bool pag_tru; bool chk_enabled; DataClasses1DataContext financa_sh = new DataClasses1DataContext(); // String scriptText = //"return confirm('Do you want to submit the page?')"; // ClientScript.RegisterOnSubmitStatement(this.GetType(), // "alert", scriptText); msbox1("aaa"); if (cmimi_pren() > 0) { for (int i = 0; i < GridView1.Rows.Count; i++) { Prenotimi nxenesit = new Prenotimi(); Pagesa pag = new Pagesa(); Arka a = new Arka(); id = Convert.ToInt64((GridView1.Rows[i].Cells[3].Text).ToString()); var pr_id = financa_sh.Prenotimis.Single (p => p.Id_nxenesi == id); pr_id.Paguar = Convert.ToBoolean(((CheckBox)GridView1.Rows[i].FindControl("CheckBox1")).Checked);// paguan kestet qe jane checked dhe pag = false per ato qe sjane te checkuara pag_tru = pr_id.Paguar; chk_enabled = Convert.ToBoolean(((CheckBox)GridView1.Rows[i].FindControl("CheckBox1")).Enabled); financa_sh.SubmitChanges(); if (pag_tru && chk_enabled) { // 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 (Valuta_pren() == "EUR") { a.Tot_E = vlera_fundit.FirstOrDefault().Tot_E + cmimi_pren(); a.Tot_L = vlera_fundit.FirstOrDefault().Tot_L + 0; a.Tot_S = vlera_fundit.FirstOrDefault().Tot_S + 0; } if (Valuta_pren() == "USD") { a.Tot_S = vlera_fundit.FirstOrDefault().Tot_S + cmimi_pren(); a.Tot_L = vlera_fundit.FirstOrDefault().Tot_L + 0; a.Tot_E = vlera_fundit.FirstOrDefault().Tot_E + 0; } if (Valuta_pren() == "LEK") { a.Tot_L = vlera_fundit.FirstOrDefault().Tot_L + cmimi_pren(); a.Tot_E = vlera_fundit.FirstOrDefault().Tot_E + 0; a.Tot_S = vlera_fundit.FirstOrDefault().Tot_S + 0; } a.Vendndodhja = "Cash"; a.Data = DateTime.Now; a.Modifikuar_nga = HttpContext.Current.User.Identity.Name; a.Vlera = cmimi_pren(); a.Valuta = Valuta_pren(); a.Koment = "Pagese prenotimi shkolla."; 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 = Valuta_pren(); pag.Totali = cmimi_pren(); pag.Skonto = 0; pag.Penaliteti = 0; pag.Id_transaksioni = tr_fundit.FirstOrDefault(); pag.Nr_kestesh = 0; pag.Koment = "Pagese prenotimi"; 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; var pren = from c in financa_sh.Prenotimis where (c.Id_nxenesi == id) select c; foreach (var d in pren) { d.Id_pagesa = pg_fundit.FirstOrDefault(); } financa_sh.SubmitChanges(); } } //insert te tabela se prenotimit //var pg_fundit = from t in financa_sh.Pagesas // orderby t.Id_pagesa descending // select t.Id_pagesa; //var nx_p = from c in financa_sh.Prenotimis // where (c.Id_nxenesi == id) // select c; //int count = 0; //foreach (var d in nx_p) //{ // CheckBox chbTemp = GridView1.Rows[count].FindControl("CheckBox1") as CheckBox; // if (chbTemp.Checked) // { // d.Paguar = true; // d.Id_pagesa = pg_fundit.FirstOrDefault(); // } // count = count + 1; //} //financa_sh.SubmitChanges(); GridView1.EditIndex = -1; bind(); } else { msbox("Klases nuk i jane konfiguruar cmimet per vitin shkollor perkates !"); } }