public FRM_OrderDtetails(string ss) { InitializeComponent(); try { dgvDetails.DataSource = ClassBill.sp_OrderDetailsSel(int.Parse(ss)); } catch (Exception ex) { } }
private void btnSave_Click(object sender, EventArgs e) { if (dgvQuotation.Rows.Count <= 0 || txtBriName.Text.Equals("")) { MessageBox.Show("Fields Empty"); } else { int i = ClassBill.sp_bill(DateTime.Now.Date, txtContactName.Text, txtBriName.Text, txtBatName.Text, txtSarName.Text, txtLegal.Text, txtAmount.Text, txtTva.Text, txtTotal.Text, code); for (int x = 0; x < dgvQuotation.Rows.Count; x++) { int z = ClassBill.sp_billDet(dgvQuotation.Rows[x].Cells[0].Value.ToString(), dgvQuotation.Rows[x].Cells[1].Value.ToString(), dgvQuotation.Rows[x].Cells[2].Value.ToString(), dgvQuotation.Rows[x].Cells[3].Value.ToString(), dgvQuotation.Rows[x].Cells[4].Value.ToString(), dgvQuotation.Rows[x].Cells[5].Value.ToString()); } int y = ClassBill.updExecuteOrder(int.Parse(id)); btnSelectOrder.Enabled = btnInsert.Enabled = btnDelete.Enabled = btnUpdate.Enabled = btnSave.Enabled = false; btnPrint.Enabled = true; MessageBox.Show("Done."); } }
private void txtSearch_TextChanged(object sender, EventArgs e) { dgvOrder.DataSource = ClassBill.sp_SearchOrders(txtSearch.Text); }
public FRM_OrdersSelect() { InitializeComponent(); dgvOrder.DataSource = ClassBill.sp_orders(FRM_Bill.code); }
private void dgvOrders_DoubleClick(object sender, EventArgs e) { dgvOrderDetails.DataSource = ClassBill.sp_OrderDetailsSel(int.Parse(dgvOrders.CurrentRow.Cells[0].Value.ToString())); }