using (SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["LocalDB"].ConnectionString.ToString())) {
using (SqlCommand sqlcmd = new SqlCommand(query, con))
{
sqlcmd.Parameters.Add("@username", SqlDbType.BigInt).Value = idNo;
sqlcmd.Parameters.Add("@password", SqlDbType.Int).Value = cardPIN;
con.Open();
using (SqlDataReader sqlreader = sqlcmd.ExecuteReader())
{
while (sqlreader.Read())
{
ACOFName = sqlreader["name"].ToString();
ACOSurname = sqlreader["surname"].ToString();
ACOSecName = sqlreader["secondaryName"].ToString();
cardExpirationDate = sqlreader["expirationDate"].ToString();
cardCVV = sqlreader["cvv"].ToString();
accountNo = sqlreader["accountNo"].ToString();
cardNumber = (Int64)sqlreader["cardNumber"];
accountBalance = (Decimal)sqlreader["accountBalance"];
if (!String.IsNullOrEmpty(ACOSecName))
{
haveSecondary = true;
}
if ((string)sqlreader["gender"] == "F")
{
Gender = "Hanım";
}
else if ((string)sqlreader["gender"] == "M")
{
Gender = "Bey";
}
}
}
returnValue = (string)sqlcmd.ExecuteScalar();
}
}