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