private void btnConfirmPay_Click(object sender, EventArgs e) { bool ok = true; errP.Clear(); foreach (DataRow dr in dtPayToday.Rows) { MyTrans myTrans = new MyTrans(); errP.Clear(); drTrans = dsKaizen.Tables["Trans"].Rows.Find(dr[0].ToString()); try { myTrans.CustID = txtCustID.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtCustID, MyEx.toString()); } try { myTrans.TransOn = DateTime.Parse(dr[2].ToString()); } catch (MyException MyEx) { ok = false; errP.SetError(btnConfirmPay, MyEx.toString()); } try { myTrans.TransTotal = Convert.ToDouble(drTrans["TransTotal"].ToString()); } catch (MyException MyEx) { ok = false; errP.SetError(btnConfirmPay, MyEx.toString()); } try { myTrans.BalOwed = 0.00; } catch (MyException MyEx) { ok = false; errP.SetError(btnConfirmPay, 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"); } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "" + ex.Message, "Error !", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } MyPayment myPayment = new MyPayment(); getPaysnum(); try { myPayment.PayID = "PY-" + (seperateNumber(findPayID) + 1).ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(btnConfirmPay, MyEx.toString()); } try { myPayment.TransID = dr[0].ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(btnConfirmPay, MyEx.toString()); } try { myPayment.PayAmount = Convert.ToDouble(dr[1].ToString()); } catch (MyException MyEx) { ok = false; errP.SetError(btnConfirmPay, MyEx.toString()); } try { myPayment.PayDate = DateTime.Today; } catch (MyException MyEx) { ok = false; errP.SetError(btnConfirmPay, MyEx.toString()); } if (ok) { drPayment = dsKaizen.Tables["Payments"].NewRow(); drPayment["PayID"] = myPayment.PayID; drPayment["TransID"] = myPayment.TransID; drPayment["PayAmount"] = myPayment.PayAmount; drPayment["PayDate"] = myPayment.PayDate; dsKaizen.Tables["Payments"].Rows.Add(drPayment); daPayments.Update(dsKaizen, "Payments"); } MessageBox.Show("Payment Taken", "Order"); populateCustOutStandingTrans(txtCustID, dgvLoadTrans); } }
private void btnPPay_Click(object sender, EventArgs e) { MyPayment myPayment = new MyPayment(); bool ok = true; errP.Clear(); try { myPayment.PayID = lblPPayInvID.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(lblPPayInvID, MyEx.toString()); } try { myPayment.TransID = txtPPayTransID.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtPPayTransID, MyEx.toString()); } try { myPayment.PayAmount = Convert.ToDouble(txtBPayTo.Text.Trim()); } catch (MyException MyEx) { ok = false; errP.SetError(txtBPayTo, MyEx.toString()); } catch (FormatException Formex) { ok = false; errP.SetError(txtBPayTo, "Please Enter a vaild number"); } if (ok) { drPayment = dsKaizen.Tables["Payments"].NewRow(); drPayment["PayID"] = myPayment.PayID; drPayment["TransID"] = myPayment.TransID; drPayment["PayAmount"] = myPayment.PayAmount; drPayment["PayDate"] = myPayment.PayDate; dsKaizen.Tables["Payments"].Rows.Add(drPayment); daPayments.Update(dsKaizen, "Payments"); MyTrans myTrans = new MyTrans(); errP.Clear(); drTrans = dsKaizen.Tables["Trans"].Rows.Find(txtPPayTransID.Text); try { myTrans.CustID = lblPPayCustNo.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtCustID, MyEx.toString()); } try { myTrans.TransOn = dtpPPay.Value; } catch (MyException MyEx) { ok = false; errP.SetError(dtpPPay, MyEx.toString()); } try { myTrans.TransTotal = Convert.ToDouble(lblPPayTot.Text.Trim()); } catch (MyException MyEx) { ok = false; errP.SetError(lblPPayTot, MyEx.toString()); } try { myTrans.BalOwed = (Convert.ToDouble(lblPPayOut.Text.Trim())) - (Convert.ToDouble(txtBPayTo.Text.Trim())); } catch (MyException MyEx) { ok = false; errP.SetError(txtBPayTo, 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("Payment Taken", "Order"); clearMultiPayfrm(); } } 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(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); } }