public List<cash> getcashdata(string date) { List<cash> cd = new List<cash>(); query = " select t.t_id, t.t_dr, t.t_cr,t.t_naration, l.l_name AS dr_name, ll.l_name AS cr_name, "; query += "l.l_groupid AS dr_gid, ll.l_groupid AS cr_gid ,t.t_dramt "; query += " FROM (([transaction] t INNER JOIN ledger l ON t.t_dr = l.l_id) "; query += "INNER JOIN ledger ll ON t.t_cr = ll.l_id) "; query += " where t.t_date = @date and (l.l_groupid = 1 OR l.l_groupid = 14 OR ll.l_groupid = 1 OR ll.l_groupid = 14) "; OleDbCommand cmd = new OleDbCommand(query, con); cmd.Parameters.AddWithValue("date", date); try { con.Open(); OleDbDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { cash s = new cash() { tid = int.Parse(dr.GetValue(0).ToString()), drid = int.Parse(dr.GetValue(1).ToString()), crid = int.Parse(dr.GetValue(2).ToString()), naration = dr.GetValue(3).ToString(), drname = dr.GetValue(4).ToString(), crname = dr.GetValue(5).ToString(), drgid = int.Parse(dr.GetValue(6).ToString()), crgid = int.Parse(dr.GetValue(7).ToString()), amt = double.Parse(dr.GetValue(8).ToString()), }; cd.Add(s); } return cd; } catch (Exception e) { MessageBox.Show(e.ToString()); return cd; } finally { con.Close(); } }
private void addct_Click(object sender, RoutedEventArgs e) { // MessageBox.Show(lid + " "+cid); if (txtamt.Text != "" && txtacshac.Text != "" && txtac.Text != "") { cashmodel ct = new cashmodel(); if (ct.incertcash(cid,lid,Double.Parse(txtamt.Text),txtnaration.Text,dr,dpcashfdate.ToString())) { Show("Succesfull",1); cashtrans.Visibility = Visibility.Hidden; cash c; if (dr) { c = new cash() { tid = ct.tid, drname = txtacshac.Text, drgid = cid, crname = txtac.Text, crid = lid, amt = Double.Parse(txtamt.Text), naration = txtnaration.Text, }; int i = application.tb.Where(x => x.Lid == cid).Select<ledgerbalance, int>(x => application.tb.IndexOf(x)).Single<int>(); application.tb[i].Balance = application.tb[i].Balance + Double.Parse(txtamt.Text); application.tb[i].CurrBalance = application.tb[i].Balance.ToString("C2"); //application.tb[i].BalanceType = "dr"; int j = application.tb.Where(x => x.Lid == lid).Select<ledgerbalance, int>(x => application.tb.IndexOf(x)).Single<int>(); application.tb[j].Balance = application.tb[j].Balance - Double.Parse(txtamt.Text); application.tb[j].CurrBalance = application.tb[j].Balance.ToString("C2"); /// application.tb[i].BalanceType = "dr"; } else { c = new cash() { tid = ct.tid, drname = txtac.Text, drgid = lid, crname = txtacshac.Text , crid = cid, amt = Double.Parse(txtamt.Text), naration = txtnaration.Text, }; int i = application.tb.Where(x => x.Lid == cid).Select<ledgerbalance, int>(x => application.tb.IndexOf(x)).Single<int>(); application.tb[i].Balance = application.tb[i].Balance -Double.Parse(txtamt.Text); application.tb[i].CurrBalance = application.tb[i].Balance.ToString("C2"); //application.tb[i].BalanceType = "dr"; int j = application.tb.Where(x => x.Lid == lid).Select<ledgerbalance, int>(x => application.tb.IndexOf(x)).Single<int>(); application.tb[j].Balance = application.tb[j].Balance + Double.Parse(txtamt.Text); application.tb[j].CurrBalance = application.tb[j].Balance.ToString("C2"); } if (ctype == "crecive") { patmentrecived.Add(c); } else if (ctype == "cgiven") { paymentgiven.Add(c); } else if (ctype == "income") { income.Add(c); } else if (ctype == "expance") { expance.Add(c); } } } else { Show("Fields Cannot be Empty",2); } }