private void button3_Click(object sender, EventArgs e)
{
string mailOrder = null, orderQuery, orderItemQuery;
float totalBill = float.Parse(txtGrandTotal.Text);
double totalCost = this.unitCount;
try
{
if (!string.IsNullOrEmpty(txtInvoiceNo.Text) ||
!string.IsNullOrEmpty(this.tempBuyerId) ||
cartTable.Rows.Count != 0 ||
!string.IsNullOrEmpty(this.tempAgent))
{
orderQuery = "INSERT INTO Orders (OrderId, OrderDate, OrderStatus, PaymentStatus, CustomerId, EmpId, TotalAmount, CostOfAmount) VALUES ("
+ "'" + this.tempOrderId + "', "
+ "'" + this.tempDate + "', "
+ "'Confirmed', "
+ "'Pending',"
+ "'" + this.tempBuyerId + "', "
+ "'" + this.tempAgent + "', "
+ totalBill + ","
+ totalCost + ")";
Functions.ExecuteQuery(orderQuery);
for (int i = 0; i < cartTable.Rows.Count - 1; i++)
{
string _orderItemId = Functions.getNextID("OrderItemId", "OrderItem", "OIT");
orderItemQuery = "INSERT INTO OrderItem (OrderItemId, OrderId, ProductId, Quantity) VALUES ("
+ "'" + _orderItemId + "',"
+ "'" + this.tempOrderId + "',"
+ "'" + cartTable.Rows[i].Cells[0].Value.ToString() + "',"
+ cartTable.Rows[i].Cells[3].Value + ")";
string _productAlter = "UPDATE Product SET QuantityAvailable = '"
+ (this.tempAvailableInt - Int32.Parse(cartTable.Rows[i].Cells[3].Value.ToString()))
+ "' WHERE ProductId = '" + cartTable.Rows[i].Cells[0].Value.ToString() + "'";
Functions.ExecuteQuery(orderItemQuery);
Functions.ExecuteQuery(_productAlter);
mailOrder += ""
+ cartTable.Rows[i].Cells[0].Value
+ " - " + cartTable.Rows[i].Cells[1].Value
+ " (" + cartTable.Rows[i].Cells[3].Value
+ ") =" + cartTable.Rows[i].Cells[4].Value
+ " \n";
}
MessageBox.Show(this, "Order has been placed.\nPlease wait the mail is being processed...");
if (!String.IsNullOrEmpty(this.tempMail))
{
try
{
mailOrder += "------------------------------------------ \n"
+ "Grand total = " + this.count + "\n";
emailThis mail = new emailThis();
mail.sendMail(this.tempMail, mailOrder);
}
catch (Exception ex)
{
MessageBox.Show(this, "Error", "Mail has not been sent.\nReason: " + ex);
}
}
}
else
{
MessageBox.Show(this, "Invalid inputs", "Please recheck your entry");
}
}
catch (Exception ex)
{
MessageBox.Show(this, "Error", "Invoice duplicating is not allowed\n" + ex);
}
}
private void button3_Click(object sender, EventArgs e)
{
if (cartTable.RowCount > 1)
{
DialogResult dialogResult = MessageBox.Show("Do you wish to confirm the order?", "Confirm Order", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
string mailOrder = null, orderQuery, orderItemQuery;
float totalBill = float.Parse(txtGrandTotal.Text);
double totalCost = this.unitCount;
try
{
if (!string.IsNullOrEmpty(this.tempOrderId) &&
(this.tempDate.ToString() != "" || !string.IsNullOrEmpty(this.tempDate.ToString()) || !string.IsNullOrWhiteSpace(this.tempDate.ToString())) &&
(!string.IsNullOrEmpty(tempBuyerId) || !string.IsNullOrWhiteSpace(tempBuyerId)) &&
(!string.IsNullOrEmpty(this.tempAgent) || !string.IsNullOrWhiteSpace(this.tempAgent)))
{
DisableAfterConfirm();
orderQuery = "INSERT INTO Orders (OrderId, OrderDate, OrderStatus, PaymentStatus, CustomerId, EmpId, TotalAmount, CostOfAmount) VALUES ("
+ "'" + this.tempOrderId + "', "
+ "'" + this.tempDate + "', "
+ "'Confirmed', "
+ "'Pending',"
+ "'" + tempBuyerId + "', "
+ "'" + this.tempAgent + "', "
+ totalBill + ","
+ totalCost + ")";
Functions.ExecuteQuery(orderQuery);
for (int i = 0; i < cartTable.Rows.Count - 1; i++)
{
string _orderItemId = Functions.getNextID("OrderItemId", "OrderItem", "OIT");
orderItemQuery = "INSERT INTO OrderItem (OrderItemId, OrderId, ProductId, Quantity) VALUES ("
+ "'" + _orderItemId + "',"
+ "'" + this.tempOrderId + "',"
+ "'" + cartTable.Rows[i].Cells[0].Value.ToString() + "',"
+ cartTable.Rows[i].Cells[3].Value + ")";
string _productAlter = "UPDATE Product SET QuantityAvailable = '"
+ (this.tempAvailableInt - Int32.Parse(cartTable.Rows[i].Cells[3].Value.ToString()))
+ "' WHERE ProductId = '" + cartTable.Rows[i].Cells[0].Value.ToString() + "'";
Functions.ExecuteQuery(orderItemQuery);
Functions.ExecuteQuery(_productAlter);
mailOrder += ""
+ cartTable.Rows[i].Cells[0].Value
+ " - " + cartTable.Rows[i].Cells[1].Value
+ " (" + cartTable.Rows[i].Cells[3].Value
+ ") =" + cartTable.Rows[i].Cells[4].Value
+ " \n";
}
if (!String.IsNullOrEmpty(this.tempMail))
{
MessageBox.Show(this, "Order has been placed.\nPlease wait the mail is being processed...");
try
{
mailOrder += "------------------------------------------ \n"
+ "Grand total = " + string.Concat(this.count, ".00");
emailThis mail = new emailThis();
//mail.sendMail(this.tempMail, mailOrder);
if (mail.sendMail(this.tempMail, mailOrder))
{
MessageBox.Show("Mail has been sent to Customer");
}
newOrder();
}
catch (Exception ex)
{
MessageBox.Show(this, "Error", "Mail has not been sent.\nReason: " + ex);
}
}
else
{
MessageBox.Show(this, "Order has been placed.");
DialogResult dialogResultEmail = MessageBox.Show("Would you like to update the customer profile with an Email to send automated order?", "Update Customer details", MessageBoxButtons.YesNo);
if (dialogResultEmail == DialogResult.Yes)
{
b_update_single bu = new b_update_single();
bu.ShowDialog();
Console.WriteLine("Email added");
newOrder();
}
if (dialogResultEmail == DialogResult.No)
{
newOrder();
}
}
}
else
{
MessageBox.Show(this, "Invalid inputs", "Please recheck your entry");
}
}
catch (Exception ex)
{
MessageBox.Show(this, "Error", "Invoice duplicating is not allowed\n" + ex);
}
}
}
else
{
MessageBox.Show("Please add some item before checking out.");
}
}
