public TransDetails[] Trans(int AccNo) { string countQuery = "SELECT COUNT(*) FROM TransactionDetails WHERE AccNo = " + AccNo; SqlCommand countCommand = new SqlCommand(countQuery, conn); conn.Open(); Int32 num = (Int32)countCommand.ExecuteScalar(); Console.WriteLine("Number of Count" + num); TransDetails[] trans1 = new TransDetails[num]; string tranQuery = "SELECT TransID,AccNo,TransType,TransAmount ,TransDate FROM TransactionDetails WHERE AccNo = " + AccNo; SqlCommand selectCommand = new SqlCommand(tranQuery, conn); SqlDataReader reader1 = selectCommand.ExecuteReader(); int i = 0; Console.WriteLine("TransID AccNO TransType TransAmount TransDate "); while (reader1.Read()) { var trans2 = new TransDetails { TransID = reader1.GetInt32(0), AccNo = reader1.GetInt32(1), TransType = reader1.GetString(2), TransAmount = reader1.GetDecimal(3), TransDate = reader1.GetDateTime(4) }; trans1[i] = trans2; // Console.WriteLine(trans2.TransID); // Console.WriteLine(trans2.TransDate); Console.WriteLine(" " + trans2.TransID + " \t" + trans2.AccNo + " \t" + trans2.TransType + " \t " + trans2.TransAmount + " \t " + trans2.TransDate); i++; } conn.Close(); return(trans1); }
private void btnAddTransactions_Click(object sender, EventArgs e) { if (!string.IsNullOrWhiteSpace(txtModeofPayment.Text) && !string.IsNullOrWhiteSpace(txtTransactionAmount.Text) && !string.IsNullOrWhiteSpace(txtTransactionID.Text) && cmbPaymentStatus.SelectedIndex > 0 && cmbUsers.SelectedIndex > 0) { TransDetails objTrxDetails = new TransDetails(); objTrxDetails.ModeofPayment = txtModeofPayment.Text; objTrxDetails.TransactionAmount = Convert.ToDecimal(txtTransactionAmount.Text); objTrxDetails.TransactionID = txtTransactionID.Text; objTrxDetails.PaymentStatus = cmbPaymentStatus.Text; objTrxDetails.UserId = Convert.ToInt32(cmbUsers.SelectedValue); objTrxDetails.TransferDate = Convert.ToDateTime(dtpTransferDate.Text); objTrxDetails.Remarks = txtRemarks.Text; objTransDetails = new TransactionDetails(); int result = 0; string statusMsg = string.Empty; if (btnAddTransactions.Text.ToUpper().Contains("ADD")) { result = objTransDetails.CreateTransaction(objTrxDetails); statusMsg = "Added new Transaction Details successfully."; } if (result > 0) { ClearAllControls(); MessageBox.Show(statusMsg, "Transaction Details", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("Please Enter the Transaction Fields", "Transaction Details", MessageBoxButtons.OK, MessageBoxIcon.Error); } }