private void button4_Click(object sender, EventArgs e) { if (textBox1.Text != "") { DialogResult dr = MessageBox.Show("Delete " + textBox1.Text, "Confirm", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (dr == System.Windows.Forms.DialogResult.OK) { SuppliesTransaction deleteST = (from x in cheese.SuppliesTransactions where x.SuppliesTransactionID.Equals(textBox1.Text) select x).First(); var deletedST = (from x in cheese.DetailSuppliesTransactions where x.SuppliesTransactionID.Equals(textBox1.Text) select x); cheese.SuppliesTransactions.Remove(deleteST); foreach (DetailSuppliesTransaction detailSuppliesTransaction in deletedST) { cheese.DetailSuppliesTransactions.Remove(detailSuppliesTransaction); } cheese.SaveChanges(); clear(); textBox1.Text = ""; loadData(); } } }
private void button3_Click(object sender, EventArgs e) { if (cartRow > 0) { SuppliesTransaction sT = new SuppliesTransaction(); sT.SuppliesTransactionID = textBox1.Text; sT.SuppliesTransactionDate = DateTime.Now; sT.RequestBy = _MainForm.userID; sT.SuppliesTransactionDescription = "No Description"; sT.SuppliesTransactionStatus = "Unchecked"; sT.UpdatedBy = ""; cheese.SuppliesTransactions.Add(sT); //cheese.SaveChanges(); foreach (DataRow row in tableCart.Rows) { DetailSuppliesTransaction dST = new DetailSuppliesTransaction(); dST.SuppliesTransactionID = textBox1.Text; dST.MilkID = row.Field <string>(0); dST.Quantity = Int32.Parse(row.Field <string>(1)); //Int32.(row["Quantity"].ToString()); dST.Price = Int32.Parse(row.Field <string>(2)); dST.VendorID = row.Field <string>(3); //row["VendorID"].ToString(); cheese.DetailSuppliesTransactions.Add(dST); //cheese.SaveChanges(); } cheese.SaveChanges(); loadData(); clear(); EnabledStatus(false); ButtonStatus(true); textBox1.Text = ""; label10.Visible = false; tableCart.Clear(); flag = 0; } }
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"); } } }