private void btnPrint_Click(object sender, EventArgs e) { if (dataGridMov.Rows.Count == 0) { MessageBox.Show("Non ci sono risultati di ricerca da stampare.", "Riprovare con un'altra ricerca", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } //costruisco la lista dei movimenti da stampare List<MonthlyExpenseReportItem> itemList = new List<MonthlyExpenseReportItem>(); MonthlyExpenseReportItem item; foreach (scadenzettiDbDataSet.MovimentoRow r in mdt.Rows) { item = new MonthlyExpenseReportItem(); item.Scadenza = r.DataScadenza; item.Tipo = r.Tipo; item.Importo = item.Tipo=="uscita" ? - r.ImportoIvato : r.ImportoIvato; item.Debitore = Utenti[r.Utente]; item.Creditore = Destinatari[r.DestinatarioMov]; item.Causale = r.Causale; item.Ultimato = r.Ultimato; itemList.Add(item); } DateSearchCriteria dsc = new DateSearchCriteria(); dsc.From = dtpickDataDa.Value; dsc.To = dtpickDataA.Value; ReportAllMovForm ramf = new ReportAllMovForm(itemList, dsc); ramf.Show(); }
public List<MonthlyExpenseReportItem> cercaMovimentiCategoria(int idCat) { OleDbConnection conn = new OleDbConnection(Properties.Settings.Default.scadenzettiDbConnectionString); string queryString = "SELECT * FROM QueryReportCategoria"; OleDbCommand cmd = new OleDbCommand(queryString, conn); cmd.Parameters.Add("idCat", OleDbType.Integer).Value = idCat; conn.Open(); OleDbDataReader reader = cmd.ExecuteReader(); List<MonthlyExpenseReportItem> list = new List<MonthlyExpenseReportItem>(); while (reader.Read()) { MonthlyExpenseReportItem mov = new MonthlyExpenseReportItem(); mov.Scadenza = DateTime.Parse(reader[0].ToString()); mov.Importo = decimal.Parse(reader[1].ToString()); mov.Debitore = reader[2].ToString(); mov.Creditore = reader[3].ToString(); mov.Causale = reader[4].ToString(); mov.Tipo = reader[5].ToString(); mov.Ultimato = bool.Parse(reader[6].ToString()); list.Add(mov); } reader.Close(); conn.Close(); return list; }
public List<MonthlyExpenseReportItem> getDataForMonthlyExpense(int month, int year, List<int> idUsers) { List<MonthlyExpenseReportItem> itemList = new List<MonthlyExpenseReportItem>(); DateTime startDate = new DateTime(year, month, 1); DateTime endDate = startDate.AddMonths(1); OleDbConnection conn = new OleDbConnection(Properties.Settings.Default.scadenzettiDbConnectionString); string prefixQueryStringMov = "SELECT Utente.Nome, DestinatarioMov.Nome, Movimento.DataScadenza, Movimento.ImportoIvato, Movimento.Causale FROM Utente, DestinatarioMov, Movimento WHERE (Utente.ID =Movimento.Utente) AND (DestinatarioMov.ID=Movimento.DestinatarioMov)"; MonthlyExpenseReportItem itemReport; conn.Open(); foreach(int user in idUsers){ string queryString = prefixQueryStringMov + " AND (Utente.ID = " + user + ") AND (Movimento.DataScadenza BETWEEN #" + startDate.Month+"/"+startDate.Day+"/"+startDate.Year + "# AND #" + endDate.Month + "/" + endDate.Day + "/" + endDate.Year + "#) AND Movimento.Ultimato=0 ORDER BY Movimento.DataScadenza;"; OleDbCommand cmd = new OleDbCommand(queryString, conn); OleDbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { itemReport = new MonthlyExpenseReportItem(); itemReport.Debitore = reader[0].ToString(); itemReport.Creditore = reader[1].ToString(); itemReport.Scadenza = DateTime.Parse(reader[2].ToString()); itemReport.Importo = decimal.Parse(reader[3].ToString()); itemReport.Causale = reader[4].ToString(); itemList.Add(itemReport); } reader.Close(); } conn.Close(); return itemList; }
public List<MonthlyExpenseReportItem> cercaTuttiMov(DateTime from, DateTime to) { List<MonthlyExpenseReportItem> itemList = new List<MonthlyExpenseReportItem>(); OleDbConnection conn = new OleDbConnection(Properties.Settings.Default.scadenzettiDbConnectionString); string queryString = "SELECT * FROM QueryReportAll"; MonthlyExpenseReportItem itemReport; conn.Open(); OleDbCommand cmd = new OleDbCommand(queryString, conn); cmd.Parameters.Add("DataFrom", OleDbType.Date).Value = from; cmd.Parameters.Add("DataTo", OleDbType.Date).Value = to; OleDbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { itemReport = new MonthlyExpenseReportItem(); itemReport.Scadenza = DateTime.Parse(reader[0].ToString()); itemReport.Importo = decimal.Parse(reader[1].ToString()); itemReport.Debitore = reader[2].ToString(); itemReport.Creditore = reader[3].ToString(); itemReport.Causale = reader[4].ToString(); itemReport.Tipo = reader[5].ToString(); itemReport.Ultimato = bool.Parse(reader[6].ToString()); if (itemReport.Tipo == "uscita") itemReport.Importo = -itemReport.Importo; itemList.Add(itemReport); } reader.Close(); conn.Close(); return itemList; }