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