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