private void btnAddCompleteOrder_Click(object sender, EventArgs e) { MyTrans myTrans = new MyTrans(); bool ok = true; errP.Clear(); try { myTrans.TransID = lblAddTransID.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(lblAddTransID, MyEx.toString()); } try { myTrans.CustID = txtAddCustID.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtAddCustID, MyEx.toString()); } try { myTrans.TransOn = dtpAddDate.Value; } catch (MyException MyEx) { ok = false; errP.SetError(dtpAddDate, MyEx.toString()); } try { myTrans.TransTotal = Convert.ToDouble(lblAddTCost.Text.Trim()); } catch (MyException MyEx) { ok = false; errP.SetError(lblAddTCost, MyEx.toString()); } catch (FormatException frmex) { ok = false; MessageBox.Show("Please Input Order Details Before Adding", "Order"); } // try { if (ok) { drTrans = dsKaizen.Tables["Trans"].NewRow(); drTrans["TransID"] = myTrans.TransID; drTrans["TransType"] = "Purchase"; drTrans["CustID"] = myTrans.CustID; drTrans["TransDate"] = myTrans.TransOn; drTrans["TransTotal"] = myTrans.TransTotal; drTrans["BalanceOwed"] = myTrans.TransTotal; drTrans["Paid"] = 'N'; dsKaizen.Tables["Trans"].Rows.Add(drTrans); daTrans.Update(dsKaizen, "Trans"); // getTransDetailsID(dsKaizen.Tables["TransDetails"].Rows.Count); getTransDetsnum(); int utdDetsNumber = seperateNumber(findTransID); foreach (DataRow dr in dt.Rows) { MyTransDetails myTransDetails = new MyTransDetails(); utdDetsNumber += 1; TansDIDString = "TD-" + utdDetsNumber; try { myTransDetails.TransDetsID = TansDIDString; } catch (MyException MyEx) { ok = false; } try { myTransDetails.TransID = lblAddTransID.Text.Trim(); } catch (MyException MyEx) { ok = false; } try { myTransDetails.StockID = dr["StockID"].ToString(); } catch (MyException MyEx) { ok = false; } try { myTransDetails.Qty = Convert.ToInt32(dr["Qty"]); } catch (MyException MyEx) { ok = false; } if (ok) { drTransDets = dsKaizen.Tables["TransDetails"].NewRow(); drTransDets["TransDetsID"] = myTransDetails.TransDetsID; drTransDets["TransID"] = myTransDetails.TransID; drTransDets["StockID"] = myTransDetails.StockID; GetCurrentStock(myTransDetails.StockID); drTransDets["Qty"] = myTransDetails.Qty; drTransDets["StartDate"] = DBNull.Value; drTransDets["EndDate"] = DBNull.Value; dsKaizen.Tables["TransDetails"].Rows.Add(drTransDets); newQty = currentQty - myTransDetails.Qty; string constr = @"Data Source = .; Initial Catalog = Kaizen;Integrated Security = true "; SqlConnection con = new SqlConnection(constr); DataSet ds = new DataSet(); con.Open(); SqlCommand cmd = new SqlCommand(" UPDATE Stock SET QtyInStock = " + newQty + " WHERE StockID ='" + myTransDetails.StockID + "'", con); cmd.ExecuteNonQuery(); con.Close(); new SqlCommandBuilder(daTransD); daTransD.Update(dsKaizen, "TransDetails"); } } MessageBox.Show("Purchase Order Added"); if (MessageBox.Show("Do you wish to Make another Order?", "Add Stock", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes) { clearAddForm(); getTransID(dsKaizen.Tables["Trans"].Rows.Count); } else { tabEquip.SelectedIndex = 0; } } } // catch (Exception ex) { // MessageBox.Show("" + ex.TargetSite + "" + ex.Message, "Error !", MessageBoxButtons.AbortRetryIgnore, // MessageBoxIcon.Error); } }
private void btnEditTrans_Click(object sender, EventArgs e) { daTransD.Update(dsKaizen, "TransDetails"); if (btnEditTrans.Text == "EDIT ORDER") { enableEdittxtB(); btnEditTrans.Text = "SAVE"; } else { gatherTransDForEdit(txtEditOrderID.Text); bool ok = true; for (int i = 0; i < ogTransDrows; i++) { if (string.Equals(dt.Rows[i][1].ToString(), "Deleted")) { string deleteID = EditTransDTable.Rows[i][0].ToString(); deleteTranDets(deleteID); daTransD.Update(dsKaizen, "TransDetails"); } if (!Equals(dt.Rows[i][3], EditTransDTable.Rows[i][3]) || !Equals(dt.Rows[i][0], EditTransDTable.Rows[i][2])) { drTransDets = dsKaizen.Tables["TransDetails"].Rows.Find(EditTransDTable.Rows[i][0].ToString()); MyTransDetails myTransDetails = new MyTransDetails(); errP.Clear(); try { myTransDetails.StockID = drTransDets["StockID"].ToString(); } catch (MyException MyEx) { ok = false; } try { myTransDetails.Qty = Convert.ToInt32(drTransDets["Qty"]); } catch (MyException MyEx) { ok = false; } try { if (ok) { drTransDets.BeginEdit(); drTransDets["StockID"] = myTransDetails.StockID; drTransDets["Qty"] = myTransDetails.Qty; drTransDets.EndEdit(); daTransD.Update(dsKaizen, "TransDetails"); } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "" + ex.Message, "Error !", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } } } if (ogTransDrows < dt.Rows.Count) { getTransDetsnum(); int utdDetsNumber = seperateNumber(findTransID); // for (int i = 0; i < (dt.Rows.Count - ogTransDrows); i++) foreach (DataRow dr in dt.Rows) { if (dt.Rows.IndexOf(dr) < ogTransDrows) { } else { MyTransDetails myTransDetails = new MyTransDetails(); utdDetsNumber += 1; TansDIDString = "TD-" + utdDetsNumber; try { myTransDetails.TransDetsID = TansDIDString; } catch (MyException MyEx) { ok = false; } try { myTransDetails.TransID = txtEditOrderID.Text.Trim(); } catch (MyException MyEx) { ok = false; } try { myTransDetails.StockID = dr["StockID"].ToString(); } catch (MyException MyEx) { ok = false; } try { myTransDetails.Qty = Convert.ToInt32(dr["Qty"]); } catch (MyException MyEx) { ok = false; } if (ok) { drTransDets = dsKaizen.Tables["TransDetails"].NewRow(); drTransDets["TransDetsID"] = myTransDetails.TransDetsID; drTransDets["TransID"] = myTransDetails.TransID; drTransDets["StockID"] = myTransDetails.StockID; drTransDets["Qty"] = myTransDetails.Qty; drTransDets["StartDate"] = DBNull.Value; drTransDets["EndDate"] = DBNull.Value; dsKaizen.Tables["TransDetails"].Rows.Add(drTransDets); new SqlCommandBuilder(daTransD); daTransD.Update(dsKaizen, "TransDetails"); } } } } MyTrans myTrans = new MyTrans(); errP.Clear(); drTrans = dsKaizen.Tables["Trans"].Rows.Find(txtEditOrderID.Text); try { myTrans.CustID = txtEditCustID.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtEditCustID, MyEx.toString()); } try { myTrans.TransOn = dtpEditDate.Value; } catch (MyException MyEx) { ok = false; errP.SetError(dtpEditDate, MyEx.toString()); } try { myTrans.TransTotal = Convert.ToDouble(lblEditTCost.Text.Trim()); } catch (MyException MyEx) { ok = false; errP.SetError(lblEditTCost, MyEx.toString()); } try { myTrans.BalOwed = Convert.ToDouble(lblEditOutstanding.Text.Trim()); } catch (MyException MyEx) { ok = false; errP.SetError(lblEditOutstanding, MyEx.toString()); } try { if (ok) { drTrans.BeginEdit(); drTrans["CustID"] = myTrans.CustID; drTrans["TransDate"] = myTrans.TransOn; drTrans["TransTotal"] = myTrans.TransTotal; drTrans["BalanceOwed"] = myTrans.BalOwed; if (myTrans.BalOwed <= 0) { drTrans["Paid"] = 'Y'; } else { drTrans["Paid"] = 'N'; } drTrans.EndEdit(); daTrans.Update(dsKaizen, "Trans"); MessageBox.Show("Purchase Details Updated", "Order"); disableEdittxtB(); btnEditTrans.Text = "EDIT ORDER"; tabEquip.SelectedIndex = 0; } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "" + ex.Message, "Error !", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } } }
private void btnAddCompleteOrder_Click(object sender, EventArgs e) { MyTrans myTrans = new MyTrans(); bool ok = true; errP.Clear(); try { myTrans.TransID = lblAddTransID.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(lblAddTransID, MyEx.toString()); } try { myTrans.CustID = txtAddCustID.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(lblAddTransID, MyEx.toString()); } try { myTrans.CustID = txtAddCustID.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(lblAddTransID, MyEx.toString()); } try { myTrans.TransOn = dtpAddDate.Value; } catch (MyException MyEx) { ok = false; errP.SetError(dtpAddDate, MyEx.toString()); } try { myTrans.TransTotal = Convert.ToDouble(lblAddTCost.Text.Trim()); } catch (MyException MyEx) { ok = false; errP.SetError(lblAddTCost, MyEx.toString()); } try { if (ok) { drTrans = dsKaizen.Tables["Trans"].NewRow(); drTrans["TransID"] = myTrans.TransID; drTrans["TransType"] = "Service"; drTrans["CustID"] = myTrans.CustID; drTrans["TransDate"] = myTrans.TransOn; drTrans["TransTotal"] = myTrans.TransTotal; drTrans["BalanceOwed"] = myTrans.TransTotal; drTrans["Paid"] = 'N'; dsKaizen.Tables["Trans"].Rows.Add(drTrans); daTrans.Update(dsKaizen, "Trans"); // getTransDetailsID(dsKaizen.Tables["TransDetails"].Rows.Count); getTransDetsnum(); int utdDetsNumber = seperateNumber(findTransID); foreach (DataRow dr in dt.Rows) { MyTransDetails myTransDetails = new MyTransDetails(); utdDetsNumber += 1; TansDIDString = "TD-" + utdDetsNumber; try { myTransDetails.TransDetsID = TansDIDString; } catch (MyException MyEx) { ok = false; } try { myTransDetails.TransID = lblAddTransID.Text.Trim(); } catch (MyException MyEx) { ok = false; } try { myTransDetails.StockID = dr["StockID"].ToString(); } catch (MyException MyEx) { ok = false; } try { myTransDetails.Qty = Convert.ToInt32(dr["Qty"]); } catch (MyException MyEx) { ok = false; } if (ok) { drTransDets = dsKaizen.Tables["TransDetails"].NewRow(); drTransDets["TransDetsID"] = myTransDetails.TransDetsID; drTransDets["TransID"] = myTransDetails.TransID; drTransDets["StockID"] = myTransDetails.StockID; drTransDets["Qty"] = myTransDetails.Qty; drTransDets["StartDate"] = DBNull.Value; drTransDets["EndDate"] = DBNull.Value; dsKaizen.Tables["TransDetails"].Rows.Add(drTransDets); new SqlCommandBuilder(daTransD); daTransD.Update(dsKaizen, "TransDetails"); } } MessageBox.Show("Purchase Order Added"); if (MessageBox.Show("Do you wish to Make another Order?", "Add Stock", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes) { clearAddForm(); getTransID(dsKaizen.Tables["Trans"].Rows.Count); } else { tabService.SelectedIndex = 0; } } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "" + ex.Message, "Error !", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } }