public void InsertRecordBody(Objects.PurReturnBody obj) { try { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SP_PurReturnBodyInsert"; cmd.Parameters.AddWithValue("@PurReturnID", obj.PurReturnID); cmd.Parameters.AddWithValue("@ProductID", obj.ProductID); cmd.Parameters.AddWithValue("@Qty", obj.Qty); cmd.Parameters.AddWithValue("@Price", obj.Price); cmd.Parameters.AddWithValue("@Discount", obj.Discount); cmd.Parameters.AddWithValue("@TotalValue", obj.TotalValue); new Database(connectionstring).ExecuteNonQueryOnly(cmd); } catch (Exception exc) { throw exc; } }
private void btnSave_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(txt_InvNo.Text.Trim())) { MessageBox.Show("Please Load a Purchase First!!!", "Information Missing"); btnOpenPur.Focus(); return; } bool vHasSelectedRows = false; foreach (DataGridViewRow dr in Grid.Rows) { if (Convert.ToBoolean(dr.Cells["Select"].Value) == true) { vHasSelectedRows = true; break; } } if (!vHasSelectedRows) { MessageBox.Show("Please Select Products to Save..", "Detail Missing"); Grid.Focus(); return; } decimal vCashPaid = 0; decimal.TryParse(txtCashPaid.Text, out vCashPaid); Objects.PurReturn BAL = new Objects.PurReturn(); BAL.PurReturnID = Int64.Parse(txtReturnID.Text); BAL.PurchaseID = Int64.Parse(txt_InvNo.Text); BAL.EntryDate = dt_Entry.Value; BAL.VendorID = int.Parse(txtVendorID.Text); BAL.GrossValue = decimal.Parse(txt_Gross.Text, System.Globalization.NumberStyles.AllowDecimalPoint); BAL.CashReceived = vCashPaid; BAL.Narration = txt_Narration.Text; BAL.UserID = vUserID; if (vOpenMode) { objDAL.UpdateRecord(BAL); objDAL.DeleteRecordBody(Int64.Parse(txtReturnID.Text)); } else { BAL.PurReturnID = objDAL.getNextNo(); objDAL.InsertRecord(BAL); } //Save Detail foreach (DataGridViewRow dr in Grid.Rows) { if (dr.Cells[0].Value != null && Convert.ToBoolean(dr.Cells["Select"].Value) == true) { Objects.PurReturnBody objBody = new Objects.PurReturnBody(); objBody.PurReturnID = Int64.Parse(txtReturnID.Text); objBody.ProductID = Int32.Parse(dr.Cells["ProductID"].Value.ToString()); objBody.Qty = decimal.Parse(dr.Cells["Qty"].Value.ToString()); objBody.Price = decimal.Parse(dr.Cells["Price"].Value.ToString()); objBody.Discount = decimal.Parse(dr.Cells["Disc"].Value.ToString()); objBody.TotalValue = decimal.Parse(dr.Cells["TotalValue"].Value.ToString()); objDAL.InsertRecordBody(objBody); } } MessageBox.Show("Record Saved Successfully.", "Task Completed"); SetMode(false); } catch (Exception exc) { MessageBox.Show(exc.Message.ToString(), "Error"); } }