/// <summary> /// Insert Order details using EF /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void buttonSave_Click(object sender, EventArgs e) { try { orderDetailModel.RefNo = Guid.Parse(textBoxRefNo.Text.Trim()); orderDetailModel.OD_DCLink = int.Parse(comboBox_CustomerName.SelectedValue.ToString()); orderDetailModel.InvoiceNo = textBoxInvoiceNo.Text.Trim(); orderDetailModel.InvoiceDate = dateTimeInvoice.Value.Date; orderDetailModel.OrderDetailsNote = textBoxNote.Text.Trim(); orderDetailModel.TotalExclAmount = Convert.ToDecimal(textBoxTotalExcl.Text); orderDetailModel.TotalTaxAmount = Convert.ToDecimal(textBoxTotalTax.Text); orderDetailModel.TotalInclAmount = Convert.ToDecimal(textBoxTotalIncl.Text); task_DBEntities.OrderDetails.Add(orderDetailModel); task_DBEntities.SaveChanges(); if (orderDetailModel.RefNo != null) { using (var context = new Task_DBEntities11()) { foreach (DataGridViewRow dr in dataGridView1.Rows) { if (dr == null || dr.Cells[0].Value == null) { continue; } itemOrderModel.IO_RefNo = orderDetailModel.RefNo; itemOrderModel.IO_StockLink = Convert.ToInt32(dr.Cells[0].Value.ToString()); itemOrderModel.Description = dr.Cells[1].Value.ToString(); itemOrderModel.ItemOrderNote = dr.Cells[2].Value.ToString(); itemOrderModel.Qty = Convert.ToInt32(dr.Cells[3].Value); itemOrderModel.Price = Convert.ToInt32(dr.Cells[4].Value); itemOrderModel.Tax = Convert.ToInt32(dr.Cells[5].Value); itemOrderModel.ExclAmount = Convert.ToInt32(dr.Cells[6].Value); itemOrderModel.TaxAmount = Convert.ToInt32(dr.Cells[7].Value); itemOrderModel.InclAmount = Convert.ToInt32(dr.Cells[8].Value); task_DBEntities.ItemOrders.Add(itemOrderModel); task_DBEntities.SaveChanges(); } MessageBox.Show("Order details saved successfully!"); } } else { MessageBox.Show("Cannot save order details!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// Update Order deatils using EF(ADO.NET) /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void buttonUpdate_Click(object sender, EventArgs e) { try { if (orderDetailModel.RefNo != null) { orderDetailModel.OD_DCLink = int.Parse(comboBox_CustomerName.SelectedValue.ToString()); orderDetailModel.InvoiceNo = textBoxInvoiceNo.Text.Trim(); orderDetailModel.InvoiceDate = dateTimeInvoice.Value.Date; orderDetailModel.OrderDetailsNote = textBoxNote.Text.Trim(); orderDetailModel.TotalExclAmount = Convert.ToDecimal(textBoxTotalExcl.Text); orderDetailModel.TotalTaxAmount = Convert.ToDecimal(textBoxTotalTax.Text); orderDetailModel.TotalInclAmount = Convert.ToDecimal(textBoxTotalIncl.Text); task_DBEntities.OrderDetails.Add(orderDetailModel); task_DBEntities.SaveChanges(); if (orderDetailModel.RefNo != null) { using (var context = new Task_DBEntities11()) { itemOrderModel.IO_RefNo = orderDetailModel.RefNo; itemOrderModel.IO_StockLink = Convert.ToInt32(dataGridView1.Rows[0].Cells[0].Value.ToString()); itemOrderModel.Description = dataGridView1.Rows[0].Cells[1].Value.ToString(); itemOrderModel.ItemOrderNote = dataGridView1.Rows[0].Cells[2].Value.ToString(); itemOrderModel.Qty = (int)dataGridView1.Rows[0].Cells[3].Value; itemOrderModel.Price = Convert.ToInt32(dataGridView1.Rows[0].Cells[4].Value); itemOrderModel.Tax = Convert.ToInt32(dataGridView1.Rows[0].Cells[5].Value); itemOrderModel.ExclAmount = Convert.ToInt32(dataGridView1.Rows[0].Cells[6].Value); itemOrderModel.TaxAmount = Convert.ToInt32(dataGridView1.Rows[0].Cells[7].Value); itemOrderModel.InclAmount = (int)dataGridView1.Rows[0].Cells[8].Value; task_DBEntities.Entry(itemOrderModel).State = EntityState.Modified; task_DBEntities.ItemOrders.Add(itemOrderModel); task_DBEntities.SaveChanges(); MessageBox.Show("Order details updated successfully!"); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }