public string[] UpdateCustomer(CustomerClass fred, CreditCardClass cc, object[] stupid)
{
DBConnect DB = new DBConnect();
SqlCommand command = new SqlCommand();
string[] meh = new string[3];
ErrorCodes ec = new ErrorCodes();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "CustomerUpdate";
command.Parameters.AddWithValue("@FirstName", fred.Firstname);
command.Parameters.AddWithValue("@Address", fred.Address);
command.Parameters.AddWithValue("@City", fred.City);
command.Parameters.AddWithValue("@State", fred.State);
command.Parameters.AddWithValue("@ZipCode", fred.ZipCode);
command.Parameters.AddWithValue("@AccountBalance", cc.AccountBalance);
meh[0] = (DB.DoUpdateUsingCmdObj(command) > 0) ? "true" : "false";
SqlCommand sandy = new SqlCommand();
sandy.CommandType = CommandType.StoredProcedure;
sandy.CommandText = "VerifyInfo";
sandy.Parameters.AddWithValue("@CreditCardNum", cc.CardNumber);
sandy.Parameters.AddWithValue("@CVV", cc.CVV);
sandy.Parameters.AddWithValue("@TransAmnt", float.Parse(stupid[2].ToString()));
sandy.Parameters.AddWithValue("@FirstName", fred.Firstname);
SqlParameter returnParam = new SqlParameter("@RVAL", DbType.Int32);
returnParam.Direction = ParameterDirection.ReturnValue;
sandy.Parameters.Add(returnParam);
// DataSet ds = DB.GetDataSetUsingCmdObj(sandy);
DB.GetDataSetUsingCmdObj(sandy);
meh[1] = sandy.Parameters["@RVAL"].Value.ToString();
meh[2] = ec.GetErrorCodeMessage(int.Parse(meh[1]));
return meh;
}
public bool HelloWorld(CreditCardClass cc, CustomerClass arthur)
{
DBConnect DB = new DBConnect();
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "AddCard";
command.Parameters.AddWithValue("@CreditCardNumber", cc.CardNumber);
command.Parameters.AddWithValue("@CVV", cc.CVV);
command.Parameters.AddWithValue("@AccountNumber", cc.AccountNumber);
command.Parameters.AddWithValue("@CreditLimit", cc.CreditLimit);
command.Parameters.AddWithValue("@AccountBalance", cc.AccountBalance);
command.Parameters.AddWithValue("@FirstName", arthur.Firstname);
command.Parameters.AddWithValue("@LastName", arthur.LastName);
return (DB.DoUpdateUsingCmdObj(command) > 0) ? true : false;
}