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