Exemple #1
0
        public int DeleteItem(Int64 itemID)
        {
            Database  db        = SqlHelper.CreateConnection(SqlHelper.MyConnection);
            DbCommand dbCommand = db.GetStoredProcCommand("HBankRate_Delete");

            db.AddInParameter(dbCommand, "HouseRateID", DbType.Int64, itemID);
            DBgl_FriendRequest objItem = DBgl_FriendRequestManager.GetItemByID(itemID);

            //if (objItem != null) { RemoveCache(objItem); };
            return(db.ExecuteNonQuery(dbCommand));
            // return DataHelper.ExecuteNonQuery("", itemID);
        }
Exemple #2
0
        public static int DeleteItem(int ItemId)
        {
            Database  db        = SqlHelper.CreateConnection(SqlHelper.MyConnection);
            DbCommand dbCommand = db.GetStoredProcCommand("gl_FriendRequest_Delete");

            db.AddInParameter(dbCommand, "RequestId", DbType.Int32, ItemId);
            DBgl_FriendRequest objItem = DBgl_FriendRequestManager.GetItemByID(ItemId);

            if (objItem != null)
            {
                RemoveCache(objItem);
            }
            ;
            return(db.ExecuteNonQuery(dbCommand));
        }