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());
}
}
