public FraudRequest LoadPreviouisTransactions(SqlCommand sqlCommad)
{
SqlDataReader reader = null;
try
{
reader = sqlCommad.ExecuteReader();
FraudRequest objCustomer = new FraudRequest();
if (reader.Read())
{
if (!reader.IsDBNull(1))
{
objCustomer.IPAdress = reader.GetString(1) ?? "";
}
if (!reader.IsDBNull(2))
{
objCustomer.TransactionAmount = Convert.ToInt64(reader.GetString(2));
}
if (!reader.IsDBNull(3))
{
objCustomer.TransactionResult = GetTransactionResult(reader.GetString(3));
}
if (!reader.IsDBNull(4))
{
objCustomer.CustomerID = Convert.ToInt32(reader.GetString(4));
}
if (!reader.IsDBNull(5))
{
objCustomer.CardNumber = reader.GetInt64(5);
}
if (!reader.IsDBNull(6))
{
objCustomer.City = reader.GetString(6) ?? "";
}
if (!reader.IsDBNull(7))
{
objCustomer.Country = reader.GetString(7) ?? "";
}
if (!reader.IsDBNull(8))
{
objCustomer.CardNumber = Convert.ToInt64(reader.GetString(8));
}
}
reader.Close();
return(objCustomer);
}
finally
{
reader.Close();
}
}
public bool SaveTransaction(FraudRequest transactionMade)
{
int rowsChanged = 0;
string[] transaction = { transactionMade.IPAdress, transactionMade.TransactionAmount.ToString(), transactionMade.TransactionResult.ToString(),
transactionMade.CustomerID.ToString(), transactionMade.CardNumber.ToString(), transactionMade.City, transactionMade.Country,
transactionMade.EmailID };
SqlCommand cmd = sqlConnection.CreateCommand();
cmd.CommandText = String.Format(CultureInfo.InvariantCulture,
"Insert into dbo.Transactions" +
"(IPAdress,TransactionAmount,Result,CustomerNo,CardNumber,City,Country,Email)" +
"values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", transaction);
rowsChanged = cmd.ExecuteNonQuery();
if (rowsChanged > 0)
{
return(true);
}
return(false);
}