private void frmPayments_Load(object sender, EventArgs e) { try { DataTable db = ClassPayments.getPaymentId(); string payId = db.Rows[0][0].ToString(); int npayId = Int32.Parse(payId) + 1; txtPaymentId.Text = npayId.ToString(); AutoCompleteStringCollection collection = classCustomers.getAutoCompleteCustomersNames(); txtCusName.AutoCompleteCustomSource = collection; dgvPaymentView.DataSource = ClassPayments.PaymentSearch(); dgvPaymentView.Columns[0].HeaderText = "Payment ID"; dgvPaymentView.Columns[1].HeaderText = "Customer Id"; dgvPaymentView.Columns[2].HeaderText = "Customer Name"; dgvPaymentView.Columns[3].HeaderText = "Date"; dgvPaymentView.Columns[4].HeaderText = "Amount"; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public int insertTopayment(ClassPayments payment) { string query = "insert payment values ('" + payment.paymentid + "', '" + payment.customerid + "', '" + payment.paymentdate + "', " + payment.paymentamount + "); "; int result = clsConnection.SendQuery(query); return(result); }
private void btnSubmit_Click(object sender, EventArgs e) { float Payingvalue; int x = 1; try { if (txtcusId.Text == "") { throw new Exception("Enter a Customer."); } Payingvalue = float.Parse(txtAmountPaying.Text); if (txtAmountPaying.ForeColor == Color.Red) { throw new Exception("Enter a less paying amount."); } x = 2; } catch (Exception ex) { MessageBox.Show(ex.Message); txtAmountPaying.Text = ""; } if (x == 2) { var payement = new ClassPayments { paymentid = txtPaymentId.Text, paymentdate = lblDate.Text, paymentamount = float.Parse(txtAmountPaying.Text), customerid = txtcusId.Text }; int pay = payement.insertTopayment(payement); int customer = classCustomers.updateCustomerCreditValue(txtAmountPaying.Text, txtcusId.Text); foreach (var c in this.Controls) { if (c is TextBox) { ((TextBox)c).Text = String.Empty; } } } dgvPaymentView.DataSource = ClassPayments.PaymentSearch(); dgvPaymentView.Columns[0].HeaderText = "Payment ID"; dgvPaymentView.Columns[1].HeaderText = "Customer Id"; dgvPaymentView.Columns[2].HeaderText = "Customer Name"; dgvPaymentView.Columns[3].HeaderText = "Date"; dgvPaymentView.Columns[4].HeaderText = "Amount"; }
private void txtCusName_Leave(object sender, EventArgs e) { try { DataTable db = new DataTable(); string query = "select customerid from customer where customername ='" + txtCusName.Text + "'"; db = clsConnection.GetData(query); string cusid = db.Rows[0][0].ToString(); dgvsalesview.DataSource = ClassSales.salesdetailsSearch2(cusid); dgvsalesview.Columns[0].HeaderText = "Sales ID"; dgvsalesview.Columns[1].HeaderText = "Customer Name"; dgvsalesview.Columns[2].HeaderText = "Date"; dgvsalesview.Columns[3].HeaderText = "Amount to be paid"; dgvsalesview.Columns[4].HeaderText = "Amount paid"; dgvsalesview.Columns[5].HeaderText = "Balance"; dgvPaymentView.DataSource = ClassPayments.customerPaymentSearch(cusid); dgvPaymentView.Columns[0].HeaderText = "Payment ID"; dgvPaymentView.Columns[1].HeaderText = "Customer Name"; dgvPaymentView.Columns[2].HeaderText = "Date"; dgvPaymentView.Columns[3].HeaderText = "Amount"; DataTable db1 = new DataTable(); string query2 = "select orderid from orderbill where customerid ='" + cusid + "'"; db1 = clsConnection.GetData(query2); string ordid = db1.Rows[0][0].ToString(); dgvReturnView.DataSource = classReturns.returndetails(ordid); dgvReturnView.Columns[0].HeaderText = "Return ID"; dgvReturnView.Columns[1].HeaderText = "Order ID"; dgvReturnView.Columns[2].HeaderText = "Item ID"; dgvReturnView.Columns[3].HeaderText = "Batch ID"; dgvReturnView.Columns[4].HeaderText = "Quantity"; dgvReturnView.Columns[5].HeaderText = "Date"; dgvReturnView.Columns[5].HeaderText = "Amount"; DataTable db2 = new DataTable(); string query1 = "select creditvalue from customer where customername ='" + txtCusName.Text + "'"; db2 = clsConnection.GetData(query1); txtcredit.Text = db2.Rows[0][0].ToString(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }