private void button3_Click(object sender, EventArgs e)
        {
            if (textBox1.Text != "")
            {
                SuppliesTransaction sT = (from x in cheese.SuppliesTransactions
                                          where x.SuppliesTransactionID.Equals(textBox1.Text)
                                          select x).First();
                var dST = from x in cheese.DetailSuppliesTransactions
                          where x.SuppliesTransactionID.Equals(textBox1.Text)
                          select x;
                if (sT != null)
                {
                    sT.SuppliesTransactionDescription = textBox2.Text;
                    sT.SuppliesTransactionStatus      = "Checked";
                    sT.UpdatedBy = _MainForm.userID;
                    cheese.SaveChanges();
                    loadData();
                    clear();
                    EnabledStatus(false);
                    ButtonStatus(true);
                    label10.Visible = false;

                    GoodsReceipt gR    = new GoodsReceipt();
                    string       newID = generateGoodsReceiptID();
                    gR.GoodsReceiptID          = newID;
                    gR.SuppliesTransactionID   = textBox1.Text;
                    gR.CreatedBy               = _MainForm.userID;
                    gR.GoodsReceiptDate        = DateTime.Now;
                    gR.GoodsReceiptDescription = "No Description";
                    //gR.GoodsReceiptStatus = "Unchecked";
                    //gR.UpdatedBy = "";
                    cheese.GoodsReceipts.Add(gR);
                    //cheese.SaveChanges();
                    foreach (DetailSuppliesTransaction detail in dST)
                    {
                        DetailGoodsReceipt dGR = new DetailGoodsReceipt();

                        dGR.GoodsReceiptID = newID;
                        dGR.MilkID         = detail.MilkID.ToString();
                        dGR.Quantity       = (Int32)detail.Quantity;
                        //dGR.Price = (Int32)detail.Price;
                        //dGR.VendorID = detail.VendorID;
                        cheese.DetailGoodsReceipts.Add(dGR);
                        //cheese.SaveChanges();
                    }
                    cheese.SaveChanges();
                    loadData();
                    clear();
                    textBox1.Text = "";
                    MessageBox.Show("Data Updated");
                }
            }
        }
Пример #2
0
        private void button3_Click(object sender, EventArgs e)
        {
            if (textBox1.Text != "")
            {
                GoodsReceipt gR = (from x in cheese.GoodsReceipts
                                   where x.GoodsReceiptID.Equals(textBox1.Text)
                                   select x).First();
                if (gR != null)
                {
                    var dGR = from x in cheese.DetailGoodsReceipts
                              where x.GoodsReceiptID.Equals(textBox1.Text)
                              select x;

                    gR.GoodsReceiptDescription = textBox2.Text;
                    cheese.SaveChanges();
                    GoodsReceiptCheck gRC   = new GoodsReceiptCheck();
                    string            newID = generateGoodsReceiptCheckID();
                    gRC.GoodsReceiptID        = textBox1.Text;
                    gRC.GoodsReceiptCheckID   = newID;
                    gRC.CreatedBy             = _MainForm.userID;
                    gRC.GoodsReceiptCheckDate = DateTime.Now;
                    cheese.GoodsReceiptChecks.Add(gRC);

                    //cheese.SaveChanges();
                    foreach (DetailGoodsReceipt detail in dGR)
                    {
                        DetailGoodsReceiptCheck dGRC = new DetailGoodsReceiptCheck();
                        dGRC.GoodsReceiptCheckID = newID;
                        dGRC.MilkID   = detail.MilkID.ToString();
                        dGRC.Quantity = (Int32)detail.Quantity;
                        cheese.DetailGoodsReceiptChecks.Add(dGRC);
                        //cheese.SaveChanges();
                    }
                    cheese.SaveChanges();
                    textBox1.Text = "";
                    MessageBox.Show("Data Updated");
                    loadData();
                    clear();
                    EnabledStatus(false);
                    ButtonStatus(true);
                    label10.Visible = false;
                }
            }
        }
Пример #3
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;
            }
        }