private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0) { textBox1.Text = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString(); var goodsReceipt = (from x in cheese.GoodsReceipts where x.SuppliesTransactionID.Equals(textBox1.Text) select x).First(); textBox2.Text = goodsReceipt.GoodsReceiptID; var goodsReceiptCheck = (from x in cheese.GoodsReceiptChecks where x.GoodsReceiptID.Equals(textBox2.Text) select x).First(); textBox3.Text = goodsReceiptCheck.GoodsReceiptCheckID; textBox5.Text = "IS Description : " + dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString() + ", QM Description : " + goodsReceipt.GoodsReceiptDescription; loadDetail(); ButtonStatus(true); if (textBox3.Text != "") { var finalGoodsReceipt = from x in cheese.FinalGoodsReceipts select x; if (finalGoodsReceipt.Count() > 0) { FinalGoodsReceipt fGR = (from x in cheese.FinalGoodsReceipts where x.GoodsReceiptCheckID.Equals(textBox3.Text) select x).First(); if (fGR != null) { btnDisabled(); } } } var detailSuppliesTransaction = from x in cheese.DetailSuppliesTransactions where x.SuppliesTransactionID == textBox1.Text select new { x.MilkID, x.Price, x.Quantity, x.VendorID }; dataGridView4.DataSource = detailSuppliesTransaction.ToList(); if (detailSuppliesTransaction != null) { dataGridView2.Enabled = true; } else { dataGridView2.Enabled = false; } textBox7.Text = ""; numericUpDown1.Value = 0; } }
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 dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0) { textBox1.Text = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString(); 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; FinalGoodsReceipt finalGoodsReceipt = (from x in cheese.FinalGoodsReceipts where x.GoodsReceiptCheckID.Equals(textBox3.Text) select x).First(); textBox4.Text = finalGoodsReceipt.FinalGoodsReceiptID; loadDetail(); /* if (textBox4.Text != "") * { * var finalGoodsReceiptTemp = from x in cheese.FinalGoodsReceipts select x; * if (finalGoodsReceiptTemp.Count() > 0) * { * FinalGoodsReceipt fGR = (from x in cheese.FinalGoodsReceipts where x.GoodsReceiptCheckID.Equals(textBox3.Text) select x).First(); * if (fGR != null) * { * enableStatus(false); * } * } * }*/ var detailSuppliesTransaction = from x in cheese.DetailSuppliesTransactions where x.SuppliesTransactionID == textBox1.Text select new { x.MilkID, x.Price, x.Quantity, x.VendorID }; dataGridView2.DataSource = detailSuppliesTransaction.ToList(); if (detailSuppliesTransaction != null) { dataGridView2.Enabled = true; } else { dataGridView2.Enabled = false; } numericUpDown1.Value = 0; } }
private void loadDetail() { var finalGoodsReceipt = from x in cheese.FinalGoodsReceipts where x.GoodsReceiptCheckID.Equals(textBox3.Text) select new { x.FinalGoodsReceiptID, x.FinalGoodsReceiptDate }; dataGridView3.DataSource = finalGoodsReceipt.ToList(); if (finalGoodsReceipt != null) { dataGridView3.Enabled = true; } else { dataGridView3.Enabled = false; } if (dataGridView3.RowCount > 0) { FinalGoodsReceipt fGR = (from x in cheese.FinalGoodsReceipts where x.GoodsReceiptCheckID.Equals(textBox3.Text) select x).First(); var detailFinalGoodsReceipt = from x in cheese.DetailFinalGoodsReceipts where x.FinalGoodsReceiptID.Equals(fGR.FinalGoodsReceiptID) select new { x.MilkID, x.Quantity }; dataGridView4.DataSource = detailFinalGoodsReceipt.ToList(); } }
private void button3_Click(object sender, EventArgs e) { if (cartRow > 0) { if (cartRow == dataGridView3.RowCount - 1) { string newID = generateFinalGoodsReceiptID(); FinalGoodsReceipt fGR = new FinalGoodsReceipt(); fGR.FinalGoodsReceiptID = newID; fGR.GoodsReceiptCheckID = textBox3.Text; fGR.FinalGoodsReceiptDate = DateTime.Now; fGR.CreatedBy = _MainForm.userID; cheese.FinalGoodsReceipts.Add(fGR); foreach (DataRow row in tableCart.Rows) { DetailFinalGoodsReceipt dFGR = new DetailFinalGoodsReceipt(); dFGR.FinalGoodsReceiptID = newID; dFGR.MilkID = row.Field <string>(0); dFGR.Quantity = Int32.Parse(row.Field <string>(1)); cheese.DetailFinalGoodsReceipts.Add(dFGR); } cheese.SaveChanges(); loadData(); loadDetail(); clear(); EnabledStatus(false); ButtonStatus(true); label10.Visible = false; tableCart.Clear(); flag = 0; dataGridView1.Enabled = true; } else { label10.Text = "You Must Insert All Items"; label10.Visible = true; } } }