private void btnAdd_Click(object sender, EventArgs e) { NorthwindService.Order or = new NorthwindService.Order(); or.CustomerID = _Cusid; or.OrderDate = DateTime.Today; or.RequireDate = DateTime.Parse(txtDateRequired.Text); or.ShippedDate = DateTime.Parse(txtDateShipped.Text); or.Freight = decimal.Parse(txtFreight.Text); int a = test.AddOrder(or); if (a == 1) { MessageBox.Show("Add successful !", "Add Category", MessageBoxButtons.OK); } else { MessageBox.Show("Add failed !", "Add Category", MessageBoxButtons.OK); } }
private void dtgOrder_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e) { NorthwindService.Order or = new NorthwindService.Order(); int CurrentIndex = dtgOrder.CurrentCell.RowIndex; try { or.OrderID = Convert.ToInt32(dtgOrder.Rows[CurrentIndex].Cells[0].Value.ToString()); or.CustomerID = _Cusid; or.OrderDate = Convert.ToDateTime(dtgOrder.Rows[CurrentIndex].Cells[2].Value.ToString()); or.RequireDate = Convert.ToDateTime(dtgOrder.Rows[CurrentIndex].Cells[3].Value.ToString()); or.ShippedDate = Convert.ToDateTime(dtgOrder.Rows[CurrentIndex].Cells[4].Value.ToString()); or.ShipVia = Convert.ToInt32(dtgOrder.Rows[CurrentIndex].Cells[5].Value.ToString()); or.Freight = Convert.ToDecimal(dtgOrder.Rows[CurrentIndex].Cells[6].Value.ToString()); test.UpdateOrder(or); } catch(Exception ex) { MessageBox.Show(ex.ToString()); } }