private void btnDelete_Click(object sender, EventArgs e) { if (_canChange) { if (MessageBox.Show("Czy chcesz usunąć wpis?", "Usuwanie", MessageBoxButtons.YesNo) == DialogResult.Yes) { using (OCTOPUSEntities4 db = new OCTOPUSEntities4()) { var entry = db.Entry(_payments); if (entry.State == System.Data.Entity.EntityState.Detached) { db.Payments.Attach(_payments); } db.Payments.Remove(_payments); db.SaveChanges(); ReloadGrid(); Clear(); } } } else { MessageBox.Show("Kliknij 2x na wiersz, który chcesz usunąć - następnie usuń"); } }
private void btnSave_Click(object sender, EventArgs e) { //sprawdzic czy jest uzupelnione if (txtValue.Text != "" & txtPlace.Text != "" & txtType.Text != "" & dateTimePickPayments.Value.ToString() != "" && txtNamePayment.Text != "") { _payments.ValuePayment = decimal.Parse(txtValue.Text); _payments.PlaceName = txtPlace.Text.Trim(); _payments.TypeName = txtType.Text.Trim(); _payments.DatePayment = dateTimePickPayments.Value; _payments.ShopName = txtNamePayment.Text.Trim(); using (OCTOPUSEntities4 db = new OCTOPUSEntities4()) { if (_payments.IdPayment == 0) //insert { db.Payments.Add(_payments); } else //update { db.Entry(_payments).State = System.Data.Entity.EntityState.Modified; //ustawienie flagi na update } db.SaveChanges(); } ReloadGrid(); Clear(); } else { MessageBox.Show("Uzupełnij dane - następnie dodaj"); } }
private void ReloadGrid() { using (OCTOPUSEntities4 db = new OCTOPUSEntities4()) { _paymentsLst = db.Payments.ToList <Payments>(); gridViewPayments.DataSource = _paymentsLst; } }
private void ReloadGrid() { using (OCTOPUSEntities4 db = new OCTOPUSEntities4()) { _incomesLst = db.Incomes.ToList <Incomes>(); gridViewIncomes.DataSource = _incomesLst; } }
private void PreparePoints() { if (_all) { using (OCTOPUSEntities4 db = new OCTOPUSEntities4()) { List <Payments> _paymentsLst = new List <Payments>(); _paymentsLst = db.Payments.ToList <Payments>(); chart.Series.Add("Przychody"); List <Incomes> _incomesLst = new List <Incomes>(); _incomesLst = db.Incomes.ToList <Incomes>(); chart.Series.Add("Wydatki"); foreach (Incomes inc in _incomesLst) { chart.Series["Przychody"].Points.AddXY(inc.DateIncome, inc.ValueOfIncome); chart.Series["Przychody"]["PixelPointWidth"] = "15"; } foreach (Payments payment in _paymentsLst) { chart.Series["Wydatki"].Points.AddXY(payment.DatePayment, payment.ValuePayment); chart.Series["Wydatki"]["PixelPointWidth"] = "15"; } } } else { int counterOfPoint = 0; if (_incomesLst != null) { // _incomesLst.Where(incIt => incIt.DateIncome > _dateFrom && incIt.DateIncome < _dateTo).GroupBy(grp => grp.TypeIncome).ToList() //tworzenie wykresu wydatków foreach (Incomes inc in _incomesLst.Where(incIt => incIt.DateIncome > _dateFrom && incIt.DateIncome < _dateTo).Distinct().ToList()) { //chart.Series[_nameSeries].Points.AddXY(inc.TypeIncome, inc.ValueOfIncome); chart.Series[_nameSeries].Points.AddXY(inc.TypeIncome, inc.ValueOfIncome);// _incomesLst.Where(y=>y.TypeIncome == inc.TypeIncome).Sum(x=>x.ValueOfIncome).Value); chart.Series[_nameSeries].Points.ElementAt(counterOfPoint).ToolTip = inc.ValueOfIncome.ToString(); counterOfPoint++; } } else { //tworzenie wykresu przychodów foreach (Payments payment in _paymnetsLst.Where(payIt => payIt.DatePayment > _dateFrom && payIt.DatePayment < _dateTo).ToList()) { chart.Series[_nameSeries].Points.AddXY(payment.TypeName, payment.ValuePayment); chart.Series[_nameSeries].Points.ElementAt(counterOfPoint).ToolTip = payment.ValuePayment.ToString(); counterOfPoint++; } } SetBarWidth(); } SetScrollbars(); }
private void gridViewIncomes_DoubleClick(object sender, EventArgs e) { if (gridViewIncomes.CurrentRow.Index != -1) { _canChange = true; _incom.IdIncomes = Convert.ToInt32(gridViewIncomes.CurrentRow.Cells["IdIncomes"].Value); using (OCTOPUSEntities4 db = new OCTOPUSEntities4()) { _incom = db.Incomes.Where(id => id.IdIncomes == _incom.IdIncomes).FirstOrDefault(); txtValue.Text = _incom.ValueOfIncome.ToString(); txtName.Text = _incom.NameIncome; txtType.Text = _incom.TypeIncome; dateTimePicekIncome.Value = _incom.DateIncome.Value; } } }
private void gridViewPayments_DoubleClick(object sender, EventArgs e) { if (gridViewPayments.CurrentRow.Index != -1) { _canChange = true; _payments.IdPayment = Convert.ToInt32(gridViewPayments.CurrentRow.Cells["IdPayment"].Value); using (OCTOPUSEntities4 db = new OCTOPUSEntities4()) { _payments = db.Payments.Where(id => id.IdPayment == _payments.IdPayment).FirstOrDefault(); txtValue.Text = _payments.ValuePayment.ToString(); txtPlace.Text = _payments.PlaceName; txtType.Text = _payments.TypeName; dateTimePickPayments.Value = _payments.DatePayment.Value; txtNamePayment.Text = _payments.ShopName; } } }
private void btnFiltr_Click(object sender, EventArgs e) { if (cmbField.SelectedValue.ToString() != "" && cmbOperand.SelectedValue.ToString() != "" && txtValueFilter.Text != "") { decimal x = 0; if (cmbField.SelectedValue.ToString() == "Kwota" && decimal.TryParse(txtValueFilter.Text, out x)) { using (OCTOPUSEntities4 db = new OCTOPUSEntities4()) { List <Payments> payments = new List <Payments>(); payments = db.Payments.ToList <Payments>(); List <Payments> paymentsFiltered = new List <Payments>(); switch (cmbField.SelectedValue.ToString()) { case "Kwota": if (cmbOperand.SelectedValue.ToString() == "=") { if (cmbSortType.SelectedValue.ToString() == "Malejące") { paymentsFiltered = payments.Where(p => p.ValuePayment == decimal.Parse(txtValueFilter.Text)).ToList().OrderByDescending(o => o.ValuePayment).ToList(); } else if (cmbSortType.SelectedValue.ToString() == "Rosnące") { paymentsFiltered = payments.Where(p => p.ValuePayment == decimal.Parse(txtValueFilter.Text)).ToList().OrderBy(o => o.ValuePayment).ToList(); } else { paymentsFiltered = payments.Where(p => p.ValuePayment == decimal.Parse(txtValueFilter.Text)).ToList(); } } if (cmbOperand.SelectedValue.ToString() == "<") { if (cmbSortType.SelectedValue.ToString() == "Malejące") { paymentsFiltered = payments.Where(p => p.ValuePayment < decimal.Parse(txtValueFilter.Text)).ToList().OrderByDescending(o => o.ValuePayment).ToList(); } else if (cmbSortType.SelectedValue.ToString() == "Rosnące") { paymentsFiltered = payments.Where(p => p.ValuePayment < decimal.Parse(txtValueFilter.Text)).ToList().OrderBy(o => o.ValuePayment).ToList(); } else { paymentsFiltered = payments.Where(p => p.ValuePayment < decimal.Parse(txtValueFilter.Text)).ToList(); } } if (cmbOperand.SelectedValue.ToString() == ">") { if (cmbSortType.SelectedValue.ToString() == "Malejące") { paymentsFiltered = payments.Where(p => p.ValuePayment > decimal.Parse(txtValueFilter.Text)).ToList().OrderByDescending(o => o.ValuePayment).ToList(); } else if (cmbSortType.SelectedValue.ToString() == "Rosnące") { paymentsFiltered = payments.Where(p => p.ValuePayment > decimal.Parse(txtValueFilter.Text)).ToList().OrderBy(o => o.ValuePayment).ToList(); } else { paymentsFiltered = payments.Where(p => p.ValuePayment < decimal.Parse(txtValueFilter.Text)).ToList(); } } gridViewPayments.DataSource = paymentsFiltered; break; case "Data": if (cmbOperand.SelectedValue.ToString() == "=") { if (cmbSortType.SelectedValue.ToString() == "Malejące") { paymentsFiltered = payments.Where(p => p.DatePayment.ToString().Remove(10, 9) == txtValueFilter.Text).ToList().OrderByDescending(o => o.ValuePayment).ToList(); } else if (cmbSortType.SelectedValue.ToString() == "Rosnące") { paymentsFiltered = payments.Where(p => p.DatePayment.ToString().Remove(10, 9) == txtValueFilter.Text).ToList().OrderBy(o => o.ValuePayment).ToList(); } else { paymentsFiltered = payments.Where(p => p.DatePayment.ToString().Remove(10, 9) == txtValueFilter.Text).ToList(); } } gridViewPayments.DataSource = paymentsFiltered; break; case "Nazwa": if (cmbOperand.SelectedValue.ToString() == "=") { if (cmbSortType.SelectedValue.ToString() == "Malejące") { paymentsFiltered = payments.Where(p => p.ShopName == txtValueFilter.Text).ToList().OrderByDescending(o => o.ValuePayment).ToList(); } else if (cmbSortType.SelectedValue.ToString() == "Rosnące") { paymentsFiltered = payments.Where(p => p.ShopName == txtValueFilter.Text).ToList().OrderBy(o => o.ValuePayment).ToList(); } else { paymentsFiltered = payments.Where(p => p.ShopName == txtValueFilter.Text).ToList(); } } gridViewPayments.DataSource = paymentsFiltered; break; case "Typ": if (cmbOperand.SelectedValue.ToString() == "=") { if (cmbSortType.SelectedValue.ToString() == "Malejące") { paymentsFiltered = payments.Where(p => p.TypeName == txtValueFilter.Text).ToList().OrderByDescending(o => o.ValuePayment).ToList(); } else if (cmbSortType.SelectedValue.ToString() == "Rosnące") { paymentsFiltered = payments.Where(p => p.TypeName == txtValueFilter.Text).ToList().OrderBy(o => o.ValuePayment).ToList(); } else { paymentsFiltered = payments.Where(p => p.TypeName == txtValueFilter.Text).ToList(); } } gridViewPayments.DataSource = paymentsFiltered; break; case "Miejsce": if (cmbOperand.SelectedValue.ToString() == "=") { if (cmbSortType.SelectedValue.ToString() == "Malejące") { paymentsFiltered = payments.Where(p => p.PlaceName == txtValueFilter.Text).ToList().OrderByDescending(o => o.ValuePayment).ToList(); } else if (cmbSortType.SelectedValue.ToString() == "Rosnące") { paymentsFiltered = payments.Where(p => p.PlaceName == txtValueFilter.Text).ToList().OrderBy(o => o.ValuePayment).ToList(); } else { paymentsFiltered = payments.Where(p => p.PlaceName == txtValueFilter.Text).ToList(); } } gridViewPayments.DataSource = paymentsFiltered; break; } } } else { MessageBox.Show("Popraw dane!!"); } } }