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