/*******************************************************************/
public Customer_Order_New(Customer_Order_Details getCustNames)
{
InitializeComponent();
customer = getCustNames;
dgv = dgvOrderList;
cNames = customer.names;
lblCustomerNames.Text = cNames;
DataGridViewButtonColumn deleteOrder = new DataGridViewButtonColumn();
DataGridViewButtonColumn viewPhotos = new DataGridViewButtonColumn();
deleteOrder.Text = "Remove Product";
deleteOrder.UseColumnTextForButtonValue = true;
deleteOrder.Visible = true;
deleteOrder.HeaderText = "Action";
viewPhotos.Text = "View Images";
viewPhotos.UseColumnTextForButtonValue = true;
viewPhotos.Visible = true;
viewPhotos.HeaderText = "Print Images";
dgv.ColumnCount = 4;
dgv.Columns[0].Name = "Product Name";
dgv.Columns[0].Width = 120;
dgv.Columns[1].Name = "Description";
dgv.Columns[1].Width = 118;
dgv.Columns[2].Name = "Product Price";
dgv.Columns[2].Width = 100;
dgv.Columns[3].Name = "Item ID";
dgv.Columns[3].Width = 70;
dgv.Columns.Add(viewPhotos);
dgv.Columns.Add(deleteOrder);
dgv.RowHeadersVisible = false;
dgv.ColumnHeadersHeight = 30;
getOrderID();
}
private void Button20_Click(object sender, EventArgs e)
{
Customer_Order_Details customerOrderDetails = new Customer_Order_Details();
customerOrderDetails.Show();
}
private void BtnSaveOrder_Click_1(object sender, EventArgs e)
{
try
{
if (row == 0)
{
int item_id = itemID.Next(1, 99);
dgv.Rows.Add(product, "Phone Cover", lblPrice.Text, "#" + item_id.ToString(), images);
items[row] = new Order(product, photos, item_id, prodID, pQty);
orderTotal += (pQty * price);
lblOTotal.Text = "R" + orderTotal.ToString();
row++;
}
else if (saveCurrentOrder == true)
{
if (MessageBox.Show("Do you want to save the current item?", "Place Customer Order", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
int item_id = itemID.Next(1, 99);
dgv.Rows.Add(product, "Phone Cover", lblPrice.Text, "#" + item_id.ToString(), images);
items[row] = new Order(product, photos, item_id, prodID, pQty);
row++;
orderTotal += subT;
lblOTotal.Text = "R" + orderTotal.ToString();
}
}
//SavingOrder save = new SavingOrder();
if (dbCon.IsConnect())
{
DateTime date = DateTime.Now;
string orderInsert = "INSERT INTO `order` (`order_id`, `order_date_placed`, `customer_id`, `order_status_id`, `order_total`, `order_quantity`) " +
"VALUES(@id, @date, @cID, @osd, @OrderTotal, @QTY)";
var com = new MySqlCommand(orderInsert, dbCon.Connection);
com.Parameters.AddWithValue("@id", ID);
com.Parameters.AddWithValue("@date", date.Date);
com.Parameters.AddWithValue("@cID", customer.customerID);
com.Parameters.AddWithValue("@osd", 1);
com.Parameters.AddWithValue("@OrderTotal", orderTotal);
com.Parameters.AddWithValue("@QTY", row);
com.ExecuteNonQuery();
if (rBtnDelivered.Checked == true)
{
var delivery = new MySqlCommand("INSERT INTO `delivery` (`delivery_id`, `delivery_location_address`, `delivery_date`, `order_id`, `delivery_fee_id`, `delivery_status_id`) " +
"VALUES(NULL, @ADDR, @DELDATE, @OID, @FEE, @ODSTATUS)", dbCon.Connection);
delivery.Parameters.AddWithValue("@ADDR", txtDelAddress.Text);
delivery.Parameters.AddWithValue("@DELDATE", date.Date);
delivery.Parameters.AddWithValue("@OID", ID);
delivery.Parameters.AddWithValue("@FEE", 1);
delivery.Parameters.AddWithValue("@ODSTATUS", 1);
delivery.ExecuteNonQuery();
}
}
foreach (Order item in items)
{
if (item != null)
{
saved = true;
if (dbCon.IsConnect())
{
var command = new MySqlCommand("INSERT INTO `order_line` (`product_id`, `order_id`, `order_line_quantity`) " +
"VALUES (@ProductID, @orderID, @quantity)", dbCon.Connection);
command.Parameters.AddWithValue("@orderID", ID);
command.Parameters.AddWithValue("@quantity", item.getProductQty);
command.Parameters.AddWithValue("@ProductID", item.getProductID);
int complete = command.ExecuteNonQuery();
int size = item.getOrderImages.Length;
int prodID = item.getProductID;
for (int indx = 0; indx < size; indx++)
{
FileStream file = new FileStream(item.getOrderImages[indx].ToString(), FileMode.Open, FileAccess.Read);
BinaryReader read = new BinaryReader(file);
saveImg = read.ReadBytes((int)file.Length);
var cmd = new MySqlCommand("INSERT INTO `order_image` (`order_image`, `order_id`, `product_id`) " +
"VALUES (@image, @orderID, @ImageProduct)", dbCon.Connection);
cmd.Parameters.AddWithValue("@orderID", ID);
cmd.Parameters.AddWithValue("@ImageProduct", prodID);
cmd.Parameters.AddWithValue("@image", saveImg);
int uploaded = cmd.ExecuteNonQuery();
}
}
}
}
//SendSMS(String AccountID, String Email, String Password, String Recipient, String Message);
if (dbCon.IsConnect())
{
var comnd = new MySqlCommand("INSERT INTO `audit_trail` (`audit_trail_id`, `employee_id`, `audit_trail_date_time`, `audit_trail_description`) " +
"VALUES(NULL, @EMPID, @DT, @ADESC)", dbCon.Connection);
comnd.Parameters.AddWithValue("@EMPID", 1);
comnd.Parameters.AddWithValue("@DT", DateTime.Now.Date);
comnd.Parameters.AddWithValue("@ADESC", "A new order " + ID + " was placed by Simon for " + customer.names);
comnd.ExecuteNonQuery();
}
this.Close();
if (saved == true)
{
if (MessageBox.Show("Order Successfully Saved!", "Customer Order", MessageBoxButtons.OK, MessageBoxIcon.Information) == DialogResult.OK)
{
if (MessageBox.Show("Do you want to place a new order?", "Place Customer Order", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
updateStock();
getOrderID();
items = null;
items = new Order[10];
row = 0;
lblOrderID.Text = ID.ToString();
saved = false;
dgv.Rows.Clear();
btnAddProduct.Enabled = false;
btnSaveOrder.Enabled = false;
lblOTotal.Text = "R0.00";
pBoxPrintPhoto.Image = null;
controls.Hide();
orderTotal = 0;
Customer_Order_Details selectCustomer = new Customer_Order_Details();
selectCustomer.ShowDialog();
}
else
{
this.Close();
updateStock();
items = null;
row = 0;
saved = false;
}
}
}
}
catch (Exception er)
{
MessageBox.Show("Error: " + er.Message);
}
}
