private void button1_Click(object sender, EventArgs e)
{
if (textBox4.Text != "")
{
DialogResult dr = MessageBox.Show("Create " + textBox1.Text + " Invoice Verification", "Confirm", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (dr == System.Windows.Forms.DialogResult.OK)
{
VerifiedInvoice vI = new VerifiedInvoice();
vI.FinalGoodsReceiptID = textBox4.Text;
vI.VerifiedInvoiceID = generateVerifiedInvoiceID();
vI.VerifiedInvoiceStatus = "Created";
vI.VerifiedInvoiceDate = DateTime.Now;
vI.TotalPrice = Int32.Parse(textBox8.Text);
vI.CreatedBy = _MainForm.userID;
vI.SuppliesTransactionID = textBox1.Text;
cheese.VerifiedInvoices.Add(vI);
cheese.SaveChanges();
loadData();
clear();
enableStatus(false);
MessageBox.Show("Invoice Verification Created");
}
}
}
private void dataGridView5_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
clear();
if (e.RowIndex >= 0)
{
textBox5.Text = dataGridView5.Rows[e.RowIndex].Cells[0].Value.ToString();
textBox1.Text = dataGridView5.Rows[e.RowIndex].Cells[1].Value.ToString();
textBox4.Text = dataGridView5.Rows[e.RowIndex].Cells[2].Value.ToString();
FinalGoodsReceipt finalGoodsReceipt = (from x in cheese.FinalGoodsReceipts where x.FinalGoodsReceiptID.Equals(textBox4.Text) select x).First();
GoodsReceipt goodsReceipt = (from x in cheese.GoodsReceipts where x.SuppliesTransactionID.Equals(textBox1.Text) select x).First();
textBox2.Text = goodsReceipt.GoodsReceiptID;
GoodsReceiptCheck goodsReceiptCheck = (from x in cheese.GoodsReceiptChecks where x.GoodsReceiptID.Equals(textBox2.Text) select x).First();
textBox3.Text = goodsReceiptCheck.GoodsReceiptCheckID;
var suppliesTransaction = (from x in cheese.SuppliesTransactions where x.SuppliesTransactionID.Equals(textBox1.Text) select new { x.SuppliesTransactionID, x.SuppliesTransactionStatus, x.SuppliesTransactionDescription });
var detailSuppliesTransaction = (from x in cheese.DetailSuppliesTransactions where x.SuppliesTransactionID.Equals(textBox1.Text) select new { x.MilkID, x.VendorID, x.Price });
var finalGoodsReceiptTemp = (from x in cheese.FinalGoodsReceipts where x.FinalGoodsReceiptID.Equals(textBox4.Text) select new { x.FinalGoodsReceiptID, x.FinalGoodsReceiptDate });
var detailFinalGoodsReceipt = (from x in cheese.DetailFinalGoodsReceipts where x.FinalGoodsReceiptID.Equals(textBox4.Text) select new { x.MilkID, x.Quantity });
dataGridView1.DataSource = finalGoodsReceiptTemp.ToList();
dataGridView2.DataSource = detailFinalGoodsReceipt.ToList();
dataGridView3.DataSource = suppliesTransaction.ToList();
dataGridView4.DataSource = detailSuppliesTransaction.ToList();
if (textBox5.Text == "")
{
enableStatus(false);
}
else
{
VerifiedInvoice verifiedInvoice = (from x in cheese.VerifiedInvoices where x.VerifiedInvoiceID.Equals(textBox5.Text) select x).First();
if (verifiedInvoice.VerifiedInvoiceStatus == "Created")
{
enableStatus(true);
}
else
{
enableStatus(false);
}
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox5.Text != "")
{
DialogResult dr = MessageBox.Show("Confirm " + textBox1.Text + " Invoice Verification Payment", "Confirm", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (dr == System.Windows.Forms.DialogResult.OK)
{
VerifiedInvoice vI = (from x in cheese.VerifiedInvoices where x.VerifiedInvoiceID.Equals(textBox5.Text) select x).First();
vI.PaidBy = _MainForm.userID;
vI.PaidConfirmationDate = DateTime.Now;
vI.VerifiedInvoiceStatus = "Payment Completed";
cheese.SaveChanges();
loadData();
clear();
enableStatus(false);
MessageBox.Show("Invoice Verification Paid");
}
}
}
