//modify more public float calcRevenuePerMonth(int customerID, DateTime startDate, DateTime endDate, bool needAll) { DateTime start; MySqlDataReader sales = SalesLeadDA.getInstance().sales(customerID, startDate, endDate, needAll); start = Convert.ToDateTime(startDate); float monthly = 0f; while (sales.Read()) { monthly += sales.GetFloat(8) + sales.GetFloat(10); } return(monthly); }
public DataView getAllRevenue() { return(SalesLeadDA.getInstance().readAllSales()); }