示例#1
0
        public int CreateCardsinfo(CraditCard ObjCrd)
        {
            using (SqlConnection con = new SqlConnection(connstring))
            {
                SqlCommand com = new SqlCommand("sp_Save_Orders", con);
                com.CommandType = CommandType.StoredProcedure;
                com.Parameters.AddWithValue("@OrderItemId", ObjCrd.OrderID);
                com.Parameters.AddWithValue("@OrderQuantity", ObjCrd.Qunt);
                com.Parameters.AddWithValue("@LoginId", ObjCrd.LoginID);
                com.Parameters.AddWithValue("@Type", ObjCrd.Type);
                com.Parameters.AddWithValue("@CcNumber", ObjCrd.CcNumber);
                com.Parameters.AddWithValue("@CName", ObjCrd.CName);
                com.Parameters.AddWithValue("@Cvv", ObjCrd.Cvv);
                com.Parameters.AddWithValue("@Exp", ObjCrd.Exp);
                com.Parameters.AddWithValue("@Street", ObjCrd.Street);
                com.Parameters.AddWithValue("@CityID", ObjCrd.CityID);
                com.Parameters.AddWithValue("@StateID", ObjCrd.StateID);
                com.Parameters.AddWithValue("@CountryID", ObjCrd.CountryID);
                com.Parameters.AddWithValue("@Zipcode", ObjCrd.Zipcode);

                con.Open();
                int i = com.ExecuteNonQuery();
                con.Close();
                if (i >= 1)
                {
                    return(1);
                }
                else
                {
                    return(0);
                }
            }
        }
示例#2
0
 public int CreateCraditApp(CraditCard Obj)
 {
     return(CrdObj.CreateCardsinfo(Obj));
 }