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