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