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