private void btnAdd_Click(object sender, EventArgs e) { InvoiceHeader i = new InvoiceHeader(); i.CustomerID = (int)cmbCustomer.SelectedValue; i.DeliveryNote = Convert.ToInt32(txtDeliveryNote.Text); i.InvoiceDate = dtpInvoiceDate.Value; i.PaymentDate = dtpPaymentDate.Value; i.TotalAmount = 0; db.InvoiceHeaders.Add(i); db.SaveChanges(); txtInvoiceID.Text = i.InvoiceID.ToString(); }
public void InvoiceSave() { //asil faturayı kaydederken önce bir header acıcam sonra bu headera detay ekleyecem. InvoiceHeader invoiceHeader = new InvoiceHeader(); invoiceHeader.CustomerID = Convert.ToInt32(comboBoxCustomer.SelectedValue); invoiceHeader.PaymentDate = dateTimePickerPaymentDate.Value; invoiceHeader.DeliveryNote = Convert.ToInt32(txtDeliveryNote.Text); invoiceHeader.TotalAmount = 0; invoiceHeader.InvoiceDate = DateTime.Now; db.InvoiceHeaders.Add(invoiceHeader); db.SaveChanges(); lblInvoiceNo.Text = invoiceHeader.InvoiceID.ToString(); }
private void btnDeleteInvoice_Click(object sender, EventArgs e) { try { if (dataGridViewInvoiceDetails.ColumnCount != 6) { InvoiceDetails id = new InvoiceDetails(); id = db.InvoiceDetailss.Where(x => x.InvoiceID == selectedInvoiceID && x.ProductID == selectedProductID).FirstOrDefault(); db.InvoiceDetailss.Remove(id); db.SaveChanges(); MessageBox.Show("Succesfull delete Invoice Detail"); int invoiceId = selectedInvoiceID; if (db.InvoiceHeaders.Any(x => x.InvoiceID == invoiceId)) { var invoice = db.InvoiceDetailss.Where(x => x.InvoiceID == invoiceId).Select(x => new { x.ProductID, x.InvoiceID, x.product.ProductName, x.Unitprice, x.Quantity, x.VATAmount, TotalAmount = x.Quantity * x.Unitprice, AmountWithVAT = (x.Quantity * x.Unitprice) * 1.18 }).ToList(); dataGridViewInvoiceDetails.DataSource = invoice; dataGridViewInvoiceDetails.Columns[0].Visible = false; dataGridViewInvoiceDetails.Columns[1].Visible = false; int customerID = Convert.ToInt32(db.InvoiceHeaders.Where(x => x.InvoiceID == invoiceId).Select(x => x.CustomerID).FirstOrDefault()); int countyID = db.Customers.Find(customerID).CountyID; int cityID = db.Counties.Find(countyID).CityID; txtCustomerName.Text = db.Customers.Find(customerID).CompanyName; txtCustomerCounty.Text = db.Counties.Find(countyID).CountyName; txtCustomerCity.Text = db.Cities.Find(cityID).CityName; GetTotalAmount(); } else { MessageBox.Show("No invoices"); } } else { if (dataGridViewInvoiceDetails.SelectedRows.Count == 1) { int selectedInvoice = Convert.ToInt32(dataGridViewInvoiceDetails.CurrentRow.Cells["InvoiceID"].Value); InvoiceHeader ih = db.InvoiceHeaders.Find(selectedInvoice); db.InvoiceHeaders.Remove(ih); db.SaveChanges(); MessageBox.Show("Delete is successful"); FillInvoices(); } else { MessageBox.Show("Please make a one selection"); } } } catch (Exception) { MessageBox.Show("Please make a Invoice Or InvoiceDetails"); } }