public void DisplayAllOrders()
{
try
{
ClassLibrary.CustomerOrder order = new ClassLibrary.CustomerOrder();
dtOrders = order.GetAllOrders().Tables[0];
dataGridView1.DataSource = dtOrders;
dataGridView1.Columns["ORDER_totalprice"].DefaultCellStyle.Format = "c";
//set the product_id column as primary key so you can search the table later
dtOrders.PrimaryKey = new DataColumn[] { dtOrders.Columns["ORDER_id"] };
dataGridView1.DataSource = dtOrders;
dataGridView1.Columns[0].HeaderText = "ID";
dataGridView1.Columns[1].HeaderText = "Name";
dataGridView1.Columns[2].HeaderText = "Date";
dataGridView1.Columns[3].HeaderText = "Total Price";
dataGridView1.Columns[4].HeaderText = "Status";
dataGridView1.Columns[5].HeaderText = "Delivery Date";
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
}
catch (Exception ex)
{
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
ClassLibrary.CustomerOrder order = new ClassLibrary.CustomerOrder();
object id = dataGridView1.CurrentRow.Cells["ORDER_id"].Value;
DataRow selectedRow = dtOrders.Rows.Find(id);
DialogResult dlgResult = MessageBox.Show
("Are you sure you want to delete \nselected order with id of " + id,
"Continue?", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dlgResult == DialogResult.Yes)
{
order.Id = Convert.ToInt32(id);
order.Delete();
DisplayAllOrders();
}
else if (dlgResult == DialogResult.No)
{
}
}
catch (Exception ex)
{
DialogResult dlgResult = MessageBox.Show
("Cant delete the record! Please delete supplier order first!",
"", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void btnSaveToDatabase_Click(object sender, EventArgs e)
{
ClassLibrary.CustomerOrder order = new ClassLibrary.CustomerOrder();
DataRowView selectedCustomer = (DataRowView)cmbCustomers.SelectedItem;
//add order
order.CustId = (int)selectedCustomer.Row.ItemArray[0];
order.OrderDate = Convert.ToDateTime(cmbDate.Text);
order.TotalPrice = totalPrice;
order.Status = txtStatus.Text;
//ADDING MODE
if (drOrder == null)
{
int lastInsertedId = order.Add();
//add OrderDetails
ClassLibrary.CustomerOrderDetails orderdetails = new ClassLibrary.CustomerOrderDetails();
orderdetails.OrderId = lastInsertedId;
foreach (OrderDetails o in ord)
{
orderdetails.Price = Convert.ToDecimal(o.Price.ToString().Replace("$", ""));
orderdetails.ProductId = o.ProductID;
orderdetails.Quantity = o.Quantity;
orderdetails.AddOrderDetails();
}
}
//EDITING MODE
else
{
try
{
if (dateTimePicker1.Enabled == true)
{
order.DateDelivery = Convert.ToDateTime(dateTimePicker1.Text);
}
else
{
order.DateDelivery = DateTime.MinValue;
}
order.Id = Convert.ToInt32(drOrder.ItemArray[0]);
order.Update();
//add OrderDetails
ClassLibrary.CustomerOrderDetails orderdetails = new ClassLibrary.CustomerOrderDetails();
orderdetails.OrderId = order.Id;
orderdetails.Delete();
foreach (OrderDetails o in ord)
{
orderdetails.ProductId = o.ProductID;
orderdetails.Quantity = o.Quantity;
orderdetails.AddOrderDetails();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
frmDisOrder.DisplayAllOrders();
Close();
}
