private void button11_Click(object sender, EventArgs e)
{
chart1.Show();
switch (comboBox4.SelectedIndex + 1)
{
case 1:
{
if (chart1.Series[0].Points != null)
{
chart1.Series[0].Points.Clear();
}
chart1.Series[0].LegendText = "Sales";
chart1.Series["Series1"].Color = Color.Green;
for (int i = 0; i < Misc.GetTodayMonth(); i++)
{
var sum = db.service_payments.Where(o => o.date == i).Select(o => o.price).Sum();
chart1.Series[0].Points.AddXY(i, sum);
}
break;
}
case 2:
{
if (chart1.Series[0].Points != null)
{
chart1.Series[0].Points.Clear();
}
chart1.Series[0].LegendText = "Lost profit";
var data = (from a in db.active_debts
join b in db.debt_table on a.debt_id equals b.id
select new EasyDataRepresentation
{
Debt = b.debt.Value,
Month = b.month_id.Value
}
).ToList();
chart1.Series["Series1"].Color = Color.Red;
for (int i = 0; i < data.Count(); i++)
{
var sum = data.Select(o => o.Debt).Sum();
chart1.Series[0].Points.AddXY(i, sum);
}
break;
}
}
}
public static void CreatePaymentEntry(int index, int client_id, decimal insertedMoney)
{
using (PSEntity db = new PSEntity())
{
db.service_payments.Add(new service_payments
{
id = db.service_payments.Count() + 1,
client_id = client_id,
service_id = index + 1,
usage = 100,
date = Misc.GetTodayMonth(),
price = insertedMoney
});
db.SaveChanges();
}
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
string a, b, c, d, f, g;
if (ServicePayRequests.MainServiceDataProvider(int.Parse(comboBox1.SelectedIndex.ToString()), user.client_id, Misc.GetTodayMonth(), (decimal)user.dwelling_space))
{
LablingService.GetTextAboutServiceWithMetrics(int.Parse(comboBox1.SelectedIndex.ToString()), user.client_id, Misc.GetTodayMonth(), out a, out b, out c, out d, out f, out g);
}
else
{
LablingService.SetTextForStaticService(int.Parse(comboBox1.SelectedIndex.ToString()), user.client_id, Misc.GetTodayMonth(), (decimal)user.dwelling_space, out a, out b, out c, out d, out f, out g);
}
label25.Text = a;
label27.Text = b;
label28.Text = c;
label32.Text = f;
TariffBox.Show();
UsageBox.Show();
ModBox.Show();
PaymentBox.Show();
if (d == "-1")
{
OverBox.Hide();
}
else
{
OverBox.Show();
label30.Text = d;
}
if (g == "-1")
{
DebtBox.Hide();
}
else
{
DebtBox.Show();
label34.Text = g;
}
label32.Show();
}
private void button4_Click(object sender, EventArgs e)
{
PaymentHandler.PaymentStateMachine(int.Parse(comboBox1.SelectedIndex.ToString()), user.client_id, Misc.GetTodayMonth(),
decimal.Parse(MoneyInstertText.Text.ToString()), decimal.Parse(label30.Text.ToString()), decimal.Parse(label32.Text.ToString()),
PaymentHandler.GetPaymentState(decimal.Parse(label30.Text.ToString()), decimal.Parse(label34.Text.ToString())), decimal.Parse(label32.Text.ToString()));
UpdateForm();
}
