private void picEmergeSave_Click(object sender, EventArgs e) { foreach (DataRow drStaff in dsBelfray.Tables["Staff"].Rows) { if (drStaff["staffID"].ToString().Equals(lblStaffNo.Text)) { MyStaff myStaff = new MyStaff(); bool ok = true; errP.Clear(); //Contact Name try { myStaff.ContactName = txtContactName.Text.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(txtContactName, MyEx.toString()); } //Contact Tel No try { myStaff.ContactTelNo = txtContactTel.Text.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(txtPhoneNo, MyEx.toString()); } //Try Adding try { if (ok) { drStaff.BeginEdit(); drStaff["staffEmergName"] = myStaff.ContactName; drStaff["staffEmergTel"] = myStaff.ContactTelNo; drStaff.EndEdit(); daStaff.Update(dsBelfray, "Staff"); MessageBox.Show("Emergency Contact Info Updated"); picEmergeCancel.Visible = false; picEmergeSave.Visible = false; picEmergeEdit.Visible = true; txtContactName.Enabled = false; txtContactTel.Enabled = false; } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "", ex.Message + "Error!", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } } } }
private void picSaveADDPTD_Click(object sender, EventArgs e) { MyProdTypeCode myProdType = new MyProdTypeCode(); bool ok = true; errP.Clear(); try { myProdType.ProdTypeCode = txtProdTypeCode.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtProdTypeCode, MyEx.toString()); } try { myProdType.ProdTypeDesc = txtProdDesc2.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtProdDesc2, MyEx.toString()); } //Try Adding try { if (ok) { drProductType = dsBelfray.Tables["ProductType"].NewRow(); drProductType["productTypeCode"] = myProdType.ProdTypeCode; drProductType["productTypeDesc"] = myProdType.ProdTypeDesc; dsBelfray.Tables["ProductType"].Rows.Add(drProductType); daProductType.Update(dsBelfray, "ProductType"); MessageBox.Show("Product Type Added"); if (MessageBox.Show("Do you wish to add another product type?", "AddProductType", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes) { txtProdTypeCode.Text = ""; txtProdDesc2.Text = ""; formLoad = true; test = true; } else { pnlProdType.Enabled = false; txtProdTypeCode.Text = ""; txtProdDesc2.Text = ""; pnlDetails.Enabled = true; formLoad = true; test = true; } } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "", ex.Message + "Error!", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } }
//THIS DOESNT WORK private void PicSaveADDPTD_Click(object sender, EventArgs e) { //ProductTypeCode drProductType = dsBelfray.Tables["ProductType"].Rows.Find(lblPTC.Text); MyProdTypeCode myProdType = new MyProdTypeCode(); bool ok = true; errP.Clear(); try { myProdType.ProdTypeCode = lblPTC.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(lblPTC, MyEx.toString()); } try { myProdType.ProdTypeDesc = txtProdDesc2.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtProdDesc2, MyEx.toString()); } //Try try { if (ok) { drProductType.BeginEdit(); drProductType["productTypeDesc"] = myProdType.ProdTypeDesc; drProductType.EndEdit(); daProductType.Update(dsBelfray, "ProductType"); pnlProdType.Enabled = false; lblPTC.Enabled = false; txtProdDesc2.Enabled = false; chkBxEditPTD.Checked = false; this.Update(); MessageBox.Show("Product Type Edited"); } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "", ex.Message + "Error!", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } }
private void picSaveADDSupp_Click(object sender, EventArgs e) { MySupplier mySupp = new MySupplier(); bool ok = true; errP.Clear(); try { mySupp.SupplierID = lblSupplierID.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(lblSupplierID, MyEx.toString()); } try { mySupp.SupplierName = txtSuppName.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtSuppName, MyEx.toString()); } try { mySupp.SupplierAddress = txtSuppAddress.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtSuppAddress, MyEx.toString()); } try { mySupp.SupplierTown = txtSuppTown.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtSuppTown, MyEx.toString()); } try { mySupp.SupplierCounty = txtSuppCounty.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtSuppCounty, MyEx.toString()); } try { mySupp.SupplierPostCode = txtSuppPC.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtSuppPC, MyEx.toString()); } try { mySupp.SupplierEmail = txtSuppEmail.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtSuppEmail, MyEx.toString()); } try { mySupp.SupplierTelNo = txtSuppTel.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtSuppTel, MyEx.toString()); } //Try Adding try { if (ok) { drSupplier = dsBelfray.Tables["Supplier"].NewRow(); drSupplier["supplierID"] = mySupp.SupplierID; drSupplier["supplierName"] = mySupp.SupplierName; drSupplier["supplierAddress"] = mySupp.SupplierAddress; drSupplier["supplierTown"] = mySupp.SupplierTown; drSupplier["supplierCounty"] = mySupp.SupplierCounty; drSupplier["supplierPostCode"] = mySupp.SupplierPostCode; drSupplier["supplierEmail"] = mySupp.SupplierEmail; drSupplier["supplierTelNo"] = mySupp.SupplierTelNo; dsBelfray.Tables["Supplier"].Rows.Add(drSupplier); daSupplier.Update(dsBelfray, "Supplier"); MessageBox.Show("Supplier Added"); if (MessageBox.Show("Do you wish to add another Supplier?", "AddSupplier", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes) { clearSuppPanel(); test = true; } else { pnlSuppDetails.Enabled = false; pnlDetails.Enabled = true; clearSuppPanel(); test = true; } } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "", ex.Message + "Error!", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } }
//SaveProduct private void picSaveAddProdDet_Click(object sender, EventArgs e) { MyProduct myProduct = new MyProduct(); bool ok = true; errP.Clear(); try { myProduct.ProductNo = lblProductNumberDisplay.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(lblProductNumberDisplay, MyEx.toString()); } try { myProduct.ProductTypeCode = cbTypeCode.SelectedValue.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(cbTypeCode, MyEx.toString()); } try { myProduct.ProductDesc = txtProdDesc.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtProdDesc, MyEx.toString()); } try { myProduct.CostPrice = txtCostPrice.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtCostPrice, MyEx.toString()); } try { myProduct.QtyInStock = txtQTY.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtQTY, MyEx.toString()); } try { myProduct.PackSize = txtPackSize.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtPackSize, MyEx.toString()); } try { myProduct.ReOrderLvl = txtReOrder.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtReOrder, MyEx.toString()); } try { myProduct.SupplierID = cbSuppID.SelectedValue.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(cbSuppID, MyEx.toString()); } //Try Adding try { if (ok) { drProduct = dsBelfray.Tables["Product"].NewRow(); drProduct["productNumber"] = myProduct.ProductNo; drProduct["productTypeCode"] = myProduct.ProductTypeCode; drProduct["productDesc"] = myProduct.ProductDesc; drProduct["costPrice"] = myProduct.CostPrice; drProduct["qtyInStock"] = myProduct.QtyInStock; drProduct["packSize"] = myProduct.PackSize; drProduct["reorderLvl"] = myProduct.ReOrderLvl; drProduct["supplierID"] = myProduct.SupplierID; dsBelfray.Tables["Product"].Rows.Add(drProduct); daProduct.Update(dsBelfray, "Product"); MessageBox.Show("Product Added"); if (MessageBox.Show("Do you wish to add another product?", "AddProduct", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes) { formLoad = true; clearAddPanel(); getProdNum(dsBelfray.Tables["Product"].Rows.Count); string s = drProduct["productNumber"].ToString(); string s1 = "PRD" + (Convert.ToInt32(s.Replace("PRD", "")) + 1).ToString().PadLeft(5, '0'); lblProductNumberDisplay.Text = s1; } else { this.Close(); } } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "", ex.Message + "Error!", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } }
private void btnConfirmAddProduct_Click(object sender, EventArgs e) { MyProduct myProduct = new MyProduct(); bool ok = true; errorProvider1.Clear(); try { myProduct.ProductNo = lblAddActualProductNo1.Text.Trim(); } catch (MyException MyEx) { ok = false; errorProvider1.SetError(lblAddActualProductNo1, MyEx.toString()); } try { myProduct.ProductDescription = txtAddProductDescription1.Text.Trim(); } catch (MyException MyEx) { ok = false; errorProvider1.SetError(txtAddProductDescription1, MyEx.toString()); } try { myProduct.ProductPrice = Convert.ToDouble(txtAddProductPrice1.Text.Trim()); } catch (MyException MyEx) { ok = false; errorProvider1.SetError(txtAddProductPrice1, MyEx.toString()); } try { myProduct.ProductQty = Convert.ToInt32(txtAddProductQty1.Text.Trim()); } catch (MyException MyEx) { ok = false; errorProvider1.SetError(txtAddProductQty1, MyEx.toString()); } try { myProduct.SupplierNo = cmbSupplier.SelectedValue.ToString(); } catch (MyException MyEx) { ok = false; errorProvider1.SetError(cmbSupplier, MyEx.toString()); } try { if (ok) { drProduct = dsSurefill.Tables["Product"].NewRow(); drProduct["ProductNo"] = myProduct.ProductNo; drProduct["ProductDescription"] = myProduct.ProductDescription; drProduct["ProductMeasure"] = 1000; drProduct["ProductPrice"] = myProduct.ProductPrice; drProduct["ProductQty"] = myProduct.ProductQty; drProduct["SupplierNo"] = myProduct.SupplierNo; dsSurefill.Tables["Product"].Rows.Add(drProduct); daProduct.Update(dsSurefill, "Product"); MessageBox.Show("Product Added"); if (MessageBox.Show("Do you want to add another Product?", "Add Product", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes) { clearAddForm(); getNumber(dsSurefill.Tables["Product"].Rows.Count); } else { } } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "" + ex.Message, "Error!", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } }
private void btnConfirmAddSupplier_Click(object sender, EventArgs e) { MySupplier mySupplier = new MySupplier(); bool ok = true; errorProvider1.Clear(); try { mySupplier.SupplierNo = lblAddActualSupplierNo.Text.Trim(); } catch (MyException MyEx) { ok = false; errorProvider1.SetError(lblAddActualSupplierNo, MyEx.toString()); } try { mySupplier.Name = txtAddSupplierName.Text.Trim(); } catch (MyException MyEx) { ok = false; errorProvider1.SetError(txtAddSupplierName, MyEx.toString()); } try { mySupplier.Street = txtAddSupplierStreet.Text.Trim(); } catch (MyException MyEx) { ok = false; errorProvider1.SetError(txtAddSupplierStreet, MyEx.toString()); } try { mySupplier.Town = txtAddSupplierTown.Text.Trim(); } catch (MyException MyEx) { ok = false; errorProvider1.SetError(txtAddSupplierTown, MyEx.toString()); } try { mySupplier.County = txtAddSupplierCounty.Text.Trim(); } catch (MyException MyEx) { ok = false; errorProvider1.SetError(txtAddSupplierCounty, MyEx.toString()); } try { mySupplier.Postcode = txtAddSupplierPostcode.Text.Trim(); } catch (MyException MyEx) { ok = false; errorProvider1.SetError(txtAddSupplierPostcode, MyEx.toString()); } try { mySupplier.TelephoneNo = txtAddSupplierTelephoneNo.Text.Trim(); } catch (MyException MyEx) { ok = false; errorProvider1.SetError(txtAddSupplierTelephoneNo, MyEx.toString()); } try { mySupplier.Email = txtAddSupplierEmail.Text.Trim(); } catch (MyException MyEx) { ok = false; errorProvider1.SetError(txtAddSupplierEmail, MyEx.toString()); } try { if (ok) { drSupplier = dsSurefill.Tables["Supplier"].NewRow(); drSupplier["SupplierNo"] = mySupplier.SupplierNo; drSupplier["Name"] = mySupplier.Name; drSupplier["Street"] = mySupplier.Street; drSupplier["Town"] = mySupplier.Town; drSupplier["County"] = mySupplier.County; drSupplier["Postcode"] = mySupplier.Postcode; drSupplier["Email"] = mySupplier.Email; drSupplier["TelephoneNo"] = mySupplier.TelephoneNo; dsSurefill.Tables["Supplier"].Rows.Add(drSupplier); daSupplier.Update(dsSurefill, "Supplier"); MessageBox.Show("Supplier Added"); if (MessageBox.Show("Do you want to add another Supplier?", "Add Supplier", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes) { clearAddForm(); getNumber(dsSurefill.Tables["Supplier"].Rows.Count); } else { } } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "" + ex.Message, "Error!", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } }
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 picBookingSave_Click(object sender, EventArgs e) { MyBooking myBook = new MyBooking(); MainWindow.maxCap = 0; bool ok = true; errP.Clear(); //Booking Number try { myBook.BookingNumber = lblBookingNo.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(lblBookingNo, MyEx.toString()); } //Check In Date try { myBook.CheckInDate = dtpBookingCheckIn.Value; } catch (MyException MyEx) { ok = false; errP.SetError(dtpBookingCheckIn, MyEx.toString()); } //Check Out Date try { myBook.CheckOutDate = dtpBookingCheckOut.Value; } catch (MyException MyEx) { ok = false; errP.SetError(dtpBookingCheckOut, MyEx.toString()); } //Check In Time try { myBook.BookingTime = "13:00"; } catch (MyException MyEx) { ok = false; errP.SetError(lblCheckInTime, MyEx.toString()); } //Customer Number try { myBook.CustomerNumber = cmbCustomerNo.SelectedValue.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(cmbCustomerNo, MyEx.toString()); } //Payment Type try { myBook.PaymentTypeID = cmbPayType.SelectedValue.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(cmbPayType, MyEx.toString()); } //Party Size try { for (int x = 0; x < 19; x++) { MainWindow.maxCap += Globals.capacity[x]; } if (int.Parse(txtPartySize.Text.Trim()) <= MainWindow.maxCap && int.Parse(txtPartySize.Text.Trim()) > 0) { myBook.PartySize = int.Parse(txtPartySize.Text.Trim()); } else { ok = false; errP.SetError(txtPartySize, "Party size must not exceed the capacity of the room, please enter a value of " + (MainWindow.maxCap) + " or less. Alternatively cancel and select a larger room."); } } catch (MyException MyEx) { ok = false; errP.SetError(txtPartySize, MyEx.toString()); } //Try Adding try { if (ok) { drBooking = dsBelfray.Tables["Booking"].NewRow(); drBooking["bookingNo"] = myBook.BookingNumber; drBooking["checkInDate"] = myBook.CheckInDate; drBooking["checkOutDate"] = myBook.CheckOutDate; drBooking["bookingTime"] = myBook.BookingTime; drBooking["paymentTypeID"] = myBook.PaymentTypeID; drBooking["partySize"] = myBook.PartySize; drBooking["customerNo"] = myBook.CustomerNumber; dsBelfray.Tables["Booking"].Rows.Add(drBooking); daBooking.Update(dsBelfray, "Booking"); int roomRows = dgvRooms.RowCount; for (int x = 0; x < roomRows; x++) { drBookingItem = dsBelfray.Tables["BookingItem"].NewRow(); drBookingItem["bookingNo"] = dgvRooms.Rows[x].Cells[0].Value.ToString(); drBookingItem["itemNo"] = "RM" + dgvRooms.Rows[x].Cells[1].Value.ToString(); drBookingItem["itemQty"] = DBNull.Value; dsBelfray.Tables["BookingItem"].Rows.Add(drBookingItem); } daBookingItem.Update(dsBelfray, "BookingItem"); MessageBox.Show("Booking Added"); cancelled = true; this.Close(); } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "", ex.Message + "Error!", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } }
private void picEmergeSave_Click(object sender, EventArgs e) { bool ok = true; errP.Clear(); //Contact Name try { myStaff.ContactName = txtContactName.Text.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(txtContactName, MyEx.toString()); } //Contact Tel No try { myStaff.ContactTelNo = txtContactTel.Text.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(txtPhoneNo, MyEx.toString()); } //Try Adding try { if (ok) { //Disable Emergency Info gbEmergency.Enabled = false; picEmergeSave.Visible = false; picEmergeCancel.Visible = false; //Enable Emergency Info gbAccountInfo.Enabled = true; picPassSave.Visible = true; picPassCancel.Visible = true; picCurrVisible.Visible = true; int length = txtSurname.Text.ToString().Length; string lastInitial = txtSurname.Text.ToString().Substring(0, 1); string lName = txtSurname.Text.ToString().Substring(1, length - 1); char[] fName = txtForename.Text.ToString().ToCharArray(); string initial = fName[0].ToString().ToUpper(); string login = lastInitial.ToUpper() + lName + initial; int inst = 0; bool found = false; foreach (DataRow drStaff in dsBelfray.Tables["Staff"].Rows) { if (found) { string newLogin = login + Convert.ToString(inst); if (drStaff["staffLogin"].ToString().Equals(newLogin)) { inst++; found = true; } } else { if (drStaff["staffLogin"].ToString().Equals(login)) { inst++; found = true; } } } if (found) { lblLogin.Text = lastInitial.ToUpper() + lName + initial + Convert.ToString(inst); } else { lblLogin.Text = lastInitial.ToUpper() + lName + initial; } } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "", ex.Message + "Error!", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } }
private void picBookingSave_Click(object sender, EventArgs e) { MyBooking myBook = new MyBooking(); bool ok = true; errP.Clear(); //Booking Number try { myBook.BookingNumber = lblBookingNo.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(lblBookingNo, MyEx.toString()); } ////Booking Type //try //{ // myBook.TypeID = "TYP100001"; //} //catch (MyException MyEx) //{ // ok = false; // errP.SetError(lblBookingType, MyEx.toString()); //} //Check In Date try { myBook.CheckInDate = dtpBookingCheckIn.Value; } catch (MyException MyEx) { ok = false; errP.SetError(dtpBookingCheckIn, MyEx.toString()); } //Check Out Date try { myBook.CheckOutDate = dtpBookingCheckOut.Value; } catch (MyException MyEx) { ok = false; errP.SetError(dtpBookingCheckOut, MyEx.toString()); } //Check In Time try { myBook.BookingTime = "13:00"; } catch (MyException MyEx) { ok = false; errP.SetError(lblCheckInTime, MyEx.toString()); } //Customer Number try { myBook.CustomerNumber = cmbCustomerNo.SelectedValue.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(cmbCustomerNo, MyEx.toString()); } //Payment Type try { myBook.PaymentTypeID = cmbPayType.SelectedValue.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(cmbPayType, MyEx.toString()); } //Party Size try { checkMaxCap(); if (int.Parse(txtPartySize.Text.Trim()) <= MainWindow.maxCap && int.Parse(txtPartySize.Text.Trim()) > 0) { myBook.PartySize = int.Parse(txtPartySize.Text.Trim()); } else { ok = false; errP.SetError(txtPartySize, "Party size must not exceed the capacity of the room, please enter a value of " + (MainWindow.maxCap) + " or less. Alternatively cancel and select a larger room."); } } catch (MyException MyEx) { ok = false; errP.SetError(txtPartySize, MyEx.toString()); } //Try Adding try { if (ok) { drBooking.BeginEdit(); drBooking["checkInDate"] = myBook.CheckInDate; drBooking["checkOutDate"] = myBook.CheckOutDate; drBooking["bookingTime"] = myBook.BookingTime; //drBooking["typeID"] = myBook.TypeID; drBooking["paymentTypeID"] = myBook.PaymentTypeID; //drBooking["roomNo"] = myBook.RoomNo; //drBooking["tableNo"] = myBook.TableNo; drBooking["partySize"] = myBook.PartySize; drBooking["customerNo"] = myBook.CustomerNumber; drBooking.EndEdit(); daBooking.Update(dsBelfray, "Booking"); MessageBox.Show("Booking Updated"); cancelled = true; this.Close(); } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "", ex.Message + "Error!", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } }
private void PicSaveProductEdit_Click(object sender, EventArgs e) { MyProduct myProduct = new MyProduct(); bool ok = true; errP.Clear(); try { myProduct.ProductNo = lblProductNumberDisplay.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(lblProductNumberDisplay, MyEx.toString()); } try { myProduct.ProductTypeCode = cbTypeCode.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(cbTypeCode, MyEx.toString()); } try { myProduct.ProductDesc = txtProdDesc.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtProdDesc, MyEx.toString()); } try { myProduct.CostPrice = txtCostPrice.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtCostPrice, MyEx.toString()); } try { myProduct.QtyInStock = txtQTY.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtQTY, MyEx.toString()); } try { myProduct.PackSize = txtPackSize.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtPackSize, MyEx.toString()); } try { myProduct.ReOrderLvl = txtReOrder.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtReOrder, MyEx.toString()); } try { myProduct.SupplierID = cbSuppID.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(cbSuppID, MyEx.toString()); } //try edit try { if (ok) { drProduct.BeginEdit(); drProduct["productNumber"] = myProduct.ProductNo; drProduct["productTypeCode"] = myProduct.ProductTypeCode; drProduct["productDesc"] = myProduct.ProductDesc; drProduct["costPrice"] = myProduct.CostPrice; drProduct["qtyInStock"] = myProduct.QtyInStock; drProduct["packSize"] = myProduct.PackSize; drProduct["reorderLvl"] = myProduct.ReOrderLvl; drProduct["supplierID"] = myProduct.SupplierID; drProduct.EndEdit(); daProduct.Update(dsBelfray, "Product"); MessageBox.Show("Product Details Edited"); } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "", ex.Message + "Error!", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } }
private void PicSaveSupplier_Click(object sender, EventArgs e) { drSupplier = dsBelfray.Tables["Supplier"].Rows.Find(lblESupplierID.Text); MySupplier mySupp = new MySupplier(); bool ok = true; errP.Clear(); try { mySupp.SupplierID = lblESupplierID.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(lblESupplierID, MyEx.toString()); } try { mySupp.SupplierName = txtSuppName.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtSuppName, MyEx.toString()); } try { mySupp.SupplierAddress = txtSuppAddress.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtSuppAddress, MyEx.toString()); } try { mySupp.SupplierTown = txtSuppTown.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtSuppTown, MyEx.toString()); } try { mySupp.SupplierCounty = txtSuppCounty.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtSuppCounty, MyEx.toString()); } try { mySupp.SupplierPostCode = txtSuppPC.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtSuppPC, MyEx.toString()); } try { mySupp.SupplierEmail = txtSuppEmail.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtSuppEmail, MyEx.toString()); } try { mySupp.SupplierTelNo = txtSuppTel.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtSuppTel, MyEx.toString()); } //Try Adding try { if (ok) { drSupplier.BeginEdit(); drSupplier["supplierName"] = mySupp.SupplierName; drSupplier["supplierAddress"] = mySupp.SupplierAddress; drSupplier["supplierTown"] = mySupp.SupplierTown; drSupplier["supplierCounty"] = mySupp.SupplierCounty; drSupplier["supplierPostCode"] = mySupp.SupplierPostCode; drSupplier["supplierEmail"] = mySupp.SupplierEmail; drSupplier["supplierTelNo"] = mySupp.SupplierTelNo; drSupplier.EndEdit(); daSupplier.Update(dsBelfray, "Supplier"); MessageBox.Show("Supplier Updated"); chkBxEditSupp.Checked = false; this.Update(); } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "", ex.Message + "Error!", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } }
private void picAdd_Click(object sender, EventArgs e) { bool ok = true; errP.Clear(); int rows = dgvCurrentOrder.RowCount; bool newItem = false; int qty = 0; if (rows > 1) { for (int x = 0; x < rows - 1; x++) { if (!lblItemNo.Text.ToString().Equals(dgvCurrentOrder.Rows[x].Cells[2].Value.ToString())) { newItem = true; } else { newItem = false; break; } } } else { newItem = true; } if (newItem) { try { if (MyValidation.validNumber(txtQty.Text.Trim()) && MyValidation.validLength((txtQty.Text.Trim()), 1, 1) && !txtQty.Text.ToString().Equals("0")) { qty = Convert.ToInt32(txtQty.Text.Trim()); } else { throw new MyException("Quantity must be a number between 1 and 9."); } } catch (MyException MyEx) { ok = false; errP.SetError(txtQty, MyEx.toString()); } //Try Adding try { if (ok) { if (rows > 1) { for (int x = 0; x < rows - 1; x++) { if (dgvCurrentOrder.Rows[x].Cells[2].Value.ToString().Equals(lblItemNo.Text)) { newItem = false; break; } } } if (newItem) { dgvCurrentOrder.Rows.Add(lblBookingNo.Text, lblRoomNo.Text, lblItemNo.Text, lblItemPrice.Text, txtQty.Text); } else { MessageBox.Show("Item Number " + lblItemNo.Text + " has already been added, choose a new item or remove current Item from the order and add with correct quantity.", "Edit Room Service", MessageBoxButtons.OK); } picAdd.Visible = false; picSave.Visible = true; //Reset Item Detals lblItemNo.Text = "-"; lblItemNo.Enabled = false; lblItemDescription.Text = "-"; lblItemDescription.Enabled = false; lblItemPrice.Text = "-"; lblItemPrice.Enabled = false; txtQty.Text = "0"; txtQty.Enabled = false; lblItemTotal.Text = "-"; lblItemTotal.Enabled = false; lblItemNum.Enabled = false; lblItemDesc.Enabled = false; lblPrice.Enabled = false; lblQty.Enabled = false; lblTotal.Enabled = false; dgvItemList.ClearSelection(); } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "", ex.Message + "Error!", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } } else { MessageBox.Show("This Item has already been ordered by this room, you must remove the item from the current order list and add it agin with the correct information.", "Add an Item", MessageBoxButtons.OK); } }
private void picStaffSave_Click(object sender, EventArgs e) { bool ok = true; errP.Clear(); //Forename try { myStaff.Forename = txtForename.Text.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(txtForename, MyEx.toString()); } //Surname try { myStaff.Surname = txtSurname.Text.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(txtSurname, MyEx.toString()); } //Street try { myStaff.Street = txtStreet.Text.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(txtStreet, MyEx.toString()); } //City try { myStaff.City = txtCity.Text.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(txtCity, MyEx.toString()); } //County try { myStaff.County = txtCounty.Text.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(txtCounty, MyEx.toString()); } //Postcode try { myStaff.Postcode = txtPostcode.Text.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(txtPostcode, MyEx.toString()); } //Tel No try { myStaff.TelNo = txtPhoneNo.Text.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(txtPhoneNo, MyEx.toString()); } //Try Adding try { if (ok) { //Disable User Info gbUserInfo.Enabled = false; picStaffCancel.Visible = false; picStaffSave.Visible = false; //Enable Emergency Info gbEmergency.Enabled = true; picEmergeSave.Visible = true; picEmergeCancel.Visible = true; } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "", ex.Message + "Error!", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } }
private void picPassSave_Click(object sender, EventArgs e) { bool ok = true; errP.Clear(); //Customer Number try { switch (cmbAccountType.SelectedIndex) { case 0: myStaff.AccType = "ADM"; break; case 1: myStaff.AccType = "HTL"; break; case 2: myStaff.AccType = "RES"; break; } } catch (MyException MyEx) { ok = false; errP.SetError(cmbAccountType, MyEx.toString()); } //Customer Number try { myStaff.StaffPW = txtPassword.Text.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(txtPassword, MyEx.toString()); } //Try Adding try { if (ok) { drStaff = dsBelfray.Tables["Staff"].NewRow(); drStaff["staffID"] = lblStaffNo.Text.ToString(); drStaff["staffFName"] = myStaff.Forename; drStaff["staffLName"] = myStaff.Surname; drStaff["staffStreet"] = myStaff.Street; drStaff["staffCity"] = myStaff.City; drStaff["staffCounty"] = myStaff.County; drStaff["staffPcode"] = myStaff.Postcode; drStaff["staffTelNo"] = myStaff.TelNo; drStaff["staffEmergName"] = myStaff.ContactName; drStaff["staffEmergTel"] = myStaff.ContactTelNo; drStaff["staffLogin"] = lblLogin.Text.ToString(); drStaff["staffPassword"] = myStaff.StaffPW; drStaff["accTypeID"] = myStaff.AccType; dsBelfray.Tables["Staff"].Rows.Add(drStaff); daStaff.Update(dsBelfray, "Staff"); MessageBox.Show("Staff Added"); this.Close(); } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "", ex.Message + "Error!", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } }
private void btnAAStaff_Click(object sender, EventArgs e) { MyStaff myStaff = new MyStaff(); bool ok = true; errP.Clear(); try { myStaff.StaffID = lblAddStaffID.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(lblAddStaffID, MyEx.toString()); } try { myStaff.Email = txtAEmail.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtAEmail, MyEx.toString()); } try { myStaff.Forename = txtAForeN.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtAForeN, MyEx.toString()); } try { myStaff.TelNo = txtATel.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtATel, MyEx.toString()); } try { myStaff.Job = cmbAJr.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(cmbAJr, MyEx.toString()); } try { myStaff.Surname = txtASurN.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtASurN, MyEx.toString()); } try { myStaff.JobDescription = txtAJobDesc.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtAJobDesc, MyEx.toString()); } try { if (ok) { drStaff = dsKaizen.Tables["Staff"].NewRow(); drStaff["StaffID"] = myStaff.StaffID; drStaff["StaffFName"] = myStaff.Forename; drStaff["StaffSName"] = myStaff.Surname; drStaff["Job"] = myStaff.Job; drStaff["JobDesc"] = myStaff.JobDescription; drStaff["StaffEmail"] = myStaff.Email; drStaff["StaffTel"] = myStaff.TelNo; dsKaizen.Tables["Staff"].Rows.Add(drStaff); daStaff.Update(dsKaizen, "Staff"); MessageBox.Show("Employee Added"); if (MessageBox.Show("Do you wish to add another Employee?", "Add Employee", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes) { clearAddForm(); getStaffID(dsKaizen.Tables["Staff"].Rows.Count); } else { tabStaff.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(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 btnEdEdit_Click(object sender, EventArgs e) { if (btnEdEdit.Text.Trim() == "EDIT") { enableEditTxtboxes(); btnEdEdit.Text = "Save"; } else { MyStaff myStaff = new MyStaff(); bool ok = true; errP.Clear(); try { myStaff.StaffID = lblEdStaffID.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(lblEdStaffID, MyEx.toString()); } try { myStaff.Email = txtEdEmail.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtEdEmail, MyEx.toString()); } try { myStaff.Forename = txtEdForeN.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtEdForeN, MyEx.toString()); } try { myStaff.TelNo = txtEdTel.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtEdTel, MyEx.toString()); } try { myStaff.Job = txtEdJobR.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtEdJobR, MyEx.toString()); } try { myStaff.Surname = txtEdSurN.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtEdSurN, MyEx.toString()); } try { myStaff.JobDescription = txtEdJobDesc.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtEdJobDesc, MyEx.toString()); } try { if (ok) { drStaff.BeginEdit(); drStaff["StaffID"] = myStaff.StaffID; drStaff["StaffFName"] = myStaff.Forename; drStaff["StaffSName"] = myStaff.Surname; drStaff["Job"] = myStaff.Job; drStaff["JobDesc"] = myStaff.JobDescription; drStaff["StaffEmail"] = myStaff.Email; drStaff["StaffTel"] = myStaff.TelNo; drStaff.EndEdit(); daStaff.Update(dsKaizen, "Staff"); btnEdEdit.Text = "EDIT"; MessageBox.Show("Employee Details Updated", "Staff"); tabStaff.SelectedIndex = 0; disableEditTxtboxes(); } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "" + ex.Message, "Error !", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } } }
private void btnConfirmEditProduct_Click(object sender, EventArgs e) { if (btnConfirmEditProduct.Text == "Edit") { txtAddProductDescription.Enabled = true; txtEditProductPrice.Enabled = true; txtEditProductQty.Enabled = true; btnConfirmEditProduct.Text = "Save"; } else { MyProduct myProduct = new MyProduct(); bool ok = true; errorProvider1.Clear(); try { myProduct.ProductNo = lblEditActualProductNo.Text.Trim(); } catch (MyException MyEx) { ok = false; errorProvider1.SetError(lblEditActualProductNo, MyEx.toString()); } try { myProduct.ProductDescription = txtEditProductDescription.Text.Trim(); } catch (MyException MyEx) { ok = false; errorProvider1.SetError(txtEditProductDescription, MyEx.toString()); } try { myProduct.ProductPrice = Convert.ToDouble(txtEditProductPrice.Text.Trim()); } catch (MyException MyEx) { ok = false; errorProvider1.SetError(txtEditProductPrice, MyEx.toString()); } try { myProduct.ProductQty = Convert.ToInt32(txtEditProductQty.Text.Trim()); } catch (MyException MyEx) { ok = false; errorProvider1.SetError(txtEditProductQty, MyEx.toString()); } try { if (ok) { drProduct.BeginEdit(); drProduct["ProductNo"] = myProduct.ProductNo; drProduct["ProductDescription"] = myProduct.ProductDescription; drProduct["ProductPrice"] = myProduct.ProductPrice; drProduct["ProductQty"] = myProduct.ProductQty; drProduct.EndEdit(); daProduct.Update(dsSurefill, "Product"); MessageBox.Show("Product details updated", "Product"); txtEditProductDescription.Enabled = false; txtEditProductPrice.Enabled = false; txtEditProductQty.Enabled = false; btnConfirmEditProduct.Text = "Edit"; } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "" + ex.Message, "Error!", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } } }
private void picCustomerSave_Click(object sender, EventArgs e) { MyCustomer myCust = new MyCustomer(); bool ok = true; errP.Clear(); //Customer Number try { myCust.CustomerNumber = lblCustNo.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(lblCustNo, MyEx.toString()); } //Customer Title try { myCust.Title = cmbTitle.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(cmbTitle, MyEx.toString()); } //Customer Forename try { myCust.Forename = txtForename.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtForename, MyEx.toString()); } //Customer Surname try { myCust.Surname = txtSurname.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtSurname, MyEx.toString()); } //Customer Street try { myCust.Street = txtStreet.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtStreet, MyEx.toString()); } //Customer City try { myCust.City = txtCity.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtCity, MyEx.toString()); } //Customer County try { myCust.County = txtCounty.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtCounty, MyEx.toString()); } //Customer PostCode try { myCust.Postcode = txtPostcode.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtPostcode, MyEx.toString()); } //Customer TelNo try { myCust.TelNo = txtPhoneNo.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtPhoneNo, MyEx.toString()); } //Try Adding try { if (ok) { drCustomer.BeginEdit(); drCustomer["customerForename"] = myCust.Title; drCustomer["customerForename"] = myCust.Forename; drCustomer["customerSurname"] = myCust.Surname; drCustomer["customerStreet"] = myCust.Street; drCustomer["customerCity"] = myCust.City; drCustomer["customerCounty"] = myCust.County; drCustomer["customerPostcode"] = myCust.Postcode; drCustomer["customerTel"] = myCust.TelNo; drCustomer.EndEdit(); daCustomer.Update(dsBelfray, "Customer"); MessageBox.Show("Customer Updated"); disableCustomerEdit(); } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "", ex.Message + "Error!", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } }
private void picPassSave_Click(object sender, EventArgs e) { foreach (DataRow drStaff in dsBelfray.Tables["Staff"].Rows) { if (drStaff["staffID"].ToString().Equals(lblStaffNo.Text)) { MyStaff myStaff = new MyStaff(); bool ok = true; errP.Clear(); //Account Type try { switch (cmbAccountType.SelectedIndex) { case 0: myStaff.AccType = "ADM"; break; case 1: myStaff.AccType = "HTL"; break; case 2: myStaff.AccType = "RES"; break; } } catch (MyException MyEx) { ok = false; errP.SetError(cmbAccountType, MyEx.toString()); } //Staff Password try { myStaff.StaffPW = txtCurrent.Text.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(txtCurrent, MyEx.toString()); } //Try Adding try { if (ok) { drStaff.BeginEdit(); drStaff["staffPassword"] = myStaff.StaffPW; drStaff["accTypeID"] = myStaff.AccType; drStaff.EndEdit(); daStaff.Update(dsBelfray, "Staff"); MessageBox.Show("Account Info Updated"); picPassCancel.Visible = false; picPassSave.Visible = false; picPassEdit.Visible = true; txtCurrent.Enabled = false; cmbAccountType.Enabled = false; } } 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 picStaffSave_Click(object sender, EventArgs e) { foreach (DataRow drStaff in dsBelfray.Tables["Staff"].Rows) { if (drStaff["staffID"].ToString().Equals(lblStaffNo.Text)) { MyStaff myStaff = new MyStaff(); bool ok = true; errP.Clear(); //Forename try { myStaff.Forename = txtForename.Text.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(txtForename, MyEx.toString()); } //Surname try { myStaff.Surname = txtSurname.Text.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(txtSurname, MyEx.toString()); } //Street try { myStaff.Street = txtStreet.Text.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(txtStreet, MyEx.toString()); } //City try { myStaff.City = txtCity.Text.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(txtCity, MyEx.toString()); } //County try { myStaff.County = txtCounty.Text.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(txtCounty, MyEx.toString()); } //Postcode try { myStaff.Postcode = txtPostcode.Text.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(txtPostcode, MyEx.toString()); } //Tel No try { myStaff.TelNo = txtPhoneNo.Text.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(txtPhoneNo, MyEx.toString()); } //Try Adding try { if (ok) { int length = txtSurname.Text.ToString().Length; string lastInitial = txtSurname.Text.ToString().Substring(0, 1); string lName = txtSurname.Text.ToString().Substring(1, length - 1); char[] fName = txtForename.Text.ToString().ToCharArray(); string initial = fName[0].ToString().ToUpper(); lblLogin.Text = lastInitial.ToUpper() + lName + initial; drStaff.BeginEdit(); drStaff["staffFName"] = myStaff.Forename; drStaff["staffLName"] = myStaff.Surname; drStaff["staffStreet"] = myStaff.Street; drStaff["staffCity"] = myStaff.City; drStaff["staffCounty"] = myStaff.County; drStaff["staffPcode"] = myStaff.Postcode; drStaff["staffTelNo"] = myStaff.TelNo; drStaff["staffLogin"] = lblLogin.Text.ToString(); drStaff.EndEdit(); daStaff.Update(dsBelfray, "Staff"); MessageBox.Show("User Info Updated"); picStaffCancel.Visible = false; picStaffSave.Visible = false; picStaffEdit.Visible = true; txtForename.Enabled = false; txtSurname.Enabled = false; txtStreet.Enabled = false; txtCity.Enabled = false; txtCounty.Enabled = false; txtPostcode.Enabled = false; txtPhoneNo.Enabled = false; } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "", ex.Message + "Error!", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } } } }
private void picCustomerSave_Click(object sender, EventArgs e) { MyCustomer myCust = new MyCustomer(); bool ok = true; errP.Clear(); //Customer Number try { myCust.CustomerNumber = lblCustNo.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(lblCustNo, MyEx.toString()); } //Customer Title try { myCust.Title = cmbTitle.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(cmbTitle, MyEx.toString()); } //Customer Forename try { myCust.Forename = txtForename.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtForename, MyEx.toString()); } //Customer Surname try { myCust.Surname = txtSurname.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtSurname, MyEx.toString()); } //Customer Street try { myCust.Street = txtStreet.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtStreet, MyEx.toString()); } //Customer City try { myCust.City = txtCity.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtCity, MyEx.toString()); } //Customer County try { myCust.County = txtCounty.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtCounty, MyEx.toString()); } //Customer PostCode try { myCust.Postcode = txtPostcode.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtPostcode, MyEx.toString()); } //Customer TelNo try { myCust.TelNo = txtPhoneNo.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtPhoneNo, MyEx.toString()); } //Try Adding try { if (ok) { drCustomer = dsBelfray.Tables["Customer"].NewRow(); drCustomer["customerNo"] = myCust.CustomerNumber; drCustomer["customerTitle"] = myCust.Title; drCustomer["customerForename"] = myCust.Forename; drCustomer["customerSurname"] = myCust.Surname; drCustomer["customerStreet"] = myCust.Street; drCustomer["customerCity"] = myCust.City; drCustomer["customerCounty"] = myCust.County; drCustomer["customerPostcode"] = myCust.Postcode; drCustomer["customerTel"] = myCust.TelNo; dsBelfray.Tables["Customer"].Rows.Add(drCustomer); daCustomer.Update(dsBelfray, "Customer"); MessageBox.Show("Customer Added"); clearCustomerPanel(); custPanelCont(); bookPanelCont(); int noRows = dsBelfray.Tables["Customer"].Rows.Count; //cb ProductType cmbCustomerNo.DataSource = dsBelfray.Tables["Customer"]; cmbCustomerNo.ValueMember = "customerNo"; cmbCustomerNo.DisplayMember = "customerNo"; cmbCustomerNo.SelectedIndex = noRows - 1; } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "", ex.Message + "Error!", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } }
private void btnAdd_Click(object sender, EventArgs e) { MyStock myStock = new MyStock(); bool ok = true; errP.Clear(); try { myStock.StockID = lblAddStockID.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(lblAddStockID, MyEx.toString()); } try { myStock.StockDesc = txtAddDesc.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtAddDesc, MyEx.toString()); } try { myStock.QtyInStock = Convert.ToInt32(txtAddQTY.Text.Trim()); } catch (MyException MyEx) { ok = false; errP.SetError(txtAddQTY, MyEx.toString()); } catch (FormatException Formex) { ok = false; errP.SetError(txtAddQTY, "Please Enter a vaild number"); } try { myStock.EquipType = this.cmbAddProdType.GetItemText(this.cmbAddProdType.SelectedItem); } catch (MyException MyEx) { ok = false; errP.SetError(cmbAddProdType, MyEx.toString()); } try { myStock.PurPrice = Convert.ToDouble(txtAddPurchase.Text.Trim()); } catch (MyException MyEx) { ok = false; errP.SetError(txtAddPurchase, MyEx.toString()); } catch (FormatException Formex) { ok = false; errP.SetError(txtAddPurchase, "Please Enter a vaild number"); } try { myStock.RentalPrice = Convert.ToDouble(txtAddRental.Text.Trim()); } catch (MyException MyEx) { ok = false; errP.SetError(txtAddRental, MyEx.toString()); } catch (FormatException Formex) { ok = false; errP.SetError(txtAddRental, "Please Enter a vaild number"); } try { myStock.ServicePrice = Convert.ToDouble(txtAddService.Text.Trim()); } catch (MyException MyEx) { ok = false; errP.SetError(txtAddService, MyEx.toString()); } catch (FormatException Formex) { ok = false; errP.SetError(txtAddService, "Please Enter a vaild number"); } try { myStock.SuppID = txtAddProdSupplierID.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtAddProdSupplierID, MyEx.toString()); } try { if (ok) { drStock = dsKaizen.Tables["Stock"].NewRow(); drStock["StockID"] = myStock.StockID; drStock["StockDescription"] = myStock.StockDesc; drStock["Equiptype"] = myStock.EquipType; drStock["PurPrice"] = myStock.PurPrice; drStock["RentPrice"] = myStock.RentalPrice; drStock["ServPrice"] = myStock.ServicePrice; drStock["QtyInStock"] = myStock.QtyInStock; drStock["SuppID"] = myStock.SuppID; dsKaizen.Tables["Stock"].Rows.Add(drStock); daStock.Update(dsKaizen, "Stock"); MessageBox.Show("Stock Item/s Added"); clearAddForm(); if (MessageBox.Show("Do you wish to add more stock items?", "Add Stock", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes) { getStockID(dsKaizen.Tables["Stock"].Rows.Count); } else { tabStock.SelectedIndex = 0; } } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "" + ex.Message, "Error !", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } }
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 btnEditEdit_Click(object sender, EventArgs e) { if (btnEditStock.Text == "EDIT STOCK") { enableEditTxtboxes(); btnEditStock.Text = "Save"; } else { MyStock myStock = new MyStock(); bool ok = true; errP.Clear(); try { myStock.StockDesc = txtEditDesc.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtEditDesc, MyEx.toString()); } try { myStock.QtyInStock = Convert.ToInt32(txtEditQTY.Text.Trim()); } catch (MyException MyEx) { ok = false; errP.SetError(txtEditQTY, MyEx.toString()); } catch (FormatException Formex) { ok = false; errP.SetError(txtEditQTY, "Please Enter a vaild number"); } try { myStock.EquipType = this.cmbEditProdType.GetItemText(this.cmbEditProdType.SelectedItem); } catch (MyException MyEx) { ok = false; errP.SetError(cmbEditProdType, MyEx.toString()); } try { myStock.PurPrice = Convert.ToDouble(txtEditPurchase.Text.Trim()); } catch (MyException MyEx) { ok = false; errP.SetError(txtEditPurchase, MyEx.toString()); } catch (FormatException Formex) { ok = false; errP.SetError(txtEditPurchase, "Please Enter a vaild number"); } try { myStock.RentalPrice = Convert.ToDouble(txtEditRental.Text.Trim()); } catch (MyException MyEx) { ok = false; errP.SetError(txtEditRental, MyEx.toString()); } catch (FormatException Formex) { ok = false; errP.SetError(txtEditRental, "Please Enter a vaild number"); } try { myStock.ServicePrice = Convert.ToDouble(txtEditService.Text.Trim()); } catch (MyException MyEx) { ok = false; errP.SetError(txtEditService, MyEx.toString()); } catch (FormatException Formex) { ok = false; errP.SetError(txtEditService, "Please Enter a vaild number"); } try { myStock.SuppID = txtEditProdSupplierID.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(txtEditProdSupplierID, MyEx.toString()); } try { if (ok) { drStock.BeginEdit(); drStock["StockDescription"] = myStock.StockDesc; drStock["EquipType"] = myStock.EquipType; drStock["PurPrice"] = myStock.PurPrice; drStock["RentPrice"] = myStock.RentalPrice; drStock["ServPrice"] = myStock.ServicePrice; drStock["QtyInStock"] = myStock.QtyInStock; drStock["SuppID"] = myStock.SuppID; drStock.EndEdit(); daStock.Update(dsKaizen, "Stock"); MessageBox.Show("Stock Details Updated", "Stock"); disableEditTxtboxes(); btnEditStock.Text = "EDIT STOCK"; tabStock.SelectedIndex = 0; } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "" + ex.Message, "Error !", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } } }
private void btnConfirmEditSupplier_Click(object sender, EventArgs e) { if (btnConfirmEditSupplier.Text == "Edit") { txtAddSupplierName.Enabled = true; txtEditSupplierStreet.Enabled = true; txtEditSupplierTown.Enabled = true; txtEditSupplierCounty.Enabled = true; txtEditSupplierPostcode.Enabled = true; txtEditSupplierEmail.Enabled = true; txtEditSupplierTelephoneNo.Enabled = true; btnConfirmEditSupplier.Text = "Save"; } else { MySupplier mySupplier = new MySupplier(); bool ok = true; errorProvider1.Clear(); try { mySupplier.SupplierNo = lblEditActualSupplierNo.Text.Trim(); } catch (MyException MyEx) { ok = false; errorProvider1.SetError(lblEditActualSupplierNo, MyEx.toString()); } try { mySupplier.Name = txtEditSupplierName.Text.Trim(); } catch (MyException MyEx) { ok = false; errorProvider1.SetError(txtEditSupplierName, MyEx.toString()); } try { mySupplier.Street = txtEditSupplierStreet.Text.Trim(); } catch (MyException MyEx) { ok = false; errorProvider1.SetError(txtEditSupplierStreet, MyEx.toString()); } try { mySupplier.Town = txtEditSupplierTown.Text.Trim(); } catch (MyException MyEx) { ok = false; errorProvider1.SetError(txtEditSupplierTown, MyEx.toString()); } try { mySupplier.County = txtEditSupplierCounty.Text.Trim(); } catch (MyException MyEx) { ok = false; errorProvider1.SetError(txtEditSupplierCounty, MyEx.toString()); } try { mySupplier.Postcode = txtEditSupplierPostcode.Text.Trim(); } catch (MyException MyEx) { ok = false; errorProvider1.SetError(txtEditSupplierPostcode, MyEx.toString()); } try { mySupplier.TelephoneNo = txtEditSupplierTelephoneNo.Text.Trim(); } catch (MyException MyEx) { ok = false; errorProvider1.SetError(txtEditSupplierTelephoneNo, MyEx.toString()); } try { mySupplier.Email = txtEditSupplierEmail.Text.Trim(); } catch (MyException MyEx) { ok = false; errorProvider1.SetError(txtEditSupplierEmail, MyEx.toString()); } try { if (ok) { drSupplier.BeginEdit(); drSupplier["SupplierNo"] = mySupplier.SupplierNo; drSupplier["Name"] = mySupplier.Name; drSupplier["Street"] = mySupplier.Street; drSupplier["Town"] = mySupplier.Town; drSupplier["County"] = mySupplier.County; drSupplier["Postcode"] = mySupplier.Postcode; drSupplier["Email"] = mySupplier.Email; drSupplier["TelephoneNo"] = mySupplier.TelephoneNo; drSupplier.EndEdit(); daSupplier.Update(dsSurefill, "Supplier"); MessageBox.Show("Supplier details updated", "Supplier"); txtEditSupplierName.Enabled = false; txtEditSupplierStreet.Enabled = false; txtEditSupplierTown.Enabled = false; txtEditSupplierCounty.Enabled = false; txtEditSupplierPostcode.Enabled = false; txtEditSupplierEmail.Enabled = false; txtEditSupplierTelephoneNo.Enabled = false; btnConfirmEditSupplier.Text = "Edit"; } } 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); } }