private void Button1_Click_1(object sender, EventArgs e)
{
if (!Validation.validate(txtCustomerFirst.Text, "name") || !Validation.validate(txtCustomerLast.Text, "name") || !Validation.validate(txtCustomerID.Text, "id") ||
!Validation.validate(txtCustomerPhone.Text, "phone") || !Validation.validate(txtCustomerEmail.Text, "email"))
{
MessageBox.Show("All input fields must be valid");
return;
}
DBConnection dBConnection = DBConnection.Instance();
try
{
if (dBConnection.IsConnect())
{
string query = "INSERT INTO customer(customer_first, customer_last, customer_email, customer_phone, customer_id_number) VALUES('" + txtCustomerFirst.Text + "', " +
"'" + txtCustomerLast.Text + "', '" + txtCustomerEmail.Text.ToLower() + "', '" + txtCustomerPhone.Text + "', '" + txtCustomerID.Text + "')";
var command = new MySqlCommand(query, dBConnection.Connection);
command.ExecuteNonQuery();
}
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
this.Close();
Main_Form.ActiveForm.Refresh();
}
private void BtnServiceAdd_Click(object sender, EventArgs e)
{
double price = txtServicePrice.Text.Contains("R") ? Convert.ToDouble(txtServicePrice.Text.Substring(1)) : Convert.ToDouble(txtServicePrice.Text);
if (!Validation.validate(txtServiceName.Text, "name") || !Validation.validate(txtServiceDescription.Text, "name") || !Validation.validate(txtServicePrice.Text, "price"))
{
MessageBox.Show("All input fields must be valid");
return;
}
if (cbxServiceType.SelectedIndex <= -1)
{
MessageBox.Show("Please select a service type");
return;
}
try
{
string bookingTypeID = "";
string query = "SELECT service_type_id FROM service_type WHERE service_type_name = '" + cbxServiceType.SelectedItem.ToString() + "'";
var command = new MySqlCommand(query, dbCon.Connection);
var reader = command.ExecuteReader();
reader.Read();
bookingTypeID = reader.GetString(0);
reader.Close();
query = "INSERT INTO `service`(`service_name`, `service_description`, `service_price`, `service_type_id`) VALUES('" +
txtServiceName.Text + "', '" + txtServiceDescription.Text + "', '" + price + "', '" + bookingTypeID + "')";
command = new MySqlCommand(query, dbCon.Connection);
command.ExecuteNonQuery();
this.Close();
Main_Form.ActiveForm.Refresh();
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
private void Button1_Click_1(object sender, EventArgs e)
{
if (!Validation.validate(txtCustomerFirst.Text, "name") || !Validation.validate(txtCustomerLast.Text, "name") || !Validation.validate(txtCustomerID.Text, "id") ||
!Validation.validate(txtCustomerPhone.Text, "phone") || !Validation.validate(txtCustomerEmail.Text, "email"))
{
MessageBox.Show("All input fields must be valid");
return;
}
DBConnection dBConnection = DBConnection.Instance();
try
{
if (dBConnection.IsConnect())
{
string query = "UPDATE `customer` SET `customer_id` = '" + GetCustomerRow + "', `customer_first` = '" + txtCustomerFirst.Text + "', `customer_last` = '" + txtCustomerLast.Text +
"', `customer_email` = '" + txtCustomerEmail.Text.ToLower() + "', `customer_phone` = '" + txtCustomerPhone.Text + "', `customer_id_number` = '" + txtCustomerID.Text + "' WHERE " +
"customer_id = '" + GetCustomerRow + "'";
var command = new MySqlCommand(query, dBConnection.Connection);
command.ExecuteNonQuery();
}
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
Close();
}
private void button1_Click(object sender, EventArgs e)
{
if (!Validation.validate(txtPhotoshootTypeName.Text, "name") || !Validation.validate(txtPhotoshootTypeDescription.Text, "name"))
{
MessageBox.Show("All input fields must be valid");
return;
}
try
{
DBConnection dBConnection = DBConnection.Instance();
if (dBConnection.IsConnect())
{
string booking_type_id = " ";
string query = "SELECT booking_type_id FROM booking_type WHERE booking_type_name = 'Photoshoot'";
var command = new MySqlCommand(query, dBConnection.Connection);
var reader = command.ExecuteReader();
while (reader.Read())
{
booking_type_id = reader.GetString(0);
}
reader.Close();
query = "INSERT INTO `photoshoot_type` (`photoshoot_type_id`, `photoshoot_type_name`, `photoshoot_type_description`, `booking_type_id`) VALUES";
query += "(NULL, '" + txtPhotoshootTypeName.Text + "', '" + txtPhotoshootTypeDescription.Text + "', '" + booking_type_id + "')";
command = new MySqlCommand(query, dBConnection.Connection);
command.ExecuteNonQuery();
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
this.Close();
}
private void Button1_Click(object sender, EventArgs e)
{
if (txtProductTypeName.Enabled)
{
if (!Validation.validate(txtProductTypeName.Text, "name") || !Validation.validate(txtProductTypeDescription.Text, "name"))
{
MessageBox.Show("All input fields must be valid");
return;
}
try
{
DBConnection dBConnection = DBConnection.Instance();
if (dBConnection.IsConnect())
{
string query = "UPDATE `product_type` SET `product_type_id` = '" + product_type_id + "', `product_type_name` = '" + txtProductTypeName.Text + "', `product_type_description`";
query += " = '" + txtProductTypeDescription.Text + "' WHERE product_type_id = '" + product_type_id + "'";
var command = new MySqlCommand(query, dBConnection.Connection);
command.ExecuteNonQuery();
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
this.Close();
}
this.Close();
}
private void Btn_AddType_Click(object sender, EventArgs e)
{
if (!Validation.validate(txtTypeName.Text, "name") || !Validation.validate(txtTypeDescription.Text, "name") || cbxAccessLevel.SelectedIndex < 0)
{
MessageBox.Show("All input fields must be valid");
return;
}
addEmployeeType();
}
private void BtnEmpAdd_Click(object sender, EventArgs e)
{
if (!Validation.validate(txtEmployeeFirst.Text, "name") || !Validation.validate(txtEmployeeLast.Text, "name") || !Validation.validate(txtEmployeeID.Text, "id") ||
!Validation.validate(txtEmployeeEmail.Text, "email") || !Validation.validate(txtEmployeePhone.Text, "phone"))
{
MessageBox.Show("All input fields must be valid");
return;
}
addEmployee();
User_Add user_Add = new User_Add();
user_Add.ShowDialog();
}
private void btnAddProducts_Click(object sender, EventArgs e)
{
double price = txtProductPrice.Text.Contains("R") ? Convert.ToDouble(txtProductPrice.Text.Substring(1)) : Convert.ToDouble(txtProductPrice.Text);
if (!Validation.validate(txtProductName.Text, "name") || !Validation.validate(txtProductDescription.Text, "name") || !Validation.validate(txtProductPrice.Text, "price"))
{
MessageBox.Show("All input fields must be valid");
return;
}
if (cbxProductType.SelectedIndex <= -1)
{
MessageBox.Show("Please select a product type");
return;
}
try
{
if (dbCon.IsConnect())
{
string bookingTypeID = "";
string query = "SELECT product_type_id FROM product_type WHERE product_type_name = '" + cbxProductType.SelectedItem.ToString() + "'";
var command = new MySqlCommand(query, dbCon.Connection);
var reader = command.ExecuteReader();
reader.Read();
bookingTypeID = reader.GetString(0);
reader.Close();
MemoryStream stream = new MemoryStream();
pictureBox1.Image.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg);
byte[] pic = stream.ToArray();
query = "INSERT INTO `product`(`product_name`, `product_description`, `product_price`, `product_type_id`, `image`) VALUES('" +
txtProductName.Text + "', '" + txtProductDescription.Text + "', '" + price + "', '" + bookingTypeID + "', '" + pic + "')";
command = new MySqlCommand(query, dbCon.Connection);
command.ExecuteNonQuery();
}
this.Close();
Main_Form.ActiveForm.Refresh();
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
private void Button1_Click(object sender, EventArgs e)
{
if (!Validation.validate(txtEmpTypeName.Text, "name") || !Validation.validate(txtEmpTypeDescription.Text, "name"))
{
MessageBox.Show("All input fields must be valid");
return;
}
try
{
DBConnection dBCon = DBConnection.Instance();
string query = "UPDATE `employee_type` SET `employee_type_name` = '" + txtEmpTypeName.Text + "', `employee_type_description` = '" + txtEmpTypeDescription.Text + "', " +
"`access_level` = '" + cbxAccessLevel.SelectedItem.ToString() + "' WHERE employee_type_id = '" + id + "'";
var command = new MySqlCommand(query, dBCon.Connection);
command.ExecuteNonQuery();
this.Close();
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private void Button1_Click(object sender, EventArgs e)
{
double price = txtServicePrice.Text.Contains("R") ? Convert.ToDouble(txtServicePrice.Text.Substring(1)) : Convert.ToDouble(txtServicePrice.Text);
if (!Validation.validate(txtServiceName.Text, "name") || !Validation.validate(txtServiceDescription.Text, "name") || !Validation.validate(txtServicePrice.Text, "price"))
{
MessageBox.Show("All input fields must be valid");
return;
}
if (cbxServiceType.SelectedIndex <= -1)
{
MessageBox.Show("Please select a service type");
return;
}
try
{
DBConnection dbConnection = DBConnection.Instance();
if (dbConnection.IsConnect())
{
string serviceTypeID = "";
string query = "SELECT service_type_id FROM service_type WHERE service_type_name = '" + cbxServiceType.SelectedItem.ToString() + "'";
var command = new MySqlCommand(query, dbConnection.Connection);
var reader = command.ExecuteReader();
reader.Read();
serviceTypeID = reader.GetString(0);
reader.Close();
query = "UPDATE `service` SET `service_name` = '" + txtServiceName.Text + "', `service_description` = '" +
"" + txtServiceDescription.Text + "', `service_price` = '" + price + "', `service_type_id` = '" +
"" + serviceTypeID + "' WHERE service_id = '" + serviceID + "'";
command = new MySqlCommand(query, dbConnection.Connection);
command.ExecuteNonQuery();
}
this.Close();
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
private void Button4_Click(object sender, EventArgs e)
{
if (!Validation.validate(txtSupplierName.Text, "name") || !Validation.validate(txtSupplierPhone.Text, "phone") || !Validation.validate(txtSupplierEmail.Text, "email"))
{
MessageBox.Show("All input fields must be valid");
return;
}
if (cbxSupplierType.SelectedIndex <= -1)
{
MessageBox.Show("Please select a supplier type");
return;
}
try
{
DBConnection dbCon = DBConnection.Instance();
if (dbCon.IsConnect())
{
string supplierTypeID = "";
string query = "SELECT supplier_type_id FROM supplier_type WHERE supplier_type_name = '" + cbxSupplierType.SelectedItem.ToString() + "'";
var command = new MySqlCommand(query, dbCon.Connection);
var reader = command.ExecuteReader();
reader.Read();
supplierTypeID = reader.GetString(0);
reader.Close();
query = "INSERT INTO `supplier`( `supplier_name`,`supplier_email`, `supplier_phone`, `supplier_location_address`, `supplier_type_id`) VALUES('" +
txtSupplierName.Text + "', '" + txtSupplierEmail.Text + "', '" + txtSupplierPhone.Text + "', '" + txtAddress.Text + "', '" + supplierTypeID + "')";
command = new MySqlCommand(query, dbCon.Connection);
command.ExecuteNonQuery();
}
this.Close();
Main_Form.ActiveForm.Refresh();
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
if (!Validation.validate(txtProductTypeName.Text, "name") || !Validation.validate(txtProdutTypeDesc.Text, "name"))
{
MessageBox.Show("All input fields must be valid");
return;
}
try
{
if (dbCon.IsConnect())
{
string query = "INSERT INTO `product_type`(`product_type_id`, `product_type_name`, `product_type_description`) VALUES('NULL', '" +
txtProductTypeName.Text + "', '" + txtProdutTypeDesc.Text + "')";
var command = new MySqlCommand(query, dbCon.Connection);
command.ExecuteNonQuery();
}
this.Close();
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
}
private void TxtCustomerEmail_TextChanged(object sender, EventArgs e)
{
Validation.checkMark(lblCustomerEmail, Validation.validate(txtCustomerEmail.Text, "email"));
}
private void TxtCustomerPhone_TextChanged(object sender, EventArgs e)
{
Validation.checkMark(lblCustomerPhone, Validation.validate(txtCustomerPhone.Text, "phone"));
}
private void TxtCustomerID_TextChanged(object sender, EventArgs e)
{
Validation.checkMark(lblCustomerID, Validation.validate(txtCustomerID.Text, "id"));
}
private void TxtCustomerLast_TextChanged(object sender, EventArgs e)
{
Validation.checkMark(lblCustomerLast, Validation.validate(txtCustomerLast.Text, "name"));
}
private void TxtServicePrice_TextChanged(object sender, EventArgs e)
{
Validation.checkMark(lblServicePrice, Validation.validate(txtServicePrice.Text, "price"));
}
private void Button6_Click(object sender, EventArgs e)
{
if (txtPackageName.Enabled)
{
DataTable Services = new DataTable();
DataTable Products = new DataTable();
if (!Validation.validate(txtPackageName.Text, "name") || !Validation.validate(txtPackageDescription.Text, "name"))
{
MessageBox.Show("Please enter a valid Name and description");
return;
}
if (dgvServicesInPackage.Rows.Count == 0)
{
MessageBox.Show("No services have been added to the package");
}
else if (dgvProductsInPackage.Rows.Count == 0)
{
MessageBox.Show("No products have been added to the package");
}
foreach (DataGridViewColumn column in dgvServicesInPackage.Columns)
{
Services.Columns.Add(column.Name);
}
foreach (DataGridViewRow row in dgvServicesInPackage.Rows)
{
DataRow dRow = Services.NewRow();
foreach (DataGridViewCell cell in row.Cells)
{
dRow[cell.ColumnIndex] = cell.Value;
}
Services.Rows.Add(dRow);
}
foreach (DataGridViewColumn column in dgvProductsInPackage.Columns)
{
Products.Columns.Add(column.Name);
}
foreach (DataGridViewRow row in dgvProductsInPackage.Rows)
{
DataRow dRow = Products.NewRow();
foreach (DataGridViewCell cell in row.Cells)
{
dRow[cell.ColumnIndex] = cell.Value;
}
Products.Rows.Add(dRow);
}
try
{
DBConnection dBConnection = DBConnection.Instance();
if (dBConnection.IsConnect())
{
int booking_package_id = 0;
string package_type = " ";
string query = "SELECT booking_package_type_id FROM booking_package_type WHERE booking_package_type_name = 'Event'";
var command = new MySqlCommand(query, dBConnection.Connection);
var reader = command.ExecuteReader();
while (reader.Read())
{
package_type = reader.GetString(0);
}
reader.Close();
query = "SELECT booking_package_id FROM booking_package WHERE booking_package_name = '" + bookingPackageName + "'";
command = new MySqlCommand(query, dBConnection.Connection);
reader = command.ExecuteReader();
while (reader.Read())
{
booking_package_id = reader.GetInt32(0);
}
reader.Close();
query = "DELETE FROM `booking_package_product` WHERE booking_package_id = '" + booking_package_id + "'";
command = new MySqlCommand(query, dBConnection.Connection);
command.ExecuteNonQuery();
query = "DELETE FROM `booking_package_service` WHERE booking_package_id = '" + booking_package_id + "'";
command = new MySqlCommand(query, dBConnection.Connection);
command.ExecuteNonQuery();
query = "DELETE FROM `booking_package` WHERE booking_package_id = '" + booking_package_id + "'";
command = new MySqlCommand(query, dBConnection.Connection);
command.ExecuteNonQuery();
query = "INSERT INTO `booking_package` (`booking_package_id`, `booking_package_name`, `booking_package_description`, `booking_package_type_id`) VALUES";
query += "('" + booking_package_id + "', '" + txtPackageName.Text + "', '" + txtPackageDescription.Text + "', '" + package_type + "')";
command = new MySqlCommand(query, dBConnection.Connection);
command.ExecuteNonQuery();
for (int k = 0; k < Services.Rows.Count; k++)
{
query = "INSERT INTO `booking_package_service` (`booking_package_id`, `service_id`) VALUES('" + booking_package_id + "', " +
"'" + Services.Rows[k].ItemArray[0] + "')";
command = new MySqlCommand(query, dBConnection.Connection);
command.ExecuteNonQuery();
}
for (int l = 0; l < Products.Rows.Count; l++)
{
query = "INSERT INTO `booking_package_product` (`booking_package_id`, `product_id`, `booking_package_product_quantity`) VALUES" +
"('" + booking_package_id + "', '" + Products.Rows[l].ItemArray[0] + "', '" + Products.Rows[l].ItemArray[2] + "')";
command = new MySqlCommand(query, dBConnection.Connection);
command.ExecuteNonQuery();
}
}
}
catch (Exception except)
{
MessageBox.Show(except.Message);
}
this.Close();
}
this.Close();
}
private void txtProductPrice_TextChanged(object sender, EventArgs e)
{
Validation.checkMark(lblProductPrice, Validation.validate(txtProductPrice.Text, "price"));
}
private void TextBox1_TextChanged(object sender, EventArgs e)
{
Validation.checkMark(lblServiceName, Validation.validate(txtServiceName.Text, "name"));
}
private void TxtType_TextChanged(object sender, EventArgs e)
{
Validation.checkMark(lblTypeName, Validation.validate(txtTypeName.Text, "name"));
}
private void TxtTelephoneNo_TextChanged(object sender, EventArgs e)
{
Validation.checkMark(lblSupplierPhone, Validation.validate(txtSupplierPhone.Text, "phone"));
}
private void TxtAmount_TextChanged(object sender, EventArgs e)
{
Validation.checkMark(lblOrderPayment, Validation.validate(txtAmount.Text, "price"));
}
private void BtnEmployeeOK_Click(object sender, EventArgs e)
{
if (!Validation.validate(txtEmployeeFirst.Text, "name") || !Validation.validate(txtEmployeeLast.Text, "name") || !Validation.validate(txtEmployeeID.Text, "price") ||
!Validation.validate(txtEmployeeEmail.Text, "email") || !Validation.validate(txtEmployeePhone.Text, "phone"))
{
MessageBox.Show("All input fields must be valid");
return;
}
if (cbxEmployeeTitle.SelectedIndex < 0 || cbxEmployeeGender.SelectedIndex < 0 ||
cbxEmployeeStatus.SelectedIndex < 0 || cbxEmployeeType.SelectedIndex < 0)
{
MessageBox.Show("Please choose values for all comboboxes");
return;
}
DBConnection dBConnection = DBConnection.Instance();
try
{
if (dBConnection.IsConnect())
{
string titleID = " ";
string maritalID = " ";
string employee_type_ID = " ";
string gender = " ";
string query = "SELECT title_id FROM title WHERE title_name = '" + cbxEmployeeTitle.SelectedItem.ToString() + "'";
var command = new MySqlCommand(query, dBConnection.Connection);
var reader = command.ExecuteReader();
while (reader.Read())
{
titleID = reader.GetString(0);
}
reader.Close();
query = "SELECT marital_status_id FROM marital_status WHERE marital_status_name = '" + cbxEmployeeStatus.SelectedItem.ToString() + "'";
command = new MySqlCommand(query, dBConnection.Connection);
reader = command.ExecuteReader();
while (reader.Read())
{
maritalID = reader.GetString(0);
}
reader.Close();
query = "SELECT employee_type_id FROM employee_type WHERE employee_type_name = '" + cbxEmployeeType.SelectedItem.ToString() + "'";
command = new MySqlCommand(query, dBConnection.Connection);
reader = command.ExecuteReader();
while (reader.Read())
{
employee_type_ID = reader.GetString(0);
}
reader.Close();
gender = cbxEmployeeGender.SelectedItem.ToString().Substring(0, 1);
query = "UPDATE `employee` SET `employee_id` = '" + GetEmployeeRow + "', `employee_first` = '" + txtEmployeeFirst.Text + "', `employee_last` = '" + txtEmployeeLast.Text +
"', `employee_idnumber` = '" + txtEmployeeID.Text + "', `employee_phone` = '" + txtEmployeePhone.Text + "', `employee_email` = '" + txtEmployeeEmail.Text.ToLower() + "', " +
"`employee_address` = '" + txtEmployeeAddress.Text + "', `employee_type` = '" + employee_type_ID + "', `employee_marital` = '" + maritalID + "', " +
"`employee_title` = '" + titleID + "' WHERE employee_id = '" + GetEmployeeRow + "'";
command = new MySqlCommand(query, dBConnection.Connection);
command.ExecuteNonQuery();
}
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
this.Close();
}
private void TxtEmployeeFirst_TextChanged(object sender, EventArgs e)
{
Validation.checkMark(lblEmployeeFirst, Validation.validate(txtEmployeeFirst.Text, "name"));
}
private void TxtDescription_TextChanged(object sender, EventArgs e)
{
Validation.checkMark(lblTypeDescription, Validation.validate(txtTypeDescription.Text, "name"));
}
private void button6_Click(object sender, EventArgs e)
{
DataTable Services = new DataTable();
DataTable Products = new DataTable();
if (!Validation.validate(txtPackageName.Text, "name") || !Validation.validate(txtPackageDescription.Text, "name"))
{
MessageBox.Show("Name and description must be valid");
return;
}
if (dgvServicesInPackage.Rows.Count == 0)
{
MessageBox.Show("No services have been added to the package");
}
else if (dgvProductsInPackage.Rows.Count == 0)
{
MessageBox.Show("No products have been added to the package");
}
foreach (DataGridViewColumn column in dgvServicesInPackage.Columns)
{
Services.Columns.Add(column.Name);
}
foreach (DataGridViewRow row in dgvServicesInPackage.Rows)
{
DataRow dRow = Services.NewRow();
foreach (DataGridViewCell cell in row.Cells)
{
dRow[cell.ColumnIndex] = cell.Value;
}
Services.Rows.Add(dRow);
}
foreach (DataGridViewColumn column in dgvProductsInPackage.Columns)
{
Products.Columns.Add(column.Name);
}
foreach (DataGridViewRow row in dgvProductsInPackage.Rows)
{
DataRow dRow = Products.NewRow();
foreach (DataGridViewCell cell in row.Cells)
{
dRow[cell.ColumnIndex] = cell.Value;
}
Products.Rows.Add(dRow);
}
try
{
DBConnection dBConnection = DBConnection.Instance();
if (dBConnection.IsConnect())
{
string package_type = "";
int booking_package_id = 0;
string query = "SELECT booking_package_type_id FROM booking_package_type WHERE booking_package_type_name = 'Photoshoot'";
var command = new MySqlCommand(query, dBConnection.Connection);
var reader = command.ExecuteReader();
reader.Read();
package_type = reader.GetString(0);
reader.Close();
query = "INSERT INTO `booking_package` (`booking_package_id`, `booking_package_name`, `booking_package_description`, `booking_package_type_id`) VALUES";
query += "(NULL, '" + txtPackageName.Text + "', '" + txtPackageDescription.Text + "', '" + package_type + "')";
command = new MySqlCommand(query, dBConnection.Connection);
command.ExecuteNonQuery();
query = "SELECT booking_package_id FROM booking_package WHERE booking_package_name = '" + txtPackageName.Text + "'";
command = new MySqlCommand(query, dBConnection.Connection);
reader = command.ExecuteReader();
reader.Read();
booking_package_id = Convert.ToInt32(reader.GetInt32(0));
reader.Close();
for (int i = 0; i < Services.Rows.Count; i++)
{
query = "INSERT INTO `booking_package_service` (`booking_package_id`, `service_id`) VALUES('" + booking_package_id + "', " +
"'" + Services.Rows[i].ItemArray[0] + "')";
command = new MySqlCommand(query, dBConnection.Connection);
command.ExecuteNonQuery();
}
for (int j = 0; j < Products.Rows.Count; j++)
{
query = "INSERT INTO `booking_package_product` (`booking_package_id`, `product_id`, `booking_package_product_quantity`) VALUES" +
"('" + booking_package_id + "', '" + Products.Rows[j].ItemArray[0] + "', '" + Products.Rows[j].ItemArray[2] + "')";
command = new MySqlCommand(query, dBConnection.Connection);
command.ExecuteNonQuery();
}
}
}
catch (Exception except)
{
MessageBox.Show(except.Message);
}
this.Close();
Main_Form.ActiveForm.Refresh();
}
