public void chart_revenues_date() { string format = "yyyy. MM. dd"; DateTime start = startDate.Value; DateTime finish = finishDate.Value; List <Revenu> revenus = new List <Revenu>(); connection.Open(); SqlCommand cmd_revenu = connection.CreateCommand(); SqlDataReader reader = (null); cmd_revenu.CommandType = CommandType.Text; cmd_revenu.CommandText = "select SUM(Amount) as amount, Date from [Revenues] where Date between '" + start.ToString(format) + "' and '" + finish.ToString(format) + "' group by Date"; cmd_revenu.ExecuteNonQuery(); reader = cmd_revenu.ExecuteReader(); while (reader.Read()) { Revenu r = new Revenu(); r.amount = float.Parse(reader["amount"].ToString()); r.date = Convert.ToDateTime(reader["Date"]).ToString(format); revenus.Add(r); } reader.Close(); foreach (Revenu r in revenus) { this.chart.Series["Revenues"].Points.AddXY(r.date, r.amount); } revenus.Clear(); connection.Close(); }
public IActionResult Post([FromBody] Revenu revenu) { //>Check if (revenu == null) { return(BadRequest()); } RevenuService.Create(revenu); //>Return return(new ObjectResult(revenu)); }
/// <summary> /// Used for getting the result of the soustraction between revenu and expense. /// </summary> /// <param name="pRevenu"></param> /// <param name="pExpense"></param> /// <returns></returns> public Money GetDifferencialWithRevenuAndExpense(Revenu pRevenu, Expense pExpense) { //>Declaration decimal lResult = decimal.Zero; Money lMoney; //>Processing lResult = pRevenu.Money.Amount - pExpense.Money.Amount; lMoney = new Money { Amount = lResult, IdCurrency = (int)ENUMCurrencyType.Euro }; //->Return return(lMoney); }