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