private void btnReturn_Click(object sender, EventArgs e) { try { var q = db.Client_Purchase_Order_Line.Where(op => op.Client_Purchase_Order_Line_ID == polid).FirstOrDefault(); int prid = Convert.ToInt32(q.Product_ID.ToString()); var q1 = db.Products.Where(op => op.Product_ID == prid).FirstOrDefault(); newCRL = new Credit_Return_Line() { Client_Purchase_Order_Line_ID = polid, Quantity_Returned = Convert.ToInt32(textBox7.Text), Reason_For_Return_ID = Convert.ToInt32(comboBox1.SelectedValue), Credit_Return_ID = newCR.Credit_Return_Id, Credit_Return_Amount = Convert.ToDecimal(q1.Order_Price.ToString()) * Convert.ToInt32(textBox7.Text) }; db.Credit_Return_Line.Add(newCRL); db.SaveChanges(); dataGridView2.DataSource = db.Get_Credit_Return_Line(newCR.Credit_Return_Id); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void dataGridView4_CellClick(object sender, DataGridViewCellEventArgs e) { DataGridViewRow r = this.dataGridView4.Rows[e.RowIndex]; string crnum = r.Cells[0].Value.ToString(); try { var q = db.Credit_Return.Where(c => c.CR_Number == crnum).FirstOrDefault(); int crid = Convert.ToInt32(q.Credit_Return_Id.ToString()); dataGridView3.DataSource = db.Get_Credit_Return_Line(crid); } catch (Exception) { MessageBox.Show("Something went wrong!,Please try again"); } }