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